public IEnumerable <T> FindWarehouseDashboardData(List <Dictionary <string, object> > keyValueParam) { var result = new List <RequestOrder>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_REQUEST_ORDER_WAREHOUSE") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var RequestOrder = new RequestOrder(); RequestOrder.RequestOrderID = int.Parse(reader[0].ToString()); RequestOrder.VoucherCode = reader[1].ToString(); RequestOrder.RequestDate = DateTime.Parse(reader[2].ToString()); RequestOrder.WarehouseID = int.Parse(reader[3].ToString()); RequestOrder.WarehouseName = reader[4].ToString(); RequestOrder.DepartementID = int.Parse(reader[5].ToString()); RequestOrder.DepartementName = reader[6].ToString(); RequestOrder.Note = reader[7].ToString(); result.Add(RequestOrder); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <StockAdjustment>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_STOCK_ADJUSTMENT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var stockAdjustment = new StockAdjustment { AdjustmentID = int.Parse(reader[0].ToString()), VoucherCode = reader[1].ToString(), AdjustmentDate = DateTime.Parse(reader[2].ToString()), ProductCode = reader[3].ToString(), ProductName = reader[4].ToString(), AdjustmentType = reader[5].ToString(), Qty = decimal.Parse(reader[6].ToString()), Note = reader[7].ToString() }; result.Add(stockAdjustment); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Costumer>(); using (DBClass = new MSSQLDatabase()) { SqlCommand cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_OUTLET_COSTUMER"); RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var costumer = new Costumer(int.Parse(reader[9].ToString())); costumer.CustId = int.Parse(reader[0].ToString()); costumer.FirstName = reader[1].ToString(); costumer.LastName = reader[2].ToString(); costumer.Address = reader[3].ToString(); costumer.Phone = reader[4].ToString(); costumer.MobilePhone = reader[5].ToString(); costumer.Email = reader[6].ToString(); costumer.StatusId = int.Parse(reader[7].ToString()); costumer.Active = reader[8].ToString() == "True"; result.Add(costumer); } } return(result as List <T>); }
public IEnumerable <T> DashboardCreditPastDueAlertNotification(List <Dictionary <string, object> > keyValueParam) { var result = new List <SalesCredit>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_SALES_CREDIT_PAST_DUE_NOTIFICATION") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var salesCredit = new SalesCredit(); salesCredit.CreditID = int.Parse(reader[0].ToString()); salesCredit.SalesVoucherCode = reader[1].ToString(); salesCredit.DepartementName = reader[2].ToString(); salesCredit.CustomerName = reader[3].ToString(); salesCredit.CreditDate = DateTime.Parse(reader[4].ToString()); salesCredit.TotalCredit = decimal.Parse(reader[5].ToString()); salesCredit.TotalInstallment = decimal.Parse(reader[6].ToString()); salesCredit.CreditBalance = decimal.Parse(reader[7].ToString()); result.Add(salesCredit); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <ProformaInvoice>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_PROFORMA_INVOICE") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var proforma = new ProformaInvoice(); proforma.ProformaID = int.Parse(reader[0].ToString()); proforma.VoucherCode = reader[1].ToString(); proforma.SalesDate = DateTime.Parse(reader[2].ToString()); proforma.CustomerName = reader[3].ToString(); proforma.DepartementName = reader[4].ToString(); proforma.MarketingName = reader[5].ToString(); proforma.Note = reader[6].ToString(); proforma.Discount = decimal.Parse(reader[7].ToString()); proforma.Shipping = decimal.Parse(reader[8].ToString()); proforma.GrandTotal = decimal.Parse(reader[9].ToString()); result.Add(proforma); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <JobCosting>(); using (DBClass = new MSSQLDatabase()) { SqlCommand cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_JOB_COSTING"); RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var jobCosting = new JobCosting(); jobCosting.JobCostingID = int.Parse(reader[0].ToString()); jobCosting.VoucherCode = reader[1].ToString(); jobCosting.JobCostingDate = DateTime.Parse(reader[2].ToString()); jobCosting.DestinationCode = reader[3].ToString(); jobCosting.DestinationName = reader[4].ToString(); jobCosting.DestinationQty = decimal.Parse(reader[5].ToString()); jobCosting.DestinationDate = DateTime.Parse(reader[6].ToString()); jobCosting.Note = reader[7].ToString(); result.Add(jobCosting); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <BankAccount>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_BANK_ACCOUNT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var bankAccount = new BankAccount(); bankAccount.BankAccountID = int.Parse(reader[0].ToString()); bankAccount.DepartementName = reader[1].ToString(); bankAccount.BankName = reader[2].ToString(); bankAccount.AccountNumber = reader[3].ToString(); bankAccount.AccountName = reader[4].ToString(); bankAccount.StartingBalance = decimal.Parse(reader[5].ToString()); bankAccount.CurrentBalance = decimal.Parse(reader[6].ToString()); bankAccount.Active = bool.Parse(reader[7].ToString()); result.Add(bankAccount); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Product>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PRODUCT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var product = new Product(); product.ProductID = int.Parse(reader[0].ToString()); product.ProductCode = reader[1].ToString(); product.ProductName = reader[2].ToString(); product.CategoryName = reader[3].ToString(); product.UnitName = reader[4].ToString(); product.BronzePrice = decimal.Parse(reader[5].ToString()); product.SilverPrice = decimal.Parse(reader[6].ToString()); product.GoldPrice = decimal.Parse(reader[7].ToString()); product.Pricelist = bool.Parse(reader[8].ToString()); product.Active = bool.Parse(reader[9].ToString()); result.Add(product); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <CashBankAdjustment>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_CASH_BANK_ADJUSTMENT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var cashBankAdjustment = new CashBankAdjustment(); cashBankAdjustment.AdjustmentID = int.Parse(reader[0].ToString()); cashBankAdjustment.VoucherCode = reader[1].ToString(); cashBankAdjustment.AdjustmentDate = DateTime.Parse(reader[2].ToString()); cashBankAdjustment.DepartementName = reader[3].ToString(); cashBankAdjustment.BankAccount = reader[4].ToString(); cashBankAdjustment.AdjustmentType = reader[5].ToString(); cashBankAdjustment.Nominal = decimal.Parse(reader[6].ToString()); cashBankAdjustment.Note = reader[7].ToString(); result.Add(cashBankAdjustment); } } return(result as List <T>); }
public IEnumerable <T> FindAllCashIncome(List <Dictionary <string, object> > keyValueParam) { var result = new List <Income>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_CASH_INCOME") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var income = new Income { IncomeID = int.Parse(reader[0].ToString()), VoucherCode = reader[1].ToString(), IncomeDate = DateTime.Parse(reader[2].ToString()), Description = reader[3].ToString(), Nominal = decimal.Parse(reader[4].ToString()), Note = reader[5].ToString() }; result.Add(income); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Customer>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_CUSTOMER") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var customer = new Customer(); customer.CustomerID = int.Parse(reader[0].ToString()); customer.FirstName = StringManipulation.UppercaseFirst(reader[1].ToString()); customer.LastName = StringManipulation.UppercaseFirst(reader[2].ToString()); customer.Address = reader[3].ToString(); customer.Phone = reader[4].ToString(); customer.MobilePhone = reader[5].ToString(); customer.Email = reader[6].ToString(); customer.DepartementName = reader[7].ToString(); customer.StatusName = reader[8].ToString(); customer.Active = bool.Parse(reader[9].ToString()); result.Add(customer); } } return(result as List <T>); }
public IEnumerable <T> FindNormalStock(List <Dictionary <string, object> > keyValueParam) { var result = new List <ProductStock>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_STOCK_WITH_NORMAL_STOCK") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var stock = new ProductStock(); stock.StockID = int.Parse(reader[0].ToString()); stock.ProductID = int.Parse(reader[1].ToString()); stock.ProductCode = reader[2].ToString(); stock.ProductName = reader[3].ToString(); stock.DepartementName = reader[4].ToString(); stock.StartQuantity = decimal.Parse(reader[5].ToString()); stock.CurrentQuantity = decimal.Parse(reader[6].ToString()); stock.MinimumQuantity = decimal.Parse(reader[7].ToString()); result.Add(stock); } } return(result as List <T>); }
public int SaveRow(T param, string createdBy) { int objID = 0; using (DBClass = new MSSQLDatabase()) { try { var cmd = DBClass.GetStoredProcedureCommand("APP_SAVE_NEW_PURCHASE_ORDER") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Insert); DBClass.AddSimpleParameter(cmd, "@CreatedBy", createdBy); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objID = int.Parse(reader[0].ToString()); } var listItems = (param as PurchaseOrder).Items; foreach (var item in listItems) { SavePurchasedItem(objID, item); } } catch (Exception) { DeleteRow(objID, "System"); objID = 0; } } return(objID); }
public IEnumerable <T> FindAllForDashboard(List <Dictionary <string, object> > keyValueParam) { var result = new List <PurchaseOrder>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PURCHASE_ORDER_DASHBOARD") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var purchaseOrder = new PurchaseOrder { PurchaseOrderID = int.Parse(reader[0].ToString()), DepartementID = int.Parse(reader[1].ToString()), VoucherCode = reader[2].ToString(), PurchaseDate = DateTime.Parse(reader[3].ToString()), DepartementName = reader[4].ToString(), SupplierName = reader[5].ToString(), Note = reader[6].ToString() }; result.Add(purchaseOrder); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Departement>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_DEPARTEMENT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var departement = new Departement(); departement.DepartementID = int.Parse(reader[0].ToString()); departement.DepartementName = reader[1].ToString(); departement.CompanyID = int.Parse(reader[2].ToString()); departement.CompanyName = reader[3].ToString(); departement.Address = reader[4].ToString(); departement.Phone = reader[5].ToString(); departement.Head = reader[6].ToString(); departement.WarehouseID = string.IsNullOrEmpty(reader[7].ToString()) ? (int?)null : int.Parse(reader[7].ToString()); departement.WarehouseName = reader[8].ToString(); departement.Active = bool.Parse(reader[9].ToString()); result.Add(departement); } } return(result as List <T>); }
public IEnumerable <SalesInvoice> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <SalesInvoice>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_SALES") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var salesInvoice = new SalesInvoice { InvoiceID = int.Parse(reader[0].ToString()), VoucherCode = reader[1].ToString(), SalesDate = DateTime.Parse(reader[2].ToString()), CustomerName = reader[3].ToString(), DepartementName = reader[4].ToString(), MarketingName = reader[5].ToString(), Note = reader[6].ToString(), Discount = decimal.Parse(reader[7].ToString()), Shipping = decimal.Parse(reader[8].ToString()), GrandTotal = decimal.Parse(reader[9].ToString()) }; result.Add(salesInvoice); } } return(result); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <SalesCredit>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_SALES_CREDIT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var salesCredit = new SalesCredit { CreditID = int.Parse(reader[0].ToString()), SalesID = int.Parse(reader[1].ToString()), SalesVoucherCode = reader[2].ToString(), DepartementName = reader[3].ToString(), CustomerName = reader[4].ToString(), CreditDate = DateTime.Parse(reader[5].ToString()), TotalCredit = decimal.Parse(reader[6].ToString()), TotalInstallment = decimal.Parse(reader[7].ToString()), CreditBalance = decimal.Parse(reader[8].ToString()) }; result.Add(salesCredit); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Repackage>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_STOCK_REPACKAGE") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var repackage = new Repackage(); repackage.RepackageID = int.Parse(reader[0].ToString()); repackage.VoucherCode = reader[1].ToString(); repackage.RepackageDate = DateTime.Parse(reader[2].ToString()); repackage.SourceName = reader[3].ToString(); repackage.SourceQty = decimal.Parse(reader[4].ToString()); repackage.DestinationName = reader[5].ToString(); repackage.DestinationQty = decimal.Parse(reader[6].ToString()); repackage.Note = reader[7].ToString(); result.Add(repackage); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <DepositSales>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_DEPOSIT_SALES") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var depositSales = new DepositSales(); depositSales.DepositAccountID = int.Parse(reader[0].ToString()); depositSales.VoucherCode = reader[1].ToString(); depositSales.DepartementName = reader[2].ToString(); depositSales.AccountByName = reader[3].ToString(); depositSales.StartingBalance = decimal.Parse(reader[4].ToString()); depositSales.Balance = decimal.Parse(reader[5].ToString()); depositSales.Note = reader[6].ToString(); depositSales.CreatedDate = DateTime.Parse(reader[7].ToString()); result.Add(depositSales); } } return(result as List <T>); }
public int SaveRow(SalesInvoice param, string createdBy) { int objID = 0; using (DBClass = new MSSQLDatabase()) { try { var cmd = DBClass.GetStoredProcedureCommand("APP_SAVE_NEW_SALES") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Insert); DBClass.AddSimpleParameter(cmd, "@CreatedBy", createdBy); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objID = int.Parse(reader[0].ToString()); } var listItems = param.Items; var listPayments = param.Payments; foreach (var item in listItems) { if (item.SubTotal > 0) { SaveItem(objID, item); } else { SavePresent(objID, item); } } if (listPayments.Count < 1) { SaveSalesCredit(objID, param.GrandTotal, param.SalesDate); } else { foreach (var payment in listPayments) { SavePayment(objID, payment); } } } catch (Exception) { DeleteRow(objID, "system"); objID = 0; } } return(objID); }
public int UpdateCashIncomeRow(T param, string updatedBy) { using (DBClass = new MSSQLDatabase()) { using (DbTransaction txn = DBClass.BeginTransaction()) { var cmd = DBClass.GetStoredProcedureCommand("APP_UPDATE_INCOME_BY_CASH") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Update); DBClass.AddSimpleParameter(cmd, "@LastUpdatedBy", updatedBy); DBClass.ExecuteNonQuery(cmd, txn); txn.Commit(); } } return(0); }
public int SaveRow(T param, string createdBy) { int objID = 0; using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_SAVE_NOTIFICATION") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Insert); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objID = int.Parse(reader[0].ToString()); } } return(objID); }
public int UpdateRow(T param, string updatedBy) { using (DBClass = new MSSQLDatabase()) { using (DbTransaction txn = DBClass.BeginTransaction()) { var cmd = DBClass.GetStoredProcedureCommand("dbo.APP_UPDATE_CUSTOMER") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Update); DBClass.AddSimpleParameter(cmd, "@LastUpdatedBy", updatedBy); DBClass.ExecuteNonQuery(cmd, txn); txn.Commit(); } } /* bypass compiler error need to be updated soon */ return(0); }
public bool UniqueNameAvailableExcept(List <Dictionary <string, object> > keyValueParam) { var result = false; using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_CUSTOMER_NAME_AVAILABLE2") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { result = int.Parse(reader[0].ToString()) == 0; } } return(result); }
public int SaveRow(Bank param, string createdBy) { int objId = 0; using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_SAVE_NEW_BANK") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Insert); DBClass.AddSimpleParameter(cmd, "@CreatedBy", createdBy); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objId = int.Parse(reader[0].ToString()); } } return(objId); }
public int SaveRow(T param, int createdBy) { int objID = 0; using (DBClass = new MSSQLDatabase()) { SqlCommand cmd = DBClass.GetStoredProcedureCommand("dbo.APP_SAVE_NEW_CUSTOMER"); RoutinesParameterSetter.Set(ref cmd, param, CRUDType.Insert); cmd.Parameters.AddWithValue("@CreatedBy", createdBy); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objID = int.Parse(reader[0].ToString()); } } return(objID); }
public IEnumerable <T> FindAllExceptSupervisor(List <Dictionary <string, object> > keyValueParam) { var result = new List <Departement>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_DEPARTEMENT_EXCEPT_SUPERVISOR") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var departement = new Departement(); departement.DepartementID = int.Parse(reader[0].ToString()); departement.DepartementName = reader[1].ToString(); result.Add(departement); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <PublicIP>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PUBLIC_IP") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var publicIP = new PublicIP(); publicIP.PublicIPID = int.Parse(reader[0].ToString()); publicIP.IPAddress = reader[1].ToString(); result.Add(publicIP); } } return(result as List <T>); }
public IEnumerable <Bank> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Bank>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_BANK") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var bank = new Bank(); bank.BankID = int.Parse(reader[0].ToString()); bank.BankName = reader[1].ToString(); result.Add(bank); } } return(result); }
public void PaidWithDepositSales(List <Dictionary <string, object> > keyValueParam) { using (DBClass = new MSSQLDatabase()) { using (DbTransaction txn = DBClass.BeginTransaction()) { try { var cmd = DBClass.GetStoredProcedureCommand("PAID_WITH_DEPOSIT_SALES") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); DBClass.ExecuteNonQuery(cmd, txn); txn.Commit(); } catch (Exception) { } } } }