private void cmd_tax_Click(object sender, EventArgs e)
{
Bus_Cus.CreateFolder(dgv_Data.Rows[index].Cells[0].Value.ToString().Trim());
Bus_Letter.Kill_process();
DTO_TaxInvoice _tax = new DTO_TaxInvoice();
BUS_TaxInvoce _bus_tax = new BUS_TaxInvoce();
BUS_Payment _bus_pay = new BUS_Payment();
DataTable tb_payment = new DataTable();
_tax.Matter_ID = dgv_Data.Rows[index].Cells[0].Value.ToString().Trim();
DataTable tb_tax = new DataTable();
tb_tax = _bus_tax.Load(_tax.Matter_ID);
if (tb_tax.Rows.Count > 0)
{
_tax.Tax_No = tb_tax.Rows[0][0].ToString().Trim();
}
else
{
_tax.Tax_No = _bus_tax.CreateID();
}
_bus_tax.Insert(_tax);
BUS_TimeAndFees _bus_time = new BUS_TimeAndFees();
DataTable tb_Sum;
tb_payment = _bus_pay.Load(_tax.Matter_ID);
string d = dgv_Data.Rows[index].Cells[17].Value.ToString().Trim();
if (d == "True")
{
tb_Sum = _bus_time.LoadFixedPrice(_tax.Matter_ID);
}
else
{
tb_Sum = _bus_time.LoadHoursPrice(_tax.Matter_ID);
}
string Des = "";
for (int i = 0; i < tb_Sum.Rows.Count; i++)
{
Des += tb_Sum.Rows[i][2].ToString().Trim() + "\t" + tb_Sum.Rows[i][3].ToString().Trim() + "\n";
}
Bus_Letter.Fill_TaxInvoice("" + dgv_Data.Rows[index].Cells[5].Value.ToString().Trim() + " " + dgv_Data.Rows[index].Cells[6].Value.ToString().Trim(), dgv_Data.Rows[index].Cells[0].Value.ToString().Trim(), _tax.Tax_No, txt_address1.Text.Trim() + " " + txt_address2.Text.Trim(), cbx_suburb.Text.Trim() + " " + txt_State.Text.Trim() + " " + txt_Post_Code.Text.Trim(), cbx_Salutation.Text.Trim(), Des, tb_payment.Rows[0][2].ToString().Trim(), tb_payment.Rows[0][3].ToString().Trim(), tb_payment.Rows[0][4].ToString().Trim(), tb_payment.Rows[0][5].ToString().Trim(), dgv_Data.Rows[index].Cells[6].Value.ToString().Trim(), fileLocation);
}
public bool Insert(DTO_TaxInvoice Invoice)
{
connect();
string sql = "INSERT INTO capston1_customers.TaxInvoice (Tax_No, Matter_ID) VALUES (@Tax_No, @Matter_ID)";
try
{
_cmd = new MySqlCommand(sql, _cnn);
_cmd.Parameters.Add("@Tax_No", MySqlDbType.VarChar, 30).Value = Invoice.Tax_No;
_cmd.Parameters.Add("@Matter_ID", MySqlDbType.VarChar, 30).Value = Invoice.Matter_ID;
_cmd.ExecuteNonQuery();
_cmd.Dispose();
disconnect();
}
catch (Exception ex)
{
disconnect();
return(false);
throw ex;
}
return(true);
}
public bool Insert(DTO_TaxInvoice invoice)
{
return(Tax.Insert(invoice));
}
