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