public class Student
{
private int _id;
private string _firstName;
private string _lastName;
private string _loginName;
private string _loginPassword;
private string _gender;
private string _mobileNo;
private string _country;
private string _state;
private string _city;
private string _education;
private string _comment;
private string _enqueryStatus;
private DateTime _created;
public int Id
{
get { return _id; }
set { _id = value; }
}
public string FirstName
{
get { return _firstName; }
set { _firstName = value; }
}
public string LastName
{
get { return _lastName; }
set { _lastName = value; }
}
public string LoginName
{
get { return _loginName; }
set { _loginName = value; }
}
public string LoginPassword
{
get { return _loginPassword; }
set { _loginPassword = value; }
}
public string Gender
{
get { return _gender; }
set { _gender = value; }
}
public string MobileNo
{
get { return _mobileNo; }
set { _mobileNo = value; }
}
public string Country
{
get { return _country; }
set { _country = value; }
}
public string State
{
get { return _state; }
set { _state = value; }
}
public string City
{
get { return _city; }
set { _city = value; }
}
public string Education
{
get { return _education; }
set { _education = value; }
}
public string Comment
{
get { return _comment; }
set { _comment = value; }
}
public string EnqueryStatus
{
get { return _enqueryStatus; }
set { _enqueryStatus = value; }
}
public DateTime Created
{
get { return _created; }
set { _created = value; }
}
public void addEnquiry(Student stud)
{
string query = "insert into Enquiry_Studen(SE_Enquiry_ID, SE_First_Name, SE_Last_Name, SE_Login_Name, SE_Password, SE_Gender, SE_Mobile_No, SE_Country, SE_State, SE_City, SE_Enquiry_Status, SE_Comment, SE_Creation_Date) values(@EnquiryID, @FirstName, @LastName, @LoginName, @Password, @Gender, @MobileNo, @Country, @State, @City, @EnqueryStatus, @Comment, @CreationDate)";
DBHandler dbHandler = DBHandler.getInstance();
SqlConnection con = new SqlConnection(dbHandler.connString);
SqlCommand command = new SqlCommand(query, con);
command.Parameters.Add("@EnquiryID", SqlDbType.VarChar).Value = 7;
command.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = stud.FirstName;
command.Parameters.Add("@LastName", SqlDbType.VarChar).Value = stud.LastName;
command.Parameters.Add("@LoginName", SqlDbType.VarChar).Value = stud.LoginName;
command.Parameters.Add("@Password", SqlDbType.VarChar).Value = stud.LoginPassword;
command.Parameters.Add("@Gender", SqlDbType.VarChar).Value = stud.Gender;
command.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = stud.MobileNo;
command.Parameters.Add("@Country", SqlDbType.VarChar).Value = stud.Country;
command.Parameters.Add("@State", SqlDbType.VarChar).Value = stud.State;
command.Parameters.Add("@City", SqlDbType.VarChar).Value = stud.City;
command.Parameters.Add("@EnqueryStatus", SqlDbType.VarChar).Value = stud.EnqueryStatus;
command.Parameters.Add("@Comment", SqlDbType.VarChar).Value = stud.Comment;
command.Parameters.Add("@CreationDate", SqlDbType.Date).Value = stud.Created;
using (con)
{
con.Open();
dbHandler.ExecuteNonQuery(command);
}
}
public string getEnqueryStatus(int sid)
{
string Status;
string query = "select SE_Enquiry_Status from Enquiry_Student where SE_Enquery_Id = @EnqueryID";
DBHandler dbHandler = DBHandler.getInstance();
SqlConnection con = new SqlConnection(dbHandler.connString);
SqlCommand command = new SqlCommand(query, con);
command.Parameters.Add("@EnqueryID", SqlDbType.Int).Value = sid;
using (con)
{
con.Open();
Status = (string)dbHandler.ExecuteScaler(command);
}
return Status;
}
public bool validateUser(string lName, string lPassword)
{
SqlDataReader reader;
string query = "select SE_Login_Name, SE_Password from Enquiry_Student where SE_Login_Name=@LoginName";
DBHandler dbHandler = DBHandler.getInstance();
SqlConnection con = new SqlConnection(dbHandler.connString);
SqlCommand command = new SqlCommand(query, con);
command.Parameters.Add("@LoginName", SqlDbType.VarChar).Value = lName;
using (con)
{
con.Open();
reader = dbHandler.ExecuteDataReader(command);
if (reader.HasRows)
{
reader.Read();
if (reader["SE_Login_Name"].ToString() == lName && reader["SE_Password"].ToString() == lPassword)
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
}
}
}
