public CustomerLoginModel IsUserExist(CustomerLoginModel _Dto, string userip)
{
try
{
//using (DatabaseEntities DatabaseEntities = new DatabaseEntities())
//{
db = new DatabaseEntities();
//string dd = PasswordManager.DecryptText("aWIbcZIuvxlFajh8TMADjrxSKlmndmUM");
string EMPPassword = PasswordManager.CryptText(_Dto.EMPPassword);
//string EMPPasswordTest = PasswordManager.DecryptText(_Dto.EMPPassword);
var data = (from user in db.UserMasters
join entMas in db.EntityMasters on user.EntityId equals entMas.Id
where user.UserName == _Dto.EMPUserId && user.Password == EMPPassword // _Dto.EMPPassword
select new { user, entMas }).FirstOrDefault();
if (data != null)
{
_Dto.Id = data.user.Id;
_Dto.CustomerOfficeId = data.user.Id;
//_Dto.EFIN = data.Id;
_Dto.TaxOfficeUsername = data.user.UserName;
_Dto.CrossLinkUserId = data.user.UserName;
_Dto.EntityID = data.user.EntityId;//.ToString();
_Dto.IsChangedPassword = true;
_Dto.IsSetSecurityQuestion = true;
//_Dto.EntityDisplayID = data.entMas.Id;
_Dto.BaseEntityId = data.entMas.BaseEntityId;
_Dto.IsActivationCompleted = 1;
_Dto.IsVerified = true;
_Dto.uTaxNotCollectingSBFee = true;
var permissions = new Sitemap.SitemapService().GetUserRolePermissions(data.user.Id);
_Dto.IsnewCustomers = permissions.NewCustomer.ViewPermission;
_Dto.IsOfficeMgmt = permissions.OfficeManamgement.ViewPermission;
_Dto.FeeReport = permissions.ReportPermissions.FeeReport;
_Dto.NoBankApp = permissions.ReportPermissions.NoBankApp;
_Dto.Enrollstatus = permissions.ReportPermissions.Enrollstatus;
_Dto.LoginReport = permissions.ReportPermissions.LoginReport;
}
if (data != null)
{
_Dto.Token = _TokenService.GenerateToken(data.user.Id, userip);
}
else
{
_Dto = Get(_Dto, userip);
}
return(_Dto);
// }
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "CustomerLogin/IsUserExist", Guid.Empty);
return(null);
}
}
public AccountDTO IsUserExist(string userName, string password)
{
//string ClientIP = Request.GetClientIpAddress();
using (DatabaseEntities DatabaseEntities = new DatabaseEntities())
{
string uTaxPassword = PasswordManager.CryptText(password);
var usermaster = (from user in DatabaseEntities.UserMasters
where user.UserName == userName && user.Password == uTaxPassword//password
select user).FirstOrDefault();
if (usermaster != null)
{
_AccountDto.Id = usermaster.Id;
_AccountDto.Email = usermaster.EmailAddress;
_AccountDto.Name = usermaster.FirstName + " " + usermaster.LastName;
_AccountDto.UserName = usermaster.UserName;
_AccountDto.Token = _TokenService.GenerateToken(_AccountDto.Id);
usermaster.LastLoginDate = DateTime.Now;
db.Entry(usermaster).State = System.Data.Entity.EntityState.Modified;
DatabaseEntities.SaveChanges();
}
return(_AccountDto);
}
}
public bool ResetPassword(string passwordHash, Guid UserId)
{
try
{
using (DatabaseEntities DatabaseEntities = new DatabaseEntities())
{
string uTaxPassword = PasswordManager.CryptText(passwordHash);
var usermaster = (from user in DatabaseEntities.UserMasters
where user.Id == UserId
select user).FirstOrDefault();
usermaster.LastLoginDate = DateTime.Now;
db.Entry(usermaster).State = System.Data.Entity.EntityState.Modified;
usermaster.Password = uTaxPassword;// passwordHash;
DatabaseEntities.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
throw ex.InnerException;
}
finally
{
}
}
public bool SaveMyPassword(string currentpassword, string password, Guid Id)
{
try
{
var IsCorrect = false;
emp_CustomerLoginInformation _CustomerLoginInformation = new emp_CustomerLoginInformation();
string EMPPassword = PasswordManager.CryptText(currentpassword);
_CustomerLoginInformation = db.emp_CustomerLoginInformation.Where(o => o.CustomerOfficeId == Id && o.EMPPassword == EMPPassword).FirstOrDefault();
if (_CustomerLoginInformation != null)
{
string uTaxPassword = PasswordManager.CryptText(password);
_CustomerLoginInformation.EMPPassword = uTaxPassword;// password;
_CustomerLoginInformation.StatusCode = EMPConstants.Active;
_CustomerLoginInformation.LastUpdatedBy = Id;
_CustomerLoginInformation.LastUpdatedDate = DateTime.Now;
db.Entry(_CustomerLoginInformation).State = System.Data.Entity.EntityState.Modified;
IsCorrect = true;
}
else
{
var UserMaster = db.UserMasters.Where(o => o.Id == Id && o.Password == EMPPassword).FirstOrDefault();
if (UserMaster != null)
{
string uTaxPassword = PasswordManager.CryptText(password);
UserMaster.Password = uTaxPassword;// password;
UserMaster.StatusCode = EMPConstants.Active;
UserMaster.LastUpdatedBy = Id;
UserMaster.LastUpdatedDate = DateTime.Now;
db.Entry(UserMaster).State = System.Data.Entity.EntityState.Modified;
IsCorrect = true;
}
}
if (!IsCorrect)
{
return(false);
}
try
{
db.SaveChanges();
return(true);
}
catch (DbUpdateConcurrencyException ex)
{
ExceptionLogger.LogException(ex.ToString(), "ChangePassword/update", Id);
return(false);
}
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "ChangePassword/update", Id);
return(false);
}
}
public string updatexlinkdetails(xlinkModel model)
{
try
{
db = new DatabaseEntities();
var isexist = (from s in db.UtaxCrosslinkDetails
where s.CLAccountId == model.CLAccountId && s.StatusCode == EMPConstants.Active
select s).FirstOrDefault();
if (model.Id == 0)
{
if (isexist != null)
return "Exists";
UtaxCrosslinkDetail detail = new UtaxCrosslinkDetail();
detail.CreatedBy = model.UserId;
detail.CreatedDate = DateTime.Now;
detail.Password = model.Password == "" ? "" : PasswordManager.CryptText(model.Password);
detail.StatusCode = EMPConstants.Active;
detail.CLAccountId = model.CLAccountId;
detail.CLAccountPassword = PasswordManager.CryptText(model.CLAccountPassword);
detail.CLLogin = model.CLLogin;
detail.UpdatedBy = model.UserId;
detail.UpdatedDate = DateTime.Now;
detail.Username = model.MasterId;
db.UtaxCrosslinkDetails.Add(detail);
db.SaveChanges();
}
else if (model.Id != 0)
{
if (isexist != null)
{
if (isexist.Id != model.Id)
return "Exists";
}
var data = db.UtaxCrosslinkDetails.Where(x => x.Id == model.Id).FirstOrDefault();
if (data != null)
{
data.Username = model.MasterId;
data.Password = model.Password == "" ? "" : PasswordManager.CryptText(model.Password);
data.StatusCode = EMPConstants.Active;
data.CLAccountId = model.CLAccountId;
data.CLAccountPassword = PasswordManager.CryptText(model.CLAccountPassword);
data.CLLogin = model.CLLogin;
data.UpdatedBy = model.UserId;
data.UpdatedDate = DateTime.Now;
db.SaveChanges();
}
}
return "Success";
}
catch (Exception)
{
return "Fail";
}
}
public Guid Save(ResetPasswordModel _Dto, Guid Id, int EntityState)
{
try
{
emp_CustomerLoginInformation _CustomerLoginInformation = new emp_CustomerLoginInformation();
if (_Dto != null)
{
string EMPPassword = PasswordManager.CryptText(_Dto.EMPPassword);
_CustomerLoginInformation.Id = Id;
_CustomerLoginInformation.EMPPassword = EMPPassword;
_CustomerLoginInformation.CustomerOfficeId = _Dto.CustomerOfficeId;
_CustomerLoginInformation.CreatedDate = DateTime.Now;
_CustomerLoginInformation.StatusCode = EMPConstants.Active;
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
_CustomerLoginInformation.LastUpdatedBy = _Dto.UserId;
_CustomerLoginInformation.LastUpdatedDate = DateTime.Now;
db.Entry(_CustomerLoginInformation).State = System.Data.Entity.EntityState.Modified;
}
else
{
_CustomerLoginInformation.CreatedBy = _Dto.UserId;
_CustomerLoginInformation.CreatedDate = DateTime.Now;
_CustomerLoginInformation.LastUpdatedBy = _Dto.UserId;
_CustomerLoginInformation.LastUpdatedDate = DateTime.Now;
db.emp_CustomerLoginInformation.Add(_CustomerLoginInformation);
}
try
{
db.SaveChanges();
return(_CustomerLoginInformation.Id);
}
catch (DbUpdateConcurrencyException)
{
if (!IsExists(_CustomerLoginInformation.Id))
{
return(_CustomerLoginInformation.Id);
}
else
{
return(Guid.Empty);
}
}
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "ResetPassword/PostResetPassword", Id);
return(Guid.Empty);
}
}
// public DatabaseEntities db = new DatabaseEntities();
//public IQueryable<ChangePasswordModel> GetAll()
//{
// db = new DatabaseEntities();
// var data = db.emp_CustomerLoginInformation.Select(o => new ChangePasswordModel
// {
// Id = o.Id,
// EMPPassword = o.EMPPassword,
// CustomerOfficeId = o.CustomerOfficeId,
// StatusCode = o.StatusCode
// }).DefaultIfEmpty();
// return data;
//}
public CustomerLoginModel Get(CustomerLoginModel _Dto, string userip)
{
try
{
DropDownService ddService = new DropDownService();
List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>();
db = new DatabaseEntities();
//var data2 = db.emp_CustomerLoginInformation.ToList();
string EMPPassword = PasswordManager.CryptText(_Dto.EMPPassword); // _Dto.EMPPassword
var data = (from ci in db.emp_CustomerInformation
join cli in db.emp_CustomerLoginInformation on ci.Id equals cli.CustomerOfficeId
join entMas in db.EntityMasters on ci.EntityId equals entMas.Id
where cli.EMPUserId == _Dto.EMPUserId && cli.EMPPassword == EMPPassword && (ci.StatusCode == EMPConstants.Active || ci.StatusCode == EMPConstants.Pending)
//&& ci.IsHold != true//ci.StatusCode == EMPConstants.Created ||
select new { ci, cli, EntityId = entMas.Id, entMas.BaseEntityId }).FirstOrDefault();
if (data != null)
{
if ((data.ci.IsHold ?? false) && data.ci.EntityId != (int)EMPConstants.Entity.SO && data.ci.EntityId != (int)EMPConstants.Entity.MO && data.ci.EntityId != (int)EMPConstants.Entity.SVB)
{
_Dto.Id = Guid.Empty;
_Dto.Message = "Your site has been placed on hold, please contact your Software Provider";
return(_Dto);
}
_Dto.Id = data.cli.Id;
_Dto.CustomerOfficeId = data.cli.CustomerOfficeId;
//11212016
_Dto.EFIN = data.ci.EFIN;
_Dto.EFINStatus = data.ci.EFINStatus;
_Dto.TaxOfficeUsername = data.cli.TaxOfficeUsername;
_Dto.CrossLinkUserId = data.cli.CrossLinkUserId;
_Dto.IsChangedPassword = (data.cli.CrossLinkPassword == data.cli.EMPPassword) ? true : false;
_Dto.IsSetSecurityQuestion = db.SecurityAnswerUserMaps.Where(o => o.UserId == data.cli.CustomerOfficeId).Any();
_Dto.Token = _TokenService.GenerateToken(data.ci.Id, userip);
_Dto.ParentID = data.ci.ParentId.ToString();
_Dto.SalesYearID = data.ci.SalesYearID.ToString();
//_Dto.EntityDisplayID = data.DisplayId;
_Dto.BaseEntityId = data.BaseEntityId;
// _Dto.EntityID = data.EntityId;
_Dto.EntityID = data.ci.EntityId;//.ToString();
_Dto.IsMSOUser = data.ci.IsMSOUser ?? false;
_Dto.IsActivationCompleted = data.ci.IsActivationCompleted ?? 0;
_Dto.IsEnrollmentSubmit = new SubSiteFeeService().IsEnrollmentSubmit(data.ci.Id);
_Dto.IsVerified = data.ci.IsVerified ?? false;
_Dto.uTaxNotCollectingSBFee = data.ci.uTaxNotCollectingSBFee ?? false;
_Dto.IsTaxReturn = true;
if (data.ci.ParentId == Guid.Empty || data.ci.ParentId == null)
{
var taxreturn = db.MainOfficeConfigurations.Where(x => x.emp_CustomerInformation_ID == data.ci.Id && x.StatusCode == EMPConstants.Active).FirstOrDefault();
if (taxreturn != null)
{
_Dto.IsTaxReturn = taxreturn.IsSiteTransmitTaxReturns;
}
}
_Dto.IsHold = data.ci.IsHold ?? false;
Guid TopParentId = Guid.Empty;
EntityHierarchyDTOs = ddService.GetEntityHierarchies(data.ci.Id);
var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault();
TopParentId = TopFromHierarchy.CustomerId ?? Guid.Empty;
DefaultBankModel DefaultBank = new DefaultBankModel();
DefaultBank = (from enrollbank in db.EnrollmentBankSelections
where enrollbank.CustomerId == data.cli.CustomerOfficeId && enrollbank.StatusCode == EMPConstants.Active && enrollbank.BankSubmissionStatus == 1
orderby enrollbank.BankSubmissionStatus descending, enrollbank.LastUpdatedDate descending
select new DefaultBankModel {
BankId = enrollbank.BankId, BankSubmissionStatus = enrollbank.BankSubmissionStatus ?? 0, LastUpdatedDate = enrollbank.LastUpdatedDate
}).FirstOrDefault();
if (DefaultBank != null)
{
_Dto.BankId = DefaultBank.BankId;
}
else
{
DefaultBankModel DefaultBank2 = (from enrollbank in db.EnrollmentBankSelections
where enrollbank.CustomerId == data.cli.CustomerOfficeId && enrollbank.StatusCode == EMPConstants.Active
orderby enrollbank.BankSubmissionStatus descending, enrollbank.LastUpdatedDate descending
select new DefaultBankModel {
BankId = enrollbank.BankId, BankSubmissionStatus = enrollbank.BankSubmissionStatus ?? 0, LastUpdatedDate = enrollbank.LastUpdatedDate
}).FirstOrDefault();
if (DefaultBank2 != null)
{
_Dto.BankId = DefaultBank2.BankId;
}
}
if (_Dto.EntityID != (int)EMPConstants.Entity.SO && _Dto.EntityID != (int)EMPConstants.Entity.SOME && _Dto.EntityID != (int)EMPConstants.Entity.SOME_SS && _Dto.BankId != Guid.Empty)
{
var SSBConfig = db.SubSiteBankConfigs.Where(o => o.emp_CustomerInformation_ID == TopParentId && o.BankMaster_ID == _Dto.BankId).ToList();
if (SSBConfig.Count() == 0)
{
_Dto.BankId = Guid.Empty;
}
}
if (TopParentId != Guid.Empty)
{
if (TopParentId == data.ci.Id)
{
_Dto.CanSubSiteLoginToEmp = true;
}
else
{
if (_Dto.BaseEntityId == (int)EMPConstants.BaseEntities.AE_SS)
{
// _Dto.CanSubSiteLoginToEmp = db.SubSiteOfficeConfigs.Where(a => a.RefId.ToString() == _Dto.ParentID).Select(a => a.CanSubSiteLoginToEmp ?? false).FirstOrDefault();
//var SupParentData = db.emp_CustomerInformation.Where(o => o.Id == data.ci.ParentId).FirstOrDefault();
//if (SupParentData != null)
//{
_Dto.SupParentID = TopParentId.ToString();
var sscExist = (from ssc in db.SubSiteConfigurations where ssc.emp_CustomerInformation_ID == TopParentId select ssc).FirstOrDefault();
if (sscExist != null)
{
if (sscExist.IsuTaxManageingEnrolling == true)
{
_Dto.CanSubSiteLoginToEmp = true;
}
else
{
if (sscExist.IsuTaxPortalEnrollment == true)
{
_Dto.CanSubSiteLoginToEmp = true;
}
else
{
_Dto.CanSubSiteLoginToEmp = false;
}
}
}
var subSiteOfficeCo = (from ssc in db.SubSiteOfficeConfigs where ssc.RefId == _Dto.CustomerOfficeId select ssc).FirstOrDefault();
if (subSiteOfficeCo != null)
{
if (subSiteOfficeCo.EFINListedOtherOffice == false)
{
_Dto.EFINOwnerUserId = false;
}
else
{
if (subSiteOfficeCo.SiteOwnthisEFIN == false)
{
_Dto.EFINOwnerUserId = true;
}
else
{
_Dto.EFINOwnerUserId = false;
}
}
}
//}
}
else
{
// _Dto.CanSubSiteLoginToEmp = db.SubSiteConfigurations.Where(a => a.emp_CustomerInformation_ID.ToString() == _Dto.ParentID).Select(a => a.CanSubSiteLoginToEmp).FirstOrDefault();
var sscExist = (from ssc in db.SubSiteConfigurations where ssc.emp_CustomerInformation_ID == TopParentId select ssc).FirstOrDefault();
if (sscExist != null)
{
if (sscExist.IsuTaxManageingEnrolling == true)
{
_Dto.CanSubSiteLoginToEmp = true;
}
else
{
if (sscExist.IsuTaxPortalEnrollment == true)
{
_Dto.CanSubSiteLoginToEmp = true;
}
else
{
_Dto.CanSubSiteLoginToEmp = false;
}
}
}
var subSiteOfficeCo = (from ssc in db.SubSiteOfficeConfigs where ssc.RefId == _Dto.CustomerOfficeId select ssc).FirstOrDefault();
if (subSiteOfficeCo != null)
{
if (subSiteOfficeCo.EFINListedOtherOffice == false)
{
_Dto.EFINOwnerUserId = false;
}
else
{
if (subSiteOfficeCo.SiteOwnthisEFIN == false)
{
_Dto.EFINOwnerUserId = true;
}
else
{
_Dto.EFINOwnerUserId = false;
}
}
}
}
}
}
else
{
_Dto.CanSubSiteLoginToEmp = true;
}
if (_Dto.EntityID == (int)EMPConstants.Entity.SOME_SS)
{
_Dto.CanSubSiteLoginToEmp = true;
}
EntityHierarchyDTOs = ddService.GetEntityHierarchies(_Dto.Id);
Guid ParentId = Guid.Empty;
int Level = EntityHierarchyDTOs.Count;
if (EntityHierarchyDTOs.Count > 0)
{
var LevelOne = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault();
if (LevelOne != null)
{
ParentId = LevelOne.CustomerId ?? Guid.Empty;
}
if (EntityHierarchyDTOs.Count > 1)
{
_Dto.IsMSOUser = db.emp_CustomerInformation.Where(o => o.Id == ParentId).Select(o => o.IsMSOUser).FirstOrDefault() ?? false;
}
}
}
else
{
return(null);
}
return(_Dto);
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "CustomerLogin/Get", Guid.Empty);
return(null);
}
}
public async Task<int> SaveUser(UserDetailDTO _user, Guid Id, int EntityState)
{
UserMaster usermaster = new UserMaster();
string Password = "";
if (_user != null)
{
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var Existuser = db.UserMasters.Where(o => o.Id != Id && o.UserName == _user.UserName).Any();
if (Existuser)
return -1;
usermaster = db.UserMasters.Where(o => o.Id == Id).FirstOrDefault();
}
else
{
var Existuser = db.UserMasters.Where(o => o.UserName == _user.UserName).Any();
if (Existuser)
return -1;
Password = GetRandomPassword();
usermaster.Password = PasswordManager.CryptText(Password); //"admin1"
}
//usermaster.Id = "";
usermaster.Id = Id;
usermaster.EntityId = _user.EntityId;
usermaster.CustomerId = _user.CustomerId;
usermaster.FirstName = _user.FirstName;
usermaster.LastName = _user.LastName;
// usermaster.MiddleName = _user.MiddleName;
usermaster.UserName = _user.UserName;
usermaster.EmailAddress = _user.EmailAddress;
usermaster.IsEmailConfirmed = _user.IsEmailConfirmed;
usermaster.EmailConfirmationCode = _user.EmailConfirmationCode;
usermaster.PasswordResetCode = _user.PasswordResetCode;
usermaster.LastLoginDate = _user.LastLoginDate;
usermaster.IsActive = true;
usermaster.IsActiveDate = DateTime.Now;
usermaster.StatusCode = EMPConstants.Active;
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
usermaster.CreatedBy = _user.UserId;
usermaster.CreatedDate = DateTime.Now;
usermaster.LastUpdatedDate = DateTime.Now;
usermaster.LastUpdatedBy = _user.UserId;
db.Entry(usermaster).State = System.Data.Entity.EntityState.Modified;
}
else
{
usermaster.LastUpdatedDate = DateTime.Now;
usermaster.LastUpdatedBy = _user.UserId;
db.UserMasters.Add(usermaster);
EmailNotification _email = new EmailNotification();
_email.CreatedBy = _user.UserId;
_email.CreatedDate = DateTime.Now;
_email.EmailCC = "";
_email.EmailContent = "";
_email.EmailSubject = EMPConstants.NewUserMailSubject;
_email.EmailTo = _user.EmailAddress;
_email.EmailType = (int)EMPConstants.EmailTypes.NewAdminUser;
_email.IsSent = false;
_email.Parameters = _user.UserName + "$|$" + Password;
db.EmailNotifications.Add(_email);
}
// User Group Mapping Saving
UserGroupMap usergroup = new UserGroupMap();
UserGroupMapDTO UserGroupMapDto = await _UserGroupService.GetByUserId(usermaster.Id);
bool IsNewGroup = true;
if (UserGroupMapDto != null)
{
if (UserGroupMapDto.Id != Guid.Empty)
{
IsNewGroup = false;
usergroup.Id = UserGroupMapDto.Id;
usergroup.GroupId = _user.Groups.Id;
usergroup.UserId = usermaster.Id;
usergroup.StatusCode = EMPConstants.Active;
db.Entry(usergroup).State = System.Data.Entity.EntityState.Modified;
}
}
if (IsNewGroup)
{
usergroup.Id = Guid.NewGuid();
usergroup.GroupId = _user.Groups.Id;
usergroup.UserId = usermaster.Id;
usergroup.StatusCode = EMPConstants.Active;
db.UserGroupMaps.Add(usergroup);
}
if (_user.Roles.ToList().Count > 0)
{
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var UserRole1 = db.UserRolesMaps.Where(o => o.UserId == _user.Id).ToList();
if (UserRole1.Count() > 0)
db.UserRolesMaps.RemoveRange(UserRole1);
}
List<UserRolesMap> _UserRolesMapList = new List<UserRolesMap>();
foreach (RoleDTO Role in _user.Roles)
{
UserRolesMap _UserRolesMap = new UserRolesMap();
_UserRolesMap.Id = Guid.NewGuid();
_UserRolesMap.UserId = usermaster.Id;
_UserRolesMap.RoleId = Role.Id;
_UserRolesMap.StatusCode = EMPConstants.Active;
_UserRolesMapList.Add(_UserRolesMap);
}
db.UserRolesMaps.AddRange(_UserRolesMapList);
}
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return 1;
}
catch (DbUpdateConcurrencyException)
{
return 0;
}
}
public int Save(CustomerLoginInformationModel model)
{
int entityState = 0;
emp_CustomerLoginInformation customerLoginInformation = new emp_CustomerLoginInformation();
if (model != null)
{
Guid newguid1;
Guid CustomerOfficeId = model.CustomerOfficeId ?? Guid.Empty;
if (Guid.TryParse(model.Id, out newguid1))
{
//var ExistCust = db.emp_CustomerLoginInformation.Any(a => a.EFIN == model.EFIN && a.Id != newguid1);
//if (ExistCust)
// return -1;
//11212016 - If
int EFIN = model.EFIN ?? 0;
if (EFIN > 0 && (model.EFINStatus == 16 || model.EFINStatus == 19))
{
//if (CustomerOfficeId != Guid.Empty)
//{
var ExistCust = db.emp_CustomerInformation.Any(a => a.EFIN == model.EFIN && a.Id != CustomerOfficeId);
if (ExistCust)
{
return(-1);
}
//}
}
var ExistCrossCust = db.emp_CustomerLoginInformation.Any(a => a.CrossLinkUserId == model.CrossLinkUserId && a.Id != newguid1);
if (ExistCrossCust)
{
return(-2);
}
}
if (string.IsNullOrEmpty(model.Id))
{
customerLoginInformation.Id = Guid.NewGuid();
}
else
{
Guid newguid;
if (Guid.TryParse(model.Id, out newguid))
{
customerLoginInformation.Id = newguid;
entityState = (int)System.Data.Entity.EntityState.Modified;
}
}
// customerLoginInformation.EFIN = model.EFIN;
customerLoginInformation.MasterIdentifier = model.MasterIdentifier;
customerLoginInformation.CrossLinkUserId = model.CrossLinkUserId;
customerLoginInformation.CrossLinkPassword = PasswordManager.CryptText(model.CrossLinkPassword);// model.CrossLinkPassword;
customerLoginInformation.OfficePortalUrl = model.OfficePortalUrl;
customerLoginInformation.TaxOfficeUsername = model.TaxOfficeUsername;
customerLoginInformation.TaxOfficePassword = PasswordManager.CryptText(model.TaxOfficePassword); // model.TaxOfficePassword;
customerLoginInformation.CustomerOfficeId = model.CustomerOfficeId;
customerLoginInformation.EMPPassword = PasswordManager.CryptText(model.EMPPassword); //model.EMPPassword;
customerLoginInformation.EMPUserId = model.EMPUserId;
customerLoginInformation.StatusCode = EMPConstants.Active;
customerLoginInformation.CLAccountId = model.CLAccountId;
customerLoginInformation.CLLogin = model.CLLogin;
customerLoginInformation.CLAccountPassword = string.IsNullOrEmpty(model.CLAccountPassword) ? "" : PasswordManager.CryptText(model.CLAccountPassword);
if (entityState == (int)System.Data.Entity.EntityState.Modified)
{
customerLoginInformation.CreatedDate = DateTime.Now;
customerLoginInformation.LastUpdatedDate = DateTime.Now;
customerLoginInformation.LastUpdatedBy = model.UserId;
customerLoginInformation.CreatedBy = model.UserId;
db.Entry(customerLoginInformation).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.Entry(customerLoginInformation).State = System.Data.Entity.EntityState.Added;
customerLoginInformation.LastUpdatedBy = model.UserId;
customerLoginInformation.LastUpdatedDate = DateTime.Now;
db.emp_CustomerLoginInformation.Add(customerLoginInformation);
}
emp_CustomerInformation empCustInfo = new emp_CustomerInformation();
empCustInfo = db.emp_CustomerInformation.Where(o => o.Id == model.CustomerOfficeId).FirstOrDefault();
if (empCustInfo != null)
{
//11212016 - 2
empCustInfo.EFIN = model.EFIN;
empCustInfo.EFINStatus = model.EFINStatus;
empCustInfo.StatusCode = empCustInfo.IsActivationCompleted == 1 ? EMPConstants.Active : EMPConstants.Created;
empCustInfo.CreatedBy = model.UserId;
empCustInfo.LastUpdatedBy = model.UserId;
if (empCustInfo.EntityId == (int)EMPConstants.Entity.SO || empCustInfo.EntityId == (int)EMPConstants.Entity.SOME)
{
if (empCustInfo.StatusCode == EMPConstants.Active || empCustInfo.IsActivationCompleted == 1)
{
empCustInfo.StatusCode = EMPConstants.Active;
empCustInfo.IsActivationCompleted = 1;
empCustInfo.AccountStatus = "Active";
if (empCustInfo.EntityId == (int)EMPConstants.Entity.SO)
{
empCustInfo.EROType = "Single Office";
}
else if (empCustInfo.EntityId == (int)EMPConstants.Entity.SOME)
{
empCustInfo.EROType = "SOME";
}
}
}
empCustInfo.CreatedDate = System.DateTime.Now;
empCustInfo.LastUpdatedDate = System.DateTime.Now;
db.Entry(empCustInfo).State = System.Data.Entity.EntityState.Modified;
}
}
try
{
db.SaveChanges();
db.Dispose();
if (model != null)
{
if (model.CustomerOfficeId != Guid.Empty)
{
DropDownService ddService = new DropDownService();
var items = ddService.GetBottomToTopHierarchy(model.CustomerOfficeId ?? Guid.Empty);
}
}
return(1);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerLoginInformationService/Save", Guid.Empty);
return(0);
throw;
}
}
