private void btnOrder_Click(object sender, EventArgs e) //Add Receipt
{
if (radioButton1.Checked || radioButton2.Checked &&
!txtPAmount.Text.Equals("") && !txtCusName.Text.Equals(""))
{
AllDataContext dc = new AllDataContext();
q = (from cu in dc.GetTable <Customer>()
where cu.Name == txtCusName.Text
select cu.Id).SingleOrDefault();
addOrder();
opDetails();
addLedger();
ORefreshGrid();
CRefreshGrid();
LRefreshGrid();
LGrid();
txtd1.Text = txtd2.Text = txtd3.Text = txtd4.Text =
txtd5.Text = txtd6.Text = txtd7.Text = txtd8.Text =
txtq1.Text = txtq2.Text = txtq3.Text = txtq4.Text =
txtq5.Text = txtq6.Text = txtq7.Text = txtq8.Text =
txtr1.Text = txtr2.Text = txtr3.Text = txtr4.Text =
txtr5.Text = txtr6.Text = txtr7.Text = txtr8.Text =
txtp1.Text = txtp2.Text = txtp3.Text = txtp4.Text =
txtp5.Text = txtp6.Text = txtp7.Text = txtp8.Text =
txtCusName.Text = txtPAmount.Text = "";
MessageBox.Show("New Receipt Added Successfully");
lblOId.Text = (Convert.ToInt32(lblOId.Text) + 1).ToString();
}
else
{
MessageBox.Show("Please Fill receipt Information!");
}
}
private void CGrid() //Customer's DataGridView
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.GetTable <Customer>()
select cu;
dataGridView1.AutoGenerateColumns = false;
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "name";
dataGridView1.Columns[0].HeaderText = "Customer Name";
dataGridView1.Columns[0].DataPropertyName = "Name";
dataGridView1.Columns[1].Name = "mobilenumber";
dataGridView1.Columns[1].HeaderText = "Mobile Number";
dataGridView1.Columns[1].DataPropertyName = "MobileNumber";
dataGridView1.Columns[2].Name = "address";
dataGridView1.Columns[2].HeaderText = "Address";
dataGridView1.Columns[2].DataPropertyName = "Address";
dataGridView1.Columns[3].Name = "cnic";
dataGridView1.Columns[3].HeaderText = "CNIC";
dataGridView1.Columns[3].DataPropertyName = "CNIC";
dataGridView1.DataSource = q;
var CustomerName =
from cu in dc.Customers
select new { cu.Name, cu.Id };
listBox1.DataSource = CustomerName;
listBox1.DisplayMember = "Name";
listBox1.ValueMember = "Id";
}
private void ORGrid() //Product's DataGridView
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.GetTable <OrView>()
select cu;
dataGridView3.AutoGenerateColumns = false;
dataGridView3.ColumnCount = 5;
dataGridView3.Columns[0].Name = "id";
dataGridView3.Columns[0].HeaderText = "Order No.";
dataGridView3.Columns[0].DataPropertyName = "Id";
dataGridView3.Columns[1].Name = "cid";
dataGridView3.Columns[1].HeaderText = "Customer Name";
dataGridView3.Columns[1].DataPropertyName = "Name";
dataGridView3.Columns[2].Name = "amount";
dataGridView3.Columns[2].HeaderText = "Amount";
dataGridView3.Columns[2].DataPropertyName = "Amount";
dataGridView3.Columns[3].Name = "OrderDate";
dataGridView3.Columns[3].HeaderText = "Order Date";
dataGridView3.Columns[3].DataPropertyName = "orderDate";
dataGridView3.Columns[4].Name = "Payment";
dataGridView3.Columns[4].HeaderText = "Payment";
dataGridView3.Columns[4].DataPropertyName = "payment";
dataGridView3.DataSource = q;
}
private void addLedger() //Add Ledger Method
{
AllDataContext dc = new AllDataContext();
var z = (from w in dc.GetTable <Customer>()
where w.Name == txtCusName.Text
select w.Id).SingleOrDefault();
int?i = dc.Ledgers.Where(x => x.C_Id == z)
.Max(x => (int?)x.Id);
var r = (from u in dc.GetTable <Ledger>()
where u.Id == i
select u.Balance).SingleOrDefault();
//Ledger Start
Ledger l = new Ledger();
l.C_Id = q;
l.O_Id = Convert.ToInt32(lblOId.Text);
if (Convert.ToDouble(txtPAmount.Text) == Convert.ToDouble(lblTAmount.Text))
{
l.Balance = r;
}
else if (Convert.ToDouble(txtPAmount.Text) == 0)
{
l.Credit = lblTAmount.Text;
l.Balance = (Convert.ToDouble(r) + Convert.ToDouble(l.Credit)).ToString();
}
else if (Convert.ToDouble(txtPAmount.Text) < Convert.ToDouble(lblTAmount.Text))
{
double j = Convert.ToDouble(lblTAmount.Text) - Convert.ToDouble(txtPAmount.Text);
l.Credit = Convert.ToString(j);
l.Balance = (Convert.ToDouble(r) + Convert.ToDouble(l.Credit)).ToString();
}
else
{
double j = Convert.ToDouble(txtPAmount.Text) - Convert.ToDouble(lblTAmount.Text);
l.Debit = Convert.ToString(j);
l.Balance = (Convert.ToDouble(r) - Convert.ToDouble(l.Debit)).ToString();
}
dc.Ledgers.InsertOnSubmit(l);
dc.SubmitChanges();
//Ledger End
}
private void RefreshGrid() //Show Customer In Grid After Add
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.GetTable <Customer>()
select cu;
dataGridView1.DataSource = q;
var CustomerName =
from cu in dc.Customers
select new { cu.Name, cu.Id };
listBox1.DataSource = CustomerName;
listBox1.DisplayMember = "Name";
listBox1.ValueMember = "Id";
}
private void opDetails() //Add Order Product Details
{
if (txtd1.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d1 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd1.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d1;
pd.Kg = txtq1.Text;
pd.Price = txtp1.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd2.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d2 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd2.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d2;
pd.Kg = txtq2.Text;
pd.Price = txtp2.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd3.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d3 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd3.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d3;
pd.Kg = txtq3.Text;
pd.Price = txtp3.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd4.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d4 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd4.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d4;
pd.Kg = txtq4.Text;
pd.Price = txtp4.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd5.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d5 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd5.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d5;
pd.Kg = txtq5.Text;
pd.Price = txtp5.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd6.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d6 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd6.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d6;
pd.Kg = txtq6.Text;
pd.Price = txtp6.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd7.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d7 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd7.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d7;
pd.Kg = txtq7.Text;
pd.Price = txtp7.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
if (txtd8.Text != "")
{
AllDataContext dc = new AllDataContext();
PDetail pd = new PDetail();
pd.O_Id = Convert.ToInt32(lblOId.Text);
int d8 = (from cu in dc.GetTable <FastFood>()
where cu.Name == txtd8.Text
select cu.Id).SingleOrDefault();
pd.P_Id = d8;
pd.Kg = txtq8.Text;
pd.Price = txtp8.Text;
dc.PDetails.InsertOnSubmit(pd);
dc.SubmitChanges();
}
}