public string GetAccountId(Guid Id) { DropDownService ddService = new DropDownService(); List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = ddService.GetEntityHierarchies(Id); var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault(); int EntityId = TopFromHierarchy.EntityId ?? 0; Guid ParentId = TopFromHierarchy.CustomerId ?? Guid.Empty; if (EntityId == (int)EMPConstants.Entity.SVB || EntityId == (int)EMPConstants.Entity.MO) { var custinfo = db.emp_CustomerLoginInformation.Where(x => x.CustomerOfficeId == ParentId).FirstOrDefault(); if (custinfo != null) { if (string.IsNullOrEmpty(custinfo.CLAccountId)) { return(custinfo.MasterIdentifier); } else { return(custinfo.CLAccountId); } } else { return(""); } } else { return(""); } }
/// <summary> /// This Method is used to Get the Main Office Configuration Details /// </summary> /// <returns></returns> public IQueryable <SubSiteFeeDTO> GetSubSiteFeeById(Guid UserId) { try { DropDownService ddService = new DropDownService(); List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = ddService.GetEntityHierarchies(UserId); Guid TopParentId = Guid.Empty; Guid FeeSourceParentId = Guid.Empty; if (EntityHierarchyDTOs.Count > 0) { var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault(); TopParentId = TopFromHierarchy.CustomerId ?? Guid.Empty; var FeeSource = EntityHierarchyDTOs.Where(o => o.EntityId == o.FeeSourceEntityId).FirstOrDefault(); if (FeeSource != null) { FeeSourceParentId = FeeSource.CustomerId ?? Guid.Empty; } else { FeeSourceParentId = TopParentId; } } db = new DatabaseEntities(); var DBQuery = (from sfc in db.SubSiteFeeConfigs where (sfc.StatusCode == EMPConstants.Active) && sfc.emp_CustomerInformation_ID == TopParentId select sfc); List <SubSiteFeeDTO> lstsbfee = new List <SubSiteFeeDTO>(); foreach (var qr in DBQuery) { SubSiteFeeDTO odto = new SubSiteFeeDTO(); odto.Id = qr.ID.ToString(); odto.refId = qr.emp_CustomerInformation_ID.ToString(); odto.IsAddOnFeeCharge = qr.IsAddOnFeeCharge; odto.IsSameforAll = qr.IsSameforAll; odto.IsSubSiteAddonFee = qr.IsSubSiteAddonFee; odto.ServiceorTransmission = qr.ServiceorTransmission; odto.SubSiteBankFees = db.SubSiteBankFeesConfigs.Where(a => a.SubSiteFeeConfig_ID == qr.ID).Select(a => new SubSiteBankFeesDTO { BankMaster_ID = a.BankMaster_ID.ToString(), BankMaxFees = a.BankMaxFees, BankMaxFees_MSO = a.BankMaxFees_MSO }).ToList(); lstsbfee.Add(odto); } return(lstsbfee.AsQueryable()); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "SubSiteFeeService/GetSubSiteFeeById", UserId); return(new List <SubSiteFeeDTO>().AsQueryable()); } }
/// <summary> /// Acessa a pagina de detalhes do funcionario selecionado /// </summary> /// <param name="id"></param> /// <param name="modo"></param> /// <returns></returns> public ActionResult FichaCadastral(int id, string modo) { //ViewBag.ComboPerfil = //PopulaCombos(); bool editar = (modo == "edit"); using (EntityApplication <Cargo> app = new EntityApplication <Cargo>()) { ViewData["cmbCargos"] = new DropDownService().GerarComboSelect(fonte: app.ObterTodos(), campoValor: "Id", campoTexto: "Nome"); } using (EntityApplication <Modalidade> app = new EntityApplication <Modalidade>()) { ViewData["cmbModalidade"] = new DropDownService().GerarComboSelect(app.ObterTodos(), "Id", "NomeModalidade"); } using (EntityApplication <EstadoCivil> app = new EntityApplication <EstadoCivil>()) { ViewData["cmbEstadoCivil"] = new DropDownService().GerarComboSelect(app.ObterTodos(), "Id", "Nome"); } ViewBag.TituloDaPagina = "Ficha Cadastral"; ViewBag.Editar = editar; ViewBag.Modo = modo; FuncionarioViewModel funcionario; if (modo == "edit" || modo == "read") { funcionario = Mapper.Map <Funcionario, FuncionarioViewModel>(_app.ObtemFuncionario(id)); } else { funcionario = new FuncionarioViewModel(); } using (ContratoApplication cApp = new ContratoApplication()) { funcionario.Contrato = cApp.RecuperaContratoPorFuncionario(funcionario.Id); } return(View(funcionario)); }
public bool setDefaultBank(Guid CustomerId, Guid UserId, Guid BankId) { DropDownService ddService = new DropDownService(); List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = ddService.GetEntityHierarchies(UserId); Guid TopParentId = Guid.Empty; if (EntityHierarchyDTOs.Count > 0) { var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault(); TopParentId = TopFromHierarchy.CustomerId ?? Guid.Empty; } var result = db.SetDefaultBankSP(CustomerId.ToString(), UserId.ToString(), BankId.ToString()); var res1 = db.OfficeManagementGridSP(CustomerId.ToString(), CustomerId.ToString(), TopParentId == Guid.Empty ? null : TopParentId.ToString()); return(true); }
public ActionResult FichaCadastral(int id, string modo) { //ViewBag.ComboPerfil = //PopulaCombos(); bool editar = (modo == "edit"); using (EntityApplication <Cargo> app = new EntityApplication <Cargo>()) { ViewData["cmbCargos"] = new DropDownService().HtmlCombo(app.ObterTodos(), "Id", "Nome"); } using (EntityApplication <Modalidade> app = new EntityApplication <Modalidade>()) { ViewData["cmbModalidade"] = new DropDownService().HtmlCombo(app.ObterTodos(), "Id", "NomeModalidade"); } using (EntityApplication <EstadoCivil> app = new EntityApplication <EstadoCivil>()) { ViewData["cmbEstadoCivil"] = new DropDownService().HtmlCombo(app.ObterTodos(), "Id", "Nome"); } ViewBag.TituloDaPagina = "Ficha Cadastral"; ViewBag.Editar = editar; ViewBag.Modo = modo; Funcionario funcionario; if (modo == "edit" || modo == "read") { funcionario = _app.ObtemFuncionario(id); } else { funcionario = new Funcionario(); } return(View(funcionario)); }
protected override async Task OnInitializedAsync() { Users = await UserService.GetUsersAsync(); GenderEnumItems = await DropDownService.GetGenderEnumItemsAsync(); IsEnabledEnumItems = await DropDownService.GetIsEnabledEnumItemsAsync(); RoleEnumItems = await DropDownService.GetRoleEnumItemsAsync(); //await BindItemQueryAsync(Users, new QueryPageOptions //{ // Filters = null, // PageIndex = 1, // PageItems = 10, // Searchs = null, // SearchText = null, // SortName = null, // SortOrder = SortOrder.Unset //}); await base.OnInitializedAsync(); }
public List <FeeSetupReportDTO> GetNoBankAppSubmissionReport(string strguid) { try { db = new DatabaseEntities(); List <string> lstCustGuid = strguid.Split(',').ToList(); List <Guid> BE_CustomerList = db.BankEnrollments.Where(x => x.IsActive == true && x.StatusCode != EMPConstants.Ready && x.ArchiveStatusCode != EMPConstants.Archive).Select(a => a.CustomerId ?? Guid.Empty).ToList(); //List<Guid> ES_CustomerList = (from be in db.EnrollmentBankSelections // // join ssbc in db.SubSiteBankConfigs on new { x1 = be.BankId, x2 = be.CustomerId } equals new { x1 = ssbc.BankMaster_ID, x2 = ssbc.emp_CustomerInformation_ID } // where !BE_CustomerList.Contains(be.CustomerId) && be.StatusCode == EMPConstants.Active // select be.CustomerId).ToList(); //var data = (from cu in db.emp_CustomerInformation // join cl in db.emp_CustomerLoginInformation on cu.Id equals cl.CustomerOfficeId // where ES_CustomerList.Contains(cu.Id) && cl.CrossLinkUserId != null // select new { cu, cl }).Take(1); List <ReportCustomerModel> data = new List <ReportCustomerModel>(); EnrollmentBankSelectionInfo.EnrollmentBankSelectionService oService = new EnrollmentBankSelectionInfo.EnrollmentBankSelectionService(); if (db.emp_CustomerInformation.Any(a => lstCustGuid.Contains(a.Id.ToString()))) { List <string> lstGuids = GetChildData(lstCustGuid); data = (from cu in db.emp_CustomerInformation join cl in db.emp_CustomerLoginInformation on cu.Id equals cl.CustomerOfficeId where !BE_CustomerList.Contains(cu.Id) && lstGuids.Contains(cu.Id.ToString()) && cl.CrossLinkUserId != null //&& ES_CustomerList.Contains(cu.Id) select new ReportCustomerModel { cu = cu, cl = cl }).ToList(); } else { data = (from cu in db.emp_CustomerInformation join cl in db.emp_CustomerLoginInformation on cu.Id equals cl.CustomerOfficeId where !BE_CustomerList.Contains(cu.Id) && cl.CrossLinkUserId != null // && ES_CustomerList.Contains(cu.Id) select new ReportCustomerModel { cu = cu, cl = cl }).ToList(); } List <FeeSetupReportDTO> lstmodel = new List <FeeSetupReportDTO>(); DropDownService _ddService = new DropDownService(); //if (data.Count() > 0) { foreach (var itm in data) { List <Guid> ES_BankList = (from be in db.EnrollmentBankSelections // join ssbc in db.SubSiteBankConfigs on new { x1 = be.BankId, x2 = be.CustomerId } equals new { x1 = ssbc.BankMaster_ID, x2 = ssbc.emp_CustomerInformation_ID } where be.CustomerId == itm.cu.Id && !BE_CustomerList.Contains(be.CustomerId) && be.StatusCode == EMPConstants.Active select be.BankId).ToList(); if (ES_BankList.Count > 0) { if (itm.cu.EntityId != (int)EMPConstants.Entity.SO && itm.cu.EntityId != (int)EMPConstants.Entity.SOME && itm.cu.EntityId != (int)EMPConstants.Entity.SOME_SS) { List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = _ddService.GetEntityHierarchies(itm.cu.Id); Guid TopParentId = Guid.Empty; if (EntityHierarchyDTOs.Count > 0) { var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault(); TopParentId = TopFromHierarchy.CustomerId ?? Guid.Empty; var SubSiteBankConfigs = db.SubSiteBankConfigs.Where(o => o.emp_CustomerInformation_ID == TopParentId && ES_BankList.Contains(o.BankMaster_ID)).Select(o => o.BankMaster_ID).ToList(); if (SubSiteBankConfigs.Count() == 0) { continue; } // SubSiteBankConfigs } else { var SubSiteBankConfigs = db.SubSiteBankConfigs.Where(o => o.emp_CustomerInformation_ID == itm.cu.Id && ES_BankList.Contains(o.BankMaster_ID)).Select(o => o.BankMaster_ID).ToList(); if (SubSiteBankConfigs.Count() == 0) { continue; } } } FeeSetupReportDTO omodel = new FeeSetupReportDTO(); omodel.UserID = itm.cl.EMPUserId; if (itm.cu.ParentId != null) { omodel.ParentUserID = db.emp_CustomerLoginInformation.Where(a => a.CustomerOfficeId == itm.cu.ParentId).Select(a => a.CrossLinkUserId).FirstOrDefault(); } else { omodel.ParentUserID = ""; } omodel.CompanyName = itm.cu.CompanyName; omodel.Efin = itm.cu.EFIN.ToString().PadLeft(6, '0'); omodel.MasterID = itm.cl.MasterIdentifier; omodel.AccountOwner = itm.cu.BusinessOwnerFirstName; lstmodel.Add(omodel); } } } return(lstmodel.OrderBy(a => a.CompanyName).ToList()); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "ReportsService/GetNoBankAppSubmissionReport", Guid.Empty); return(new List <FeeSetupReportDTO>()); } }
public IQueryable <SubSiteBankFeeConfigDTO> SubSiteOfficeBankFee(Guid UserId) { try { DropDownService ddService = new DropDownService(); List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = ddService.GetEntityHierarchies(UserId); Guid ParentId = Guid.Empty; Guid FeeSourceParentId = Guid.Empty; if (EntityHierarchyDTOs.Count > 0) { var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault(); ParentId = TopFromHierarchy.CustomerId ?? Guid.Empty; } db = new DatabaseEntities(); List <int> FeeFor = new List <int>(); FeeFor.Add((int)EMPConstants.FeesFor.SVBFees); FeeFor.Add((int)EMPConstants.FeesFor.TransmissionFees); List <SubSiteBankFeeConfigDTO> ListDTO = new List <SubSiteBankFeeConfigDTO>(); if (EntityHierarchyDTOs.Count <= 1) { var data = (from fee in db.FeeMasters //join cust in db.CustomerAssociatedFees on fee.Id equals cust.FeeMaster_ID where FeeFor.Contains(fee.FeesFor ?? 0) //&& cust.emp_CustomerInformation_ID == ParentId select new { fee.FeesFor, fee.Amount }).ToList(); var dataa = (from s in data group s by s.FeesFor into g select new { feesfor = g.Key, Amount = g.Sum(x => x.Amount) }).ToList(); foreach (var itm in dataa.ToList()) { SubSiteBankFeeConfigDTO SubSiteBankFeeConfig = new SubSiteBankFeeConfigDTO(); SubSiteBankFeeConfig.ServiceorTransmitter = itm.feesfor ?? 0; SubSiteBankFeeConfig.AmountDSK = itm.Amount ?? 0; ListDTO.Add(SubSiteBankFeeConfig); } } else { var data = (from fee in db.FeeMasters join cust in db.CustomerAssociatedFees on fee.Id equals cust.FeeMaster_ID where FeeFor.Contains(fee.FeesFor ?? 0) && cust.emp_CustomerInformation_ID == ParentId select new { fee.FeesFor, cust.Amount }).ToList(); var dataa = (from s in data group s by s.FeesFor into g select new { feesfor = g.Key, Amount = g.Sum(x => x.Amount) }).ToList(); foreach (var itm in dataa.ToList()) { SubSiteBankFeeConfigDTO SubSiteBankFeeConfig = new SubSiteBankFeeConfigDTO(); SubSiteBankFeeConfig.ServiceorTransmitter = itm.feesfor ?? 0; SubSiteBankFeeConfig.AmountDSK = itm.Amount; ListDTO.Add(SubSiteBankFeeConfig); } } return(ListDTO.AsQueryable()); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/SubSiteOfficeBankFee", UserId); return(null); } }
/// <summary> /// This Method is used to Get SubSite Office Configuration Details /// </summary> /// <param name="userid"></param> /// <returns></returns> public async Task <SubSiteOfficeConfigDTO> GetSubSiteOfficeConfigById(Guid userid, Guid parentId) { try { DropDownService ddService = new DropDownService(); List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = ddService.GetEntityHierarchies(userid); Guid ParentId = Guid.Empty; if (EntityHierarchyDTOs.Count > 2) { var LevelOne = EntityHierarchyDTOs.Where(o => o.Customer_Level == 1).FirstOrDefault(); if (LevelOne != null) { ParentId = LevelOne.CustomerId ?? Guid.Empty; } else { ParentId = EntityHierarchyDTOs.Where(o => o.Customer_Level == 0).Select(o => o.CustomerId).FirstOrDefault() ?? Guid.Empty; } } db = new DatabaseEntities(); var data = await db.SubSiteOfficeConfigs.Where(o => o.RefId == userid).Select(o => new SubSiteOfficeConfigDTO { Id = o.Id.ToString(), RefId = o.RefId.ToString(), EFINListedOtherOffice = o.EFINListedOtherOffice, SiteOwnthisEFIN = o.SiteOwnthisEFIN, EFINOwnerSite = o.EFINOwnerSite, SOorSSorEFIN = o.SOorSSorEFIN.ToString(), SubSiteSendTaxReturn = o.SubSiteSendTaxReturn, SiteanMSOLocation = o.SiteanMSOLocation, IsMainSiteTransmitTaxReturn = o.IsMainSiteTransmitTaxReturn, NoofTaxProfessionals = o.NoofTaxProfessionals, IsSoftwareOnNetwork = o.IsSoftwareOnNetwork, NoofComputers = o.NoofComputers, PreferredLanguage = o.PreferredLanguage, CanSubSiteLoginToEmp = o.CanSubSiteLoginToEmp ?? false, IsBusinessSoftware = o.HasBusinessSoftware, IsSharingEFIN = o.IsSharingEFIN }).FirstOrDefaultAsync(); if (data == null) { if (EntityHierarchyDTOs.Count > 2) { SubSiteOfficeConfigDTO data1 = new SubSiteOfficeConfigDTO(); var subsiteconfig = (from ssc in db.SubSiteOfficeConfigs where ssc.RefId == parentId select ssc).FirstOrDefault(); // data1.Id = "0"; if (subsiteconfig != null) { data1.SubSiteSendTaxReturn = subsiteconfig.SubSiteSendTaxReturn; } else { data1.SubSiteSendTaxReturn = true; } data1.IsBusinessSoftware = db.emp_CustomerInformation.Where(x => x.Id == userid).Select(x => x.QuoteSoftwarePackage).FirstOrDefault() == EMPConstants.EnterprisePackage; return(data1); } else { SubSiteOfficeConfigDTO data1 = new SubSiteOfficeConfigDTO(); var subsiteconfig = (from ssc in db.SubSiteConfigurations where ssc.emp_CustomerInformation_ID == parentId select ssc).FirstOrDefault(); // data1.Id = "0"; if (subsiteconfig != null) { data1.iIsSubSiteSendTaxReturn = subsiteconfig.SubSiteTaxReturn ?? 0; } else { data1.iIsSubSiteSendTaxReturn = 0; } data1.IsBusinessSoftware = db.emp_CustomerInformation.Where(x => x.Id == userid).Select(x => x.QuoteSoftwarePackage).FirstOrDefault() == EMPConstants.EnterprisePackage; return(data1); } } else { if (EntityHierarchyDTOs.Count < 3) { var subsiteconfig = (from ssc in db.SubSiteConfigurations where ssc.emp_CustomerInformation_ID == parentId select ssc).FirstOrDefault(); if (subsiteconfig != null) { data.iIsSubSiteSendTaxReturn = subsiteconfig.SubSiteTaxReturn ?? 0; } else { data.iIsSubSiteSendTaxReturn = (data.SubSiteSendTaxReturn == true) ? 1 : 0; } } } return(data); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/GetSubSiteOfficeConfigById", Guid.Empty); return(null); } }
/// <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 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); } }
/// <summary> /// This Method is used to Get the Main Office Configuration Details /// </summary> /// <returns></returns> public async Task <SubSiteDTO> GetById(Guid userid) { try { DropDownService ddService = new DropDownService(); List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>(); EntityHierarchyDTOs = ddService.GetEntityHierarchies(userid); Guid ParentId = Guid.Empty; int Level = EntityHierarchyDTOs.Count; if (EntityHierarchyDTOs.Count == 1) { var LevelOne = EntityHierarchyDTOs.Where(o => o.Customer_Level == 0).FirstOrDefault(); if (LevelOne != null) { ParentId = LevelOne.CustomerId ?? Guid.Empty; } } else { var LevelOne = EntityHierarchyDTOs.Where(o => o.Customer_Level == 1).FirstOrDefault(); if (LevelOne != null) { ParentId = LevelOne.CustomerId ?? Guid.Empty; } } userid = ParentId; db = new DatabaseEntities(); var data = await db.SubSiteConfigurations.Where(o => (o.StatusCode == EMPConstants.Active || o.StatusCode == EMPConstants.Pending) && o.emp_CustomerInformation_ID == userid).Select(o => new SubSiteDTO { Id = o.ID.ToString(), refId = o.emp_CustomerInformation_ID.ToString(), IsuTaxManageingEnrolling = o.IsuTaxManageingEnrolling, IsuTaxPortalEnrollment = o.IsuTaxPortalEnrollment, IsuTaxManageOnboarding = o.IsuTaxManageOnboarding, EnrollmentEmails = o.EnrollmentEmails ?? false, IsuTaxCustomerSupport = o.IsuTaxCustomerSupport, NoofSupportStaff = o.NoofSupportStaff, NoofDays = o.NoofDays, OpenHours = o.OpenHours.Value.ToString(), // "hh:mm tt"),// "hh:mm tt"), CloseHours = o.CloseHours.Value.ToString(), //"hh:mm tt"),//"hh:mm tt"), TimeZone = o.TimeZone.ToString(), SubSiteTaxReturn = o.SubSiteTaxReturn, IsAutoEnrollAffiliateProgram = o.IsAutoEnrollAffiliateProgram, IsSubSiteEFINAllow = o.IsSubSiteEFINAllow, CanSubSiteLoginToEmp = o.CanSubSiteLoginToEmp, Affiliates = o.SubSiteAffiliateProgramConfigs.Select(s => new SubSiteAffiliateProgramDTO() { AffiliateProgramId = s.AffiliateProgramMaster_ID }).ToList(), SubSiteBankQuestions = o.SubSiteBankConfigs.Select(s => new SubSiteBankQuestionDTO() { BankId = s.BankMaster_ID, QuestionId = s.SubQuestion_ID ?? Guid.Empty }).ToList() }).FirstOrDefaultAsync(); if (data != null) { DateTime dt = new DateTime(); bool res = DateTime.TryParse(data.OpenHours, out dt); string ddt = new DateTime().Add(dt.TimeOfDay).ToString("hh:mm tt"); data.OpenHours = ddt; DateTime dt1 = new DateTime(); bool res1 = DateTime.TryParse(data.CloseHours, out dt1); string ddt1 = new DateTime().Add(dt1.TimeOfDay).ToString("hh:mm tt"); data.CloseHours = ddt1; } else { if (Level > 2) { data = new DTO.SubSiteDTO(); var SubSiteOfficeCon = db.SubSiteOfficeConfigs.Where(o => o.RefId == ParentId).FirstOrDefault(); if (SubSiteOfficeCon != null) { if (SubSiteOfficeCon.SOorSSorEFIN == 2 || SubSiteOfficeCon.SOorSSorEFIN == 3) { data.IsSubSiteEFINAllow = true; } } } // OpenHours = new DateTime().Add(o.OpenHours.Value).ToString("hh:mm tt"),// "hh:mm tt"), // CloseHours = new DateTime().Add(o.CloseHours.Value).ToString("hh:mm tt"),//"hh:mm tt"), } return(data); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "SubSiteConfigService/GetById", userid); return(null); } }
public GamesController(DropDownService dropDownService, GamesService gamesService) { this.dropDownService = dropDownService; this.gamesService = gamesService; }
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; } }