public void InsertCheckListTrans(Vendor.BusinessLayer.CheckListBL argCheckList) { SqlConnection conn; conn = new SqlConnection(); conn = BsfGlobal.OpenVendorAnalDB(); SqlTransaction tran = conn.BeginTransaction(); try { SqlCommand Command = new SqlCommand("Insert_VendorCheckListTrans", conn, tran); Command.CommandType = CommandType.StoredProcedure; Command.Parameters.Clear(); Command.Parameters.AddWithValue("@VendorId", argCheckList.VendorId); Command.Parameters.AddWithValue("@CheckListId", argCheckList.CheckListId); Command.Parameters.AddWithValue("@RegType", argCheckList.RegType); Command.Parameters.AddWithValue("@Points", argCheckList.Points); Command.ExecuteNonQuery(); tran.Commit(); } catch { tran.Rollback(); } finally { conn.Close(); } }
public frmCheckList() { InitializeComponent(); m_oCheckList = new Vendor.BusinessLayer.CheckListBL(); }
public void InsertCheckListTrans(Vendor.BusinessLayer.CheckListBL argCheckList) { m_oRegister.InsertCheckListTrans(argCheckList); }