public void Save_Click(object obj) { Mouse.OverrideCursor = Cursors.Wait; bool isSucceed = false; var lstSystemSettings = _serviceInstance.GetSystemSettings(); if (lstSystemSettings.Count() > 0) { prevSettings = null; prevSettings = lstSystemSettings.ToList(); } for (int i = 0; i < ListSettings.Count; i++) { if (ListSettings[i].ValueDescription != prevSettings[i].ValueDescription) { AdminUserProp setting = new AdminUserProp(); setting.ValueDescription = ListSettings[i].ValueDescription; setting.ValueKey = ListSettings[i].ValueKey; _serviceInstance.UpdateSystemSettings(setting); } } isSucceed = true; if (isSucceed) { MessageBox.Show(Resources.msgUpdatedSuccessfully); } Mouse.OverrideCursor = Cursors.Arrow; }
private void Find() { CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgStart, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { //if (string.IsNullOrEmpty(ValueKey) && string.IsNullOrEmpty(ValueDescription)) //{ // return; //} AdminUserProp settings = new AdminUserProp(); settings.ValueKey = ValueKey; settings.ValueDescription = ValueDescription; SystemSettingsList = null; SystemSettingsList = new ObservableCollection <AdminUserProp>(_serviceInstance.FindSystemSettings(settings)); } catch (Exception ex) { LogHelper.LogErrorToDb(ex); bool displayErrorOnUI = false; CommonSettings.logger.LogError(this.GetType(), ex); if (displayErrorOnUI) { throw; } } finally { CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgEnd, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// Delete system settings /// </summary> /// <param name="setting"></param> /// <returns></returns> public bool DeleteSystemSettings(AdminUserProp setting) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool result = false; using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { var settingData = objAppWorksEntities.SettingTables.Where(x => x.ValueKey == setting.ValueKey).FirstOrDefault(); objAppWorksEntities.SettingTables.Remove(settingData); objAppWorksEntities.SaveChanges(); result = true; } return(result); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To Remove the Record of existing User /// </summary> /// <param name="AdminUserProp"></param> /// <returns>void</returns> /// <createdBy></createdBy> /// <createdOn>Apr-28,2016</createdOn> public void RemoveUserDetails(AdminUserProp objAdminUserProp) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { int userId = (from T in objAppWorksEntities.Users where T.UserCode == objAdminUserProp.UserCode && (T.Password == objAdminUserProp.Password || T.PIN == objAdminUserProp.Password) select T.UserID).FirstOrDefault(); if (userId != 0) { var x = (from tblUser in objAppWorksEntities.Users where tblUser.UserID == userId && tblUser.Password == objAdminUserProp.Password select tblUser).FirstOrDefault(); objAppWorksEntities.Users.Remove(x); objAppWorksEntities.SaveChanges(); } } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// add system settings /// </summary> /// <param name="setting"></param> /// <returns></returns> public bool InsertSystemSettings(AdminUserProp setting) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool result = false; using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { SettingTable newSetting = new SettingTable(); newSetting.ValueKey = setting.ValueKey; newSetting.ValueDescription = setting.ValueDescription; objAppWorksEntities.SettingTables.Add(newSetting); objAppWorksEntities.SaveChanges(); result = true; } return(result); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// Function to check the Login Credentials. /// </summary> /// <param name="objAdminUserProp"></param> /// <returns>Bool</returns> /// <createdBy></createdBy> /// <createdOn>Apr-18,2016</createdOn> public bool IsUserExists(AdminUserProp objAdminUserProp, List <RoleList> lstRoles) { using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { bool result = false; CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { // Count Existance of User var count = (from list in objAppWorksEntities.Users where list.UserCode == objAdminUserProp.UserCode select list).Count(); if (Convert.ToInt32(count) == 0) { result = true; AddAdminUser(objAdminUserProp, lstRoles); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(result); } }
/// <summary> /// To Show the Existing Role of User /// </summary> /// <param name="objAdminUserProp"></param> /// <returns>List</returns> /// <createdBy></createdBy> /// <createdOn>Apr-22,2016</createdOn> public List <string> EixstingRoleList(AdminUserProp objAdminUserProp) { List <string> objlstExistsRole = new List <string>(); CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { int userId = (from T in objAppWorksEntities.Users where T.UserCode == objAdminUserProp.UserCode && (T.Password == objAdminUserProp.Password || T.PIN == objAdminUserProp.Password) select T.UserID).FirstOrDefault(); if (userId != 0) { objlstExistsRole = (from tblList in objAppWorksEntities.UserRoles where tblList.UserID == userId select tblList.RoleName).ToList(); } } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(objlstExistsRole); }
private void Save() { CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgStart, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool isSucceed = false; try { if (string.IsNullOrEmpty(ValueKey)) { MessageBox.Show("Enter Value Key"); return; } if (string.IsNullOrEmpty(ValueDescription)) { MessageBox.Show("Enter Value Description"); return; } var list = _serviceInstance.GetSystemSettings(); var exists = list.Where(x => x.ValueKey.Equals(ValueKey, StringComparison.OrdinalIgnoreCase)).FirstOrDefault(); if (exists != null) { MessageBox.Show("Value Key Already Exists"); return; } AdminUserProp setting = new AdminUserProp(); setting.ValueDescription = ValueDescription; setting.ValueKey = ValueKey; _serviceInstance.InsertSystemSettings(setting); SystemSettingsList.Add(setting); isSucceed = true; } catch (Exception ex) { LogHelper.LogErrorToDb(ex); bool displayErrorOnUI = false; CommonSettings.logger.LogError(this.GetType(), ex); if (displayErrorOnUI) { throw; } } finally { if (isSucceed) { MessageBox.Show(Resources.msgInsertedSuccessfully); FindMode(); } CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgEnd, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
private void Update() { CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgStart, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool isSucceed = false; try { if (string.IsNullOrEmpty(ValueKey)) { MessageBox.Show("Enter Value Key"); return; } if (string.IsNullOrEmpty(ValueDescription)) { MessageBox.Show("Enter Value Description"); return; } if (SelectedGridItem != null) { var existingSettings = _serviceInstance.GetSystemSettings(); AdminUserProp setting = new AdminUserProp(); setting.ValueKey = SelectedGridItem.ValueKey; setting.ValueDescription = ValueDescription; _serviceInstance.UpdateSystemSettings(setting); var item = SystemSettingsList.Where(x => x.ValueKey == setting.ValueKey).FirstOrDefault(); SystemSettingsList.Remove(item); systemSettingsList.Add(setting); isSucceed = true; } } catch (Exception ex) { LogHelper.LogErrorToDb(ex); bool displayErrorOnUI = false; CommonSettings.logger.LogError(this.GetType(), ex); if (displayErrorOnUI) { throw; } } finally { if (isSucceed) { MessageBox.Show(Resources.msgUpdatedSuccessfully); ModifyMode(); } CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgEnd, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// Function To Update the user role . /// </summary> /// <param name="objLoginProp"></param> /// <returns>List</returns> /// <createdBy></createdBy> /// <createdOn>Apr-28,2016</createdOn> public void DeleteUserRecord(AdminUserProp objAdminUserProp) { try { AdminUserDAL objAdminUserDAL = new AdminUserDAL(); CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); objAdminUserDAL.RemoveUserDetails(objAdminUserProp); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To Modify the Record of existing User /// </summary> /// <param name="AdminUserProp"></param> /// <returns>List</returns> /// <createdBy></createdBy> /// <createdOn>Apr-28,2016</createdOn> public AdminUserDeatils GetModificationRecord(AdminUserProp objAdminUserProp) { AdminUserDeatils objAdminUserDeatils = new AdminUserDeatils(); using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { objAdminUserDeatils = (from tblUsers in objAppWorksEntities.Users where tblUsers.UserCode == objAdminUserProp.UserCode select new AdminUserDeatils { UserIDInfo = tblUsers.UserID, UserCodeInfo = tblUsers.UserCode, FirstNameInfo = tblUsers.FirstName, LastNameInfo = tblUsers.LastName, PhoneInfo = tblUsers.Phone, ExtentionInfo = tblUsers.PhoneExtension, CellPhoneInfo = tblUsers.CellPhone, FaxNumberInfo = tblUsers.FaxNumber, EmailInfo = tblUsers.EmailAddress, PasswordInfo = tblUsers.Password, PortPassIdInfo = tblUsers.PortPassIDNumber, PinInfo = tblUsers.PIN, LblXOffsetInfo = (decimal)tblUsers.LabelXOffset, LblYOffsetInfo = (decimal)tblUsers.LabelYOffset, EmployeeInfo = tblUsers.EmployeeNumber, RecordStatusInfo = tblUsers.RecordStatus, CreationDateInfo = tblUsers.CreationDate, CreatedByInfo = tblUsers.CreatedBy }).FirstOrDefault(); //= list.ToList(); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(objAdminUserDeatils); } }
/// <summary> /// /// </summary> /// <param name="setting"></param> /// <returns></returns> public bool InsertSystemSettings(AdminUserProp setting) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); AdminUserDAL objAdminUserDAL = new AdminUserDAL(); return(objAdminUserDAL.InsertSystemSettings(setting)); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
private void Delete() { CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgStart, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); bool isSucceed = false; try { if (SelectedGridItem != null) { MessageBoxResult result = MessageBox.Show("Are You Sure to Delete?", "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Cancel || result == MessageBoxResult.No) { return; } AdminUserProp setting = new AdminUserProp(); setting.ValueDescription = SelectedGridItem.ValueDescription; setting.ValueKey = SelectedGridItem.ValueKey; _serviceInstance.DeleteSystemSettings(setting); SystemSettingsList.Remove(SelectedGridItem); isSucceed = true; } } catch (Exception ex) { LogHelper.LogErrorToDb(ex); bool displayErrorOnUI = false; CommonSettings.logger.LogError(this.GetType(), ex); if (displayErrorOnUI) { throw; } } finally { if (isSucceed) { MessageBox.Show(Resources.msgDeleteSuccessfully); ModifyMode(); } CommonSettings.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, Resources.loggerMsgEnd, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// Function to check the Existance of Current User. /// </summary> /// <param name="objLoginProp"></param> /// <returns>Bool</returns> /// <createdBy></createdBy> /// <createdOn>Apr-19,2016</createdOn> public bool IsUserExists(AdminUserProp objAdminUserProp, List <RoleList> lstRoles) { bool result; AdminUserDAL objAdminUserDAL = new AdminUserDAL(); /// Creating The Object of AdminUserDAL CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { result = objAdminUserDAL.IsUserExists(objAdminUserProp, lstRoles); /// Getting The Result of Calling Method IsUserExists. } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(result); }
/// <summary> /// Function To Modify the user role . /// </summary> /// <param name="objLoginProp"></param> /// <returns>List</returns> /// <createdBy></createdBy> /// <createdOn>Apr-28,2016</createdOn> public AdminUserDeatils GetModificationRecord(AdminUserProp objAdminUserProp) { AdminUserDeatils objAdminUserDeatils = new AdminUserDeatils(); AdminUserDAL objAdminUserDAL = new AdminUserDAL(); CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { objAdminUserDeatils = objAdminUserDAL.GetModificationRecord(objAdminUserProp); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(objAdminUserDeatils); }
/// <summary> /// Function To Chanege the user role . /// </summary> /// <param name="objLoginProp"></param> /// <returns>List</returns> /// <createdBy></createdBy> /// <createdOn>Apr-23,2016</createdOn> public List <string> AllRoleList(AdminUserProp objAdminUserProp) { List <string> objlstNewRole = new List <string>(); AdminUserDAL objAdminUserDAL = new AdminUserDAL(); /// Creating The Object of AdminUserDAL CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { //Calling and binding the existing user Role. objlstNewRole = objAdminUserDAL.AllRoleList(objAdminUserProp); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(objlstNewRole); }
/// <summary> /// To Add the All Roles Existing in Application /// </summary> /// <param name="objAdminUserProp"></param> /// <returns>List</returns> /// <createdBy></createdBy> /// <createdOn>Apr-23,2016</createdOn> public List <string> AllRoleList(AdminUserProp objAdminUserProp) { List <string> objlstAllRole = new List <string>(); CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { objlstAllRole = (from tblList in objAppWorksEntities.UserRoles orderby tblList.RoleName select tblList.RoleName).Distinct().ToList(); } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(objlstAllRole); }
/// <summary> /// Find Systems Settings /// </summary> /// <param name="setting"></param> /// <returns></returns> public List <AdminUserProp> FindSystemSettings(AdminUserProp setting) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); List <AdminUserProp> listSettings = new List <AdminUserProp>(); using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { var settingData = objAppWorksEntities.SettingTables.AsQueryable(); if (!string.IsNullOrEmpty(setting.ValueKey)) { settingData = settingData.AsQueryable().Where(x => x.ValueKey.Contains(setting.ValueKey)); } if (!string.IsNullOrEmpty(setting.ValueDescription)) { settingData = settingData.Where(x => x.ValueKey.Contains(setting.ValueDescription)); } listSettings = settingData.Select(x => new AdminUserProp() { ValueKey = x.ValueKey, ValueDescription = x.ValueDescription }).ToList(); } return(listSettings); } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }
/// <summary> /// To Add the Record of existing User /// </summary> /// <param name="objAdminUserProp"></param> /// <returns>Int</returns> /// <createdBy></createdBy> /// <createdOn>Apr-19,2016</createdOn> public int AddAdminUser(AdminUserProp objAdminUserProp, List <RoleList> lstRoles) { using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { int getUserId; CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); try { User objTblUsers = new User(); objTblUsers.UserCode = objAdminUserProp.UserCode; objTblUsers.FirstName = objAdminUserProp.FirstName; objTblUsers.LastName = objAdminUserProp.LastName; objTblUsers.Password = objAdminUserProp.Password; objTblUsers.PIN = objAdminUserProp.PIN; objTblUsers.Phone = objAdminUserProp.Phone; objTblUsers.PhoneExtension = objAdminUserProp.PhoneExtension; objTblUsers.CellPhone = objAdminUserProp.CellPhone; objTblUsers.EmailAddress = objAdminUserProp.EmailAddress; objTblUsers.FaxNumber = objAdminUserProp.FaxNumber; objTblUsers.LabelXOffset = Convert.ToDecimal(objAdminUserProp.LabelXOffset); objTblUsers.LabelYOffset = Convert.ToDecimal(objAdminUserProp.LabelYOffset); objTblUsers.IMEI = objAdminUserProp.IMEI; objTblUsers.LastConnection = objAdminUserProp.LastConnection; if (!string.IsNullOrEmpty(objAdminUserProp.datsVersion)) { objTblUsers.datsVersion = Convert.ToInt16(objAdminUserProp.datsVersion); } objTblUsers.RecordStatus = objAdminUserProp.RecordStatus; objTblUsers.CreationDate = objAdminUserProp.CreationDate; objTblUsers.CreatedBy = objAdminUserProp.CreatedBy; objTblUsers.UpdatedDate = objAdminUserProp.UpdatedDate; objTblUsers.UpdatedBy = objAdminUserProp.UpdatedBy; objTblUsers.EmployeeNumber = objAdminUserProp.EmployeeNumber; objTblUsers.PortPassIDNumber = objAdminUserProp.PortPassIDNumber; objTblUsers.Department = objAdminUserProp.Department; if (!string.IsNullOrEmpty(objAdminUserProp.StraightTimeRate)) { objTblUsers.StraightTimeRate = Convert.ToDecimal(objAdminUserProp.StraightTimeRate); } if (!string.IsNullOrEmpty(objAdminUserProp.PieceRateRate)) { objTblUsers.PieceRateRate = Convert.ToDecimal(objAdminUserProp.PieceRateRate); } if (!string.IsNullOrEmpty(objAdminUserProp.PDIRate)) { objTblUsers.PDIRate = Convert.ToDecimal(objAdminUserProp.PDIRate); } if (!string.IsNullOrEmpty(objAdminUserProp.FlatBenefitPayRate)) { objTblUsers.FlatBenefitPayRate = Convert.ToDecimal(objAdminUserProp.FlatBenefitPayRate); } objTblUsers.AlternateEmailAddress = objAdminUserProp.AlternateEmailAddress; objAppWorksEntities.Users.Add(objTblUsers); /// Insert the Record in Respected Table. objAppWorksEntities.SaveChanges(); /// Check the Chenges in Table After Record Insertion. getUserId = objTblUsers.UserID; /// Return the UserId of Inserted User. /// Insert the Default Role in UserRole Table //UserRole objTblUserRole = new UserRole(); //objTblUserRole.RoleName = "Default Role"; //objTblUserRole.UserID = getUserId; //objTblUserRole.CreationDate = objAdminUserProp.CreationDate; //objTblUserRole.CreatedBy = objAdminUserProp.CreatedBy; //objTblUserRole.UpdatedDate = objAdminUserProp.UpdatedDate; //objTblUserRole.UpdatedBy = objAdminUserProp.UpdatedBy; //objAppWorksEntities.UserRoles.Add(objTblUserRole); //objAppWorksEntities.SaveChanges(); if (lstRoles.Count > 0 && getUserId > 0) { foreach (RoleList role in lstRoles) { if ((bool)role.IsSelected) { UserRole userrole = new UserRole(); userrole.UserID = getUserId; userrole.RoleName = role.RoleName; userrole.CreationDate = DateTime.Now; userrole.CreatedBy = objTblUsers.CreatedBy; objAppWorksEntities.UserRoles.Add(userrole); objAppWorksEntities.SaveChanges(); } } } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } return(getUserId); } }
/// <summary> /// To Update the Modified Record of existing User /// </summary> /// <param name="AdminUserProp"></param> /// <returns>void</returns> /// <createdBy></createdBy> /// <createdOn>Apr-28,2016</createdOn> public void UpdateUserDetails(AdminUserProp objAdminUserProp, List <RoleList> lstRoles) { try { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "Called {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); using (PortStorageEntities objAppWorksEntities = new PortStorageEntities()) { var objTblUsers = (from qry in objAppWorksEntities.Users where qry.UserCode == objAdminUserProp.UserCode select qry).FirstOrDefault();//objAppWorksEntities.Users.Find(objAdminUserProp.UserCode); if (objTblUsers != null) { objTblUsers.UserCode = objAdminUserProp.UserCode; objTblUsers.FirstName = objAdminUserProp.FirstName; objTblUsers.LastName = objAdminUserProp.LastName; objTblUsers.Password = objAdminUserProp.Password; objTblUsers.PIN = objAdminUserProp.PIN; objTblUsers.Phone = objAdminUserProp.Phone; objTblUsers.PhoneExtension = objAdminUserProp.PhoneExtension; objTblUsers.CellPhone = objAdminUserProp.CellPhone; objTblUsers.EmailAddress = objAdminUserProp.EmailAddress; objTblUsers.FaxNumber = objAdminUserProp.FaxNumber; objTblUsers.LabelXOffset = Convert.ToDecimal(objAdminUserProp.LabelXOffset); objTblUsers.LabelYOffset = Convert.ToDecimal(objAdminUserProp.LabelYOffset); objTblUsers.IMEI = objAdminUserProp.IMEI; objTblUsers.LastConnection = objAdminUserProp.LastConnection; if (objAdminUserProp.datsVersion != "") { objTblUsers.datsVersion = Convert.ToInt16(objAdminUserProp.datsVersion); } objTblUsers.RecordStatus = objAdminUserProp.RecordStatus; objTblUsers.CreationDate = objAdminUserProp.CreationDate; objTblUsers.CreatedBy = objAdminUserProp.CreatedBy; objTblUsers.UpdatedDate = objAdminUserProp.UpdatedDate; objTblUsers.UpdatedBy = objAdminUserProp.UpdatedBy; objTblUsers.EmployeeNumber = objAdminUserProp.EmployeeNumber; objTblUsers.PortPassIDNumber = objAdminUserProp.PortPassIDNumber; objTblUsers.Department = objAdminUserProp.Department; if (objAdminUserProp.StraightTimeRate != "") { objTblUsers.StraightTimeRate = Convert.ToDecimal(objAdminUserProp.StraightTimeRate); } if (objAdminUserProp.PieceRateRate != "") { objTblUsers.PieceRateRate = Convert.ToDecimal(objAdminUserProp.PieceRateRate); } if (objAdminUserProp.PDIRate != "") { objTblUsers.PDIRate = Convert.ToDecimal(objAdminUserProp.PDIRate); } if (objAdminUserProp.FlatBenefitPayRate != "") { objTblUsers.FlatBenefitPayRate = Convert.ToDecimal(objAdminUserProp.FlatBenefitPayRate); } objTblUsers.AlternateEmailAddress = objAdminUserProp.AlternateEmailAddress; objAppWorksEntities.SaveChanges(); if (lstRoles.Count > 0) { var lstUserRoles = (from roles in objAppWorksEntities.UserRoles where roles.UserID == objAdminUserProp.UserID select roles); if (lstUserRoles.Count() > 0) { foreach (UserRole urole in lstUserRoles.ToList()) { objAppWorksEntities.UserRoles.Remove(urole); objAppWorksEntities.SaveChanges(); } } foreach (RoleList role in lstRoles) { if ((bool)role.IsSelected) { UserRole userrole = new UserRole(); userrole.UserID = objAdminUserProp.UserID; userrole.RoleName = role.RoleName; userrole.CreationDate = DateTime.Now; userrole.CreatedBy = objTblUsers.CreatedBy; objAppWorksEntities.UserRoles.Add(userrole); objAppWorksEntities.SaveChanges(); } } } } } } catch (Exception) { throw; } finally { CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name)); } }