Exemple #1
0
        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();
            }
        }
Exemple #2
0
 public frmCheckList()
 {
     InitializeComponent();
     m_oCheckList = new Vendor.BusinessLayer.CheckListBL();
 }
Exemple #3
0
 public void InsertCheckListTrans(Vendor.BusinessLayer.CheckListBL argCheckList)
 {
     m_oRegister.InsertCheckListTrans(argCheckList);
 }