public void insertcompany(datavalues p)
{
try
{
conn.Open();
cmd.CommandText = "INSERT INTO company (companyname,companyaddress,companycontactno) VALUES('" + p.Companyname + "','" + p.Companyaddress + "','" + p.Companycontactno + "')";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public void insertproduct(datavalues p)
{
try
{
conn.Open();
cmd.CommandText = "INSERT INTO product(productname, productquantity, productprice, producttotal) VALUES('" + p.Productname + "','" + p.Productquantity + "','" + p.Productprice + "','" + p.Producttotal + "')";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public void insertuser(datavalues p)
{
try
{
conn.Open();
cmd.CommandText = "INSERT INTO user (username,password,contactno) VALUES('" + p.Name + "','" + p.Address + "','" + p.Contactno + "')";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public void insertowncompany(datavalues p)
{
try
{
conn.Open();
cmd.CommandText = "UPDATE owncompany SET owncompanyname='" + p.Owncompany + "' , owncompanyaddress='" + p.Owncompaddress + "', owncompanyno='" + p.Owncompcontactno + "' WHERE owncompanyID = 1";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
public void insertvoice(datavalues p)
{
try
{
conn.Open();
cmd.CommandText = "INSERT INTO invoice(invoiceno,invoicedatetime,billprice,companyname) VALUES('" + p.Billnumber + "','" + p.Invoicedatetime + "','" + p.Billprice + "','" + p.Companynameforinvoice + "')";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void btnCompanySubmit_Click(object sender, EventArgs e)
{
try
{
if (Iscomp())
{
datavalues pc = new datavalues();
pc.Companyname = txtCompantName.Text;
pc.Companyaddress = txtCompanyAddress.Text;
pc.Companycontactno = txtComanyContact.Text;
b.insertcompany(pc);
MessageBox.Show("Company has been added successfully", "Congratulations", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
catch (Exception)
{
}
}
private void btnowncompsubmit_Click(object sender, EventArgs e)
{
try
{
if (Isowncomp())
{
datavalues pc = new datavalues();
pc.Owncompany = txtowncomp.Text;
pc.Owncompaddress = txtownadd.Text;
pc.Owncompcontactno = txtowncntct.Text;
b.insertowncompany(pc);
MessageBox.Show("Your company information has been replaced successfully", "Congratulations", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Isuser())
{
datavalues pc = new datavalues();
pc.Name = txtUserName.Text;
pc.Address = txtPassword.Text;
pc.Contactno = txtContact.Text;
b.insertuser(pc);
MessageBox.Show("User has been added successfully", "Congratulations", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnProductSubmit_Click(object sender, EventArgs e)
{
try
{
if (Isproduct())
{
datavalues pc = new datavalues();
pc.Productname = txtProductName.Text;
pc.Productquantity = Convert.ToInt16(txtQuantity.Text);
pc.Productprice = Convert.ToInt16(txtPrize.Text);
int calculation = (Convert.ToInt16(txtQuantity.Text) * Convert.ToInt16(txtPrize.Text));
pc.Producttotal = calculation;
b.insertproduct(pc);
MessageBox.Show("Product has been addded successfully", "Congratulations", MessageBoxButtons.OK, MessageBoxIcon.None);
}
}
catch (Exception)
{
}
}
public datavalues invoicehistorydetail(datavalues p)
{
try
{
conn.Open();
cmd.CommandText = "SELECT invoiceno,invoicedatetime,billprice,companyname FROM invoice;";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
SQLiteDataReader sdr = null;
using (sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
p.Billnumber = sdr[0].ToString();
p.Invoivedatetime = sdr[1].ToString();
p.Billprice = Convert.ToDecimal(sdr[2]);
p.Companynameforinvoice = sdr[3].ToString();
}
}
return(p);
//cmd.Dispose();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void btnprinterorder_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource != null)
{
PrinterSettings ps = new PrinterSettings();
var recordDoc = new PrintDocument();
recordDoc.PrinterSettings = ps;
IEnumerable <PaperSize> paperSizes = ps.PaperSizes.Cast <PaperSize>();
PaperSize sizeA4 = paperSizes.First <PaperSize>(size => size.Kind == PaperKind.A4); // setting paper size to A4 size
recordDoc.DefaultPageSettings.PaperSize = sizeA4;
recordDoc = printDocument1;
printPreviewDialog1.Document = recordDoc;
//recordDoc.DefaultPageSettings.Landscape = true;
//printDocument1.Print();
recordDoc.Print();
datavalues pc = new datavalues();
pc.Billnumber = lblbillno.Text;
pc.Invoicedatetime = DateTime.Now;
pc.Billprice = Convert.ToDecimal(txttotalamount.Text);
pc.Companynameforinvoice = cmbcompanyname.SelectedValue.ToString();;
b.insertvoice(pc);
//database
}
else
{
MessageBox.Show("List is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// }
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}