public List <CAPaymentDetailEntity> CAPaymentDetails(List <CAPaymentDetail> details, string refid) { List <CAPaymentDetailEntity> lstDetailEntities = new List <CAPaymentDetailEntity>(); foreach (var result in details) { var newresult = new CAPaymentDetailEntity(); newresult.RefDetailId = result.RefDetailID.ToString(); newresult.RefId = refid; newresult.Description = result.Description; newresult.DebitAccount = result.DebitAccount; newresult.CreditAccount = result.CreditAccount; newresult.Amount = result.Amount; newresult.AmountOC = result.AmountOC; newresult.BudgetSourceId = result.BudgetSource == null ? null : result.BudgetSource.BudgetSourceID.ToString(); newresult.BudgetChapterCode = result.BudgetChapterCode; newresult.BudgetKindItemCode = result.BudgetKindItemCode; newresult.BudgetSubKindItemCode = result.BudgetSubKindItemCode; newresult.BudgetItemCode = result.BudgetItemCode; newresult.BudgetSubItemCode = result.BudgetSubItemCode; newresult.MethodDistributeId = result.MethodDistributeID; newresult.CashWithDrawTypeId = ConvertCash.ConvertCash(result.CashWithDrawTypeID); newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString(); newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString(); newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString(); newresult.ProjectActivityId = result.Project1 == null ? null : result.Project1.ProjectID.ToString(); newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.Approved = result.Approved; newresult.SortOrder = result.SortOrder ?? 0; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.OrgRefNo = result.OrgRefNo; newresult.OrgRefDate = result.OrgRefDate; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.BankId = result.BankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.BankAccount).BankInfoID.ToString(); newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString(); newresult.BudgetExpenseId = result.BudgetExpenseID.ToString(); lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
private static object[] Take(CAPaymentDetailEntity cAPaymentDetailEntity) { return(new object[] { "@RefDetailId", cAPaymentDetailEntity.RefDetailId, "@RefId", cAPaymentDetailEntity.RefId, "@Description", cAPaymentDetailEntity.Description, "@DebitAccount", cAPaymentDetailEntity.DebitAccount, "@CreditAccount", cAPaymentDetailEntity.CreditAccount, "@Amount", cAPaymentDetailEntity.Amount, "@AmountOC", cAPaymentDetailEntity.AmountOC, "@BudgetSourceId", cAPaymentDetailEntity.BudgetSourceId, "@BudgetChapterCode", cAPaymentDetailEntity.BudgetChapterCode, "@BudgetKindItemCode", cAPaymentDetailEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", cAPaymentDetailEntity.BudgetSubKindItemCode, "@BudgetItemCode", cAPaymentDetailEntity.BudgetItemCode, "@BudgetSubItemCode", cAPaymentDetailEntity.BudgetSubItemCode, "@MethodDistributeId", cAPaymentDetailEntity.MethodDistributeId, "@CashWithDrawTypeId", cAPaymentDetailEntity.CashWithDrawTypeId, "@AccountingObjectId", cAPaymentDetailEntity.AccountingObjectId, "@ActivityId", cAPaymentDetailEntity.ActivityId, "@ProjectId", cAPaymentDetailEntity.ProjectId, "@ProjectActivityId", cAPaymentDetailEntity.ProjectActivityId, "@ListItemId", cAPaymentDetailEntity.ListItemId, "@Approved", cAPaymentDetailEntity.Approved, "@SortOrder", cAPaymentDetailEntity.SortOrder, "@BudgetDetailItemCode", cAPaymentDetailEntity.BudgetDetailItemCode, "@OrgRefNo", cAPaymentDetailEntity.OrgRefNo, "@OrgRefDate", cAPaymentDetailEntity.OrgRefDate, "@FundStructureId", cAPaymentDetailEntity.FundStructureId, "@BankId", cAPaymentDetailEntity.BankId, "@ProjectExpenseEAId", cAPaymentDetailEntity.ProjectExpenseEAId, "@ProjectActivityEAId", cAPaymentDetailEntity.ProjectActivityEAId, "@BudgetExpenseID", cAPaymentDetailEntity.BudgetExpenseId, "@ContractID", cAPaymentDetailEntity.ContractId, "@CapitalPlanID", cAPaymentDetailEntity.CapitalPlanId, "@AutoBusinessID", cAPaymentDetailEntity.AutoBusinessId, }); }
public string UpdateCAPaymentDetail(CAPaymentDetailEntity caPaymentDetail) { const string procedures = @"uspUpdate_CAPaymentDetail"; return(Db.Update(procedures, true, Take(caPaymentDetail))); }
public string InsertCAPaymentDetail(CAPaymentDetailEntity caPaymentDetail) { const string procedures = @"uspInsert_CAPaymentDetail"; return(Db.Insert(procedures, true, Take(caPaymentDetail))); }