private void bunifuFlatButton4_Click(object sender, EventArgs e)
{
var frmReports = new FrmReports {
StrReport = "MyLogs", PrintWhere = ("{V_Logs.u_name} ='" + username + "'")
};
frmReports.ShowDialog();
frmReports.Close();
}
private async void printReceiptToolStripMenuItem_Click(object sender, EventArgs e)
{
if (_payments < AmountDue)
{
// var msg = new T_Message();
// var ok = new Frm_OK();
// ok.OkDescription = "Error";
// ok.msgtxt.Text = @"Insufficient amount! Please check and try again!";
// ok.titletxt.Text = @"Error";
// msg.Show(this);
// ok.ShowDialog();
// msg.Close();
// Focus();
//PopupNotifier popup=new PopupNotifier();
popup.TitleText = "Error";
popup.ContentText = "Insufficient amount! Please check and try again!";
popup.Popup();
}
else
{
var tQuestion = new T_Question();
var question = new Frm_Question();
question.titletxt.Text = @"Confirmation";
question.msgtxt.Text = @"This action will save this transaction. Do you want to continue this transaction?";
tQuestion.Show(this);
question.ShowDialog();
tQuestion.Close();
Focus();
if (question.DialogResult != DialogResult.Yes)
{
return;
}
//*******Print receipt********************
UseWaitCursor = true;
if (!Hascustomer)
{
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql =
"Update tbl_Transaction set inv_amnt_due=@inv_amnt_due, inv_tax=@inv_tax,inv_tax_tot=@inv_tax_tot,Inv_Money_Render=@Inv_Money_Render, Inv_Change=@Inv_Change, Inv_total=@Inv_total, Inv_Num_of_items=@Inv_Num_of_items, tran_stat=@tran_stat Where Inv_Num=@Inv_Num";
Sqlcmd.Parameters.AddWithValue("@inv_amnt_due",
Convert.ToSingle(lblsubtotal.Text));
Sqlcmd.Parameters.AddWithValue("@inv_tax",
Convert.ToSingle(lbltax.Text));
Sqlcmd.Parameters.AddWithValue("@inv_tax_tot",
Convert.ToSingle(lbltotaltax.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_Money_Render",
Convert.ToSingle(numericUpDown1.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_Change",
Convert.ToSingle(lblchange.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_total",
Convert.ToSingle(AmountDue));
Sqlcmd.Parameters.AddWithValue("@Inv_Num_of_items",
Convert.ToInt32(Totitems));
Sqlcmd.Parameters.AddWithValue("@Inv_Num",
lblinvoice.Text);
Sqlcmd.Parameters.AddWithValue("@tran_stat",
"Cash");
Sqlcmd.Connection = Cnn;
Sqlcmd.CommandText = Strsql;
Sqlcmd.ExecuteNonQuery();
Sqlcmd.Dispose();
Strsql = "";
Cnn.Close();
//*********retrieve product sold to deduct to products table
await XretriveProduct();
popup.TitleText = @"Success";
popup.ContentText = @"Transaction successful!";
popup.Popup();
var frmReports = new FrmReports {
StrReport = "Receipt", PrintWhere = ("{V_Receipt.Inv_Num} ='" + lblinvoice.Text + "'")
};
frmReports.ShowDialog();
frmReports.Close();
timer1.Stop();
NewTrans = true;
FillCart = true;
CustomerRetrieve = false;
CustomerId = null;
Hascustomer = false;
UseWaitCursor = false;
Dispose();
}
else
{
Sqlcmd.Parameters.Clear();
await Conopen();
Strsql =
"Update tbl_Transaction set inv_amnt_due=@inv_amnt_due, inv_tax=@inv_tax,inv_tax_tot=@inv_tax_tot,Inv_Money_Render=@Inv_Money_Render, Inv_Change=@Inv_Change, Inv_total=@Inv_total, Inv_Num_of_items=@Inv_Num_of_items, tran_stat=@tran_stat, cus_ID=@cus_ID Where Inv_Num=@Inv_Num";
Sqlcmd.Parameters.AddWithValue("@inv_amnt_due",
Convert.ToSingle(lblsubtotal.Text));
Sqlcmd.Parameters.AddWithValue("@inv_tax",
Convert.ToSingle(lbltax.Text));
Sqlcmd.Parameters.AddWithValue("@inv_tax_tot",
Convert.ToSingle(lbltotaltax.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_Money_Render",
Convert.ToSingle(numericUpDown1.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_Change",
Convert.ToSingle(lblchange.Text));
Sqlcmd.Parameters.AddWithValue("@Inv_total",
Convert.ToSingle(AmountDue));
Sqlcmd.Parameters.AddWithValue("@Inv_Num_of_items",
Convert.ToInt32(Totitems));
Sqlcmd.Parameters.AddWithValue("@Inv_Num",
lblinvoice.Text);
Sqlcmd.Parameters.AddWithValue("@tran_stat",
"Cash");
Sqlcmd.Parameters.AddWithValue("@cus_ID",
CustomerId);
Sqlcmd.Connection = Cnn;
Sqlcmd.CommandText = Strsql;
Sqlcmd.ExecuteNonQuery();
Sqlcmd.Dispose();
Strsql = "";
Cnn.Close();
//*********retrieve product sold to deduct to products table
await XretriveProduct();
popup.TitleText = @"Success";
popup.ContentText = @"Transaction successful!";
popup.Popup();
var frmReports = new FrmReports {
StrReport = "Receipt_Customer", PrintWhere = ("{V_Receipt_Customer.Inv_Num} ='" + lblinvoice.Text + "'")
};
frmReports.ShowDialog();
frmReports.Close();
timer1.Stop();
NewTrans = true;
FillCart = true;
CustomerRetrieve = false;
CustomerId = null;
Hascustomer = false;
UseWaitCursor = false;
Dispose();
}
}
}
