protected PurchaseInvoicesDetails GetByID(int _ID) { Gate.Command.CommandText = "select * from PurchaseInvoicesDetails"; Gate.Command.CommandText += " Where ID = @ID "; Gate.Command.Parameters.Clear(); Gate.Command.Parameters.AddWithValue("@ID", _ID); System.Data.SqlClient.SqlDataReader Reader = Gate.Execute(); PurchaseInvoicesDetails NewObj = new PurchaseInvoicesDetails(); if (Reader != null && Reader.Read()) { if (Reader["ID"] != null) { NewObj.ID = int.Parse(Reader["ID"].ToString()); } if (Reader["pur_invoiceID"] != null) { NewObj.pur_invoiceID = int.Parse(Reader["pur_invoiceID"].ToString()); } if (Reader["ProductID"] != null) { NewObj.ProductID = int.Parse(Reader["ProductID"].ToString()); } if (Reader["QTY"] != null) { NewObj.QTY = int.Parse(Reader["QTY"].ToString()); } if (Reader["BuyPrice"] != null) { NewObj.BuyPrice = float.Parse(Reader["BuyPrice"].ToString()); } if (Reader["SalePrice"] != null) { NewObj.SalePrice = float.Parse(Reader["SalePrice"].ToString()); } if (Reader["Tax"] != null) { NewObj.Tax = float.Parse(Reader["Tax"].ToString()); } if (Reader["ExpireDate"] != null) { NewObj.ExpireDate = (DateTime)Reader["ExpireDate"]; } if (Reader["Total"] != null) { NewObj.Total = float.Parse(Reader["Total"].ToString()); } if (Reader["Discount"] != null) { NewObj.Discount = float.Parse(Reader["Discount"].ToString()); } } ; Gate.Close(); return(NewObj); }
protected List <PurchaseInvoicesDetails> GetAll() { Gate.Command.CommandText = "select * from PurchaseInvoicesDetails"; Gate.Command.Parameters.Clear(); System.Data.SqlClient.SqlDataReader Reader = Gate.Execute(); List <PurchaseInvoicesDetails> List = new List <PurchaseInvoicesDetails>(); while (Reader != null && Reader.Read()) { PurchaseInvoicesDetails NewObj = new PurchaseInvoicesDetails(); if (Reader["ID"] != null) { NewObj.ID = int.Parse(Reader["ID"].ToString()); } if (Reader["pur_invoiceID"] != null) { NewObj.pur_invoiceID = int.Parse(Reader["pur_invoiceID"].ToString()); } if (Reader["ProductID"] != null) { NewObj.ProductID = int.Parse(Reader["ProductID"].ToString()); } if (Reader["QTY"] != null) { NewObj.QTY = int.Parse(Reader["QTY"].ToString()); } if (Reader["BuyPrice"] != null) { NewObj.BuyPrice = float.Parse(Reader["BuyPrice"].ToString()); } if (Reader["SalePrice"] != null) { NewObj.SalePrice = float.Parse(Reader["SalePrice"].ToString()); } if (Reader["Tax"] != null) { NewObj.Tax = float.Parse(Reader["Tax"].ToString()); } if (Reader["ExpireDate"] != null) { NewObj.ExpireDate = (DateTime)Reader["ExpireDate"]; } if (Reader["Total"] != null) { NewObj.Total = float.Parse(Reader["Total"].ToString()); } if (Reader["Discount"] != null) { NewObj.Discount = float.Parse(Reader["Discount"].ToString()); } List.Add(NewObj); } ; Gate.Close(); return(List); }