public int VoucherCancelCRCP(string BrCode, string EDate, string SetNo, string Reason, string Mid, string ScrollNo)
 {
     try
     {
         VerifyCode = CanRes.GetVK(Mid.ToString());
         sql        = "EXEC SP_CANCEL_ENTRY @FLAG='CRCP',@SETNO='" + SetNo + "',@EDT='" + conn.ConvertDate(EDate) + "',@BRCD='" + BrCode + "',@MID='" + Mid + "', @F3 = '" + VerifyCode.ToString() + "', @Reason = '" + Reason.ToString() + "'";
         Result     = conn.sExecuteQuery(sql);
     }
     catch (Exception Ex)
     {
         ExceptionLogging.SendErrorToText(Ex);
     }
     return(Result);
 }