public static Entity.EmployeeMaster GetById(int employeeId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@EmployeeId", SqlDbType.Int, ParameterDirection.Input, employeeId);
SqlDataReader dr = oDm.ExecuteReader("EmployeeMaster_GetById");
Entity.EmployeeMaster employeeMaster = new Entity.EmployeeMaster();
if (dr.HasRows)
{
while (dr.Read())
{
employeeMaster.EmployeeId = employeeId;
employeeMaster.FName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
employeeMaster.LName = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
employeeMaster.Email = (dr[3] == DBNull.Value) ? "" : dr[3].ToString();
employeeMaster.ContactNo = (dr[4] == DBNull.Value) ? "" : dr[4].ToString();
employeeMaster.BranchId = (dr[5] == DBNull.Value) ? 0 : int.Parse(dr[5].ToString());
employeeMaster.DesignationId = (dr[6] == DBNull.Value) ? 0 : int.Parse(dr[6].ToString());
employeeMaster.Status = (dr[7] == DBNull.Value) ? false : Convert.ToBoolean(dr[7]);
employeeMaster.Password = (dr[8] == DBNull.Value) ? "" : dr[8].ToString();
employeeMaster.Address = (dr[9] == DBNull.Value) ? "" : dr[9].ToString();
}
}
return(employeeMaster);
}
}
public static void ChangePassword(Entity.EmployeeMaster Employee)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@EmployeeId", SqlDbType.Int, ParameterDirection.Input, Employee.EmployeeId);
oDm.Add("@Password", SqlDbType.VarChar, 50, Employee.Password);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("ChangePassword");
}
}
protected void UserLogin()
{
string u = txtUserName.Text.Trim();
string p = txtPassword.Text.Trim();
BusinessLayer.EmployeeMaster ObjEmployee = new BusinessLayer.EmployeeMaster();
Entity.EmployeeMaster Employee = new Entity.EmployeeMaster();
Employee = ObjEmployee.AuthenticateUser(u);
if (Employee != null)
{
if (BusinessLayer.Cryptography.Decrypt(Employee.Password) == p)
{
string UserId = Employee.EmployeeId.ToString();
FormsAuthenticationTicket Authticket = new FormsAuthenticationTicket(
1,
UserId,
DateTime.Now,
DateTime.Now.AddMinutes(240),
false,
UserId,
FormsAuthentication.FormsCookiePath);
string hash = FormsAuthentication.Encrypt(Authticket);
HttpCookie Authcookie = new HttpCookie(FormsAuthentication.FormsCookieName, hash);
if (Authticket.IsPersistent)
{
Authcookie.Expires = Authticket.Expiration;
}
Response.Cookies.Add(Authcookie);
System.Web.Caching.Cache cacheObject = System.Web.HttpContext.Current.Cache;
cacheObject.Insert(UserId, Employee.Roles);
Session["UserId"] = Employee.EmployeeId;
Session["Role"] = Employee.DesignationId;
Session.Timeout = 240;
Response.Redirect("AddEditBlock.aspx");
}
}
txtUserName.Text = "";
txtPassword.Focus();
}
public static int Save(Entity.EmployeeMaster employeemaster)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@EmployeeId", SqlDbType.Int, employeemaster.EmployeeId);
oDm.Add("@FName", SqlDbType.VarChar, 50, employeemaster.FName);
oDm.Add("@LName", SqlDbType.VarChar, 50, employeemaster.LName);
oDm.Add("@Email", SqlDbType.VarChar, 50, employeemaster.Email);
oDm.Add("@ContactNo", SqlDbType.VarChar, 50, employeemaster.ContactNo);
oDm.Add("@BranchId", SqlDbType.Int, employeemaster.BranchId);
oDm.Add("@DesignationId", SqlDbType.Int, employeemaster.DesignationId);
oDm.Add("@Status", SqlDbType.Bit, employeemaster.Status);
oDm.Add("@Password", SqlDbType.VarChar, 20, employeemaster.Password);
oDm.Add("@CreatedBy", SqlDbType.Int, employeemaster.CreatedBy);
//oDm.Add("@Address", SqlDbType.VarChar, 200, employeemaster.Address);
oDm.CommandType = CommandType.StoredProcedure;
return(oDm.ExecuteNonQuery("EmployeeMaster_Save"));
}
}
public static Entity.EmployeeMaster AuthenticateUser(string Email)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@Email", SqlDbType.VarChar, 50, Email);
oDm.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = oDm.ExecuteReader("GetUserNameAndPass");
Entity.EmployeeMaster Employee = new Entity.EmployeeMaster();
if (dr.HasRows)
{
while (dr.Read())
{
Employee.EmployeeId = (dr[0] == DBNull.Value) ? 0 : Convert.ToInt32(dr[0].ToString());
Employee.DesignationId = (dr[1] == DBNull.Value) ? 0 : Convert.ToInt32(dr[1].ToString());
Employee.Email = (dr[2] == DBNull.Value) ? "" : dr[2].ToString();
Employee.Password = (dr[3] == DBNull.Value) ? "" : dr[3].ToString();
Employee.Roles = (dr[4] == DBNull.Value) ? "" : dr[4].ToString();
}
return(Employee);
}
return(null);
}
}
public void ChangePassword(Entity.EmployeeMaster Employee)
{
DataAccess.EmployeeMaster.ChangePassword(Employee);
}
public int Save(Entity.EmployeeMaster employeemaster)
{
return(DataAccess.EmployeeMaster.Save(employeemaster));
}
