public static List <clsParts> GetAllParts2() { List <clsParts> x = new List <clsParts>(); using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("shop.spSelectAllPart2", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { clsParts y = new clsParts(); y.ID = Convert.ToInt32(rdr["ID"]); y.PartName = Convert.ToString(rdr["PartName"]); y.PartTypee = Convert.ToString(rdr["PartType"]); y.SupplierName = Convert.ToString(rdr["SupplierName"]); y.StockLevel = Convert.ToInt32(rdr["StockLevel"]); y.MinStockLevel = Convert.ToInt32(rdr["MinStockLevel"]); y.CostPrice = Convert.ToDouble(rdr["CostPrice"]); y.SellingPrice = Convert.ToDouble(rdr["SellingPrice"]); y.Discount = Convert.ToDouble(rdr["Discount"]); y.Location = Convert.ToString(rdr["Location"]); y.Remarks = Convert.ToString(rdr["Remarks"]); y.Flag = Convert.ToString(rdr["Flag"]); x.Add(y); } } return(x); }
public static int insert(clsParts x) { using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("shop.spInsertPart", conn); cmd.CommandType = CommandType.StoredProcedure; string f = "Unknown"; cmd.Parameters.AddWithValue("@pn", x.PartName); cmd.Parameters.AddWithValue("@pt", x.PartType); cmd.Parameters.AddWithValue("@suid", x.SUID); cmd.Parameters.AddWithValue("@sl", x.StockLevel); cmd.Parameters.AddWithValue("@msl", x.MinStockLevel); cmd.Parameters.AddWithValue("@cp", x.CostPrice); cmd.Parameters.AddWithValue("@sp", x.SellingPrice); cmd.Parameters.AddWithValue("@d", x.Discount); cmd.Parameters.AddWithValue("@l", x.Location); cmd.Parameters.AddWithValue("@f", f); cmd.Parameters.AddWithValue("@r", x.Remarks); int r = cmd.ExecuteNonQuery(); return(r); } }