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