public void SaveLoaiSanPham(LoaiSanPham loaisanpham)
{
string connectionString = ConfigurationManager.ConnectionStrings["LoaiSanPhamContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SAVELOAISANPHAM", con);
cmd.CommandType = CommandType.StoredProcedure;
// ID bi hidden
SqlParameter paraID = new SqlParameter();
paraID.ParameterName = "@MaLoaiSP";
paraID.Value = loaisanpham.MaLoaiSP;
cmd.Parameters.Add(paraID);
SqlParameter paraTen = new SqlParameter();
paraTen.ParameterName = "@TenLoaiSP";
paraTen.Value = loaisanpham.TenLoaiSP;
cmd.Parameters.Add(paraTen);
SqlParameter paraLoiNhuan = new SqlParameter();
paraLoiNhuan.ParameterName = "@PhanTramLoiNhuan";
paraLoiNhuan.Value = loaisanpham.PhanTramLoiNhuan;
cmd.Parameters.Add(paraLoiNhuan);
SqlParameter paraDVT = new SqlParameter();
paraDVT.ParameterName = "@MaDVT";
paraDVT.Value = loaisanpham.MaDVT;
cmd.Parameters.Add(paraDVT);
con.Open();
cmd.ExecuteNonQuery();
}
}
public void AddLoaiSanPham(LoaiSanPham loaisanpham)
{
string connectionString = ConfigurationManager.ConnectionStrings["LoaiSanPhamContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("AddLoaiSanPham", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paraMa = new SqlParameter();
paraMa.ParameterName = "@MaLoaiSP";
paraMa.Value = loaisanpham.MaLoaiSP;
cmd.Parameters.Add(paraMa);
SqlParameter paraTen = new SqlParameter();
paraTen.ParameterName = "@TenLoaiSP";
paraTen.Value = loaisanpham.TenLoaiSP;
cmd.Parameters.Add(paraTen);
SqlParameter paraLoiNhuan = new SqlParameter();
paraLoiNhuan.ParameterName = "@PhanTramLoiNhuan";
paraLoiNhuan.Value = loaisanpham.PhanTramLoiNhuan;
cmd.Parameters.Add(paraLoiNhuan);
SqlParameter paraDVT = new SqlParameter();
paraDVT.ParameterName = "@MaDVT";
paraDVT.Value = loaisanpham.MaDVT;
cmd.Parameters.Add(paraDVT);
//SqlParameter paraTenNDVT = new SqlParameter();
//paraDVT.ParameterName = "@TenDVT";
//paraDVT.Value = dvt.TenDVT;
//cmd.Parameters.Add(paraDVT);
con.Open();
cmd.ExecuteNonQuery();
}
}
