private Boolean _validateIfPrinted()
{
SqlCommand cmd = new SqlCommand("SELECT ISNULL(count(*),0) FROM tblLotCardGroup WHERE LotCardGroupNo=@LotCardNo AND IsPrinted = 1");
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@LotCardNo", _formNos.ToString().Trim());
if (Convert.ToInt32(SqlHelper.ExecuteScalar(ClsConfig.Cantier_LotCardLabelConnectionString, cmd)) > 0)
{
MessageBoxResult messageBoxResult = MessageBox.Show("This lot card was already printed. Are you sure you want to print it again?"
, "Confirmation", MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
//reportViewer.ViewerCore.PrintReport();
if (ClsCantierDB.Sohbi_GetInsideLotCards4PrintingNew(_formNos.ToString().Trim()).Rows.Count > 0)
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
//MessageBox.Show(defaultPrinterName);
PrintData(docA, docB, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
}
else
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
//MessageBox.Show(defaultPrinterName);
PrintData2(docA, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
}
}
else
{
}
}
else
{
SqlCommand cmd2 = new SqlCommand(
"UPDATE [dbo].[tblLotCardGroup] SET IsPrinted = 1 WHERE LotCardGroupNo=@LotCardNo");
cmd2.CommandType = CommandType.Text;
cmd2.Parameters.AddWithValue("@LotCardNo", _formNos.ToString().Trim());
SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd2);
//reportViewer.ViewerCore.PrintReport();
if (ClsCantierDB.Sohbi_GetInsideLotCards4PrintingNew(_formNos.ToString().Trim()).Rows.Count > 0)
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
PrintData(docA, docB, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
//MessageBox.Show(defaultPrinterName);
}
else
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
//MessageBox.Show(defaultPrinterName);
PrintData2(docA, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
}
}
return(true);
}
