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 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> 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> 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 <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 <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 <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 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 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 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 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 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 <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 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 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) { } } } }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <ProductCategory>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PRODUCT_CATEGORY") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var category = new ProductCategory(); category.CategoryID = int.Parse(reader[0].ToString()); category.CategoryName = reader[1].ToString(); category.Active = bool.Parse(reader[2].ToString()); result.Add(category); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Cash>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_CASH") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var cash = new Cash(); cash.DepartementName = reader[0].ToString(); cash.StartingBalance = decimal.Parse(reader[1].ToString()); cash.CurrentBalance = decimal.Parse(reader[2].ToString()); result.Add(cash); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Company>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_COMPANY") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var _company = new Company(); _company.CompanyID = int.Parse(reader[0].ToString()); _company.CompanyName = reader[1].ToString(); _company.Active = bool.Parse(reader[2].ToString()); result.Add(_company); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <ProductUnit>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PRODUCT_UNIT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var productUnit = new ProductUnit(); productUnit.UnitID = int.Parse(reader[0].ToString()); productUnit.UnitName = reader[1].ToString(); productUnit.Abbreviation = reader[2].ToString(); productUnit.Active = bool.Parse(reader[3].ToString()); result.Add(productUnit); } } return(result as List <T>); }
public IEnumerable <T> GetAllDepartementStock(List <Dictionary <string, object> > keyValueParam) { var result = new List <ProductStock>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_DEPARTEMENT_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(); result.Add(stock); } } return(result as List <T>); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Marketing>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_MARKETING") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var _marketing = new Marketing(); _marketing.MarketingID = int.Parse(reader[0].ToString()); _marketing.MarketingName = reader[1].ToString(); _marketing.DepartementName = reader[2].ToString(); _marketing.Active = bool.Parse(reader[3].ToString()); result.Add(_marketing); } } return(result as List <T>); }
public IEnumerable <T> DashboardCreditPassAlert(List <Dictionary <string, object> > keyValueParam) { var result = new List <Customer>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_CUSTOMER_LIMITCREDIT_PASS_ALERT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var customer = new Customer(); customer.DepartementName = reader[0].ToString(); customer.FirstName = StringManipulation.UppercaseFirst(reader[1].ToString()); customer.LastName = StringManipulation.UppercaseFirst(reader[2].ToString()); customer.CreditLimit = decimal.Parse(reader[3].ToString()); customer.CreditTotal = decimal.Parse(reader[4].ToString()); result.Add(customer); } } return(result as List <T>); }
public IEnumerable <T> DashboardMinimumStockAlert(List <Dictionary <string, object> > keyValueParam) { var result = new List <ProductStock>(); using (DBClass = new MSSQLDatabase()) { var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_STOCK_MINIMUM_ALERT") as SqlCommand; RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var stock = new ProductStock(); stock.DepartementName = reader[0].ToString(); stock.ProductCode = reader[1].ToString(); stock.ProductName = reader[2].ToString(); stock.MinimumQuantity = decimal.Parse(reader[3].ToString()); stock.CurrentQuantity = decimal.Parse(reader[4].ToString()); result.Add(stock); } } return(result as List <T>); }