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