public void Insert_Update_Delete(Cls_LoaiDichVu_DTA LoaiDV_Data, string sThucThi)
{
sConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_LoaiDichVu";
cmd.Connection = this.sConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MaLoaiDV", SqlDbType.Char);
cmd.Parameters["@MaLoaiDV"].Value = LoaiDV_Data.MaLoaiDV;
cmd.Parameters.Add("@TenLoaiDV", SqlDbType.NVarChar);
cmd.Parameters["@TenLoaiDV"].Value = LoaiDV_Data.TenLoaiDV;
cmd.Parameters.Add("@LoaiDV", SqlDbType.NVarChar);
cmd.Parameters["@LoaiDV"].Value = LoaiDV_Data.LoaiDV;
cmd.Parameters.Add("@sqlTemp", SqlDbType.NVarChar);
if (sThucThi == "Insert" || sThucThi == "Delete" || sThucThi == "Update")
{
cmd.Parameters["@sqlTemp"].Value = sThucThi;
}
cmd.ExecuteNonQuery();
sConn.Close();
}
//Download source code FREE tai Sharecode.vn
public void Insert_Update_Delete(Cls_LoaiDichVu_DTA LoaiDV_Data, string sThucThi)
{
LoaiDV_Bus.Insert_Update_Delete(LoaiDV_Data, sThucThi);
}
