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