protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
protected override void Dispose(bool disposing)
{
if (_db != null)
{
_db.Dispose();
}
base.Dispose(disposing);
}
public async Task <Guid> SaveStatus(PhoneTypeDTO _Dto, Guid Id, int EntityState)
{
PhoneTypeMaster PhoneType = new PhoneTypeMaster();
PhoneType = await db.PhoneTypeMasters.Where(o => o.Id == Id).FirstOrDefaultAsync();
PhoneType.ActivatedDate = DateTime.Now;
if (PhoneType.StatusCode == EMPConstants.InActive)
{
PhoneType.StatusCode = EMPConstants.Active;
}
else if (PhoneType.StatusCode == EMPConstants.Active)
{
PhoneType.StatusCode = EMPConstants.InActive;
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
PhoneType.LastUpdatedDate = DateTime.Now;
PhoneType.LastUpdatedBy = _Dto.UserId;
db.Entry(PhoneType).State = System.Data.Entity.EntityState.Modified;
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return(PhoneType.Id);
}
catch (DbUpdateConcurrencyException)
{
if (!IsExists(PhoneType.Id))
{
return(Guid.Empty);
}
else
{
throw;
}
}
}
public async Task <Guid> SaveStatus(BankSubQuestionDTO _Dto, Guid Id, int EntityState)
{
BankSubQuestion bankSubQuestion = new BankSubQuestion();
bankSubQuestion = await db.BankSubQuestions.Where(o => o.Id == Id).FirstOrDefaultAsync();
if (bankSubQuestion.StatusCode == EMPConstants.InActive)
{
bankSubQuestion.StatusCode = EMPConstants.Active;
}
else if (bankSubQuestion.StatusCode == EMPConstants.Active)
{
bankSubQuestion.StatusCode = EMPConstants.InActive;
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
bankSubQuestion.LastUpdatedDate = DateTime.Now;
bankSubQuestion.LastUpdatedBy = _Dto.UserId;
db.Entry(bankSubQuestion).State = System.Data.Entity.EntityState.Modified;
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return(bankSubQuestion.Id);
}
catch (DbUpdateConcurrencyException)
{
if (!IsExists(bankSubQuestion.Id))
{
return(Guid.Empty);
}
else
{
throw;
}
}
}
/// <summary>
/// This Method is used to update Amount for Customer Associated Fees
/// </summary>
/// <param name="tmDto"></param>
/// <returns></returns>
public bool UpdateCustomerAssociatedFees(TransmitterFeeDTO tmDto)
{
bool iretval = false;
//int entityState = 0;
try
{
if (tmDto != null)
{
Guid newguid, newguid2;
bool IsRefId = Guid.TryParse(tmDto.FeeMaster_ID, out newguid2);
bool IsRefId1 = Guid.TryParse(tmDto.refId, out newguid);
CustomerAssociatedFee customerassociatedfee = new CustomerAssociatedFee();
var data = db.CustomerAssociatedFees.Where(a => a.emp_CustomerInformation_ID == newguid && a.FeeMaster_ID == newguid2 && a.IsActive == true).FirstOrDefault();
if (data != null)
{
customerassociatedfee = data;
customerassociatedfee.LastUpdatedBy = tmDto.UserId ?? Guid.Empty;
customerassociatedfee.LastUpdatedDate = System.DateTime.Now;
customerassociatedfee.IsActive = false;
db.Entry(customerassociatedfee).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
//EMP.Core.Utilities.AuditLogger.AudittrailLog(customerassociatedfee, data, "Modify", tmDto.UserId ?? Guid.Empty);
}
db = new DatabaseEntities();
CustomerAssociatedFee customerassociatedfeeSave = new CustomerAssociatedFee();
customerassociatedfeeSave = data;
customerassociatedfeeSave.ID = Guid.NewGuid();
customerassociatedfeeSave.Amount = tmDto.Amount;
customerassociatedfeeSave.IsActive = true;
customerassociatedfeeSave.CreatedBy = tmDto.UserId ?? Guid.Empty;
customerassociatedfeeSave.CreatedDate = System.DateTime.Now;
customerassociatedfeeSave.LastUpdatedBy = tmDto.UserId ?? Guid.Empty;
customerassociatedfeeSave.LastUpdatedDate = System.DateTime.Now;
db.CustomerAssociatedFees.Add(customerassociatedfeeSave);
db.SaveChanges();
db.Dispose();
//EMP.Core.Utilities.AuditLogger.AudittrailLog(customerassociatedfeeSave, null, "Add", tmDto.UserId ?? Guid.Empty);
iretval = true;
}
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "SubSiteFeeService/UpdateCustomerAssociatedFees", Guid.Empty);
return(false);
}
return(iretval);
}
protected void Dispose(bool disposing)
{
if (disposing)
{
if (_db != null)
{
_db.Dispose();
_db = null;
}
}
}
protected virtual void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
entities.Dispose();
}
}
this.disposed = true;
}
public bool Save(userSecurityAnswerModel _Dto)
{
try
{
List <SecurityAnswerUserMap> _SecurityAnswers = new List <SecurityAnswerUserMap>();
List <SecurityQuestionAnswerModel> _userSecurityAnswerModel = new List <SecurityQuestionAnswerModel>();
if (_Dto.Status == "2")
{
var result = db.SecurityAnswerUserMaps.Where(o => o.UserId == _Dto.Id).ToList();
if (result.Count() > 0)
{
db.SecurityAnswerUserMaps.RemoveRange(result);
}
}
foreach (var item in _Dto.QuestionsLst)
{
SecurityAnswerUserMap _SecurityAnswer = new SecurityAnswerUserMap();
_SecurityAnswer.Id = Guid.NewGuid();
_SecurityAnswer.QuestionId = item.QuestionId;
_SecurityAnswer.Answer = item.Answer;
_SecurityAnswer.DisplayOrder = item.DisplayOrder;
_SecurityAnswer.UserId = _Dto.Id;
_SecurityAnswer.CreatedBy = _Dto.Id;
_SecurityAnswer.LastUpdatedBy = _Dto.Id;
_SecurityAnswer.LastUpdatedDate = DateTime.Now;
_SecurityAnswer.CreatedDate = DateTime.Now;
_SecurityAnswer.StatusCode = EMPConstants.Active;
_SecurityAnswers.Add(_SecurityAnswer);
}
db.SecurityAnswerUserMaps.AddRange(_SecurityAnswers);
try
{
db.SaveChanges();
db.Dispose();
}
catch (DbUpdateConcurrencyException ex)
{
ExceptionLogger.LogException(ex.ToString(), "SecurityAnswer/PostSecurityQuestion", Guid.Empty);
return(false);
}
return(true);
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "SecurityAnswer/PostSecurityQuestion", Guid.Empty);
return(false);
}
}
public async Task <Guid> SaveStatus(ResetPasswordModel _Dto, Guid Id, int EntityState)
{
try
{
emp_CustomerLoginInformation CustomerLoginInformation = new emp_CustomerLoginInformation();
CustomerLoginInformation = await db.emp_CustomerLoginInformation.Where(o => o.Id == Id).FirstOrDefaultAsync();
//securityQuestionMaster.ActivatedDate = DateTime.Now;
if (CustomerLoginInformation.StatusCode == EMPConstants.InActive)
{
CustomerLoginInformation.StatusCode = EMPConstants.Active;
}
else if (CustomerLoginInformation.StatusCode == EMPConstants.Active)
{
CustomerLoginInformation.StatusCode = EMPConstants.InActive;
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
CustomerLoginInformation.LastUpdatedDate = DateTime.Now;
CustomerLoginInformation.LastUpdatedBy = _Dto.UserId;
db.Entry(CustomerLoginInformation).State = System.Data.Entity.EntityState.Modified;
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return(CustomerLoginInformation.Id);
}
catch (DbUpdateConcurrencyException)
{
if (!IsExists(CustomerLoginInformation.Id))
{
return(Guid.Empty);
}
else
{
return(Guid.Empty);
}
}
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "ResetPassword/PutResetPassword", Id);
return(Guid.Empty);
}
}
/// <summary>
/// Method to validate token against expiry and existence in database.
/// </summary>
/// <param name="tokenId"></param>
/// <returns></returns>
public bool ValidateToken(string tokenId)
{
db = new DatabaseEntities();
var token = db.TokenMasters.Where(t => t.AuthToken == tokenId && t.ExpiredOn > DateTime.Now).FirstOrDefault();
if (token != null && !(DateTime.Now > token.ExpiredOn))
{
token.ExpiredOn = token.ExpiredOn.AddSeconds(Convert.ToDouble(ConfigurationManager.AppSettings["TokenExpiredOn"].ToString()));
db.Entry(token).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
return(true);
}
return(false);
}
//public UserService(DatabaseEntities _db, UserDetailDTO _user)
//{
// db = _db;
// user = _user;
//}
public IQueryable<UserDTO> GetAllUser()
{
db = new DatabaseEntities();
var User = db2.UserMasters.Select(o => new UserDTO
{
Id = o.Id,
FirstName = o.FirstName,
LastName = o.LastName,
EmailAddress = o.EmailAddress,
UserName = o.UserName,
GroupName = o.UserGroupMaps.Select(s => new GroupDTO() { Id = s.GroupId, Name = s.GroupMaster.Name }).FirstOrDefault().Name,
AccessType = o.EntityMaster.AccessTypeMaster.Name,
StatusCode = o.StatusCode
}).DefaultIfEmpty();
db.Dispose();
return User.OrderBy(o => o.FirstName);
}
public async Task <bool> Delete(Guid Id)
{
try
{
var deletedata = db.APIIntegrations.Where(o => o.Id == Id).FirstOrDefault();
if (deletedata != null)
{
db.APIIntegrations.Remove(deletedata);
await db.SaveChangesAsync();
db.Dispose();
}
return(true);
}
catch (DbUpdateConcurrencyException)
{
return(false);
}
}
/// <summary>
/// Delete tokens for the specific deleted user
/// </summary>
/// <param name="userId"></param>
/// <returns>true for successful delete</returns>
public bool DeleteByUserId(Guid userId)
{
try
{
db = new DatabaseEntities();
var data = db.TokenMasters.Where(o => o.UserId == userId);
if (data != null)
{
db.TokenMasters.RemoveRange(data);
db.SaveChanges();
db.Dispose();
}
return(true);
}
catch (DbUpdateConcurrencyException)
{
return(false);
}
}
//public UserService(uTaxDBEntities _db, UserDetailDTO _user)
//{
// db = _db;
// user = _user;
//}
public TokenDTO GenerateToken(Guid userId, string userip = "")
{
db = new DatabaseEntities();
var tokenModel = new TokenDTO();
if (userId != Guid.Empty)
{
string token = Guid.NewGuid().ToString();
DateTime issuedOn = DateTime.Now;
DateTime expiredOn = DateTime.Now.AddSeconds(Convert.ToDouble(ConfigurationManager.AppSettings["TokenExpiredOn"].ToString()));
// string hostName = Dns.GetHostName();
string myIP = userip;// Dns.GetHostByName(hostName).AddressList[0].ToString();
var tokendomain = new TokenMaster
{
UserId = userId,
AuthToken = token,
IssuedOn = issuedOn,
ExpiredOn = expiredOn,
IPAddress = myIP,
StatusCode = EMPConstants.Active
};
db.TokenMasters.Add(tokendomain);
db.SaveChanges();
db.Dispose();
tokenModel = new TokenDTO()
{
UserId = userId,
IssuedOn = issuedOn,
ExpiredOn = expiredOn,
AuthToken = token,
StatusCode = EMPConstants.Active
};
}
return(tokenModel);
}
/// <summary>
/// Method to kill the provided token id.
/// </summary>
/// <param name="tokenId">true for successful delete</param>
public bool Kill(string TokenId)
{
// GroupRoleMap _GroupRoleMap = new GroupRoleMap();
try
{
db = new DatabaseEntities();
var data = db.TokenMasters.Where(o => o.AuthToken == TokenId).FirstOrDefault();
if (data != null)
{
//db.TokenMasters.Remove(data);
data.ExpiredOn = data.ExpiredOn.AddMinutes(-Convert.ToDouble(ConfigurationManager.AppSettings["TokenExpiredOn"].ToString()));
data.StatusCode = "INA";
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
return(true);
}
catch (DbUpdateConcurrencyException)
{
return(false);
}
}
public bool ActivateCustomer(Guid CustomerId, Guid UserId)
{
try
{
db = new DatabaseEntities();
emp_CustomerInformation model = new emp_CustomerInformation();
model = db.emp_CustomerInformation.Where(a => a.Id == CustomerId).FirstOrDefault();
if (model != null)
{
model.IsActivationCompleted = 1;
model.AccountStatus = "Active";
model.LastUpdatedBy = UserId;
model.LastUpdatedDate = DateTime.Now;
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
db.Dispose();
return(true);
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "Configuration/ActivateCustomer", UserId);
return(false);
}
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "Configuration/ActivateCustomer", UserId);
return(false);
}
}
/// <summary>
/// This method is used to Save the main office details
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public int Save(SubSiteFeesDTO dto)
{
int entityState = 0;
int iretval = 0;
List <SubSiteFeeConfig> subsitefeeconfigs = new List <SubSiteFeeConfig>();
try
{
if (dto != null)
{
Guid newguid2 = Guid.NewGuid();
bool IsRefId = Guid.TryParse(dto.refId, out newguid2);
if (IsRefId)
{
var SubSiteFeeConfig = db.SubSiteFeeConfigs.Where(o => o.emp_CustomerInformation_ID == newguid2).ToList();
if (SubSiteFeeConfig.Count() > 0)
{
db.SubSiteFeeConfigs.RemoveRange(SubSiteFeeConfig);
db.SaveChanges();
}
var subsiteBankFeeconfig = db.SubSiteBankFeesConfigs.Where(o => o.emp_CustomerInformation_ID == newguid2).ToList();
if (subsiteBankFeeconfig.Count() > 0)
{
db.SubSiteBankFeesConfigs.RemoveRange(subsiteBankFeeconfig);
db.SaveChanges();
}
}
foreach (var item in dto.SubsiteFees)
{
SubSiteFeeConfig subsitefeeconfig = new SubSiteFeeConfig();
subsitefeeconfig.ID = Guid.NewGuid();
entityState = (int)System.Data.Entity.EntityState.Added;
SaveBankDetail(item.SubSiteBankFees, subsitefeeconfig.ID, newguid2, item.UserId ?? Guid.Empty);
subsitefeeconfig.emp_CustomerInformation_ID = newguid2; // newguid;
subsitefeeconfig.IsAddOnFeeCharge = item.IsAddOnFeeCharge;
if (subsitefeeconfig.IsAddOnFeeCharge)
{
subsitefeeconfig.IsSameforAll = item.IsSameforAll;
}
else
{
subsitefeeconfig.IsSameforAll = false;
}
subsitefeeconfig.IsSubSiteAddonFee = item.IsSubSiteAddonFee;
subsitefeeconfig.ServiceorTransmission = item.ServiceorTransmission;
subsitefeeconfig.StatusCode = EMPConstants.Active;
subsitefeeconfig.LastUpdatedBy = item.UserId ?? Guid.Empty;
subsitefeeconfig.LastUpdatedDate = System.DateTime.Now;
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
subsitefeeconfig.CreatedBy = item.UserId ?? Guid.Empty;
subsitefeeconfig.CreatedDate = System.DateTime.Now;
subsitefeeconfigs.Add(subsitefeeconfig);
}
else
{
// For Sub-Site Fee Changes
if (subsitefeeconfig.IsSameforAll)
{
var childRecord = db.emp_CustomerInformation.Where(o => o.ParentId == subsitefeeconfig.emp_CustomerInformation_ID && o.IsActivationCompleted != 1).Select(o => new { o.Id, o.IsActivationCompleted }).ToList();
// var IsActiveChild = childRecord.ToList().Where(o => o.IsActivationCompleted == 1).Any();
//if (!IsActiveChild)
//{
foreach (var ChildItem in childRecord)
{
var subsitebankfees = db.SubSiteBankFeesConfigs.Where(o => o.emp_CustomerInformation_ID == ChildItem.Id).ToList();
foreach (var subsitebankfeeItem in subsitebankfees)
{
var ParentSubSiteBankFees = item.SubSiteBankFees.Where(o => o.BankMaster_ID == subsitebankfeeItem.BankMaster_ID.ToString()).FirstOrDefault();
if (ParentSubSiteBankFees != null)
{
subsitebankfeeItem.BankMaxFees = ParentSubSiteBankFees.BankMaxFees;
subsitebankfeeItem.BankMaxFees_MSO = ParentSubSiteBankFees.BankMaxFees_MSO ?? 0;
db.Entry(subsitebankfeeItem).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
db.Entry(subsitefeeconfig).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
db.SubSiteFeeConfigs.AddRange(subsitefeeconfigs);
db.SaveChanges();
}
db.Dispose();
return(1);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "SubSiteFeeService/GetSubSiteBankFeeById", dto.UserId);
iretval = 0;
return(iretval);
throw;
}
}
public void Dispose()
{
db.Dispose();
throw new NotImplementedException();
}
/// <summary>
/// This method is used to save and update the Sub Site Office Configuration Details
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public Guid SaveSubSiteOfficeConfigInfo(SubSiteOfficeConfigDTO dto)
{
db = new DatabaseEntities();
Guid MyId = Guid.Empty;
int entityState = 0;
bool prevBS = false;
SubSiteOfficeConfig model = new SubSiteOfficeConfig();
if (dto != null)
{
Guid Id, refId;
if (Guid.TryParse(dto.Id, out Id))
{
model = db.SubSiteOfficeConfigs.Where(a => a.Id == Id).FirstOrDefault();
if (model != null)
{
prevBS = model.HasBusinessSoftware;
entityState = (int)System.Data.Entity.EntityState.Modified;
}
else
{
return(Guid.Empty);
}
}
else
{
model.Id = Guid.NewGuid();
entityState = (int)System.Data.Entity.EntityState.Added;
}
bool IsRefId = Guid.TryParse(dto.RefId, out refId);
if (!IsRefId)
{
return(Guid.Empty);
}
model.RefId = refId;
model.EFINListedOtherOffice = dto.EFINListedOtherOffice ?? false;
model.SiteOwnthisEFIN = dto.SiteOwnthisEFIN ?? false;
model.EFINOwnerSite = dto.EFINOwnerSite;
int SOorSSorEFIN = 0;
if (int.TryParse(dto.SOorSSorEFIN, out SOorSSorEFIN))
{
model.SOorSSorEFIN = SOorSSorEFIN;
}
else
{
return(Guid.Empty);
}
model.CanSubSiteLoginToEmp = true;
model.SubSiteSendTaxReturn = dto.SubSiteSendTaxReturn ?? false;
model.SiteanMSOLocation = dto.SiteanMSOLocation ?? false;
model.LastUpdatedBy = dto.UserId ?? Guid.Empty;
model.LastUpdatedDate = System.DateTime.Now;
///// Main Site Data
model.IsMainSiteTransmitTaxReturn = dto.IsMainSiteTransmitTaxReturn;
model.NoofTaxProfessionals = dto.NoofTaxProfessionals;
model.IsSoftwareOnNetwork = dto.IsSoftwareOnNetwork;
model.NoofComputers = dto.NoofComputers;
model.PreferredLanguage = dto.PreferredLanguage;
model.HasBusinessSoftware = dto.IsBusinessSoftware;
model.IsSharingEFIN = dto.IsSharingEFIN;
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
model.CreatedBy = dto.UserId ?? Guid.Empty;
model.CreatedDate = System.DateTime.Now;
db.SubSiteOfficeConfigs.Add(model);
}
else
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
}
//var enrollconfig = db.EnrollmentOfficeConfigurations.Where(x => x.CustomerId == refId && x.StatusCode == EMPConstants.Active).FirstOrDefault();
//if (enrollconfig != null)
//{
// enrollconfig.IsSoftwareOnNetwork = dto.IsSoftwareOnNetwork;
// enrollconfig.LastUpdatedBy = dto.UserId ?? Guid.Empty;
// enrollconfig.LastUpdatedDate = DateTime.Now;
// enrollconfig.NoofComputers = dto.NoofComputers;
// enrollconfig.NoofTaxProfessionals = dto.NoofTaxProfessionals;
// enrollconfig.PreferredLanguage = dto.PreferredLanguage;
//}
//if (model.SOorSSorEFIN == 3 && model.LastUpdatedBy != Guid.Empty)
//{
// var emp_Info = db.emp_CustomerInformation.Where(o => o.Id == dto.UserId).FirstOrDefault();
// if (emp_Info != null)
// {
// emp_Info.IsAdditionalEFINAllowed = true;
// db.Entry(emp_Info).State = System.Data.Entity.EntityState.Modified;
// }
//}
var emp_MyInfo = db.emp_CustomerInformation.Where(o => o.Id == refId).FirstOrDefault();
if (emp_MyInfo != null)
{
var emp_ParentInfo = db.emp_CustomerInformation.Where(o => o.Id == emp_MyInfo.ParentId).FirstOrDefault();
if (emp_ParentInfo != null)
{
MyId = emp_MyInfo.Id;
if (emp_ParentInfo.EntityId == (int)EMPConstants.Entity.MO)
{
if (model.SOorSSorEFIN == 1)
{
emp_MyInfo.EROType = "Multi Office - Single Office";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.MO_SO;
}
else if (model.SOorSSorEFIN == 3)
{
emp_MyInfo.EROType = "Multi Office - Additional EFIN";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.MO_AE;
}
}
else if (emp_ParentInfo.EntityId == (int)EMPConstants.Entity.SVB_MO)
{
if (model.SOorSSorEFIN == 1)
{
emp_MyInfo.EROType = "Service Bureau - Multi Office - Single Office";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.SVB_MO_SO;
}
else if (model.SOorSSorEFIN == 3)
{
emp_MyInfo.EROType = "Service Bureau - Multi Office - Additional EFIN";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.SVB_MO_AE;
}
}
else if (emp_ParentInfo.EntityId == (int)EMPConstants.Entity.SVB)
{
if (model.SOorSSorEFIN == 1)
{
emp_MyInfo.EROType = "Service Bureau - Single Office";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.SVB_SO;
}
else if (model.SOorSSorEFIN == 2)
{
emp_MyInfo.EROType = "Service Bureau - Multi Office";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.SVB_MO;
}
else if (model.SOorSSorEFIN == 3)
{
emp_MyInfo.EROType = "Service Bureau - Additional EFIN";
emp_MyInfo.EntityId = (int)EMPConstants.Entity.SVB_AE;
}
}
if (model.SOorSSorEFIN == 3)
{
emp_MyInfo.IsAdditionalEFINAllowed = true;
}
if (emp_MyInfo.EFINStatus == (int)EMPConstants.EFINStatus_ForSub.Sharing && model.SiteOwnthisEFIN == false)
{
var UserId = model.EFINOwnerSite;
if (!string.IsNullOrEmpty(UserId))
{
var UserMain = (from emp in db.emp_CustomerInformation
join emplog in db.emp_CustomerLoginInformation
on emp.Id equals emplog.CustomerOfficeId
where emplog.EMPUserId == UserId
select new { emp.EFIN }).FirstOrDefault();
if (UserMain != null)
{
emp_MyInfo.EFIN = UserMain.EFIN ?? 0;
}
}
}
db.Entry(emp_MyInfo).State = System.Data.Entity.EntityState.Modified;
}
if (emp_MyInfo.IsActivationCompleted == 1)
{
if (prevBS != dto.IsBusinessSoftware && dto.IsBusinessSoftware)
{
var loginfo = db.emp_CustomerLoginInformation.Where(x => x.CustomerOfficeId == refId).FirstOrDefault();
var sy = db.SalesYearMasters.Where(x => x.Id == emp_MyInfo.SalesYearID).Select(x => x.SalesYear).FirstOrDefault();
CustomerInformationService cis = new CustomerInformation.CustomerInformationService();
cis.SaveEmpCsrData(refId, "Business Software", emp_MyInfo.SalesforceAccountID, sy.Value.ToString());
EmailNotification _email = new EmailNotification();
_email.CreatedBy = dto.UserId ?? Guid.Empty;
_email.CreatedDate = DateTime.Now;
_email.EmailCC = "";
_email.EmailContent = "";
_email.EmailSubject = "Business Software";
_email.EmailTo = EMPConstants.SupportutaxEmail;
_email.EmailType = (int)EMPConstants.EmailTypes.BusinessSoftware;
_email.IsSent = false;
_email.Parameters = loginfo.EMPUserId + "$|$" + loginfo.MasterIdentifier + "$|$" + dto.IsBusinessSoftware;
db.EmailNotifications.Add(_email);
}
}
if (prevBS != dto.IsBusinessSoftware && dto.IsBusinessSoftware && emp_MyInfo.EntityId != (int)EMPConstants.Entity.SO)
{
var loginfo = db.emp_CustomerLoginInformation.Where(x => x.CustomerOfficeId == refId).FirstOrDefault();
var parentinfo = db.emp_CustomerInformation.Where(x => x.Id == emp_MyInfo.ParentId).FirstOrDefault();
var parentsb = db.MainOfficeConfigurations.Where(x => x.emp_CustomerInformation_ID == emp_MyInfo.ParentId).Select(x => x.HasBusinessSoftware).FirstOrDefault();
if (parentinfo != null)
{
if (parentinfo.QuoteSoftwarePackage != EMPConstants.EnterprisePackage && !parentsb)
{
EmailNotification _email = new EmailNotification();
_email.CreatedBy = dto.UserId ?? Guid.Empty;
_email.CreatedDate = DateTime.Now;
_email.EmailCC = "";
_email.EmailContent = "";
_email.EmailSubject = "Business Software";
_email.EmailTo = EMPConstants.accountutaxEmail;
_email.EmailType = (int)EMPConstants.EmailTypes.BusinessSoftware;
_email.IsSent = false;
_email.Parameters = loginfo.EMPUserId + "$|$" + loginfo.MasterIdentifier + "$|$" + dto.IsBusinessSoftware;
db.EmailNotifications.Add(_email);
}
}
}
}
}
try
{
db.SaveChanges();
db.Dispose();
if (MyId != Guid.Empty)
{
DropDownService ddService = new DropDownService();
var items = ddService.GetBottomToTopHierarchy(MyId);
}
return(model.Id);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/SaveSubSiteOfficeConfigInfo", Guid.Empty);
return(Guid.Empty);
}
}
public PaymentOptionResponse Save(CustomerPaymentInfo info)
{
PaymentOptionResponse res = new PaymentOptionResponse();
try
{
CustomerPaymentOption CPO = new CustomerPaymentOption();
bool isNew = true;
Guid userid, oldid;
if (Guid.TryParse(info.Id, out oldid) && info.Id != Guid.Empty.ToString())
{
CPO = db.CustomerPaymentOptions.Where(a => a.Id == oldid).FirstOrDefault();
if (CPO != null)
{
isNew = false;
}
else
{
res.status = false;
}
}
else
{
CPO.Id = Guid.NewGuid();
}
bool IsRefId = Guid.TryParse(info.UserId, out userid);
CPO.IsSameasBankAccount = info.IsSameBankAccount;
CPO.PaymentType = info.PaymentType;
if (isNew)
{
Guid CustId;
var customerid = db.emp_CustomerLoginInformation.Where(x => x.Id == userid).Select(x => x.CustomerOfficeId).FirstOrDefault();
bool IsCustId = Guid.TryParse(customerid.ToString(), out CustId);
CPO.CreatedBy = userid;
CPO.BankId = info.BankId;
CPO.CreatedDate = DateTime.Now;
CPO.CustomerId = userid;
CPO.SiteType = info.SiteType;
db.CustomerPaymentOptions.Add(CPO);
}
else
{
CPO.BankId = info.BankId;
CPO.UpdatedBy = userid;
CPO.UpdatedDate = DateTime.Now;
if (info.IsSameBankAccount == 2 && info.PaymentType == 2)
{
var ach = (from s in db.CustomerPaymentViaACHes
where s.PaymentOptionId == CPO.Id
select s).FirstOrDefault();
if (ach != null)
{
db.CustomerPaymentViaACHes.Remove(ach);
}
}
}
db.SaveChanges();
db.Dispose();
res.status = true;
res.Id = CPO.Id.ToString();
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/Save", Guid.Empty);
res.status = false;
}
return(res);
}
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;
}
}
/// <summary>
/// This method is used to Save the main office details
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public bool CustomerConfigStatusSave(CustomerConfigStatusDTO dto)
{
try
{
int entityState = 0;
CustomerConfigurationStatu model = new CustomerConfigurationStatu();
if (dto != null)
{
Guid Id, SitemapId, CustomerId, xBankId;
bool IsBankId = Guid.TryParse(dto.bankid, out xBankId);
if (!IsBankId)
{
return(false);
}
bool IsSitemapId = Guid.TryParse(dto.SitemapId, out SitemapId);
if (!IsSitemapId)
{
return(false);
}
bool IsCustomerId = Guid.TryParse(dto.CustomerId, out CustomerId);
if (!IsCustomerId)
{
return(false);
}
if (Guid.TryParse(dto.Id, out Id))
{
model = db.CustomerConfigurationStatus.Where(a => a.CustomerId == CustomerId && a.SitemapId == SitemapId).FirstOrDefault();
if (model != null)
{
entityState = (int)System.Data.Entity.EntityState.Modified;
}
else
{
return(false);
}
}
else
{
model.Id = Guid.NewGuid();
entityState = (int)System.Data.Entity.EntityState.Added;
}
model.CustomerId = CustomerId; // newguid;
model.StatusCode = dto.Status;
model.UpdatedBy = dto.UserId ?? Guid.Empty;
model.UpdatedDate = System.DateTime.Now;
model.bankid = xBankId; // newguid;
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
db.CustomerConfigurationStatus.Add(model);
}
else
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
}
}
try
{
db.SaveChanges();
db.Dispose();
return(true);
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "Configuration/ConfigurationStatus", Guid.Empty);
return(false);
}
}
catch (Exception ex)
{
ExceptionLogger.LogException(ex.ToString(), "Configuration/ConfigurationStatus", Guid.Empty);
return(false);
}
}
/// <summary>
/// This method is used to save and update the Enrollment Affiliate Configuration Detail
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public int SaveEnrollmentOfficeConfig(EnrollmentOfficeConfigDTO dto)
{
// int entityState = 0;
EnrollmentOfficeConfiguration model = new EnrollmentOfficeConfiguration();
if (dto != null)
{
Guid Id, UserId, CustomerId;
int entityState = (int)System.Data.Entity.EntityState.Added;
if (!Guid.TryParse(dto.CustomerId.ToString(), out CustomerId))
{
return(-1);
}
if (!Guid.TryParse(dto.UserId.ToString(), out UserId))
{
return(-1);
}
if (dto.Id != null)
{
if (!Guid.TryParse(dto.Id.ToString(), out Id))
{
return(-1);
}
entityState = (int)System.Data.Entity.EntityState.Modified;
if (Id == Guid.Empty)
{
Id = Guid.NewGuid();
model.Id = Id;
}
}
else
{
Id = Guid.NewGuid();
model.Id = Id;
}
if (entityState == (int)System.Data.Entity.EntityState.Modified)
{
model = db.EnrollmentOfficeConfigurations.Where(a => a.Id == dto.Id).FirstOrDefault();
if (model == null)
{
return(-1);
}
}
model.CustomerId = CustomerId;
model.IsMainSiteTransmitTaxReturn = dto.IsMainSiteTransmitTaxReturn;
model.NoofComputers = dto.NoofComputers;
model.NoofTaxProfessionals = dto.NoofTaxProfessionals;
model.NoofTaxProfessionals = dto.NoofTaxProfessionals;
model.PreferredLanguage = dto.PreferredLanguage;
model.IsSoftwareOnNetwork = dto.IsSoftwareOnNetwork;
model.StatusCode = EMPConstants.Active;
model.LastUpdatedBy = dto.UserId ?? Guid.Empty;
model.LastUpdatedDate = System.DateTime.Now;
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
model.CreatedBy = dto.UserId ?? Guid.Empty;
model.CreatedDate = System.DateTime.Now;
db.EnrollmentOfficeConfigurations.Add(model);
}
else
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
}
var custInfo = db.emp_CustomerInformation.Where(x => x.Id == CustomerId).FirstOrDefault();
if (custInfo.EntityId == (int)EMPConstants.Entity.MO || custInfo.EntityId == (int)EMPConstants.Entity.SVB)
{
var accountconfig = db.MainOfficeConfigurations.Where(x => x.emp_CustomerInformation_ID == CustomerId && x.StatusCode == EMPConstants.Active).FirstOrDefault();
if (accountconfig != null)
{
accountconfig.ComputerswillruninSoftware = dto.NoofComputers ?? 0;
accountconfig.IsSoftwarebeInstalledNetwork = dto.IsSoftwareOnNetwork ?? false;
accountconfig.LastUpdatedBy = dto.UserId ?? Guid.Empty;
accountconfig.LastUpdatedDate = DateTime.Now;
accountconfig.PreferredSupportLanguage = dto.PreferredLanguage ?? 0;
accountconfig.TaxProfessionals = dto.NoofTaxProfessionals ?? 0;
}
}
}
try
{
db.SaveChanges();
db.Dispose();
return(1);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "EnrollmentOfficeConfigService/SaveEnrollmentOfficeConfig", Guid.Empty);
return(-1);
}
}
/// <summary>
/// This method is used to save and update the Sub Site Office Configuration Details
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public async Task <int> SaveSubSiteOfficeAffiProgConfig(SubSiteOfficeAffiliateProgramConfigDTO dto)
{
int entityState = 0;
SubSiteOfficeAffiliateProgramConfig model = new SubSiteOfficeAffiliateProgramConfig();
if (dto != null)
{
int Id;
Guid refId, AffiliateProgId;
if (int.TryParse(dto.Id.ToString(), out Id))
{
model = db.SubSiteOfficeAffiliateProgramConfigs.Where(a => a.Id == Id).FirstOrDefault();
if (model != null)
{
entityState = (int)System.Data.Entity.EntityState.Modified;
}
else
{
return(-1);
}
}
else
{
//model.Id = Guid.NewGuid();
entityState = (int)System.Data.Entity.EntityState.Added;
}
bool IsRefId = Guid.TryParse(dto.CustomerInformation_Id, out refId);
if (!IsRefId)
{
return(-1);
}
bool IsAffiliateProgId = Guid.TryParse(dto.AffiliateProgramId, out AffiliateProgId);
if (!IsAffiliateProgId)
{
return(-1);
}
model.CustomerInformation_Id = refId;
model.AffiliateProgramId = AffiliateProgId;
model.AffiliateProgramCharge = dto.AffiliateProgramCharge;
model.StatusCode = EMPConstants.Active;
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
model.CreatedBy = dto.UserId ?? Guid.Empty;
model.CreatedDate = System.DateTime.Now;
db.SubSiteOfficeAffiliateProgramConfigs.Add(model);
//Guid SiteMapId;
//Guid.TryParse("2639fb0a-0caa-47cf-b315-587e7ce86aef", out SiteMapId);
//CustomerConfigurationStatu ConfigStatusModel = new CustomerConfigurationStatu();
//ConfigStatusModel.Id = Guid.NewGuid();
//ConfigStatusModel.CustomerId = dto.UserId ?? Guid.Empty;
//ConfigStatusModel.SitemapId = SiteMapId;
//ConfigStatusModel.StatusCode = "done";
//ConfigStatusModel.UpdatedBy = dto.UserId ?? Guid.Empty;
//ConfigStatusModel.UpdatedDate = DateTime.Now;
//db.CustomerConfigurationStatus.Add(ConfigStatusModel);
}
else
{
model.LastUpdatedBy = dto.UserId ?? Guid.Empty;
model.LastUpdatedDate = System.DateTime.Now;
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
}
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return(model.Id);
}
catch (Exception ex)
{
return(-1);
throw;
}
}
/// <summary>
/// This method is used to Save the main office details
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public Guid BankServiceSave(SubSiteBankServiceDTO dto)
{
int entityState = 0;
SubSiteConfiguration model = new SubSiteConfiguration();
if (dto != null)
{
Guid Id, refId;
bool IsRefId = Guid.TryParse(dto.refId, out refId);
if (!IsRefId)
{
return(Guid.Empty);
}
if (Guid.TryParse(dto.Id, out Id))
{
model = db.SubSiteConfigurations.Where(a => a.ID == Id).FirstOrDefault();
if (model.IsuTaxManageOnboarding != null && model.IsuTaxCustomerSupport != null)
{
Guid SiteMapId;
int EntityType = 0;
if (Guid.TryParse("68882c05-5914-4fdb-b284-e33d6c029f5a", out SiteMapId))
{
CustomerConfigurationStatu ConfigStatusModel = new CustomerConfigurationStatu();
ConfigStatusModel = db.CustomerConfigurationStatus.Where(o => o.CustomerId == refId && o.SitemapId == SiteMapId).FirstOrDefault();
if (ConfigStatusModel == null)
{
ConfigStatusModel = new CustomerConfigurationStatu();
ConfigStatusModel.Id = Guid.NewGuid();
}
else
{
EntityType = (int)System.Data.Entity.EntityState.Modified;
}
ConfigStatusModel.CustomerId = dto.UserId ?? Guid.Empty;
ConfigStatusModel.SitemapId = SiteMapId;
ConfigStatusModel.StatusCode = "done";
ConfigStatusModel.UpdatedBy = dto.UserId ?? Guid.Empty;
ConfigStatusModel.UpdatedDate = DateTime.Now;
if (EntityType == (int)System.Data.Entity.EntityState.Modified)
{
db.Entry(ConfigStatusModel).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.CustomerConfigurationStatus.Add(ConfigStatusModel);
}
}
}
if (model != null)
{
entityState = (int)System.Data.Entity.EntityState.Modified;
}
else
{
return(Guid.Empty);
}
}
else
{
model.ID = Guid.NewGuid();
entityState = (int)System.Data.Entity.EntityState.Added;
}
model.emp_CustomerInformation_ID = refId; // newguid;
if (dto.IsuTaxManageingEnrolling != null)
{
model.IsuTaxManageingEnrolling = dto.IsuTaxManageingEnrolling.Value;
}
if (dto.IsuTaxPortalEnrollment != null)
{
model.IsuTaxPortalEnrollment = dto.IsuTaxPortalEnrollment.Value;
}
if (dto.IsSubSiteEFINAllow != null)
{
model.IsSubSiteEFINAllow = dto.IsSubSiteEFINAllow.Value;
}
else
{
model.IsSubSiteEFINAllow = false;
}
model.EnrollmentEmails = dto.EnrollmentEmails;
model.CanSubSiteLoginToEmp = true;
model.StatusCode = EMPConstants.Active;
model.LastUpdatedBy = dto.UserId ?? Guid.Empty;
model.LastUpdatedDate = System.DateTime.Now;
if (entityState == (int)System.Data.Entity.EntityState.Added)
{
model.CreatedBy = dto.UserId ?? Guid.Empty;
model.CreatedDate = System.DateTime.Now;
db.SubSiteConfigurations.Add(model);
}
else
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
var Bank = db.SubSiteBankConfigs.Where(o => o.SubSiteConfiguration_ID == model.ID).ToList();
if (Bank.ToList().Count > 0)
{
db.SubSiteBankConfigs.RemoveRange(Bank);
}
}
List <SubSiteBankConfig> SubSiteBankConfigs = new List <SubSiteBankConfig>();
foreach (var item in dto.SubSiteBankQuestions)
{
SubSiteBankConfig SubSiteBank = new SubSiteBankConfig();
SubSiteBank.ID = Guid.NewGuid();
SubSiteBank.emp_CustomerInformation_ID = model.emp_CustomerInformation_ID;
SubSiteBank.BankMaster_ID = item.BankId;
SubSiteBank.SubSiteConfiguration_ID = model.ID;
SubSiteBank.SubQuestion_ID = item.QuestionId;
SubSiteBank.CreatedBy = dto.UserId ?? Guid.Empty;
SubSiteBank.CreatedDate = DateTime.Now;
SubSiteBank.LastUpdatedBy = dto.UserId ?? Guid.Empty;
SubSiteBank.LastUpdatedDate = DateTime.Now;
SubSiteBankConfigs.Add(SubSiteBank);
}
if (dto.SubSiteBankQuestions.ToList().Count > 0)
{
db.SubSiteBankConfigs.AddRange(SubSiteBankConfigs);
}
if (dto.IsuTaxManageingEnrolling ?? false)
{
var custinfo = (from s in db.emp_CustomerInformation
join sy in db.SalesYearMasters on s.SalesYearID equals sy.Id
where s.Id == refId
select new
{
s.IsMSOUser,
s.SalesforceAccountID,
sy.SalesYear
}
).FirstOrDefault();
CustomerInformation.CustomerInformationService objCIS = new CustomerInformation.CustomerInformationService();
string desc = (custinfo.IsMSOUser ?? false) ? "Automated MSO " + custinfo.SalesYear ?? 0 + " Enrollment Case " : "Automated Desktop " + custinfo.SalesYear ?? 0 + " Enrollment Case";
objCIS.SaveCSRCase(custinfo.SalesforceAccountID, (custinfo.SalesYear ?? 0).ToString(), true, desc, false);
}
}
try
{
db.SaveChanges();
db.Dispose();
return(model.ID);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "SubSiteConfigService/BankServiceSave", model.ID);
return(Guid.Empty);
throw;
}
}
public async Task <int> Save(BankMasterDTO _Dto, Guid Id, int EntityState)
{
BankMaster bankmaster = new BankMaster();
if (_Dto != null)
{
bankmaster.Id = Id;
bankmaster.BankName = _Dto.BankName;
bankmaster.BankServiceFees = _Dto.BankServiceFees;
bankmaster.MaxFeeLimitDeskTop = _Dto.MaxFeeLimitDeskTop;
bankmaster.MaxTranFeeDeskTop = _Dto.MaxTranFeeDeskTop;
bankmaster.MaxFeeLimitMSO = _Dto.MaxFeeLimitMSO;
bankmaster.MaxTranFeeMSO = _Dto.MaxTranFeeMSO;
bankmaster.ActivatedDate = _Dto.ActivatedDate;
bankmaster.BankProductDocument = _Dto.BankProductDocument;
bankmaster.DeActivatedDate = _Dto.DeActivatedDate;
bankmaster.Description = _Dto.Description;
bankmaster.StatusCode = EMPConstants.Active;
bankmaster.BankCode = _Dto.BankCode;
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var ExistBank = db.BankMasters.Where(o => o.Id != Id && o.BankName == _Dto.BankName).Any();
if (ExistBank)
{
return(-1);
}
bankmaster.LastUpdatedDate = DateTime.Now;
bankmaster.LastUpdatedBy = _Dto.UserId;
db.Entry(bankmaster).State = System.Data.Entity.EntityState.Modified;
}
else
{
var ExistBank = db.BankMasters.Where(o => o.BankName == _Dto.BankName).Any();
if (ExistBank)
{
return(-1);
}
bankmaster.CreatedBy = _Dto.UserId;
bankmaster.CreatedDate = DateTime.Now;
bankmaster.LastUpdatedDate = DateTime.Now;
bankmaster.LastUpdatedBy = _Dto.UserId;
db.BankMasters.Add(bankmaster);
}
if (_Dto.Entities.ToList().Count > 0)
{
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var MapData = db.BankEntityMaps.Where(o => o.BankId == Id).ToList();
if (MapData.Count() > 0)
{
db.BankEntityMaps.RemoveRange(MapData);
}
}
List <BankEntityMap> _BankEntityMapsList = new List <BankEntityMap>();
foreach (EntityDTO item in _Dto.Entities)
{
BankEntityMap _BankEntityMap = new BankEntityMap();
_BankEntityMap.Id = Guid.NewGuid();
_BankEntityMap.BankId = bankmaster.Id;
_BankEntityMap.EntityId = item.Id;
_BankEntityMapsList.Add(_BankEntityMap);
}
db.BankEntityMaps.AddRange(_BankEntityMapsList);
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return(1);
}
catch (DbUpdateConcurrencyException)
{
return(0);
}
}
public void Dispose()
{
db.Dispose();
}
public async Task <int> Save(FeesDTO _Dto, Guid Id, int EntityState)
{
FeeMaster _FeeMaster = new FeeMaster();
if (_Dto != null)
{
_FeeMaster.Id = Id;
_FeeMaster.Name = _Dto.Name;
_FeeMaster.FeeType = _Dto.FeeType;
_FeeMaster.FeeCategoryID = _Dto.FeeCategoryID;
_FeeMaster.IsIncludedMaxAmtCalculation = _Dto.IsIncludedMaxAmtCalculation;
_FeeMaster.SalesforceFeesFieldID = _Dto.SalesforceFeesFieldID;
if (_FeeMaster.FeeType == EMPConstants.Fixedamount)
{
_FeeMaster.FeeTypeId = 1;
}
if (_FeeMaster.FeeType == EMPConstants.Useramount)
{
_FeeMaster.FeeTypeId = 2;
}
if (_FeeMaster.FeeType == EMPConstants.SalesForce)
{
_FeeMaster.FeeTypeId = 3;
}
_FeeMaster.Amount = _Dto.Amount;
_FeeMaster.FeeNature = _Dto.FeeNature;
if (_FeeMaster.FeeNature == EMPConstants.Mandatory)
{
_FeeMaster.FeeNatureId = 1;
}
if (_FeeMaster.FeeNature == EMPConstants.Optional)
{
_FeeMaster.FeeNatureId = 2;
}
_FeeMaster.ActivatedDate = DateTime.Now;
_FeeMaster.DeActivatedDate = null;// _Dto.DeActivatedDate;
_FeeMaster.NoteForUser = _Dto.NoteForUser;
_FeeMaster.Note = _Dto.Note;
_FeeMaster.StatusCode = EMPConstants.Active;
int FeesFor = 0;
if (int.TryParse(_Dto.FeesFor, out FeesFor))
{
_FeeMaster.FeesFor = FeesFor;
}
else
{
return(0);
}
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var ExistFee = db.FeeMasters.Where(o => o.Id != Id && o.Name == _Dto.Name).Any();
if (ExistFee)
{
return(-1);
}
_FeeMaster.LastUpdatedDate = DateTime.Now;
_FeeMaster.LastUpdatedBy = _Dto.UserId;
db.Entry(_FeeMaster).State = System.Data.Entity.EntityState.Modified;
}
else
{
var ExistFee = db.FeeMasters.Where(o => o.Name == _Dto.Name).Any();
if (ExistFee)
{
return(-1);
}
_FeeMaster.CreatedBy = _Dto.UserId;
_FeeMaster.CreatedDate = DateTime.Now;
_FeeMaster.LastUpdatedDate = DateTime.Now;
_FeeMaster.LastUpdatedBy = _Dto.UserId;
db.FeeMasters.Add(_FeeMaster);
}
if (_Dto.Entities.ToList().Count > 0)
{
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var MapData = db.FeeEntityMaps.Where(o => o.FeeId == Id).ToList();
if (MapData.Count() > 0)
{
db.FeeEntityMaps.RemoveRange(MapData);
}
}
List <FeeEntityMap> _FeeEntityMapList = new List <FeeEntityMap>();
foreach (EntityDTO item in _Dto.Entities)
{
FeeEntityMap _FeeEntityMap = new FeeEntityMap();
_FeeEntityMap.Id = Guid.NewGuid();
_FeeEntityMap.FeeId = _FeeMaster.Id;
_FeeEntityMap.EntityId = item.Id;
_FeeEntityMapList.Add(_FeeEntityMap);
}
db.FeeEntityMaps.AddRange(_FeeEntityMapList);
}
try
{
await db.SaveChangesAsync();
db.Dispose();
return(1);
}
catch (DbUpdateConcurrencyException)
{
return(0);
}
}
/// <summary>
/// This method is used to save and update the Enrollment Affiliate Configuration Detail
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public int SaveEnrollmentAffiProgConfig(EnrollmentAffiliateConfigDetailDTO dto)
{
//int entityState = 0;
Guid refId = Guid.Empty, UserId, AffiliateProgId;
bool IsUserId = Guid.TryParse(dto.UserId.ToString(), out UserId);
if (!IsUserId)
{
return(-1);
}
if (dto != null)
{
// entityState = (int)System.Data.Entity.EntityState.Added;
foreach (EnrollmentAffiliateConfigDTO item in dto.Affiliates)
{
EnrollmentAffiliateConfiguration model = new EnrollmentAffiliateConfiguration();
if (item != null)
{
bool IsRefId = Guid.TryParse(item.CustomerId.ToString(), out refId);
if (!IsRefId)
{
return(-1);
}
bool IsAffiliateProgId = Guid.TryParse(item.AffiliateProgramId, out AffiliateProgId);
if (!IsAffiliateProgId)
{
return(-1);
}
decimal AffiliateProgramCharge;
bool IsAffiliateProgramCharge = decimal.TryParse(item.AffiliateProgramCharge.ToString(), out AffiliateProgramCharge);
if (!IsAffiliateProgramCharge)
{
AffiliateProgramCharge = 0;
}
model.Id = Guid.NewGuid();
model.CustomerId = refId;
model.AffiliateProgramId = AffiliateProgId;
model.AffiliateProgramCharge = AffiliateProgramCharge;
model.StatusCode = EMPConstants.Active;
model.LastUpdatedBy = UserId;
model.LastUpdatedDate = System.DateTime.Now;
model.CreatedBy = UserId;
model.CreatedDate = System.DateTime.Now;
db.EnrollmentAffiliateConfigurations.Add(model);
//if (entityState == (int)System.Data.Entity.EntityState.Added)
//{
// Guid SiteMapId;
// Guid.TryParse("2f7d1b90-78aa-4a93-85ec-81cd8b10a545", out SiteMapId);
// CustomerConfigurationStatu ConfigStatusModel = new CustomerConfigurationStatu();
// ConfigStatusModel.Id = Guid.NewGuid();
// ConfigStatusModel.CustomerId = dto.UserId ?? Guid.Empty;
// ConfigStatusModel.SitemapId = SiteMapId;
// ConfigStatusModel.StatusCode = "done";
// ConfigStatusModel.UpdatedBy = dto.UserId ?? Guid.Empty;
// ConfigStatusModel.UpdatedDate = DateTime.Now;
// db.CustomerConfigurationStatus.Add(ConfigStatusModel);
//}
}
}
var _AffiliateList = db.EnrollmentAffiliateConfigurations.Where(a => a.CustomerId == refId).ToList();
if (_AffiliateList.ToList().Count > 0)
{
db.EnrollmentAffiliateConfigurations.RemoveRange(_AffiliateList);
}
}
try
{
db.SaveChanges();
db.Dispose();
return(1);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "EnrollmentAffiliateConfigService/SaveEnrollmentAffiProgConfig", Guid.Empty);
return(-1);
throw;
}
}
public async Task <int> Save(GroupRoleDTO _dto, Guid Id, int EntityState)
{
try
{
GroupMaster groupMaster = new GroupMaster();
if (_dto != null)
{
groupMaster.Id = Id;
groupMaster.Name = _dto.GroupName;
groupMaster.StatusCode = EMPConstants.Active;
}
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var ExistGroup = db.GroupMasters.Where(o => o.Id != Id && o.Name == _dto.GroupName).Any();
if (ExistGroup)
{
return(-1);
}
groupMaster.LastUpdatedBy = _dto.UserId;
groupMaster.LastUpdatedDate = DateTime.Now;
db.Entry(groupMaster).State = System.Data.Entity.EntityState.Modified;
}
else
{
var ExistGroup = db.GroupMasters.Where(o => o.Name == _dto.GroupName).Any();
if (ExistGroup)
{
return(-1);
}
groupMaster.CreatedBy = _dto.UserId;
groupMaster.CreatedDate = DateTime.Now;
groupMaster.LastUpdatedBy = _dto.UserId;
groupMaster.LastUpdatedDate = DateTime.Now;
db.GroupMasters.Add(groupMaster);
}
if (_dto.Roles.ToList().Count > 0)
{
if (EntityState == (int)System.Data.Entity.EntityState.Modified)
{
var GroupRoleMapDel = db.GroupRoleMaps.Where(o => o.GroupId == Id).DefaultIfEmpty();
if (GroupRoleMapDel != null)
{
db.GroupRoleMaps.RemoveRange(GroupRoleMapDel);
}
}
List <GroupRoleMap> _GroupRoleMapList = new List <GroupRoleMap>();
foreach (RoleDTO item in _dto.Roles)
{
GroupRoleMap _GroupRoleMap = new GroupRoleMap();
_GroupRoleMap.Id = Guid.NewGuid();
_GroupRoleMap.GroupId = groupMaster.Id;
_GroupRoleMap.RoleId = item.Id;
_GroupRoleMapList.Add(_GroupRoleMap);
}
db.GroupRoleMaps.AddRange(_GroupRoleMapList);
}
await db.SaveChangesAsync();
db.Dispose();
return(1);
}
catch (DbUpdateConcurrencyException)
{
return(0);
}
}
