public JsonResult UserRoleChange(int id, string userRole) { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int companyId = Convert.ToInt32(dictionary[1].Id == "" ? 0 : Convert.ToInt32(dictionary[1].Id)); if (companyId != 0) { _userGroupFactory = new UserGroupFactory(); _userFactory = new UserFactory(); int userId = Convert.ToInt32(dictionary[3].Id); SEC_UserInformation user = _userFactory.FindBy(x => x.ID == userId).FirstOrDefault(); SEC_UserGroup userGroup = _userGroupFactory.FindBy(x => x.ID == user.UserGroupID).FirstOrDefault(); if (userGroup != null && userGroup.IsAdmin) { SEC_UserGroup role = _userGroupFactory.FindBy(x => x.Name == userRole).FirstOrDefault(); _userFactory = new UserFactory(); SEC_UserInformation tblUserInformation = _userFactory.FindBy(x => x.ID == id).FirstOrDefault(); if (tblUserInformation != null) { tblUserInformation.UserGroupID = role.ID; _userFactory.Edit(tblUserInformation); } _userFactory.Save(); return(Json(new { success = true, message = "Sucessifuly changed the user role" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "You are not Admin User" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateUserForm(UserModel user) { try { result = new Result(); Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userId = Convert.ToInt32(dictionary[3].Id); if (userId != 0) { _userFactory = new UserFactory(); var aUserInformation = _userFactory.FindBy(x => x.UserName == user.UserName.ToLower().Trim()).FirstOrDefault(); if (aUserInformation != null) { aUserInformation.UpdatedDate = DateTime.Now; aUserInformation.UpdatedBy = userId; aUserInformation.UserGroupID = user.UserGroupID; _userFactory.Edit(aUserInformation); result = _userFactory.Save(); } return(Json(new { success = false, message = "Your entared user name does not exist!!!" }, JsonRequestBehavior.AllowGet)); } Session["logInSession"] = null; return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } }
public Result SelfPasswordChange(ChangePasswordModel changePassword) { try { result = new Result(); result.isSucess = false; Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); if (userGroupId != 0) { int userId = Convert.ToInt32(dictionary[3].Id); string userName = dictionary[4].Id; _userFactory = new UserFactory(); bool status = _userFactory.GetAll().Any(x => x.UserName == userName && x.UserGroupID == userGroupId); if (status == true) { SEC_UserInformation tblUserInformation; tblUserInformation = _userFactory.FindBy(x => x.ID == userId).FirstOrDefault(); _passwordFactory = new UserPasswordFactory(); Encription encription = new Encription(); SEC_Password tblPassword = _passwordFactory.GetAll().FirstOrDefault(x => x.ID == tblUserInformation.PasswordID); if (tblPassword != null) { tblPassword.OldPassword = tblPassword.NewPassword; tblPassword.NewPassword = encription.Encrypt(changePassword.NewPassword.Trim()); tblPassword.IsSelfChanged = true; tblPassword.UpdatedDate = DateTime.Now; tblPassword.UpdatedBy = userId; _passwordFactory.Edit(tblPassword); } result = _passwordFactory.Save(); if (result.isSucess) { result.message = "Changed Password Sucessfully"; return(result); } } result.message = "Password not Changed try again"; return(result); } result.message = "LogOut"; } catch (Exception exception) { result.isSucess = false; result.message = exception.Message; } return(result); }
public DAL.db.Appointment SearchCardWiseAppointmentData(string cardNO) { _unScheduleAppointment = new UnScheduleAppointmentFactory(); try { var list = new DAL.db.Appointment(); list = _unScheduleAppointment.FindBy(x => (x.CardNO == cardNO) && (x.Status == "I")).FirstOrDefault(); return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.Appointment> SearchCheckBreak(string status) { _unScheduleAppointment = new UnScheduleAppointmentFactory(); try { var list = new List <DAL.db.Appointment>(); list = _unScheduleAppointment.FindBy(x => x.Status == status).OrderByDescending(x => x.AppointmentID).Take(100).ToList(); return(list); } catch (Exception e) { throw e; } }
public List <MeetingRoomRequisition> SearchMeetingRoom(int roomId, DateTime date) { _mrReqFactory = new MeetingRoomReqFactory(); try { var list = new List <MeetingRoomRequisition>(); list = _mrReqFactory.FindBy(x => x.MeetingRoomID == roomId && x.RequiredDate == date).ToList(); return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.Appointment> SearchScheduleAppointment(int employeeID) { _scheduleAppointment = new ScheduleAppointmentFactory(); try { var list = new List <DAL.db.Appointment>(); list = _scheduleAppointment.FindBy(x => (x.EmployeeID == employeeID) && (x.Status == "A" || x.Status == "I" || x.Status == "B" || x.Status == "N" || x.Status == "AP" || x.Status == "P")).ToList(); return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.Appointment> SearchNotifyDataPS(int id, int eid) { _scheduleAppointment = new ScheduleAppointmentFactory(); try { var list = new List <DAL.db.Appointment>(); list = _scheduleAppointment.FindBy(x => (x.Employee.EmployeeID == id || x.EmployeeID == eid) && (x.Status == "N" || x.Status == "P") || (x.Employee.EmployeeID == id && x.EmployeeID == eid) && (x.Status == "N" || x.Status == "P")).ToList(); return(list); } catch (Exception e) { throw e; } }
public List <SEC_UserInformation> LoadAllUserName() { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); _userFactory = new UserFactory(); var list = new List <SEC_UserInformation>(); list = _userFactory.FindBy(x => x.IsActive == true && x.UserGroupID == userGroupId).ToList(); return(list); } catch (Exception exception) { throw exception; } }
public List <Employee> GetDepWiseFloor(int empID) { _scheduleEmpFactory = new ScheduleEmployeeFactory(); try { var list = new List <Employee>(); if (empID > 0) { list = _scheduleEmpFactory.FindBy(x => x.EmployeeID == empID).ToList(); } return(list); } catch (Exception e) { throw e; } }
public Result DeleteUserGroup(int id) { Result result = new Result(); using (var dbContextTransaction = context.Database.BeginTransaction()) { try { _userGroupFactory = new UserGroupFactory(); _userFactory = new UserFactory(); int countUser = _userFactory.FindBy(x => x.UserGroupID == id).Count(); if (countUser == 0) { result.isSucess = true; _userActionMappingFactory = new UserActionMappingFactory(); int countUserAction = _userActionMappingFactory.FindBy(x => x.UserGroupID == id).Count(); if (countUserAction > 0) { _userActionMappingFactory.Delete(x => x.UserGroupID == id); result = _userActionMappingFactory.Save(); } if (result.isSucess) { _userGroupFactory.Delete(x => x.ID == id); result = _userGroupFactory.Save(); } if (result.isSucess) { result.message = result.DeleteSuccessfull(tableName); dbContextTransaction.Commit(); return(result); } } } catch (Exception ex) { result.message = ex.Message; result.isSucess = false; dbContextTransaction.Rollback(); } } return(result); }
public List <Employee> SearchDepWiseEmployeeBehalf(int did, int id) { _scheduleEmpFactory = new ScheduleEmployeeFactory(); try { var list = new List <Employee>(); if (did > 0) { list = _scheduleEmpFactory.FindBy(x => x.DepartmentID == did && x.OnBehalfEmployeeID == id && x.EmployeeID != id).ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <Employee> SearchDepWiseEmployee(int depID) { _scheduleEmpFactory = new ScheduleEmployeeFactory(); try { var list = new List <Employee>(); if (depID > 0) { list = _scheduleEmpFactory.FindBy(x => x.DepartmentID == depID).ToList(); } return(list); } catch (Exception e) { throw e; } }
public Card GetFreeCard(int deviceNo) { //int enrollmentID = 0; _card = new CardFactory(); try { var card = _card.FindBy(x => x.DeviceNO == deviceNo && x.CardNO == null).FirstOrDefault(); //if (data != null) //{ // enrollmentID = data.ID; //} return(card); } catch (Exception e) { throw e; } }
public JsonResult ActiveDeActiveUser(int id, bool status) { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); if (userGroupId != 0) { ISecurityFactory _securityLogInFactory = new SecurityFactorys(); PagePermissionVM tblUserActionMapping = _securityLogInFactory.GetCrudPermission(userGroupId, "User"); if (tblUserActionMapping.Edit) { _userGroupFactory = new UserGroupFactory(); _userFactory = new UserFactory(); int userId = Convert.ToInt32(dictionary[3].Id); SEC_UserInformation user = _userFactory.FindBy(x => x.ID == userId).FirstOrDefault(); SEC_UserGroup userGroup = _userGroupFactory.FindBy(x => x.ID == user.UserGroupID).FirstOrDefault(); if (userGroup != null && userGroup.IsAdmin) { _userFactory = new UserFactory(); SEC_UserInformation tblUserInformation = _userFactory.FindBy(x => x.ID == id).FirstOrDefault(); if (tblUserInformation != null) { tblUserInformation.IsActive = status; _userFactory.Edit(tblUserInformation); } _userFactory.Save(); if (status) { return(Json(new { success = true, message = "Sucessifuly activeted the User" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, message = "Sucessifuly de-activeted the User" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "You are not Admin User" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "You has no permission for edit" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public int GetAssignCardID(int deviceNo, string cardNO) { int cardID = 0; _card = new CardFactory(); try { var data = _card.FindBy(x => x.DeviceNO == deviceNo && x.CardNO == cardNO).FirstOrDefault(); if (data != null) { cardID = data.CardID; } return(cardID); } catch (Exception e) { throw e; } }
public JsonResult CreateUserSave(UserModel user) { JsonResult jsonResult = new JsonResult(); try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userId = Convert.ToInt32(dictionary[3].Id == "" ? 0 : Convert.ToInt32(dictionary[3].Id)); if (userId != 0) { _userFactory = new UserFactory(); _employeeFactory = new EmployeeFactory(); SEC_UserInformation isDuplicate = _userFactory.FindBy(x => x.UserName.ToLower().Trim() == user.UserName.ToLower().Trim()).FirstOrDefault(); if (isDuplicate == null) { var emp = _employeeFactory.FindBy(x => x.EmpCode == user.UserName).FirstOrDefault(); if (emp != null) { user.EmployeeID = emp.EmployeeID; user.CompanyID = emp.CompanyID; user.BranchID = emp.BranchID; user.SecurityQuestion = "0"; user.SecurityQueAns = "BD"; } else { return(Json(new { success = false, message = "Your enter employee code is not registered in the employee registration section" }, JsonRequestBehavior.AllowGet)); } jsonResult = CreateUser(user, userId); return(Json(jsonResult)); } return(Json(new { success = false, message = "Your entered user name are duplicated please chose another name" }, JsonRequestBehavior.AllowGet)); } Session["logInSession"] = null; return(Json(new { success = false, message = "LogOut" }, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(new { success = false, message = exception.Message }, JsonRequestBehavior.AllowGet)); } }
public Result UnassignCard(int deviceNo, string cardNO) { _card = new CardFactory(); try { var card = _card.FindBy(x => x.DeviceNO == deviceNo && x.CardNO == cardNO).FirstOrDefault(); if (card != null) { card.CardNO = null; _card.Edit(card); _card.Save(); _result.isSucess = true; } } catch (Exception e) { _result.isSucess = false; } return(_result); }
public List <Designation> SearchDesignation(int?DesignationID) { try { _esignationFactory = new DesignationFactory(); var list = new List <Designation>(); if (DesignationID > 0) { list = _esignationFactory.FindBy(x => x.DesignationID == DesignationID).ToList(); } else { list = _esignationFactory.GetAll().ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public List <Employee> SearchEmployee(int?empID) { _scheduleEmpFactory = new ScheduleEmployeeFactory(); try { var list = new List <Employee>(); if (empID > 0) { list = _scheduleEmpFactory.FindBy(x => x.EmployeeID == empID).ToList(); } else { list = _scheduleEmpFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.MeetingRoom> SearchMeetingRoom(int?meetingRoomID) { _mrFactory = new MeetingRoomFactory(); try { var list = new List <DAL.db.MeetingRoom>(); if (meetingRoomID > 0) { list = _mrFactory.FindBy(x => x.MeetingRoomID == meetingRoomID).ToList(); } else { list = _mrFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <Employee> SearchEmployee(int?EmployeeID) { try { _employeeFactory = new EmployeeFactory(); var list = new List <Employee>(); if (EmployeeID > 0) { list = _employeeFactory.FindBy(x => x.EmployeeID == EmployeeID).ToList(); } else { list = _employeeFactory.GetAll().ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public List <Department> SearchDepartment(int?DepartmentID) { try { _departmentFactory = new DepartmentFactory(); var list = new List <Department>(); if (DepartmentID > 0) { list = _departmentFactory.FindBy(x => x.DepartmentID == DepartmentID).ToList(); } else { list = _departmentFactory.GetAll().ToList(); } return(list); } catch (Exception ex) { throw ex; } }
public List <MeetingRoomRequisition> SearchMeetingRoomReq(int?id) { _mrReqFactory = new MeetingRoomReqFactory(); try { var list = new List <MeetingRoomRequisition>(); if (id > 0) { list = _mrReqFactory.FindBy(x => x.MeetingRoomID == id).ToList(); } else { list = _mrReqFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <SET_CompanyBranch> SearchCompanyBranch(int?id) { try { _companyBranchFactory = new CompanyBranchFactory(); var list = new List <SET_CompanyBranch>(); if (id > 0) { list = _companyBranchFactory.FindBy(x => x.BranchID == id).ToList(); } else { list = _companyBranchFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <DAL.db.MeetingParticipant> SearchMeetingRoomParticipant(int?id) { _mrPrFactory = new ParticipantFactory(); try { var list = new List <MeetingParticipant>(); if (id != null) { list = _mrPrFactory.FindBy(x => x.RequisitionID == id).ToList(); } else { list = _mrPrFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <SEC_UIModule> SearchUiModule(int?moduleID) { Result _result = new Result(); _moduleFactory = new ModuleFactory(); try { var list = new List <SEC_UIModule>(); if (moduleID > 0) { list = _moduleFactory.FindBy(x => x.ID == moduleID).ToList(); } else { list = _moduleFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public List <SEC_UIPage> SearchUiPages(int?pageID) { Result _result = new Result(); _uiPageFactory = new UiPageFactory(); try { var list = new List <SEC_UIPage>(); if (pageID > 0) { list = _uiPageFactory.FindBy(x => x.ID == pageID).ToList(); } else { list = _uiPageFactory.GetAll().ToList(); } return(list); } catch (Exception e) { throw e; } }
public ActionResult LogOff() { try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); if (dictionary[3].Id != null || dictionary[3].Id != "") { int userId = Convert.ToInt32(dictionary[3].Id); _loginStatusFactory = new LoginStatusFactory(); SEC_LoginStatus loginStatus = _loginStatusFactory.FindBy(x => x.UserID == userId).FirstOrDefault(); loginStatus.PresentLogInStatus = false; loginStatus.LogOutTime = DateTime.Now; loginStatus.ForcedLogOutStatus = false; _loginStatusFactory.Edit(loginStatus); _loginStatusFactory.Save(); System.Web.HttpContext.Current.Session["LoginUserID"] = 0; System.Web.HttpContext.Current.Session["LoginUserName"] = 0; System.Web.HttpContext.Current.Session["LoginEmployee"] = 0; System.Web.HttpContext.Current.Session["LoginCompanyID"] = 0; System.Web.HttpContext.Current.Session["LoginBranchID"] = 0; System.Web.HttpContext.Current.Session["LoginUserFullName"] = 0; System.Web.HttpContext.Current.Session["UserGroupID"] = 0; System.Web.HttpContext.Current.Session["IPAddress"] = 0; Session["logInSession"] = null; return(Redirect("/#!/")); } return(Redirect("/#!/")); } catch (Exception) { return(Redirect("/#!/")); } }
public ActionResult Login(LogOnModel model) { try { if (ModelState.IsValid) { bool getLan = false; string visitorIpAddress = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (String.IsNullOrEmpty(visitorIpAddress)) { visitorIpAddress = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; } if (string.IsNullOrEmpty(visitorIpAddress)) { visitorIpAddress = System.Web.HttpContext.Current.Request.UserHostAddress; } if (string.IsNullOrEmpty(visitorIpAddress) || visitorIpAddress.Trim() == "::1") { getLan = true; visitorIpAddress = string.Empty; } if (getLan && string.IsNullOrEmpty(visitorIpAddress)) { //This is for Local(LAN) Connected ID Address string stringHostName = Dns.GetHostName(); //Get Ip Host Entry IPHostEntry ipHostEntries = Dns.GetHostEntry(stringHostName); ipHostEntries = System.Net.Dns.GetHostEntry(Request.ServerVariables["REMOTE_HOST"]); //Get Ip Address From The Ip Host Entry Address List IPAddress[] arrIpAddress = ipHostEntries.AddressList; try { visitorIpAddress = arrIpAddress[arrIpAddress.Length - 2].ToString(); } catch { try { visitorIpAddress = arrIpAddress[0].ToString(); } catch { try { arrIpAddress = Dns.GetHostAddresses(stringHostName); visitorIpAddress = arrIpAddress[0].ToString(); } catch { visitorIpAddress = "127.0.0.1"; } } } } //////////////////////////////////// _securityFactory = new SecurityFactorys(); _userInformationFactory = new UserFactory(); _employeeFactory = new EmployeeFactory(); model.UserName = model.UserName.ToLower().Trim(); var logInStatus = _securityFactory.CheckLogIn(new LogOnModel { CompanyID = model.CompanyID, BranchID = model.BranchID, UserName = model.UserName, Password = model.Password }); if (logInStatus.IsAllowed) { var aSecurityUser = _userInformationFactory.FindBy(x => x.UserName.Contains(model.UserName)).FirstOrDefault(); var aCompanyUser = _employeeFactory.FindBy(x => x.EmployeeID == aSecurityUser.EmployeeID).FirstOrDefault(); if (aSecurityUser != null) { System.Web.HttpContext.Current.Session["LoginEmployee"] = aSecurityUser.EmployeeID; System.Web.HttpContext.Current.Session["LoginCompanyID"] = aCompanyUser.CompanyID; System.Web.HttpContext.Current.Session["LoginBranchID"] = aCompanyUser.BranchID; System.Web.HttpContext.Current.Session["LoginUserID"] = aSecurityUser.ID; System.Web.HttpContext.Current.Session["LoginUserName"] = aSecurityUser.UserName; System.Web.HttpContext.Current.Session["LoginUserFullName"] = aSecurityUser.Employee.EmpName; System.Web.HttpContext.Current.Session["UserGroupID"] = aSecurityUser.UserGroupID; System.Web.HttpContext.Current.Session["IPAddress"] = visitorIpAddress; System.Web.HttpContext.Current.Session["LoginPhoto"] = GetLoginPhoto(aSecurityUser.EmployeeID); string[] computerName = null; //try //{ // computerName = Dns.GetHostEntry(Request.ServerVariables["REMOTE_ADDR"]).HostName.Split(new Char[] { '.' }); //} //catch (Exception) //{ //} if (computerName != null) { System.Web.HttpContext.Current.Session["PCName"] = computerName[0]; } else { System.Web.HttpContext.Current.Session["PCName"] = "N/A"; } if (!String.IsNullOrEmpty(model.UserName)) { if (!aSecurityUser.UserName.Equals(model.UserName, StringComparison.Ordinal)) { return(Json(new { success = false, message = "Incorrect User Name or Password." }, JsonRequestBehavior.AllowGet)); } } else { System.Web.HttpContext.Current.Session["LoginUserID"] = 0; } if (!logInStatus.IsAllowed) { return(Json(new { success = false, message = logInStatus.Message }, JsonRequestBehavior.AllowGet)); } //if (String.IsNullOrEmpty(model.UserName)) throw new ArgumentException("Value cannot be null or empty.", "userName"); //FormsAuthentication.SetAuthCookie(model.UserName, model.RememberMe); SEC_LoginStatus tblLogInStatus = new SEC_LoginStatus(); _loginStatusFactory = new LoginStatusFactory(); tblLogInStatus.UserID = aSecurityUser.ID; tblLogInStatus.PresentLogInStatus = true; tblLogInStatus.LogInTime = DateTime.Now; tblLogInStatus.LogOutTime = DateTime.Now; tblLogInStatus.ForcedLogOutStatus = false; _loginStatusFactory.Add(tblLogInStatus); _loginStatusFactory.Save(); Session["logInSession"] = "true"; return(Json(new { success = true, message = "Success" }, JsonRequestBehavior.AllowGet)); // } return(Json(new { success = false, message = "The user name or password provided is incorrect." }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = logInStatus.Message }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = false, message = "The user name or password provided is incorrect." }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { //Route(); return(Json(new { success = false, message = e.Message }, JsonRequestBehavior.AllowGet)); } //return Json(new { success = false, message = "The user name or password provided is incorrect. 4" }, JsonRequestBehavior.AllowGet); }