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 CreditPayment GetEDCPaymentObject(int EDCCreditID, string createdBy, DateTime logDate) { var result = new CreditPayment(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_EDC_PAYMENT") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@SalesCreditId", EDCCreditID); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { result.BankLogObject = new BankLogObject { CashBankID = int.Parse(reader[0].ToString()), Description = string.Format("Pelunasan pembayaran via EDC oleh {0}", reader[3]), Deposit = decimal.Parse(reader[1].ToString()), Withdraw = 0, SalesVoucher = reader[2].ToString(), Note = "", CreatedBy = createdBy, CreatedDate = logDate }; } } return(result); }
public IEnumerable <CreditPayment> GetSalesCreditPayment(int salesID) { var result = new List <CreditPayment>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_SALES_CREDIT_PAYMENT") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@SalesId", salesID); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var payment = new CreditPayment { CreditPaymentID = int.Parse(reader[0].ToString()), CreditPaymentType = int.Parse(reader[1].ToString()), CashLogObject = new CashLogObject { DepartementID = int.Parse(reader[2].ToString()), CashID = string.IsNullOrEmpty(reader[3].ToString()) ? 0 : int.Parse(reader[3].ToString()), SalesVoucher = reader[5].ToString(), CreatedDate = DateTime.Parse(reader[6].ToString()) }, BankLogObject = new BankLogObject { CashBankID = string.IsNullOrEmpty(reader[4].ToString()) ? 0 : int.Parse(reader[4].ToString()), SalesVoucher = reader[5].ToString(), CreatedDate = DateTime.Parse(reader[6].ToString()) } }; result.Add(payment); } } return(result); }
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 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> 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 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 <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 <Items> GetSalesItems(int salesID) { var result = new List <Items>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_SALES_ITEM_AND_PRESENT") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@SalesId", salesID); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var item = new Items { SalesID = salesID, ItemID = int.Parse(reader[0].ToString()), ProductID = int.Parse(reader[1].ToString()), ProductCode = reader[2].ToString(), ProductName = reader[3].ToString(), Qty = decimal.Parse(reader[4].ToString()), Price = decimal.Parse(reader[5].ToString()), SubTotal = decimal.Parse(reader[6].ToString()), Keterangan = reader[7].ToString(), UnitName = reader[9].ToString(), LogObject = new StockLogObject { DepartementID = int.Parse(reader[10].ToString()), ProductID = int.Parse(reader[1].ToString()), SalesVoucher = reader[11].ToString() } }; result.Add(item); } } return(result); }
public T FindbyId(int id) { var departement = new Departement(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_DEPARTEMENT_BY_ID") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@DepartementId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { 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.SupervisorID = string.IsNullOrEmpty(reader[7].ToString()) ? (int?)null : int.Parse(reader[7].ToString()); departement.SupervisorName = reader[8].ToString(); departement.WarehouseID = string.IsNullOrEmpty(reader[9].ToString()) ? (int?)null : int.Parse(reader[9].ToString()); departement.WarehouseName = reader[10].ToString(); departement.IsSupervisor = bool.Parse(reader[11].ToString()); departement.IsTreasurer = bool.Parse(reader[12].ToString()); departement.IsWarehouse = bool.Parse(reader[13].ToString()); departement.IsOutlet = bool.Parse(reader[14].ToString()); departement.Active = bool.Parse(reader[15].ToString()); } } return(departement as 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 <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 IList <ProductionResult> GetProductionResults(int productionID) { var result = new List <ProductionResult>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_PRODUCTION_OUTPUTS") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@ProductionId", productionID); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var item = new ProductionResult { ProductionID = productionID, ProductID = int.Parse(reader[0].ToString()), ProductCode = reader[1].ToString(), ProductName = reader[2].ToString(), Qty = decimal.Parse(reader[3].ToString()), UnitName = reader[4].ToString(), LogObject = new StockLogObject { DepartementID = int.Parse(reader[5].ToString()), ProductID = int.Parse(reader[0].ToString()), ProductionVoucher = reader[6].ToString() } }; result.Add(item); } } return(result); }
public T FindCashIncomeById(int id) { var income = new Income(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_CASH_INCOME_BY_ID") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@IncomeId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { income.IncomeID = int.Parse(reader[0].ToString()); income.VoucherCode = reader[1].ToString(); income.CashID = int.Parse(reader[2].ToString()); income.DepartementId = int.Parse(reader[3].ToString()); income.Description = reader[4].ToString(); income.Nominal = decimal.Parse(reader[5].ToString()); income.Note = reader[6].ToString(); income.IncomeDate = DateTime.Parse(reader[7].ToString()); income.CashLogObject = new CashLogObject { DepartementID = income.DepartementId, CashID = (int)income.CashID, IncomeVoucher = income.VoucherCode }; } } return(income as 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 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 T FindbyId(int id) { var depositSales = new DepositSales(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_DEPOSIT_SALES_BY_ID") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@DepositSalesId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { depositSales.DepositAccountID = int.Parse(reader[0].ToString()); depositSales.VoucherCode = reader[1].ToString(); depositSales.DepartementID = int.Parse(reader[2].ToString()); depositSales.CashBankId = int.Parse(reader[3].ToString()); depositSales.AccountByName = reader[4].ToString(); depositSales.StartingBalance = decimal.Parse(reader[5].ToString()); depositSales.Balance = decimal.Parse(reader[6].ToString()); depositSales.Note = reader[7].ToString(); depositSales.BankLogObject = new BankLogObject { CashBankID = depositSales.CashBankId, DepositSalesVoucher = depositSales.VoucherCode }; } } return(depositSales as T); }
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 <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 <PurchasedItem> GetPurchasedItems(int purchaseOrderId) { var result = new List <PurchasedItem>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_PURCHASE_ORDER_ITEM") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@PurchaseOrderId", purchaseOrderId); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var item = new PurchasedItem { ProductID = int.Parse(reader[0].ToString()), PurchaseOrderID = int.Parse(reader[1].ToString()), ProductCode = reader[2].ToString(), ProductName = reader[3].ToString(), Qty = decimal.Parse(reader[4].ToString()), DeliveredQty = decimal.Parse(reader[5].ToString()), EstimatedDate = DateTime.Parse(reader[6].ToString()), UnitID = int.Parse(reader[7].ToString()), UnitName = reader[8].ToString(), Status = reader[9].ToString() }; result.Add(item); } } return(result); }
public T FindbyId(int id) { var cashBankAdjustment = new CashBankAdjustment(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_CASH_BANK_ADJUSTEMENT_BY_ID") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@CashBankAdjustmentId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { cashBankAdjustment.AdjustmentID = int.Parse(reader[0].ToString()); cashBankAdjustment.VoucherCode = reader[1].ToString(); cashBankAdjustment.DepartementId = int.Parse(reader[2].ToString()); cashBankAdjustment.CashBankId = int.Parse(reader[3].ToString()); cashBankAdjustment.AdjustmentType = reader[4].ToString(); cashBankAdjustment.Nominal = decimal.Parse(reader[5].ToString()); cashBankAdjustment.Note = reader[6].ToString(); cashBankAdjustment.AdjustmentDate = DateTime.Parse(reader[7].ToString()); cashBankAdjustment.LogObject = new BankLogObject { CashBankID = cashBankAdjustment.CashBankId, AdjustmentVoucher = cashBankAdjustment.VoucherCode, CreatedDate = cashBankAdjustment.AdjustmentDate }; } } return(cashBankAdjustment as T); }
public override int SaveStockCRUDLog(CRUDLogObject logObject) { var obj = logObject as StockLogObject; int objID = 0; using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("SAVE_NEW_STOCKFLOW") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@DepartementId", obj.DepartementID); DBClass.AddSimpleParameter(cmd, "@ProductId", obj.ProductID); DBClass.AddSimpleParameter(cmd, "@Description", obj.Description); DBClass.AddSimpleParameter(cmd, "@PurchaseVoucher", obj.PurchaseVoucher); DBClass.AddSimpleParameter(cmd, "@Deposit", obj.Deposit); DBClass.AddSimpleParameter(cmd, "@Withdraw", obj.Withdraw); DBClass.AddSimpleParameter(cmd, "@Note", obj.Note); DBClass.AddSimpleParameter(cmd, "@CreatedBy", obj.CreatedBy); DBClass.AddSimpleParameter(cmd, "@CreatedDate", obj.CreatedDate); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objID = int.Parse(reader[0].ToString()); } } return(objID); }
public T FindbyName(string name) { Customer customer = null; using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_CUSTOMER_BY_NAME") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@Name", name); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { 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.DepartementID = int.Parse(reader[7].ToString()); customer.StatusId = int.Parse(reader[8].ToString()); customer.Active = bool.Parse(reader[9].ToString()); customer.CreditLimit = decimal.Parse(reader[10].ToString()); } } return(customer as 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 override int SaveBankCRUDLog(BankLogObject logObject) { int objID = 0; using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("SAVE_NEW_BANKFLOW") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@CashBankId", logObject.CashBankID); DBClass.AddSimpleParameter(cmd, "@Description", logObject.Description); DBClass.AddSimpleParameter(cmd, "@SalesVoucher", logObject.SalesVoucher); DBClass.AddSimpleParameter(cmd, "@Deposit", logObject.Deposit); DBClass.AddSimpleParameter(cmd, "@Withdraw", logObject.Withdraw); DBClass.AddSimpleParameter(cmd, "@Note", logObject.Note); DBClass.AddSimpleParameter(cmd, "@CreatedBy", logObject.CreatedBy); DBClass.AddSimpleParameter(cmd, "@CreatedDate", logObject.CreatedDate); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { objID = int.Parse(reader[0].ToString()); } if (objID == 0) { throw new Exception(); } } return(objID); }
public T FindbyId(int id) { var product = new Product(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_PRODUCT_BY_ID") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@ProductId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { product.ProductID = int.Parse(reader[0].ToString()); product.ProductCode = reader[1].ToString(); product.ProductName = reader[2].ToString(); product.CategoryID = int.Parse(reader[3].ToString()); product.CategoryName = reader[4].ToString(); product.UnitID = int.Parse(reader[5].ToString()); product.UnitName = reader[6].ToString(); product.BronzePrice = decimal.Parse(reader[7].ToString()); product.SilverPrice = decimal.Parse(reader[8].ToString()); product.GoldPrice = decimal.Parse(reader[9].ToString()); product.Pricelist = bool.Parse(reader[10].ToString()); product.Active = bool.Parse(reader[11].ToString()); } } return(product as T); }
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 string GetNewProductCode(int categoryID) { string productCode = ""; switch (categoryID) { case 1: productCode = "KM-"; break; case 2: productCode = "AL-"; break; case 3: productCode = "LN-"; break; } using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("GETPRODUCTNEWCODENUMBER") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@CategoryId", categoryID); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { productCode += reader[0].ToString(); } } return(productCode); }
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 T FindBankExpenseById(int id) { var Expense = new Expense(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_BANK_EXPENSE_BY_ID") as SqlCommand; DBClass.AddSimpleParameter(cmd, "@ExpenseId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { Expense.ExpenseID = int.Parse(reader[0].ToString()); Expense.VoucherCode = reader[1].ToString(); Expense.CashBankID = int.Parse(reader[2].ToString()); Expense.DepartementId = int.Parse(reader[3].ToString()); Expense.Description = reader[4].ToString(); Expense.Nominal = decimal.Parse(reader[5].ToString()); Expense.Note = reader[6].ToString(); Expense.ExpenseDate = DateTime.Parse(reader[7].ToString()); Expense.BankLogObject = new BankLogObject { CashBankID = (int)Expense.CashBankID, ExpenseVoucher = Expense.VoucherCode }; } } return(Expense as T); }