public static List <Employer> Search(string name)
{
using (DbContext dbContext = new DbContext())
{
return(new List <Employer>()
{
new Employer()
{
AccountNumber = "EMP001", ID = 1, Name = "Deloitte", AccountProfile = "Active"
},
new Employer()
{
AccountNumber = "EMP002", ID = 2, Name = "Deloitte2", AccountProfile = "Active"
},
new Employer()
{
AccountNumber = "EMP003", ID = 3, Name = "Deloitte3", AccountProfile = "Active"
},
new Employer()
{
AccountNumber = "EMP004", ID = 4, Name = "Deloitte4", AccountProfile = "Active"
}
});
}
}
public static EmployerRegistrationViewModel SubmitRegistration(EmployerRegistrationViewModel employerRegistrationViewModel)
{
using (DbContext context = new DbContext())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
employerRegistrationViewModel.EmployerDto = SetPendingFieldsEmployerDto(employerRegistrationViewModel.EmployerDto, employerRegistrationViewModel.EmployerUnitDto);
employerRegistrationViewModel.EmployerContactDto = SetPendingFieldsEmployerContactDto(employerRegistrationViewModel.EmployerContactDto);
employerRegistrationViewModel.EmployerUnitDto = SetPendingFieldsEmployerUnitDto(employerRegistrationViewModel.EmployerUnitDto, employerRegistrationViewModel.ListAddressLinkDto);
employerRegistrationViewModel.ListAddressLinkDto = SetPendingFieldsListAddressLinkDto(employerRegistrationViewModel.ListAddressLinkDto);
var employer = Employer.FromDto(context, employerRegistrationViewModel.EmployerDto);
var employerUnit = EmployerUnit.FromDto(context, employerRegistrationViewModel.EmployerUnitDto);
employer.EmployerContacts.Add(EmployerContact.FromDto(context, employerRegistrationViewModel.EmployerContactDto));
foreach (var addressLinkDto in employerRegistrationViewModel.ListAddressLinkDto)
{
employerUnit.AddressLinks.Add(AddressLink.FromDto(context, addressLinkDto));
}
employer.EmployerUnits.Add(employerUnit);
context.SaveChanges();
dbContextTransaction.Commit();
employerRegistrationViewModel.EmployerDto = employer.ToDto();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
return(employerRegistrationViewModel);
}
public static Employer GetEmployer(int ID)
{
using (DbContext dbContext = new DbContext())
{
List <Employer> obj = new List <Employer>()
{
new Employer()
{
AccountNumber = "EMP001", ID = 1, Name = "Deloitte", AccountProfile = "Active", EAN = "EAN10010", FEIN = "FEIN3002", LiabilityDate = DateTime.Now, LiabilityIncurred = DateTime.Now.AddDays(10), PaymentMethodType = "Contributory", ChangePaymentMethod = false, HistoryTransfer = true, Successor = false, InitiatedExistingSelfService = false, InitiatedForWageClaim = true, NMPRC = "NMPRC01002", CRS = "CRS0100"
},
new Employer()
{
AccountNumber = "EMP002", ID = 2, Name = "Deloitte2", AccountProfile = "Active"
},
new Employer()
{
AccountNumber = "EMP003", ID = 3, Name = "Deloitte3", AccountProfile = "Active"
},
new Employer()
{
AccountNumber = "EMP004", ID = 4, Name = "Deloitte4", AccountProfile = "Active"
}
};
return(obj.Where(i => i.ID == ID).FirstOrDefault());
}
}
public static WageSubmissionViewModel GetWagePeriod()
{
WageSubmissionViewModel wage = new WageSubmissionViewModel();
wage.ReportingYear = (short)DateTimeUtil.Now.Year;
wage.ContributionRate = GetCurrentContributionRate();
using (DbContext context = new DbContext())
{
//To do Map the Employerid from context.
//wage.Employer = context.Employers.FirstOrDefault(emp => emp.EmployerId == 19).ToDto();
wage.Employer = context.Employers.FirstOrDefault().ToDto();
}
for (int i = 1; i <= 25; i++)
{
WageSubmissionViewModel.WageUnitCustomDto wageUnitDetailDto = new WageSubmissionViewModel.WageUnitCustomDto();
wageUnitDetailDto.SrNo = i;
wageUnitDetailDto.EmployerId = wage.Employer.EmployerId;
wageUnitDetailDto.Employer = wage.Employer;
wage.ListWageUnitDetailDto.Add(wageUnitDetailDto);
}
return(wage);
}
/// <summary>
///
/// </summary>
/// <param name="EmployerId"></param>
/// <returns></returns>
internal static List <VPRequestViewModel> GetRequestColl(int?EmployerId)
{
if (EmployerId is null)
{
return(new List <VPRequestViewModel>());
}
else
{
using (DbContext context = new DbContext())
{
var query = (from req in context.VoluntaryPlanWaiverRequests
from form in context.Forms
where req.EmployerId == EmployerId && req.FormId == form.FormId
select new VPRequestViewModel
{
RequestId = req.VoluntaryPlanWaiverRequestId,
StartDate = req.StartDate,
EndDate = req.EndDate,
StatusCode = form.StatusCode
})?.ToList();
return(query);
}
}
}
public static void Save(SecurityPermissionDto securityPermissionDto)
{
using (DbContext dbContext = new DbContext())
{
SecurityPermission.FromDto(dbContext, securityPermissionDto);
dbContext.SaveChanges();
}
}
public static VoluntaryPlanWaiverRequestDto GetRequest(VoluntaryPlanWaiverRequestDto VoluntaryPlanWaiverRequestDto)
{
using (DbContext context = new DbContext())
{
var record = (from vpwr in context.VoluntaryPlanWaiverRequests.Include("VoluntaryPlanWaiverRequestTypes").Include("Form.FormAttachments.Document")
where vpwr.FormId == VoluntaryPlanWaiverRequestDto.FormId
select vpwr).FirstOrDefault();
return(record.ToDtoDeep(context));
}
}
public static EmployerRegistrationViewModel ValidateIntroduction(EmployerRegistrationViewModel employerRegistrationViewModel)
{
using (DbContext context = new DbContext())
{
if (context.Employers.Any(emp => emp.Fein == employerRegistrationViewModel.EmployerDto.Fein))
{
Context.ValidationMessages.AddError("The FEIN entered already exists in the system for another employer account. Verify your records to ensure the information you entered is correct and re-enter the FEIN.");
}
}
return(employerRegistrationViewModel);
}
public static EmployerRegistrationViewModel ValidateAdminInfo(EmployerRegistrationViewModel employerRegistrationViewModel)
{
using (DbContext context = new DbContext())
{
if (context.Employers.Any(emp => emp.UserName == employerRegistrationViewModel.EmployerDto.UserName))
{
Context.ValidationMessages.AddError("The Username entered already exists in the system for another employer account. Please re-enter different Username.");
}
}
return(employerRegistrationViewModel);
}
/// <summary>
/// GeNext TaxableAmountSum SeqNumber
/// </summary>
/// <param name="emprAcctId"></param>
/// <param name="rptYr"></param>
/// <param name="rptQtr"></param>
/// <returns></returns>
public static short GetMaxTaxableAmountSumSeqNu(int emprAcctId, short rptYr)
{
short maxTaxableSeqNu;
using (DbContext context = new DbContext())
{
maxTaxableSeqNu = context.TaxableAmountSums.Where(x => x.EmployerId == emprAcctId && x.ReportingYear == rptYr).OrderByDescending(X => X.TaxableAmountSeqNo).Select(x => x.TaxableAmountSeqNo).FirstOrDefault();
}
return(++maxTaxableSeqNu);
}
public static List <SecurityPermissionDto> Search(string sourceType, string sourceName, string targetType, string targetName, string accessType)
{
using (DbContext dbContext = new DbContext())
{
var query = dbContext.SecurityPermissions
.ConditionalWhere(sourceType, x => x.SourceType == sourceType)
.ConditionalWhere(sourceName, x => x.SourceName == sourceName)
.ConditionalWhere(targetType, x => x.TargetType == targetType)
.ConditionalWhere(targetName, x => x.TargetName == targetName)
.ConditionalWhere(accessType, x => x.AccessType == accessType);
return(query.ToDtoList());
}
}
/// <summary>
/// Get Current Tax Rate.
/// </summary>
/// <returns></returns>
public static decimal GetCurrentContributionRate()
{
DateTime currentdate = DateTimeUtil.Now;
using (DbContext context = new DbContext())
{
var taxRate = (from rates in context.TaxRates
where rates.EffectiveBeginDate <= currentdate & currentdate <= rates.EffectiveEndDate
select rates._TaxRate).FirstOrDefault();
return(Convert.ToDecimal(taxRate));
}
}
public static WageSubmissionViewModel ValidateSelectionMethod(WageSubmissionViewModel wageDetail)
{
using (DbContext context = new DbContext())
{
if (context.TaxableAmountSums.Any(x => x.ReportingQuarter == wageDetail.ReportingQuarter && x.ReportingYear == wageDetail.ReportingYear && x.EmployerId == wageDetail.Employer.EmployerId))
{
Context.ValidationMessages.AddError("Original Employment and Wage Detail Report for this year " + wageDetail.ReportingYear + " and quarter " + LookupUtil.GetLookupCode(LookupTable.Quarter, wageDetail.ReportingQuarter).Display + " has already been submitted");
}
}
wageDetail.AdjReasonDisplay = LookupUtil.GetLookupCode(LookupTable.WageDetailAdjReasonCode, LookupTable_WageDetailAdjReasonCode.Original).Display.ToString();
wageDetail.AdjReasonCode = LookupTable_WageDetailAdjReasonCode.Original;
return(wageDetail);
}
public static Record Fetch(int id)
{
using (DbContext context = new DbContext())
{
//var query = (from p in context.People
// let a = p.Addresses.FirstOrDefault()
// let pc_email = p.PersonContacts.Where(pc => pc.InvalidContactInfoInd == "N" && pc.PersonContactTypeCode == LookupTable_PersonContactType.EmailAddress).OrderByDescending(pc => pc.PreferredContactInd).FirstOrDefault()
// let pc_phone = p.PersonContacts.Where(pc => pc.InvalidContactInfoInd == "N" && (pc.PersonContactTypeCode == LookupTable_PersonContactType.HomePhoneNumber || pc.PersonContactTypeCode == LookupTable_PersonContactType.MobilePhoneNumber)).OrderByDescending(pc => pc.PreferredContactInd).FirstOrDefault()
// orderby p.LastName, p.FirstName, p.MiddleName
// where p.PersonID == id
// select new
// {
// p.FirstName,
// p.LastName,
// p.MiddleName,
// p.SuffixCode,
// a.Line1Address,
// a.Line2Address,
// a.City,
// a.StateCode,
// Postal = a.ZipCode,
// Record = new Record
// {
// ID = p.PersonID,
// Ssn = p.SsnEinID,
// DateOfBirth = p.BirthDate,
// DateOfDeath = p.DeathDate,
// GenderCode = p.GenderCode,
// Email = pc_email.PersonContactTypeText,
// Phone = pc_phone.PersonContactTypeText
// }
// });
//var record = query.FirstOrDefault();
//if (record != null)
//{
// record.Record.Name = StringUtil.FormatName(record.FirstName, record.MiddleName, record.LastName, record.SuffixCode);
// record.Record.FormattedAddressLine1 = record.Line2Address;
// record.Record.FormattedAddressLine2 = record.City;
// record.Record.FormattedAddressLine2 += (!string.IsNullOrEmpty(record.Record.FormattedAddressLine2) ? ", " : "") + record.StateCode;
// record.Record.FormattedAddressLine2 += (!string.IsNullOrEmpty(record.Record.FormattedAddressLine2) ? " " : "") + FormatterUtil.Format(Formatter.Postal, record.Postal);
//}
//return record.Record;
return(null);
}
}
public static List <VoluntaryPlanWaiverRequestDto> SubmitRequest(VoluntaryPlanWaiverRequestDto VPRequestForm)
{
ExecuteSubmitRequestRules(VPRequestForm);
if (Context.ValidationMessages.Count(ValidationMessageSeverity.Error) == 0)
{
using (DbContext context = new DbContext())
{
VPRequestForm.VoluntaryPlanWaiverRequestTypes.RemoveAll(r => r.LeaveTypeCode == null);
VoluntaryPlanWaiverRequest.FromDto(context, VPRequestForm);
context.SaveChanges();
}
}
else
{
Context.ValidationMessages.ThrowCheck(ValidationMessageSeverity.Error);
}
return(GetRequestColl(VPRequestForm.EmployerId));
}
public static Record Fetch(int id)
{
using (DbContext context = new DbContext())
{
//var query = (from a in context.Agencies
// where a.AgencyID == id
// select new Record
// {
// ID = a.AgencyID,
// Name = a.AgencyName,
// Code = a.AgencyCode,
// Status = a.StatusCode
// });
//return query.FirstOrDefault();
return(null);
}
}
public static List <ResultRecord> Search(SearchCriteria criteria)
{
using (DbContext context = new DbContext())
{
//var query = (from a in context.Agencies
// orderby a.AgencyName
// select new ResultRecord
// {
// Id = a.AgencyID,
// Name = a.AgencyName,
// Code = a.AgencyCode,
// Status = a.StatusCode
// });
//query = query.ConditionalWhere(criteria.Name, q => q.Name.Contains(criteria.Name));
//query = query.Take(501);
//return query.ToList();
return(null);
}
}
public static List <ResultRecord> Search(SearchCriteria criteria)
{
using (DbContext context = new DbContext())
{
//var query = (from p in context.People
// orderby p.LastName, p.FirstName, p.MiddleName
// select new
// {
// p.FirstName,
// p.LastName,
// p.MiddleName,
// p.SuffixCode,
// p.Last4SsnEinID,
// ResultRecord = new ResultRecord
// {
// Id = p.PersonID,
// Ssn = p.SsnEinID,
// AgencyNum = 0, //TODO: ?? - need to assign agency
// PlanCode = null, //TODO: ?? - need to assign plan code
// LastCheckDate = null, //TODO: ?? - need to assign last check date
// IsRetired = p.RetiredMemberInd == "Y",
// DateOfBirth = p.BirthDate,
// GenderCode = p.GenderCode
// }
// });
//query = query.ConditionalWhere(criteria?.Ssn?.Length == 9, q => q.ResultRecord.Ssn == criteria.Ssn);
//query = query.ConditionalWhere(criteria?.Ssn?.Length == 4, q => q.Last4SsnEinID == criteria.Ssn);
//query = query.ConditionalWhere(criteria.Name, q => q.FirstName.Contains(criteria.Name) || q.LastName.Contains(criteria.Name) || q.MiddleName.Contains(criteria.Name)); //TODO: ?? enhance to support case-insensitive searching for Oracle?
//var records = query.Take(501).ToList();
//foreach (var record in records)
//{
// record.ResultRecord.Name = StringUtil.FormatName(record.FirstName, record.MiddleName, record.LastName, record.SuffixCode);
//}
//return records.Select(r => r.ResultRecord).ToList();
return(null);
}
}
public static VoluntaryPlanWaiverRequestDto GetRequest(int RequestId)
{
using (DbContext context = new DbContext())
{
#region Commented
//var query = (from req in context.VoluntaryPlanWaiverRequests
// join frm in context.Forms
// on req.FormId equals frm.FormId
// join reqtyp in context.VoluntaryPlanWaiverRequestTypes
// on req.VoluntaryPlanWaiverRequestId equals reqtyp.VoluntaryPlanWaiverRequestId
// //join frmatt in context.FormAttachments
// //on frm.FormId equals frmatt.FormId
// //join doc in context.Documents
// //on frmatt.DocumentId equals doc.DocumentID
// where req.VoluntaryPlanWaiverRequestId == RequestId
// select new VPRequestViewModel
// {
// RequestId = req.VoluntaryPlanWaiverRequestId,
// StartDate = req.StartDate,
// EndDate = req.EndDate,
// TypesofLeaveAvailable = reqtyp.LeaveTypeCode,
// WeeksAvailableAnnually = reqtyp.DurationInWeeksCode,
// PercentageofWagesPaid = reqtyp.PercentagePaid,
// DocumentName = "My Document"//doc.DocumentName
// })?.ToList();
//return query;
#endregion
var record = (from vpwr in context.VoluntaryPlanWaiverRequests.Include("VoluntaryPlanWaiverRequestTypes").Include("Form.FormAttachments.Document")
where vpwr.VoluntaryPlanWaiverRequestId == RequestId
select vpwr).FirstOrDefault();
return(record.ToDtoDeep(context));
}
}
public static MakePaymentViewModel GetEmployerDueAmount(int emprAccountID)
{
MakePaymentViewModel LocalPaymentViewModel = new MakePaymentViewModel();
EmployerAccountTransactionDto localEmployerAccountTransaction = new EmployerAccountTransactionDto();
EmployerDto localEmployerDto = new EmployerDto();
PaymentMainDto localPaymentMainDto = new PaymentMainDto();
PaymentProfileDto localPaymentProfileDto = new PaymentProfileDto();
using (DbContext context = new DbContext())
{
localEmployerDto = (from employerDetail in context.Employers
where employerDetail.EmployerId == emprAccountID
select new EmployerDto
{
EmployerId = employerDetail.EmployerId,
EntityName = employerDetail.EntityName,
}).FirstOrDefault();
if (localEmployerDto != null)
{
localEmployerAccountTransaction = (from emptranDetail in context.EmployerAccountTransactions
where emptranDetail.EmployerId == localEmployerDto.EmployerId
select new EmployerAccountTransactionDto
{
OwedAmount = emptranDetail.OwedAmount,
UnpaidAmount = emptranDetail.UnpaidAmount
}).FirstOrDefault();
localPaymentMainDto = (from pmtMainDetail in context.PaymentMains
where pmtMainDetail.EmployerId == localEmployerAccountTransaction.EmployerId
select new PaymentMainDto
{
RoutingTransitNumber = pmtMainDetail.RoutingTransitNumber,
BankAccountNumber = pmtMainDetail.BankAccountNumber,
BankAccountTypeCode = pmtMainDetail.BankAccountTypeCode,
PaymentAmount = pmtMainDetail.PaymentAmount,
PaymentTransactionDate = pmtMainDetail.PaymentTransactionDate,
PaymentMethodCode = pmtMainDetail.PaymentMethodCode,
PaymentStatusCode = pmtMainDetail.PaymentStatusCode,
PaymentMainId = pmtMainDetail.PaymentMainId
}).FirstOrDefault();
localPaymentProfileDto = (from pmtProfile in context.PaymentProfiles
where pmtProfile.EmployerId == localPaymentMainDto.EmployerId && pmtProfile.BankAccountNumber == localPaymentMainDto.BankAccountNumber
select new PaymentProfileDto
{
AgentId = pmtProfile.AgentId,
BankAccountNumber = pmtProfile.BankAccountNumber,
CreateDateTime = pmtProfile.CreateDateTime,
CreateUserId = pmtProfile.CreateUserId,
EmployerId = pmtProfile.EmployerId,
PaymentAccountTypeCode = pmtProfile.PaymentAccountTypeCode,
PaymentProfileId = pmtProfile.PaymentProfileId,
PaymentTypeCode = pmtProfile.PaymentTypeCode,
RoutingTransitNumber = pmtProfile.RoutingTransitNumber,
UpdateDateTime = pmtProfile.UpdateDateTime,
UpdateNumber = pmtProfile.UpdateNumber,
UpdateUserId = pmtProfile.UpdateUserId,
}).FirstOrDefault();
}
}
LocalPaymentViewModel.EmployerAccountTransactionDto = localEmployerAccountTransaction;
LocalPaymentViewModel.EmployerDto = localEmployerDto;
LocalPaymentViewModel.PaymentMainDto = localPaymentMainDto;
LocalPaymentViewModel.PaymentProfileDto = localPaymentProfileDto;
return(LocalPaymentViewModel);
}
public static List <VPRequestViewModel> SubmitRequest(VPRequestForm VPRequestForm)
{
#region Commented
//VoluntaryPlanWaiverRequestDto obj = new VoluntaryPlanWaiverRequestDto();
//obj.EmployerId = 1;
//obj.StartDate = DateTime.Now;
//obj.EndDate = DateTime.Now;
//obj.IsVoluntaryPlanWaiverRequestAcknowledged = true;
//obj.VoluntaryPlanWaiverRequestTypes.Add(new VoluntaryPlanWaiverRequestTypeDto()
//{
// LeaveTypeCode = LookupTable_WaiverLeaveType.Medical,
// PercentagePaid = 2,
// DurationInWeeksCode = LookupTable_WaiverWeeksAvailable._1Week
//});
//obj.VoluntaryPlanWaiverRequestTypes.Add(new VoluntaryPlanWaiverRequestTypeDto()
//{
// LeaveTypeCode = LookupTable_WaiverLeaveType.Medical,
// PercentagePaid = 1,
// DurationInWeeksCode = LookupTable_WaiverWeeksAvailable._4Weeks
//});
//VPRequestForm = new VPRequestForm()
//{
// EmployerId = 1,
// StartDate = DateTime.Now,
// EndDate = DateTime.Now,
// IsAcknolwedged = true,
// RequestType = new List<VoluntaryPlanWaiverRequestTypeDto>() {
// new VoluntaryPlanWaiverRequestTypeDto()
// {
// LeaveTypeCode = LookupTable_WaiverLeaveType.Medical,
// PercentagePaid = 2,
// DurationInWeeksCode = LookupTable_WaiverWeeksAvailable._1Week
// },
// new VoluntaryPlanWaiverRequestTypeDto()
// {
// LeaveTypeCode = LookupTable_WaiverLeaveType.Medical,
// PercentagePaid = 1,
// DurationInWeeksCode = LookupTable_WaiverWeeksAvailable._1Week
// }
// },
// Document = new List<DocumentDto>() {
// new DocumentDto(){
// DocumentDescription="Doc Description",
// DocumentName ="DJ.pdf"
// }
// }
//};
#endregion
ExecuteSubmitRequestRules(VPRequestForm);
if (Context.ValidationMessages.Count(ValidationMessageSeverity.Error) == 0)
{
using (DbContext context = new DbContext())
{
FormDto FormReq = new FormDto()
{
FormTypeCode = LookupTable_FormType.VPWaiverForm,
StatusCode = LookupTable_WaiverRequestStatus.SavedasDraft
};
Form.FromDto(context, FormReq);
VoluntaryPlanWaiverRequestDto VPWReq = new VoluntaryPlanWaiverRequestDto()
{
EmployerId = VPRequestForm.EmployerId,
StartDate = VPRequestForm.StartDate,
EndDate = VPRequestForm.EndDate,
IsVoluntaryPlanWaiverRequestAcknowledged = VPRequestForm.IsAcknolwedged
};
VoluntaryPlanWaiverRequest.FromDto(context, VPWReq);
VPRequestForm.RequestType.RemoveAll(p => string.IsNullOrWhiteSpace(p.LeaveTypeCode));
foreach (var requestType in VPRequestForm.RequestType)
{
VoluntaryPlanWaiverRequestType VPWReqType = new VoluntaryPlanWaiverRequestType()
{
LeaveTypeCode = requestType.LeaveTypeCode,
PercentagePaid = requestType.PercentagePaid,
DurationInWeeksCode = requestType.DurationInWeeksCode
};
context.VoluntaryPlanWaiverRequestTypes.Add(VPWReqType);
}
if (VPRequestForm.Document != null)
{
foreach (var docItem in VPRequestForm.Document)
{
Document doc = new Document()
{
DocumentName = docItem.DocumentName,
ExternalDocumentId = Guid.NewGuid(),
DocumentDescription = docItem.DocumentDescription
};
context.Documents.Add(doc);
context.FormAttachments.Add(new FormAttachment());
}
}
context.SaveChanges();
}
}
else
{
Context.ValidationMessages.ThrowCheck(ValidationMessageSeverity.Error);
}
return(GetRequestColl(VPRequestForm.EmployerId));
}
public static WageSubmissionViewModel ValidateTax(WageSubmissionViewModel wageDetail)
{
wageDetail.EmployerAccountTransactionDto.EmployerId = wageDetail.Employer.EmployerId;
wageDetail.EmployerAccountTransactionDto.ReportingQuarter = wageDetail.ReportingQuarter;
wageDetail.EmployerAccountTransactionDto.ReportingYear = wageDetail.ReportingYear;
wageDetail.EmployerAccountTransactionDto.TypeCode = LookupTable_TransactionType.ContributionsPrinciple;
wageDetail.EmployerAccountTransactionDto.StatusCode = LookupTable_PaymentStatus.PaymentStatusUnpaid;
wageDetail.EmployerAccountTransactionDto.DueDate = DateTimeUtil.Now.AddDays(Convert.ToDouble(LookupTable_PremiumPaymentDueDays.PremiumPaymentDueDays));
wageDetail.TaxableAmountSumDto.EmployerId = wageDetail.Employer.EmployerId;
wageDetail.TaxableAmountSumDto.ReportingQuarter = wageDetail.ReportingQuarter;
wageDetail.TaxableAmountSumDto.ReportingYear = wageDetail.ReportingYear;
wageDetail.TaxableAmountSumDto.StatusCode = LookupTable_TaxableAmSumStatus.Submitted;
wageDetail.TaxableAmountSumDto.TaxableAmountSeqNo = GetMaxTaxableAmountSumSeqNu(wageDetail.Employer.EmployerId, wageDetail.ReportingYear);
int quaterNumber = Convert.ToInt16(wageDetail.ReportingQuarter.ToString().Remove(0, 1));
if (quaterNumber == 1)
{
wageDetail.TaxableAmountSumDto.Quarter1TaxableAmt = wageDetail.GrossWages;
wageDetail.TaxableAmountSumDto.Quarter1GrossAmt = wageDetail.GrossWages;
}
if (quaterNumber == 2)
{
wageDetail.TaxableAmountSumDto.Quarter2TaxableAmt = wageDetail.GrossWages;
wageDetail.TaxableAmountSumDto.Quarter2GrossAmt = wageDetail.GrossWages;
}
if (quaterNumber == 3)
{
wageDetail.TaxableAmountSumDto.Quarter3TaxableAmt = wageDetail.GrossWages;
wageDetail.TaxableAmountSumDto.Quarter3GrossAmt = wageDetail.GrossWages;
}
if (quaterNumber == 4)
{
wageDetail.TaxableAmountSumDto.Quarter4TaxableAmt = wageDetail.GrossWages;
wageDetail.TaxableAmountSumDto.Quarter4GrossAmt = wageDetail.GrossWages;
}
using (DbContext context = new DbContext())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
foreach (var wageUnitDetails in wageDetail.ListWageUnitDetailDto.Where(x => x.Ssn != null))
{
wageUnitDetails.Employer = null;
WageUnitDetail.FromDto(context, wageUnitDetails);
context.SaveChanges();
}
EmployerAccountTransaction.FromDto(context, wageDetail.EmployerAccountTransactionDto);
context.SaveChanges();
TaxableAmountSum.FromDto(context, wageDetail.TaxableAmountSumDto);
context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
return(wageDetail);
}