public IEnumerable <Employeedetails> EmployeeList()
{
List <Employeedetails> _Empdetails = new List <Employeedetails>();
cmd = new SqlCommand("select EmpNo,Name,Designation,EmployeeType,Location,BusinessUnit,Division,Department,Gender,Status from employees where Status='Active'", con);
con.Open();
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Employeedetails Cobj = new Employeedetails();
Cobj.EmpNo = dr["EmpNo"].ToString();
Cobj.Name = dr["Name"].ToString();
Cobj.Designation = dr["Designation"].ToString();
Cobj.EmployeeType = dr["EmployeeType"].ToString();
Cobj.Location = dr["Location"].ToString();
Cobj.BusinessUnit = dr["BusinessUnit"].ToString();
Cobj.Division = dr["Division"].ToString();
Cobj.Department = dr["Department"].ToString();
Cobj.Gender = dr["Gender"].ToString();
Cobj.Status = dr["Status"].ToString();
Cobj.Password = "";
_Empdetails.Add(Cobj);
}
}
return(_Empdetails);
}
public bool CheckCredentials(Employeedetails Cobj)
{
cmd = new SqlCommand("select count(EmpNo) as exist from employees where Status='Active' and EmpNo=@EmpNo", con);
con.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@EmpNo", Cobj.EmployeeId);
int exist = (int)cmd.ExecuteScalar();
con.Close();
if (exist == 0)
{
return(false);
}
else
{
return(true);
}
}
public Employeedetails FetchEmpDetails(Employeedetails Cobj, string encriptpwd)
{
cmd = new SqlCommand("select count(muser_empno) as exist from HDNNippon.dbo.Musers WHERE muser_empno=@muser_empno and muser_password=@muser_password", conhdn);
conhdn.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@muser_empno", Cobj.EmployeeId);
cmd.Parameters.AddWithValue("@muser_password", encriptpwd);
int exist = (int)cmd.ExecuteScalar();
conhdn.Close();
//string str = Cobj.Password;
//char CurrentChar;
//for (int i = 0; i <= str.Length; i++) // I started i = 0, vs. yours i =1
//{
// if (i == 3)
// {
// CurrentChar = str.Substring(i, 3)[0];
// if (CurrentChar == '#')
// {
// exist = 201;
// }
// }
//}
Employeedetails _Empdetails = new Employeedetails();
if (exist != 0)
{
cmd = new SqlCommand("select EmpNo,Name,Designation,EmployeeType,Location,BusinessUnit,Division,Department,Gender,Status from employees where Status='Active' and EmpNo=@EmpNo", con);
con.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@EmpNo", Cobj.EmployeeId);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
//Employeedetails Cred = new Employeedetails();
Cobj.EmpNo = dr["EmpNo"].ToString();
Cobj.Name = dr["Name"].ToString();
Cobj.Designation = dr["Designation"].ToString();
Cobj.EmployeeType = dr["EmployeeType"].ToString();
Cobj.Location = dr["Location"].ToString();
Cobj.BusinessUnit = dr["BusinessUnit"].ToString();
Cobj.Division = dr["Division"].ToString();
Cobj.Department = dr["Department"].ToString();
Cobj.Gender = dr["Gender"].ToString();
Cobj.Status = dr["Status"].ToString();
Cobj.Password = ""; // _Empdetails.Add(Cobj);
}
}
con.Close();
return(Cobj);
}
//else if (exist == 201)
//{
// cmd = new SqlCommand("select EmpNo,Name,Designation,EmployeeType,Location,BusinessUnit,Division,Department,Gender,Status from employees where Status='Active' and EmpNo=@EmpNo", con);
// con.Open();
// cmd.CommandType = CommandType.Text;
// cmd.Parameters.AddWithValue("@EmpNo", Cobj.EmployeeId);
// SqlDataReader dr = cmd.ExecuteReader();
// if (dr.HasRows)
// {
// while (dr.Read())
// {
// Employeedetails Cred = new Employeedetails();
// Cred.EmpNo = dr["EmpNo"].ToString();
// Cred.Name = dr["Name"].ToString();
// Cred.Designation = dr["Designation"].ToString();
// Cred.EmployeeType = dr["EmployeeType"].ToString();
// Cred.Location = dr["Location"].ToString();
// Cred.BusinessUnit = dr["BusinessUnit"].ToString();
// Cred.Division = dr["Division"].ToString();
// Cred.Department = dr["Department"].ToString();
// Cred.Gender = dr["Gender"].ToString();
// Cred.Status = dr["Status"].ToString();
// _Empdetails.Add(Cred);
// }
// }
// con.Close();
// return _Empdetails;
//}
else
{
_Empdetails = null;
return(_Empdetails);
}
}
