private void btnPrint_Click(object sender, EventArgs e)
{
string reportName = "LEMSheetApprovalX.rpt";
if (File.Exists($"{Application.StartupPath}\\{reportName}"))
{
var row = gridView1.GetDataRow(gridView1.FocusedRowHandle);
try
{
string userName = LoginUser.CurrUser.GetUserName();
using (SqlConnection sqlcon = new SqlConnection(MobileDB))
{
sqlcon.Open();
string sSQL = @"ReportLEMApproval";
SqlCommand cmd = new SqlCommand(sSQL, sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@id", row.GetValue <int>(colId)));
cmd.Parameters.Add(new SqlParameter("@username", userName));
cmd.ExecuteNonQuery();
}
string[,] para = new string[2, 1];
para[0, 0] = "@username";
para[1, 0] = userName;
using (frmHM_Report_Printer frmPrint = new frmHM_Report_Printer(HMCon, HMDevXManager, para, reportName, frmHM_Report_Printer.DBFlavor.TR))
{
frmPrint.SkipDataBase = true;
frmPrint.ReportPath = Application.StartupPath;
frmPrint.ShowDialog();
}
}
catch (Exception ex)
{
ShowMessage($"Error: {ex.Message}");
}
}
else
{
ShowMessage($"The report {reportName} cannot be found.");
}
}
private void btnPrint_Click(object sender, System.EventArgs e)
{
string sSelect = "select count(*) from ap_inv_header where isnull(PAYMENT_HOLD,'F') = 'T' and ap_inv_header_id=" + _AP_INV_HEADER_ID;
if (Convert.ToInt32(ExecuteScalar(sSelect, TR_Conn)) > 0)
{
string sMessage = "Unable to process payment, payment hold currently exists on invoice.";
Popup.ShowPopup(sMessage);
this.DialogResult = DialogResult.Cancel;
this.Close();
return;
}
object oBank = lueBank.EditValue;
if (oBank != null)
{
if (txtCheckNo.Text.Trim() != "")
{
if ((ucAccountingPicker1.SelectedYear < _Year) || (ucAccountingPicker1.SelectedYear == _Year && ucAccountingPicker1.SelectedPeriod < _Period))
{
Popup.ShowPopup("Selected year and period must be equal to or greater than the invoice accrual year and period.");
return;
}
string ReportName = ExecuteScalar("select isnull(cheque_report,'') from ap_setup", TR_Conn).ToString();
if (ReportName == "")
{
Popup.ShowPopup("No check report has been specified.");
return;
}
string sFirstChkNo = txtCheckNo.EditValue.ToString();
string sChkDate = deChkDate.DateTime.ToShortDateString();
string sExec = "exec sp_APFillQuickChk '" + Connection.MLUser + "', " + _AP_INV_HEADER_ID + ", '" + chkIncludeHB.EditValue + "'";
string sMessage = ExecuteScalar(sExec, TR_Conn).ToString();
if (sMessage == "OK")
{
sExec = @"declare @message varchar(max)
exec sp_APQuickCheckPrint '" + Connection.MLUser + @"', '" + sChkDate + @"', " + oBank + @", " + sFirstChkNo + @", null, @message output
select @message";
object oMessage = Connection.SQLExecutor.ExecuteScalar(sExec, Connection.TRConnection);
if (oMessage == null || oMessage == DBNull.Value)
{
Popup.ShowPopup("Error generating check data.");
return;
}
if (!oMessage.Equals("OK"))
{
Popup.ShowPopup(oMessage.ToString());
return;
}
string sUpdateMessage = "Update and post manual check to the period: " + ucAccountingPicker1.SelectedYear + " / " +
ucAccountingPicker1.SelectedPeriod + ", " + PeriodName(ucAccountingPicker1.SelectedPeriod) + "?";
if (!b_Manual)
{
CheckElectronicSaving();
string[,] saParams = new string[2, 1];
saParams[0, 0] = "@USERNAME";
saParams[1, 0] = Connection.MLUser;
frmHM_Report_Printer HMRP = new frmHM_Report_Printer(Connection, myMgr, saParams, ReportName, frmHM_Report_Printer.DBFlavor.TR);
sSelect = "select isnull(ALLOW_CHK_PREVIEW,'F') from ap_setup";
if (ExecuteScalar(sSelect, TR_Conn).ToString().ToUpper() == "T")
{
HMRP.ShowPreview = true;
}
else
{
HMRP.ShowPreview = false;
}
HMRP.ElectronicSaving(false, b_ElectronicSaving);
HMRP.ElectronicSave += new frmHM_Report_Printer.ElectronicSaveDelegate(HMRP_ElectronicSave);
ElectronicSave = false;
HMRP.ShowDialog();
IDisposable dispose = HMRP;
dispose.Dispose();
sUpdateMessage = "Printed OK? Continue with update, and post to the period: " + ucAccountingPicker1.SelectedYear + " / " +
ucAccountingPicker1.SelectedPeriod + ", " + PeriodName(ucAccountingPicker1.SelectedPeriod) + "?";
}
if (Popup.ShowPopup(this, sUpdateMessage, frmPopup.PopupType.OK_Cancel)
== frmPopup.PopupResult.OK)
{
sMessage = ProcessCheck();
if (sMessage == "OK")
{
if (!b_Manual)
{
UpdateChkNo();
if (ElectronicSave)
{
Check_ElectronicSave();
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
Popup.ShowPopup(sMessage);
}
}
}
else
{
if (chkIncludeHB.Enabled)
{
Popup.ShowPopup(sMessage);
}
else
{
Popup.ShowPopup("A holdback balance only remains on this invoice, but the holdback has not been approved yet.");
}
}
}
else
{
Popup.ShowPopup(this, "Please enter a starting check number.");
}
}
else
{
Popup.ShowPopup(this, "Please select a bank.");
}
}
