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