public CheckLogin LoginDAL(string username, string password)
{
CheckLogin cl = new CheckLogin();
try
{
conOpen.Open();
SqlCommand cmd = new SqlCommand("select DL_LoginID,DL_Password, DL_Designation,DL_Role from E_Data_Login where DL_LoginID='" + username + "' ", conOpen);
var dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
if (dr.IsDBNull(0))
{
cl.username = null;
}
else
{
cl.username = Convert.ToString(dr.GetInt32(0));
}
if (dr.IsDBNull(1))
{
cl.password = null;
}
else
{
cl.password = dr.GetString(1);
}
if (dr.IsDBNull(2))
{
cl.designation = null;
}
else
{
cl.designation = dr.GetString(2);
}
if (dr.IsDBNull(3))
{
cl.role = null;
}
else
{
cl.role = dr.GetString(3);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(cl);
}
public string respondOfferDAL(string username, string password)
{
SetJobStatus ss = new SetJobStatus();
try
{
conOpen.Open();
SqlCommand cmd1 = new SqlCommand("select DL_Designation,DL_Role from E_Data_Login where DL_LoginID='" + username + "' and DL_Password='******' ", conOpen);
var dr = cmd1.ExecuteReader();
CheckLogin cl = new CheckLogin();
while (dr.Read())
{
if (dr.IsDBNull(0))
{
cl.designation = null;
}
else
{
cl.designation = dr.GetString(0);
}
if (dr.IsDBNull(1))
{
cl.role = null;
}
else
{
cl.role = dr.GetString(1);
}
}
if (dr.HasRows)
{
dr.Close();
SqlCommand cmd = new SqlCommand("select Offer_Letter_Status from E_Data_Candidate_Profile where Can_CandidateID='" + username + "' ", conOpen);
var dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
if (dr1.IsDBNull(0))
{
ss.offerstatus = null;
}
else
{
ss.offerstatus = dr1.GetString(0);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(ss.offerstatus);
}