public static List <clsReports> select(int ID)
        {
            List <clsReports> x = new List <clsReports>();
            int i = 0;

            using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand("shop.spSelectReports", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@id", ID);
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    clsReports y = new clsReports();
                    y.ID            = Convert.ToInt32((i += 1));
                    y.Product       = Convert.ToString(rdr["Product"]);
                    y.Price         = Convert.ToDouble(rdr["Price"]);
                    y.Qty           = Convert.ToInt32(rdr["Qty"]);
                    y.DateCreated   = Convert.ToString(rdr["DateCreated"]);
                    y.PaymentMethod = Convert.ToString(rdr["PaymentMethod"]);
                    x.Add(y);
                }
            }
            return(x);
        }
 public static int insert(clsReports x)
 {
     using (SqlConnection conn = new SqlConnection())
     {
         conn.ConnectionString = clsMain.sqlconnstring;
         conn.Open();
         SqlCommand cmd = new SqlCommand("shop.spInsertReports", conn);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@pt", x.Product);
         cmd.Parameters.AddWithValue("@pr", x.Price);
         cmd.Parameters.AddWithValue("@q", x.Qty);
         cmd.Parameters.AddWithValue("@d", DateTime.Now.ToShortDateString().ToString());
         int r = cmd.ExecuteNonQuery();
         return(r);
     }
 }
 public static int update(clsReports x)
 {
     using (SqlConnection conn = new SqlConnection())
     {
         conn.ConnectionString = clsMain.sqlconnstring;
         conn.Open();
         SqlCommand cmd = new SqlCommand("shop.spUpdateReports", conn);
         cmd.CommandType = CommandType.StoredProcedure;
         cmd.Parameters.AddWithValue("@id", x.ID);
         cmd.Parameters.AddWithValue("@pt", x.Product);
         cmd.Parameters.AddWithValue("@pr", x.Price);
         cmd.Parameters.AddWithValue("@q", x.Qty);
         cmd.Parameters.AddWithValue("@d", x.DateCreated);
         int r = cmd.ExecuteNonQuery();
         return(r);
     }
 }