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