private void button5_Click_1(object sender, EventArgs e)
{
using (ReceiptForm form = new ReceiptForm(noTxt.Text))
{
DialogResult dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
// LoadData();
}
}
}
private void dtGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
if (e.ColumnIndex == dtGrid.Columns["Select"].Index && e.RowIndex >= 0)
{
if (selectedIDs.Contains(dtGrid.Rows[e.RowIndex].Cells["ID"].Value.ToString()))
{
selectedIDs.Remove(dtGrid.Rows[e.RowIndex].Cells["ID"].Value.ToString());
}
else
{
selectedIDs.Add(dtGrid.Rows[e.RowIndex].Cells["ID"].Value.ToString());
}
}
if (e.ColumnIndex == dtGrid.Columns["View"].Index && e.RowIndex >= 0)
{
using (ReceiptForm form = new ReceiptForm(dtGrid.Rows[e.RowIndex].Cells["No"].Value.ToString()))
{
DialogResult dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
// LoadData();
}
}
}
if (e.ColumnIndex == dtGrid.Columns["Check"].Index && e.RowIndex >= 0)
{
using (ReceiptForm form = new ReceiptForm(dtGrid.Rows[e.RowIndex].Cells["No"].Value.ToString()))
{
DialogResult dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
// LoadData();
}
}
}
try
{
if (e.ColumnIndex == dtGrid.Columns["Delete"].Index && e.RowIndex >= 0)
{
if (MessageBox.Show("YES or No?", "Are you sure you want to delete this Invoice? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string Query = "DELETE from invoice WHERE id ='" + dtGrid.Rows[e.RowIndex].Cells["ID"].Value.ToString() + "'";
MySQL.Query(Query);
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(MySQL.Insert(Query)), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
MessageBox.Show("Information deleted");
LoadData();
}
}
}
catch { }
}
private void GenerateInvoice()
{
foreach (CaseTransaction t in GenericCollection.caseTransactions)
{
string ids = Guid.NewGuid().ToString();
CaseTransaction c = new CaseTransaction(ids, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, t.ItemID, noTxt.Text, t.DeliveryID, t.Qty, t.Cost, t.Units, t.Total, t.Tax, t.Coverage, t.Self, t.Payable, t.Limits, t.Setting, t.Period, t.Height, t.Weight, t.Instruction, t.Created, "false", Helper.CompanyID);
if (MySQL.Insert(c) != "")
{
}
}
//string Pid = Guid.NewGuid().ToString();
//Payment p = new Payment(Pid, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, typeCbx.Text, methodCbx.Text, Convert.ToDouble(amountTxt.Text), Convert.ToDouble(balanceTxt.Text), DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
//MySQL.Insert(p);
using (ReceiptForm form = new ReceiptForm(noTxt.Text))
{
DialogResult dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
// LoadData();
}
}
}
private void button3_Click_1(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(amountTxt.Text))
{
amountTxt.BackColor = Color.Red;
MessageBox.Show("How much is being paid ? ");
return;
}
if (GenericCollection.caseTransactions.Count < 1)
{
MessageBox.Show("No Products Defined !");
return;
}
if (string.IsNullOrEmpty(categoryCbx.Text))
{
categoryCbx.BackColor = Color.Red;
MessageBox.Show("How much is being paid ? ");
return;
}
if (string.IsNullOrEmpty(typeCbx.Text))
{
typeCbx.BackColor = Color.Red;
MessageBox.Show("How much is being paid ? ");
return;
}
taxTxt.Text = string.IsNullOrEmpty(taxTxt.Text) ? "0" : taxTxt.Text;
amountTxt.Text = string.IsNullOrEmpty(amountTxt.Text) ? "0" : amountTxt.Text;
methodCbx.Text = string.IsNullOrEmpty(methodCbx.Text) ? "none" : "none";
string Iid = Guid.NewGuid().ToString();
Invoice i = new Invoice(Iid, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, typeCbx.Text, categoryCbx.Text, VendorID, CustomerID, methodCbx.Text, Total, termsTxt.Text, Convert.ToDouble(taxTxt.Text), Convert.ToDouble(amountTxt.Text), Convert.ToDouble(balanceTxt.Text), Convert.ToDouble(amountTxt.Text), Convert.ToInt32(ItemCountTxt.Text), Helper.UserID, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
string save = MySQL.Insert(i);
if (save != "")
{
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(save), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
foreach (CaseTransaction t in GenericCollection.caseTransactions)
{
CaseTransaction c = new CaseTransaction(t.Id, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, t.ItemID, "", "", t.Qty, t.Cost, t.Units, t.Total, t.Tax, t.Coverage, t.Self, t.Payable, t.Limits, t.Setting, t.Period, t.Height, t.Weight, t.Instruction, t.Created, "false", Helper.CompanyID);
string saves = MySQL.Insert(c);
if (saves != "")
{
Queries qe = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(saves), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(qe);
}
}
string Pid = Guid.NewGuid().ToString();
Payment p = new Payment(Pid, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, typeCbx.Text, methodCbx.Text, Convert.ToDouble(amountTxt.Text), Convert.ToDouble(balanceTxt.Text), DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
string saved = MySQL.Insert(p);
if (saved != "")
{
Queries qr = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(saved), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(qr);
}
}
using (ReceiptForm form = new ReceiptForm(noTxt.Text))
{
DialogResult dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
// LoadData();
}
}
button3.Visible = false;
}