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