public List <FAAdjustmentDetailEntity> FAAdjustmentDetails(List <FAAdjustmentDetail> details, string refid) { List <FAAdjustmentDetailEntity> lstDetailEntities = new List <FAAdjustmentDetailEntity>(); foreach (var result in details) { var newresult = new FAAdjustmentDetailEntity(); 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.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 ?? 0; 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.ProjectExpenseId = result.ProjectExpense == null ? null : result.ProjectExpense.ProjectExpenseID.ToString(); newresult.TaskId = result.Task == null ? null : result.Task.TaskID.ToString(); newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString(); newresult.SortOrder = result.SortOrder ?? 0; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.BankId = result.BankAccount; newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString(); newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode; newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString(); //newresult.BudgetExpenseId = result.BudgetExpense; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
//public FAIncrementDecrementEntity GetFAIncrementDecrementByRefNo(string refNo) //{ // const string procedures = @"uspGet_FAIncrementDecrement_ByRefNo"; // object[] parms = {"@RefNo", refNo}; // return Db.Read(procedures, true, Make, parms); //} private static object[] Take(FAAdjustmentDetailEntity fAAdjustmentEntity) { return(new object[] { "@RefDetailID", fAAdjustmentEntity.RefDetailId, "@RefID", fAAdjustmentEntity.RefId, "@Description", fAAdjustmentEntity.Description, "@DebitAccount", fAAdjustmentEntity.DebitAccount, "@CreditAccount", fAAdjustmentEntity.CreditAccount, "@Amount", fAAdjustmentEntity.Amount, "@BudgetSourceID", fAAdjustmentEntity.BudgetSourceId, "@BudgetChapterCode", fAAdjustmentEntity.BudgetChapterCode, "@BudgetKindItemCode", fAAdjustmentEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", fAAdjustmentEntity.BudgetSubKindItemCode, "@BudgetItemCode", fAAdjustmentEntity.BudgetItemCode, "@BudgetSubItemCode", fAAdjustmentEntity.BudgetSubItemCode, "@MethodDistributeID", fAAdjustmentEntity.MethodDistributeId, "@CashWithDrawTypeID", fAAdjustmentEntity.CashWithDrawTypeId, "@AccountingObjectID", fAAdjustmentEntity.AccountingObjectId, "@ActivityID", fAAdjustmentEntity.ActivityId, "@ProjectID", fAAdjustmentEntity.ProjectId, "@ProjectActivityID", fAAdjustmentEntity.ProjectActivityId, "@ProjectExpenseID", fAAdjustmentEntity.ProjectExpenseId, "@TaskID", fAAdjustmentEntity.TaskId, "@ListItemID", fAAdjustmentEntity.ListItemId, "@SortOrder", fAAdjustmentEntity.SortOrder, "@BudgetDetailItemCode", fAAdjustmentEntity.BudgetDetailItemCode, "@FundStructureID", fAAdjustmentEntity.FundStructureId, "@BankID", fAAdjustmentEntity.BankId, "@ProjectExpenseEAID", fAAdjustmentEntity.ProjectExpenseEAId, "@ProjectActivityEAID", fAAdjustmentEntity.ProjectActivityEAId, "@BudgetProvideCode", fAAdjustmentEntity.BudgetProvideCode, "@TopicID", fAAdjustmentEntity.TopicId, "@BudgetExpenseID", fAAdjustmentEntity.BudgetExpenseId, "@ContractID", fAAdjustmentEntity.ContractId, "@CapitalPlanID", fAAdjustmentEntity.CapitalPlanId, }); }
public string InsertFAAdjustmentDetail(FAAdjustmentDetailEntity fAAdjustmentEntity) { const string sql = @"uspInsert_FAAdjustmentDetail"; return(Db.Insert(sql, true, Take(fAAdjustmentEntity))); }