public Result SaveMeetingRoom(DAL.db.MeetingRoom meetingRoom) { _mrFactory = new MeetingRoomFactory(); try { if (meetingRoom.MeetingRoomID > 0) { _mrFactory.Edit(meetingRoom); _result = _mrFactory.Save(); if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); } } else { _mrFactory.Add(meetingRoom); _result = _mrFactory.Save(); if (_result.isSucess) { _result.message = _result.SaveSuccessfull(tableName); } } } catch (Exception e) { _result.isSucess = false; _result.message = e.Message; } return(_result); }
public Result SaveAppointment(DAL.db.Appointment appointment) { _unScheduleAppointment = new UnScheduleAppointmentFactory(); try { if (appointment.AppointmentID > 0) { _unScheduleAppointment.Edit(appointment); _result = _unScheduleAppointment.Save(); if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); } } else { _unScheduleAppointment.Add(appointment); _result = _unScheduleAppointment.Save(); if (_result.isSucess) { _result.message = _result.SaveSuccessfull(tableName); } } } catch (Exception e) { _result.isSucess = false; _result.message = e.Message; } return(_result); }
public Result SaveEmployee(Employee emp) { Result _result = new Result(); try { _employeeFactory = new EmployeeFactory(); if (emp.EmployeeID < 1) { _employeeFactory.Add(emp); _result = _employeeFactory.Save(); if (_result.isSucess) { _result.message = _result.SaveSuccessfull(tableName); } } else { _employeeFactory.Edit(emp); _result = _employeeFactory.Save(); if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); } } } catch (Exception ex) { _result.isSucess = false; _result.message = ex.Message; } return(_result); }
public Result SaveCompanyBranch(SET_CompanyBranch companyBranch) { _result = new Result(); _companyBranchFactory = new CompanyBranchFactory(); try { Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userGroupId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); if (userGroupId != 0) { if (companyBranch.BranchID > 0) { _companyBranchFactory.Edit(companyBranch); _result = _companyBranchFactory.Save(); } else { int branchID = 1; var prvBranchID = _companyBranchFactory.GetLastRecord().OrderByDescending(x => x.BranchID).FirstOrDefault(); if (prvBranchID != null) { branchID = prvBranchID.BranchID + 1; } companyBranch.BranchID = branchID; _companyBranchFactory.Add(companyBranch); _result = _companyBranchFactory.Save(); } } else { _result.isSucess = false; _result.message = "Logout"; } } catch (Exception e) { _result.isSucess = false; _result.message = e.Message; } return(_result); }
public Result SaveDepartment(Department dept) { Result _result = new Result(); try { _departmentFactory = new DepartmentFactory(); if (dept.DepartmentID < 1) { _departmentFactory.Add(dept); _result = _departmentFactory.Save(); if (_result.isSucess) { _result.isSucess = true; _result.message = _result.SaveSuccessfull(tableName); } } else { _departmentFactory.Edit(dept); _result = _departmentFactory.Save(); if (_result.isSucess) { _result.isSucess = true; _result.message = _result.UpdateSuccessfull(tableName); } } } catch (Exception ex) { _result.isSucess = false; _result.message = ex.Message; } return(_result); }
public Result SaveDesignation(Designation designation) { Result _result = new Result(); try { _esignationFactory = new DesignationFactory(); if (designation.DesignationID < 1) { _esignationFactory.Add(designation); _result = _esignationFactory.Save(); if (_result.isSucess) { _result.isSucess = true; _result.message = _result.SaveSuccessfull(tableName); } } else { _esignationFactory.Edit(designation); _result = _esignationFactory.Save(); if (_result.isSucess) { _result.isSucess = true; _result.message = _result.UpdateSuccessfull(tableName); } } } catch (Exception ex) { _result.isSucess = false; _result.message = ex.Message; } return(_result); }
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); }
public Result UiPageSave(SEC_UIPage page) { Result _result = new Result(); _uiPageFactory = new UiPageFactory(); _userActionMappingFactory = new UserActionMappingFactory(); Dictionary <int, CheckSessionData> dictionary = CheckSessionData.GetSessionValues(); int userId = Convert.ToInt32(dictionary[6].Id == "" ? 0 : Convert.ToInt32(dictionary[6].Id)); int empId = Convert.ToInt32(dictionary[1].Id == "" ? 0 : Convert.ToInt32(dictionary[1].Id)); try { if (page.ID > 0) { _uiPageFactory.Edit(page); _result = _uiPageFactory.Save(); if (_result.isSucess) { SEC_UserActionMapping userActionMapping = new SEC_UserActionMapping(); _userGroupFactory = new UserGroupFactory(); var groupID = _userGroupFactory.GetAll().ToList(); foreach (var details in groupID) { var uiMapping = _userActionMappingFactory.FindBy(x => x.UserGroupID == details.ID && x.UIPageID == page.ID).Count(); if (uiMapping == 0) { userActionMapping.UserGroupID = details.ID; userActionMapping.UIPageID = page.ID; userActionMapping.UIModuleID = Convert.ToInt32(page.ModuleID); userActionMapping.IsCreate = false; userActionMapping.IsDelete = false; userActionMapping.IsEdit = false; userActionMapping.IsSelect = false; userActionMapping.CreatedBy = empId; userActionMapping.CreatedDate = DateTime.Now; _userActionMappingFactory.Add(userActionMapping); _result = _userActionMappingFactory.Save(); } } if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tablePageName); return(_result); } _result.message = _result.UpdateSuccessfull(tablePageName); } } else { int pageID = 1; var prvPage = _uiPageFactory.GetLastRecord().OrderByDescending(x => x.ID).FirstOrDefault(); if (prvPage != null) { pageID = prvPage.ID + 1; } page.UrlID = 1; page.ID = pageID; _uiPageFactory.Add(page); _result = _uiPageFactory.Save(); if (_result.isSucess) { var uiMapping = _userActionMappingFactory.FindBy(x => x.UserGroupID == userId && x.UIPageID == page.ID).Count(); if (uiMapping == 0) { SEC_UserActionMapping userActionMapping = new SEC_UserActionMapping(); _userGroupFactory = new UserGroupFactory(); var groupID = _userGroupFactory.GetAll().ToList(); foreach (var details in groupID) { userActionMapping.UserGroupID = details.ID; userActionMapping.UIPageID = page.ID; userActionMapping.UIModuleID = Convert.ToInt32(page.ModuleID); userActionMapping.IsCreate = false; userActionMapping.IsDelete = false; userActionMapping.IsEdit = false; userActionMapping.IsSelect = false; userActionMapping.CreatedBy = empId; userActionMapping.CreatedDate = DateTime.Now; _userActionMappingFactory.Add(userActionMapping); _result = _userActionMappingFactory.Save(); } if (_result.isSucess) { _result.message = _result.SaveSuccessfull(tablePageName); _result.lastInsertedID = userActionMapping.ID; return(_result); } } _result.message = _result.SaveSuccessfull(tablePageName); } } } catch (Exception e) { _result.isSucess = false; _result.message = e.Message; } return(_result); }
public Result SaveUserGroupWithPageMapping(SEC_UserGroup userGroup) { Result result = new Result(); using (var dbContextTransaction = context.Database.BeginTransaction()) { try { _userGroupFactory = new UserGroupFactory(); _userGroupFactory.Add(userGroup); bool isDuplicate = _userGroupFactory.FindBy(x => x.Name.ToLower().Trim() == userGroup.Name.ToLower().Trim()).Any(x => x.Name.ToLower() == userGroup.Name.ToLower()); if (!isDuplicate) { result = _userGroupFactory.Save(); _uiPageFactory = new UiPageFactory(); _userActionMappingFactory = new UserActionMappingFactory(); if (result.isSucess) { List <SEC_UIPage> uiPageList = _uiPageFactory.GetAll().ToList(); foreach (var item in uiPageList) { SEC_UserActionMapping userMappings = new SEC_UserActionMapping(); userMappings.UserGroupID = Convert.ToInt32(userGroup.ID); userMappings.UIModuleID = Convert.ToInt32(item.ModuleID); userMappings.UIPageID = item.ID; userMappings.IsSelect = false; userMappings.IsCreate = false; userMappings.IsEdit = false; userMappings.IsDelete = false; userMappings.CreatedDate = DateTime.Now; userMappings.CreatedBy = Convert.ToInt32(userGroup.CreatedBy); _userActionMappingFactory.Add(userMappings); } result = _userActionMappingFactory.Save(); } if (result.isSucess) { result.message = result.SaveSuccessfull(tableName); dbContextTransaction.Commit(); return(result); } else { result.isSucess = false; dbContextTransaction.Rollback(); return(result); } } result.message = "Your entared code is duplicate"; result.isSucess = false; dbContextTransaction.Commit(); return(result); } catch (Exception ex) { result.message = "Error occured"; result.isSucess = false; dbContextTransaction.Rollback(); } } return(result); }
public Result SaveUserGroupWithPagePermission(SEC_UserGroup userGroup, List <MenuItemVM> menuVm) { Result result = new Result(); using (var dbContextTransaction = context.Database.BeginTransaction()) { try { _userGroupFactory = new UserGroupFactory(); _userGroupFactory.Add(userGroup); bool isDuplicate = _userGroupFactory.FindBy(x => x.Name.ToLower().Trim() == userGroup.Name.ToLower().Trim()).Any(x => x.Name.ToLower() == userGroup.Name.ToLower()); if (!isDuplicate) { _userGroupFactory.Save(); _uiPageFactory = new UiPageFactory(); _userActionMappingFactory = new UserActionMappingFactory(); List <SEC_UIPage> uiPageList = _uiPageFactory.GetAll().ToList(); foreach (var item in uiPageList) { SEC_UserActionMapping userMappings = new SEC_UserActionMapping(); userMappings.UserGroupID = Convert.ToInt32(userGroup.ID); userMappings.UIModuleID = Convert.ToInt32(item.ModuleID); userMappings.UIPageID = item.ID; userMappings.IsSelect = false; userMappings.IsCreate = false; userMappings.IsEdit = false; userMappings.IsDelete = false; userMappings.CreatedDate = DateTime.Now; userMappings.CreatedBy = Convert.ToInt32(userGroup.CreatedBy); _userActionMappingFactory.Add(userMappings); } _userActionMappingFactory.Save(); if (menuVm != null) { int userGroupId = Convert.ToInt32(userGroup.ID); List <SEC_UserActionMapping> userMappingList = _userActionMappingFactory.FindBy(x => x.UserGroupID == userGroupId).ToList(); List <MenuItemVM> userMappingVmList = menuVm.Distinct().ToList(); foreach (var item in userMappingVmList) { SEC_UserActionMapping userMapping = new SEC_UserActionMapping(); userMapping = userMappingList.FirstOrDefault(x => x.UIPageID == item.PageId); if (userMapping != null) { userMapping.IsSelect = item.Select != null ? (bool)item.Select : userMapping.IsSelect; userMapping.IsCreate = item.Create != null ? (bool)item.Create : userMapping.IsCreate; userMapping.IsEdit = item.Edit != null ? (bool)item.Edit : userMapping.IsEdit; userMapping.IsDelete = item.Delete != null ? (bool)item.Delete : userMapping.IsDelete; _userActionMappingFactory.Edit(userMapping); } } _userActionMappingFactory.Save(); } result.message = "Saved Successfuly"; result.isSucess = true; dbContextTransaction.Commit(); return(result); } result.message = "Your entared code is duplicate"; result.isSucess = false; dbContextTransaction.Commit(); return(result); } catch (Exception ex) { result.message = "Error occured"; result.isSucess = false; dbContextTransaction.Rollback(); } } return(result); }
private JsonResult CreateUser(UserModel user, int userId) { result = new Result(); _questionFactory = new QuestionFactory(); _passwordFactory = new UserPasswordFactory(); var question = new SEC_SecurityQuestion(); question.ID = Guid.NewGuid(); question.SecurityQuestion = user.SecurityQuestion; question.SecutiryAnswer = user.SecurityQueAns; question.CreatedBy = userId; question.CreatedDate = DateTime.Now; _questionFactory.Add(question); result = _questionFactory.Save(); var password = new SEC_Password(); if (result.isSucess) { var encription = new Encription(); password.ID = Guid.NewGuid(); password.NewPassword = encription.Encrypt(user.Password); password.OldPassword = ""; password.IsSelfChanged = false; password.CreatedBy = userId; password.CreatedDate = DateTime.Now; _passwordFactory.Add(password); result = _passwordFactory.Save(); } var userInformation = new SEC_UserInformation(); //userInformation.ID = Guid.NewGuid(); if (result.isSucess) { userInformation.EmployeeID = user.EmployeeID; userInformation.CompanyID = user.CompanyID; userInformation.BranchID = user.BranchID; userInformation.UserFullName = user.UserFullName; userInformation.UserName = user.UserName.ToLower().Trim(); userInformation.Address = user.Address; userInformation.Email = user.EMail; userInformation.PhoneNo = user.PhoneNo; userInformation.SecurityQuestionID = question.ID; userInformation.PasswordID = password.ID; userInformation.IsEMailVerified = false; userInformation.IsPhoneNoVerified = false; userInformation.IsActive = true; userInformation.CreatedBy = userId; userInformation.CreatedDate = DateTime.Now; userInformation.UserGroupID = user.UserGroupID; _userFactory.Add(userInformation); result = _userFactory.Save(); } if (result.isSucess) { result.message = result.SaveSuccessfull(tableName); return(Json(result, JsonRequestBehavior.AllowGet)); } else { return(Json(result, JsonRequestBehavior.AllowGet)); } }
public Result SaveMeetingReq(MeetingRoomRequisition meetingRoomReq, List <DAL.db.MeetingParticipant> participantList, List <int> deleteStoreReqDtlsID) { _mrReqFactory = new MeetingRoomReqFactory(); _mrPrFactory = new ParticipantFactory(); try { if (meetingRoomReq.RequisitionID > 0) { _mrReqFactory.Edit(meetingRoomReq); _result = _mrReqFactory.Save(); if (_result.isSucess) { if (deleteStoreReqDtlsID != null) { foreach (var detailsID in deleteStoreReqDtlsID) { _mrPrFactory.Delete(x => x.ParticipantID == detailsID); _result = _mrPrFactory.Save(); } } if (participantList != null) { foreach (var list in participantList) { if (list.ParticipantID < 1) { list.RequisitionID = meetingRoomReq.RequisitionID; _mrPrFactory.Add(list); _result = _mrPrFactory.Save(); if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); } } else { _mrPrFactory.Edit(list); _result = _mrPrFactory.Save(); if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); } } } } } } else { _mrReqFactory.Add(meetingRoomReq); _result = _mrReqFactory.Save(); if (_result.isSucess) { if (participantList != null && participantList.Count > 0) { foreach (var list in participantList) { if (list.ParticipantID < 1) { list.RequisitionID = meetingRoomReq.RequisitionID; _mrPrFactory.Add(list); _result = _mrPrFactory.Save(); if (_result.isSucess) { _result.message = _result.UpdateSuccessfull(tableName); } } } } } } } catch (Exception e) { _mrReqFactory.Delete(meetingRoomReq); _result = _mrReqFactory.Save(); _result.isSucess = false; _result.message = e.Message; } return(_result); }