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)); }