private void button1_Click(object sender, EventArgs e)
{
v.Type = comboType.Text;
v.Name = nme.Text;
v.Email = email1.Text;
v.Contact = contact1.Text;
v.Address = address1.Text;
v.added_date = DateTime.Now;
string loggduser = Formlogin.loggdin;
userbll u = udal.getid(loggduser);
v.added_by = u.id;
bool success = s.Insert(v);
if (success == true)
{
MessageBox.Show("USER CREATED SUCCESFULLY");
clear();
}
else
{
MessageBox.Show("FAILED TO ADD NEW USER");
}
DataTable dt = s.Select();
dataGridView8.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
String loggduser = Formlogin.loggdin;
u.First_name = firstname.Text;
u.Last_name = lastname.Text;
u.email = Email.Text;
u.username = Username.Text;
u.password = Password.Text;
u.contact = Contact.Text;
u.Address = address.Text;
u.user_type = UserType.Text;
u.added_date = DateTime.Now;
userbll v = dal.getid(loggduser);
u.added_by = v.id;
bool success = dal.Insert(u);
if (success == true)
{
MessageBox.Show("USER CREATED SUCCESFULLY");
clear();
}
else
{
MessageBox.Show("FAILED TO ADD NEW USER");
}
DataTable dt = dal.Select();
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
u2.Name = name.Text;
u2.Category = categorycmb.Text;
u2.Description = description.Text;
u2.Rate = Decimal.Parse(rate.Text);
u2.Qty = Decimal.Parse(qty.Text);
u2.added_date = DateTime.Now;
string loggduser = Formlogin.loggdin;
userbll u = udal.getid(loggduser);
u2.added_by = u.id;
bool success = dal2.Insert(u2);
if (success == true)
{
MessageBox.Show("Products added successfullY");
clear();
}
else
{
MessageBox.Show("FAILED TO ADD NEW PRODUCT");
}
DataTable dt = dal2.Select();
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
u1.Title = title.Text;
u1.Description = description.Text;
u1.added_date = DateTime.Now;
string loggduser = Formlogin.loggdin;
userbll u = udal.getid(loggduser);
u1.added_by = u.id;
bool success = dal1.Insert(u1);
if (success == true)
{
MessageBox.Show("CATEGORY CREATED SUCCESFULLY");
clear();
}
else
{
MessageBox.Show("FAILED ");
}
}
private void button2_Click(object sender, EventArgs e)
{
Transactionbll transaction = new Transactionbll();
transaction.Type = label1.Text;
string dea_csname = dcname.Text;
DCbll dc = dcdal.getid(dea_csname);
transaction.dea_cust_id = dc.id;
transaction.Grand_total = Math.Round(decimal.Parse(grandtotal.Text), 2);
transaction.transaction_date = DateTime.Now;
transaction.tax = decimal.Parse(vat.Text);
transaction.discount = decimal.Parse(discount.Text);
string usrname = Formlogin.loggdin;
userbll u = udal.getid(usrname);
transaction.added_by = u.id;
transaction.transactiondetails = transactiondt;
bool success = false;
//inserting transaction and transaction details
using (TransactionScope scope = new TransactionScope())
{
int transactionid = -1;
bool w = tdal.Insert(transaction, out transactionid);
for (int i = 0; i < transactiondt.Rows.Count; i++)
{
trnsctiondetailbll tddetail = new trnsctiondetailbll();
String prdname = transactiondt.Rows[i][0].ToString();
productsbll p = pdal.getpid(prdname);
tddetail.pid = p.id;
tddetail.rate = decimal.Parse(transactiondt.Rows[i][1].ToString());
tddetail.qty = decimal.Parse(transactiondt.Rows[i][2].ToString());
tddetail.Total = Math.Round(decimal.Parse(transactiondt.Rows[i][3].ToString()), 2);
tddetail.dea_cust_id = dc.id;
tddetail.added_date = DateTime.Now;
tddetail.added_by = u.id;
//INC OR DEC QTY
string ttype = label1.Text;
bool x = false;
if (ttype == "PURCHASE")
{
x = pdal.increaseqty(tddetail.pid, tddetail.qty);
}
else if (ttype == "SALES")
{
x = pdal.decreaseqty(tddetail.pid, tddetail.qty);
}
bool y = tddal.Insert(tddetail);
success = w && y && x;
}
if (success == true)
{
scope.Complete();
DGVPrinter print = new DGVPrinter();
print.Title = "\r\n\r\n MIKE'S STORES PVT LTD \r\n";
print.SubTitle = "KOCHI ,KERALA ,phone - +919537583616\r\n\r\n";
print.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
print.PageNumbers = true;
print.PageNumberInHeader = false;
print.PorportionalColumns = true;
print.HeaderCellAlignment = StringAlignment.Near;
print.Footer = "Discount :" + discount.Text + "% \r\n" + "vat :" + vat.Text + "%\r\n" + "GRAND_TOTAL:" + grandtotal.Text + "\r\n" + "Date & time of purchase:" + dateTimePicker1.Value + "\r\n\r" + " THANK YOU";
print.FooterSpacing = 40;
print.PrintDataGridView(dgvproducts);
MessageBox.Show("TRANSACTION C0MPLETED SUCCESSFULLY");
dgvproducts.DataSource = null;
dgvproducts.Rows.Clear();
dgvproducts.DataSource = null;
dgvproducts.Rows.Clear();
dcsearch.Text = "";
dcname.Text = "";
dcemail.Text = "";
dccontact.Text = "";
dcaddress.Text = "";
clear();
sbtotal.Text = "";
discount.Text = "0";
grandtotal.Text = "0";
vat.Text = "0";
PA.Text = "0";
RA.Text = "0";
}
else
{
MessageBox.Show("TRANSACTION FAILED");
}
}
}
