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