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