public ProductAdjustmentHistoryCollection GetAllProductAdjustmentHistoryDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); ProductAdjustmentHistoryCollection cols = new ProductAdjustmentHistoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUsersDynamic"); while (reader.Read()) { ProductAdjustmentHistory PAH = new ProductAdjustmentHistory(); PAH.ProductID = Int32.Parse(reader["ProductID"].ToString()); PAH.AdjustedQuantity = Int32.Parse(reader["ProductID"].ToString()); PAH.Reason = reader["Reason"].ToString(); PAH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(PAH); } } catch (Exception ex) { log.Write(ex.Message, "GetAllProductAdjustmentHistoryDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesPersonQuotaHistoryCollection GetAllSalesPersonQuotaHistorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); SalesPersonQuotaHistoryCollection cols = new SalesPersonQuotaHistoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesPersonQuotaHistorysDynamic"); while (reader.Read()) { SalesPersonQuotaHistory SPQH = new SalesPersonQuotaHistory(); SPQH.SalesPersonID = Int32.Parse(reader["SalesPersonID"].ToString()); SPQH.QuotaDate = DateTime.Parse(reader["QuotaDate"].ToString()); SPQH.SalesQuota = Decimal.Parse(reader["SalesQuota"].ToString()); SPQH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());; cols.Add(SPQH); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesPersonQuotaHistorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public User GetUser(int userID) { IDBManager dbm = new DBManager(); User user = new User(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ID", userID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUser"); while (reader.Read()) { user.ID = Int32.Parse(reader["ID"].ToString()); user.EmployeeID = Int32.Parse(reader["EmployeeID"].ToString()); user.UserName = reader["UserName"].ToString(); user.Password = reader["Password"].ToString(); } } catch (Exception ex) { log.Write(ex.Message, "GetUser"); throw (ex); } finally { dbm.Dispose(); } return(user); }
public SalesTerritory GetSalesTerritory(int TerritoryID) { IDBManager dbm = new DBManager(); SalesTerritory ST = new SalesTerritory(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@TerritoryID", TerritoryID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritory"); while (reader.Read()) { ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSalesTerritory"); throw (ex); } finally { dbm.Dispose(); } return(ST); }
public SalesPersonQuotaHistoryCollection GetAllSalesPersonQuotaHistorysCollection() { IDBManager dbm = new DBManager(); SalesPersonQuotaHistoryCollection cols = new SalesPersonQuotaHistoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesPersonQuotaHistoryAll"); while (reader.Read()) { SalesPersonQuotaHistory SPQH = new SalesPersonQuotaHistory(); SPQH.SalesPersonID = Int32.Parse(reader["SalesPersonID"].ToString()); SPQH.QuotaDate = DateTime.Parse(reader["QuotaDate"].ToString()); SPQH.SalesQuota = decimal.Parse(reader["SalesQuota"].ToString()); SPQH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(SPQH); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesPersonQuotaHistorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public AddressCollection GetAllAddressesCollection() { IDBManager dbm = new DBManager(); AddressCollection cols = new AddressCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectAddressesAll"); while (reader.Read()) { Address address = new Address(); address.AddressID = Int32.Parse(reader["AddressID"].ToString()); address.AddressLine1 = reader["AddressLine1"].ToString(); address.AddressLine2 = reader["AddressLine2"].ToString(); address.City = reader["City"].ToString(); address.StateProvince = reader["StateProvince"].ToString(); address.PostalCode = reader["PostalCode"].ToString(); address.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(address); } } catch (Exception ex) { log.Write(ex.Message, "GetAllAddressesCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public Address GetAddress(int addressID) { IDBManager dbm = new DBManager(); Address address = new Address(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@AddressID", addressID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectAddress"); while (reader.Read()) { address.AddressID = Int32.Parse(reader["AddressID"].ToString()); address.AddressLine1 = reader["AddressLine1"].ToString(); address.AddressLine2 = reader["AddressLine2"].ToString(); address.City = reader["City"].ToString(); address.StateProvince = reader["StateProvince"].ToString(); address.PostalCode = reader["PostalCode"].ToString(); address.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetAddressByID"); throw (ex); } finally { dbm.Dispose(); } return(address); }
public SpecialOfferProduct GetSpecialOfferProduct(int SpecialOfferID) { IDBManager dbm = new DBManager(); SpecialOfferProduct SOP = new SpecialOfferProduct(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@SpecialOfferID", SpecialOfferID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOfferProduct"); while (reader.Read()) { SOP.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString()); SOP.ProductID = Int32.Parse(reader["ProductID"].ToString()); SOP.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSpecialOfferProduct"); throw (ex); } finally { dbm.Dispose(); } return(SOP); }
public SpecialOfferProductCollection GetAllSpecialOfferProductsDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); SpecialOfferProductCollection cols = new SpecialOfferProductCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOfferProductsDynamic"); while (reader.Read()) { SpecialOfferProduct SOP = new SpecialOfferProduct(); SOP.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString()); SOP.ProductID = Int32.Parse(reader["ProductID"].ToString()); SOP.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(SOP); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSpecialOfferProductsDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public ProductCostHistoryCollection GetAllProductCostHistorysCollection() { IDBManager dbm = new DBManager(); ProductCostHistoryCollection cols = new ProductCostHistoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductCostHistoriesAll"); while (reader.Read()) { ProductCostHistory productCostHistory = new ProductCostHistory(); productCostHistory.ID = Int32.Parse(reader["ID"].ToString()); productCostHistory.ProductID = Int32.Parse(reader["ProductID"].ToString()); productCostHistory.StartDate = DateTime.Parse(reader["StartDate"].ToString()); productCostHistory.EndDate = DateTime.Parse(reader["EndDate"].ToString()); productCostHistory.StandardCost = Decimal.Parse(reader["StandardCost"].ToString()); productCostHistory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(productCostHistory); } } catch (Exception ex) { log.Write(ex.Message, "GetAllProductCostHistorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SpecialOfferProductCollection GetAllSpecialOfferProductsCollection() { IDBManager dbm = new DBManager(); SpecialOfferProductCollection cols = new SpecialOfferProductCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSpecialOfferProductAll"); while (reader.Read()) { SpecialOfferProduct SOP = new SpecialOfferProduct(); SOP.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString()); SOP.ProductID = Int32.Parse(reader["ProductID"].ToString()); SOP.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(SOP); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSpecialOfferProductsCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesTerritoryHistory GetSalesTerritoryHistory(int ID) { IDBManager dbm = new DBManager(); SalesTerritoryHistory STH = new SalesTerritoryHistory(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ID", ID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritoryHistory"); while (reader.Read()) { STH.ID = Int32.Parse(reader["ID"].ToString()); STH.SalesPersonID = Int32.Parse(reader["SalesPersonID"].ToString()); STH.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); STH.StartDate = DateTime.Parse(reader["StartDate"].ToString()); if (reader["EndDate"] != null && reader["EndDate"].ToString() != "") { STH.EndDate = DateTime.Parse(reader["EndDate"].ToString()); } STH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSalesTerritoryHistory"); throw (ex); } finally { dbm.Dispose(); } return(STH); }
public SalesOrderDetail GetSalesOrderDetail(int salesOrderDetailID) { IDBManager dbm = new DBManager(); SalesOrderDetail SOD = new SalesOrderDetail(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@SalesOrderDetailID", salesOrderDetailID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesOrderDetail"); while (reader.Read()) { SOD.SalesOrderID = Int32.Parse(reader["SalesOrderID"].ToString()); SOD.SalesOrderDetailID = Int32.Parse(reader["SalesOrderDetailID"].ToString()); SOD.CarrierTrackingNumber = reader["CarrierTrackingNumber"].ToString(); SOD.OrderQty = short.Parse(reader["OrderQty"].ToString()); SOD.ProductID = Int32.Parse(reader["ProductID"].ToString()); SOD.SpecialOfferID = Int32.Parse(reader["SpecialOfferID"].ToString()); SOD.UnitPrice = decimal.Parse(reader["UnitPrice"].ToString()); SOD.UnitPriceDiscount = decimal.Parse(reader["UnitPriceDiscount"].ToString()); SOD.LineTotal = decimal.Parse(reader["LineTotal"].ToString()); SOD.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSalesOrderDetail"); throw (ex); } finally { dbm.Dispose(); } return(SOD); }
public ProductAdjustmentHistoryCollection GetAllProductAdjustmentHistoryCollection(int purchaseAdjustedQuantity) { IDBManager dbm = new DBManager(); ProductAdjustmentHistoryCollection cols = new ProductAdjustmentHistoryCollection(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ProductID", purchaseAdjustedQuantity); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductAdjustmentHistoryByAdjustedQuantity"); while (reader.Read()) { ProductAdjustmentHistory PAH = new ProductAdjustmentHistory(); PAH.ProductID = Int32.Parse(reader["ProductID"].ToString()); PAH.AdjustedQuantity = Int32.Parse(reader["AdjustedQuantity"].ToString()); PAH.Reason = reader["Reason"].ToString(); PAH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(PAH); } } catch (Exception ex) { log.Write(ex.Message, "ProductAdjustmentHistoryCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public ProductInventoryCollection GetAllProductInventorysCollection() { IDBManager dbm = new DBManager(); ProductInventoryCollection cols = new ProductInventoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductInventoriesAll"); while (reader.Read()) { ProductInventory productInventory = new ProductInventory(); productInventory.ProductID = Int32.Parse(reader["ProductID"].ToString()); productInventory.LocationID = Int32.Parse(reader["LocationID"].ToString()); productInventory.Shelf = reader["Shelf"].ToString(); productInventory.Quantity = Int16.Parse(reader["Quantity"].ToString()); productInventory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(productInventory); } } catch (Exception ex) { log.Write(ex.Message, "ProductInventoryCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesInvoiceDetail GetSalesInvoiceDetail(int @InvoiceDetailID) { IDBManager dbm = new DBManager(); SalesInvoiceDetail SID = new SalesInvoiceDetail(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@InvoiceDetailID", @InvoiceDetailID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesInvoiceDetail"); while (reader.Read()) { SID.@InvoiceDetailID = Int32.Parse(reader["@InvoiceDetailID"].ToString()); SID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); SID.Quantity = short.Parse(reader["Quantity"].ToString()); SID.ProductID = Int32.Parse(reader["ProductID"].ToString()); SID.SpecialOfferID = Int32.Parse(reader[""].ToString()); SID.UnitPrice = decimal.Parse(reader[""].ToString()); SID.UnitPriceDiscount = decimal.Parse(reader[""].ToString()); SID.LineTotal = decimal.Parse(reader[""].ToString()); SID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSalesInvoiceDetail"); throw (ex); } finally { dbm.Dispose(); } return(SID); }
public ProductInventoryCollection GetAllProductInventorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); ProductInventoryCollection cols = new ProductInventoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductInventoriesDynamic"); while (reader.Read()) { ProductInventory productInventory = new ProductInventory(); productInventory.ProductID = Int32.Parse(reader["ProductID"].ToString()); productInventory.LocationID = Int32.Parse(reader["LocationID"].ToString()); productInventory.Shelf = reader["Shelf"].ToString(); productInventory.Bin = Byte.Parse(reader["Bin"].ToString()); productInventory.Quantity = Int16.Parse(reader["Quantity"].ToString()); productInventory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(productInventory); } } catch (Exception ex) { log.Write(ex.Message, "GetAllProductInventorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public PurchaseInvoiceDetailCollection GetAllPurchaseInvoiceDetailCollection() { IDBManager dbm = new DBManager(); PurchaseInvoiceDetailCollection cols = new PurchaseInvoiceDetailCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseInvoiceDetailsAll"); while (reader.Read()) { PurchaseInvoiceDetail PID = new PurchaseInvoiceDetail(); PID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); PID.InvoiceDetailID = Int32.Parse(reader["InvoiceDetailID"].ToString()); PID.ProductID = Int32.Parse(reader["ProductID"].ToString()); PID.UnitPrice = Decimal.Parse(reader["UnitPrice"].ToString()); PID.Quantity = Int64.Parse(reader["Quantity"].ToString()); PID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(PID); } } catch (Exception ex) { log.Write(ex.Message, "PurchaseInvoiceDetailCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public AddressCollection GetAddressesDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); AddressCollection cols = new AddressCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectAddressesDynamic"); while (reader.Read()) { Address address = new Address(); address.AddressID = Int32.Parse(reader["AddressID"].ToString()); address.AddressLine1 = reader["AddressLine1"].ToString(); address.AddressLine2 = reader["AddressLine2"].ToString(); address.City = reader["City"].ToString(); address.StateProvince = reader["StateProvince"].ToString(); address.PostalCode = reader["PostalCode"].ToString(); address.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(address); } } catch (Exception ex) { log.Write(ex.Message, "GetAddressesDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public PurchaseInvoiceDetail GetPurchaseInvoiceDetail(int PIDID) { IDBManager dbm = new DBManager(); PurchaseInvoiceDetail PID = new PurchaseInvoiceDetail(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@InvoiceDetailID", PIDID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPurchaseInvoiceDetail"); while (reader.Read()) { PID.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); PID.InvoiceDetailID = Int32.Parse(reader["InvoiceDetailID"].ToString()); PID.ProductID = Int32.Parse(reader["ProductID"].ToString()); PID.UnitPrice = Decimal.Parse(reader["UnitPrice"].ToString()); PID.Quantity = Int64.Parse(reader["Quantity"].ToString()); PID.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetPurchaseInvoiceDetail"); throw (ex); } finally { dbm.Dispose(); } return(PID); }
public SalesTerritoryCollection GetAllSalesTerritorysCollection() { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritoryAll"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public PaymentCollection GetAllPaymentCollection() { IDBManager dbm = new DBManager(); PaymentCollection cols = new PaymentCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPaymentsAll"); while (reader.Read()) { Payment PAY = new Payment(); PAY.PaymentID = Int32.Parse(reader["PaymentID"].ToString()); PAY.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); PAY.PaymentType = reader["PaymentType"].ToString(); PAY.PaymentDate = DateTime.Parse(reader["PaymentDate"].ToString()); PAY.Amount = decimal.Parse(reader["Amount"].ToString()); PAY.Comments = reader["Comments "].ToString(); PAY.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); PAY.CheckNumber = reader["CheckNumber"].ToString(); cols.Add(PAY); } } catch (Exception ex) { log.Write(ex.Message, "PaymentCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesTerritoryCollection GetAllSalesTerritorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritorysDynamic"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public Payment GetPayment(int PAYID) { IDBManager dbm = new DBManager(); Payment PAY = new Payment(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@PaymentID", PAYID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPayment"); while (reader.Read()) { PAY.PaymentID = Int32.Parse(reader["PaymentID"].ToString()); PAY.InvoiceID = Int32.Parse(reader["InvoiceID"].ToString()); PAY.PaymentType = reader["PaymentType"].ToString(); PAY.PaymentDate = DateTime.Parse(reader["PaymentDate"].ToString()); PAY.Amount = decimal.Parse(reader["Amount"].ToString()); PAY.Comments = reader["Comments "].ToString(); PAY.CheckNumber = reader["CheckNumber"].ToString(); PAY.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetPayment"); throw (ex); } finally { dbm.Dispose(); } return(PAY); }
public SalesPersonQuotaHistory GetSalesPersonQuotaHistory(int SalesPersonID) { IDBManager dbm = new DBManager(); SalesPersonQuotaHistory SPQH = new SalesPersonQuotaHistory(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@SalesPersonID", SalesPersonID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesPersonQuotaHistory"); while (reader.Read()) { SPQH.SalesPersonID = Int32.Parse(reader["SalesPersonID"].ToString()); SPQH.QuotaDate = DateTime.Parse(reader["QuotaDate"].ToString()); SPQH.SalesQuota = Decimal.Parse(reader["SalesQuota"].ToString()); SPQH.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());; } } catch (Exception ex) { log.Write(ex.Message, "GetSalesPersonQuotaHistory"); throw (ex); } finally { dbm.Dispose(); } return(SPQH); }
public int Exists(string name) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@Name", name); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductCategoryExists"); if (reader.Read()) { return(Int32.Parse(reader["ProductCategoryID"].ToString())); } else { return(0); } } catch (Exception ex) { log.Write(ex.Message, "Exists"); throw (ex); } finally { dbm.Dispose(); } }
public UserCollection GetAllUsersCollection() { IDBManager dbm = new DBManager(); UserCollection col = new UserCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUsersAll"); while (reader.Read()) { User user = new User(); user.ID = Int32.Parse(reader["ID"].ToString()); user.EmployeeID = Int32.Parse(reader["EmployeeID"].ToString()); user.UserName = reader["UserName"].ToString(); user.Password = reader["Password"].ToString(); col.Add(user); } } catch (Exception ex) { log.Write(ex.Message, "GetAllUsersCollection"); throw (ex); } finally { dbm.Dispose(); } return(col); }
public ProductCategory GetProductCategory(int productCategoryID) { IDBManager dbm = new DBManager(); ProductCategory productCategory = new ProductCategory(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ProductCategoryID", productCategoryID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductCategory"); while (reader.Read()) { productCategory.ProductCategoryID = Int32.Parse(reader["ProductCategoryID"].ToString()); productCategory.Name = reader["Name"].ToString(); productCategory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetProductCategory"); throw (ex); } finally { dbm.Dispose(); } return(productCategory); }
public UserCollection GetAllUsersDynamicCollection(string where, string orderBy) { IDBManager dbm = new DBManager(); UserCollection col = new UserCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", where); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectUsersDynamic"); while (reader.Read()) { User user = new User(); user.ID = Int32.Parse(reader["ID"].ToString()); user.EmployeeID = Int32.Parse(reader["EmployeeID"].ToString()); user.UserName = reader["UserName"].ToString(); user.Password = reader["Password"].ToString(); col.Add(user); } } catch (Exception ex) { log.Write(ex.Message, "GetAllUsersDynamicCollection"); } finally { dbm.Dispose(); } return(col); }
public PaymentMethodCollection GetAllPaymentMethodsDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); PaymentMethodCollection cols = new PaymentMethodCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectPaymentMethodsDynamic"); while (reader.Read()) { PaymentMethod paymentMethod = new PaymentMethod(); paymentMethod.PaymentMethodID = Int32.Parse(reader["PaymentMethodID"].ToString()); paymentMethod.Name = reader["Name"].ToString(); cols.Add(paymentMethod); } } catch (Exception ex) { log.Write(ex.Message, "GetAllPaymentMethodsDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }