/// <summary> /// Deletes the bu plan receipt. /// </summary> /// <param name="bUVoucherListEntity">The b u transfer.</param> /// <returns> /// System.String. /// </returns> public string DeleteBUVoucherList(BUVoucherListEntity bUVoucherListEntity) { const string procedures = @"uspDelete_BUVoucherList"; object[] parms = { "@RefId", bUVoucherListEntity.RefId }; return(Db.Delete(procedures, true, parms)); }
public List <BUVoucherListEntity> GetBUVoucherLists(string connectionString) { List <BUVoucherListEntity> buentity = new List <BUVoucherListEntity>(); using (var context = new MISAEntity(connectionString)) { var querry = context.BUVoucherListDetails.ToList(); var projects = context.Projects.ToList(); var currencys = context.CCies.ToList(); var budgetsource = context.BudgetSources.ToList(); var listitems = context.ListItems.ToList(); var funds = context.Funds.ToList(); var fundstructures = context.FundStructures.ToList(); var budgetproviders = context.BudgetProvidences.ToList(); var accountingobject = context.AccountingObjects.ToList(); var projectexpenses = context.ProjectExpenses.ToList(); var activity = context.Activities.ToList(); var tasks = context.Tasks.ToList(); var topics = context.Topics.ToList(); banks = context.BankInfoes.ToList(); var parallel = context.BUVoucherListDetailParallels.ToList(); var detailtransfers = context.BUVoucherListDetailTransfers.ToList(); var resultcontext = context.BUVoucherLists.ToList(); foreach (var result in resultcontext) { var newresult = new BUVoucherListEntity(); newresult.RefId = result.RefID.ToString(); newresult.RefType = ConvRefType.ConvRefType(result.RefType); newresult.RefDate = result.RefDate; newresult.PostedDate = result.PostedDate; newresult.RefNo = result.RefNo; newresult.ParalellRefNo = result.ParalellRefNo; newresult.FromDate = result.FromDate; newresult.ToDate = result.ToDate; newresult.JournalMemo = result.JournalMemo; newresult.Posted = result.Posted; newresult.TotalAmount = result.TotalAmount; newresult.PostVersion = result.PostVersion; newresult.EditVersion = result.EditVersion; newresult.BUVoucherListDetailEntities = result.BUVoucherListDetails.Count <= 0 ? null : BUVoucherListDetails(result.BUVoucherListDetails.ToList(), result.RefID.ToString()); newresult.BUVoucherListDetailParallelEntities = result.BUVoucherListDetailParallels.Count <= 0 ? null : BuVoucherListDetailParallels(result.BUVoucherListDetailParallels.ToList(), result.RefID.ToString()); newresult.BUVoucherListDetailTransferEntities = result.BUVoucherListDetailTransfers.Count <= 0 ? null : BUVoucherListDetailTransfers(result.BUVoucherListDetailTransfers.ToList(), result.RefID.ToString()); buentity.Add(newresult); } } return(buentity); }
/// <summary> /// Takes the specified b u voucher list entity. /// </summary> /// <param name="bUVoucherListEntity">The b u voucher list entity.</param> /// <returns></returns> private static object[] Take(BUVoucherListEntity bUVoucherListEntity) { return(new object[] { "@RefID", bUVoucherListEntity.RefId, "@RefType", bUVoucherListEntity.RefType, "@RefDate", bUVoucherListEntity.RefDate, "@PostedDate", bUVoucherListEntity.PostedDate, "@RefNo", bUVoucherListEntity.RefNo, "@ParalellRefNo", bUVoucherListEntity.ParalellRefNo, "@FromDate", bUVoucherListEntity.FromDate, "@ToDate", bUVoucherListEntity.ToDate, "@JournalMemo", bUVoucherListEntity.JournalMemo, "@Posted", bUVoucherListEntity.Posted, "@TotalAmount", bUVoucherListEntity.TotalAmount, "@PostVersion", bUVoucherListEntity.PostVersion, "@EditVersion", bUVoucherListEntity.EditVersion, "@CurrencyCode", bUVoucherListEntity.CurrencyCode, "@ExchangeRate", bUVoucherListEntity.ExchangeRate, "@TotalAmountOC", bUVoucherListEntity.TotalAmountOC }); }
/// <summary> /// Updates the bu plan receipt. /// </summary> /// <param name="bUVoucherListEntity">The b u transfer.</param> /// <returns> /// System.String. /// </returns> public string UpdateBUVoucherList(BUVoucherListEntity bUVoucherListEntity) { const string procedures = @"uspUpdate_BUVoucherList"; return(Db.Update(procedures, true, Take(bUVoucherListEntity))); }
/// <summary> /// Inserts the bu voucher list. /// </summary> /// <param name="bUVoucherListEntity">The bu voucher list entity.</param> /// <returns></returns> public string InsertBUVoucherList(BUVoucherListEntity bUVoucherListEntity) { const string procedures = @"uspInsert_BUVoucherList"; return(Db.Insert(procedures, true, Take(bUVoucherListEntity))); }