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 Form2_Load(object sender, EventArgs e)
{
CGrid();
POC();
ORGrid();
OPRefreshGrid();
PRefreshGrid();
CRefreshGrid();
LGrid();
LRefreshGrid();
AllDataContext dc = new AllDataContext();
Ordr o = new Ordr();
int?p = dc.Ordrs.Max(cu => (int?)cu.Id);
if (p == null)
{
p = 0;
}
var u = p + 1;
lblOId.Text = u.ToString();
}
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 listBox3_Click(object sender, EventArgs e) //Product's Listbox for Order
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox3.SelectedValue);
FastFood cs = dc.FastFoods.Single(c => c.Id == selectedId);
if (txtd1.Text.Equals(""))
{
txtd1.Text = cs.Name;
txtr1.Text = cs.Rate;
}
else if (!txtd1.Text.Equals("") && txtd2.Text.Equals(""))
{
txtd2.Text = cs.Name;
txtr2.Text = cs.Rate;
}
else if (!txtd2.Text.Equals("") && txtd3.Text.Equals(""))
{
txtd3.Text = cs.Name;
txtr3.Text = cs.Rate;
}
else if (!txtd3.Text.Equals("") && txtd4.Text.Equals(""))
{
txtd4.Text = cs.Name;
txtr4.Text = cs.Rate;
}
else if (!txtd4.Text.Equals("") && txtd5.Text.Equals(""))
{
txtd5.Text = cs.Name;
txtr5.Text = cs.Rate;
}
else if (!txtd5.Text.Equals("") && txtd6.Text.Equals(""))
{
txtd6.Text = cs.Name;
txtr6.Text = cs.Rate;
}
else if (!txtd6.Text.Equals("") && txtd7.Text.Equals(""))
{
txtd7.Text = cs.Name;
txtr7.Text = cs.Rate;
}
else if (!txtd7.Text.Equals("") && txtd8.Text.Equals(""))
{
txtd8.Text = cs.Name;
txtr8.Text = cs.Rate;
}
else if (!txtd1.Text.Equals("") && !txtd2.Text.Equals("") &&
!txtd3.Text.Equals("") && !txtd4.Text.Equals("") &&
!txtd5.Text.Equals("") && !txtd6.Text.Equals("") &&
!txtd7.Text.Equals("") && !txtd8.Text.Equals(""))
{
MessageBox.Show("Receipt List are full");
}
}
//tabPage CashMemo End
//tabPage DailyState Start
private void ORefreshGrid() //Show Product In Grid After Add, Update & Delete
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.OrViews
select cu;
dataGridView3.DataSource = q;
}
//tabPage DailyState End
//tabPage Cheque Start
private void CRefreshGrid() //Show Cheque In Grid After Add
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.Cheques
select cu;
dataGridView4.DataSource = q;
}
private void listBox2_Click(object sender, EventArgs e) //Product ListBox
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox2.SelectedValue);
FastFood cs = dc.FastFoods.Single(c => c.Id == selectedId);
txtUpdatePName.Text = cs.Name;
txtUpdatePRate.Text = cs.Rate;
}
private void btnSearch_Click(object sender, EventArgs e) //Search Customer
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.Customers
where cu.Name.Contains(txtDelete.Text)
select cu;
dataGridView1.DataSource = q;
}
//tabPage Cheque End
//tabPage Ledger Start
private void LGrid()
{
AllDataContext dc = new AllDataContext();
var CustomerName = from l in dc.Customers
select new { l.Id, l.Name };
listBox4.DataSource = CustomerName;
listBox4.DisplayMember = "Name";
listBox4.ValueMember = "Id";
}
private void OPRefreshGrid() //Show Product in Listbox for Order after Add
{
AllDataContext dc = new AllDataContext();
var p = from cu in dc.FastFoods
select new { cu.Name, cu.Id };
listBox3.DataSource = p;
listBox3.DisplayMember = "Name";
listBox3.ValueMember = "Id";
}
private void listBox1_Click(object sender, EventArgs e) //Customer's Listbox
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox1.SelectedValue);
Customer cs = dc.Customers.Single(c => c.Id == selectedId);
txtUpdateName.Text = cs.Name;
txtUpdateMobile.Text = cs.MobileNumber;
txtUpdateAddress.Text = cs.Address;
txtUpdateCNIC.Text = cs.CNIC;
}
private void PUpdateGrid() //Update Product Method
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox2.SelectedValue);
FastFood ff = dc.FastFoods.Single(c => c.Id == selectedId);
ff.Name = txtUpdatePName.Text;
ff.Rate = txtUpdatePRate.Text;
dc.SubmitChanges();
}
private void AddProduct() //Add Product Method
{
AllDataContext dc = new AllDataContext();
FastFood ff = new FastFood()
{
Name = txtPName.Text,
Rate = txtPRate.Text
};
dc.FastFoods.InsertOnSubmit(ff);
dc.SubmitChanges();
}
private void updateGrid() //Customer's Update Method
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox1.SelectedValue);
Customer cs = dc.Customers.Single(c => c.Id == selectedId);
cs.Name = txtUpdateName.Text;
cs.MobileNumber = txtUpdateMobile.Text;
cs.Address = txtUpdateAddress.Text;
cs.CNIC = txtUpdateCNIC.Text;
dc.SubmitChanges();
}
private void btnDelete_Click(object sender, EventArgs e) //Delete Customer
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox1.SelectedValue);
Customer cs = dc.Customers.Single(c => c.Id == selectedId);
dc.Customers.DeleteOnSubmit(cs);
dc.SubmitChanges();
MessageBox.Show("Customer Deleted Successfully!");
RefreshGrid();
POC();
LGrid();
}
private void btnPDelete_Click(object sender, EventArgs e) //Delete Product
{
AllDataContext dc = new AllDataContext();
int selectedId = Convert.ToInt32(listBox2.SelectedValue);
FastFood ff = dc.FastFoods.Single(c => c.Id == selectedId);
dc.FastFoods.DeleteOnSubmit(ff);
dc.SubmitChanges();
txtUpdatePName.Text = txtUpdatePRate.Text = "";
MessageBox.Show("Product Deleted Successfully!");
PRefreshGrid();
OPRefreshGrid();
}
private void AddCustomer() //Add Customer Method
{
AllDataContext dc = new AllDataContext();
Customer c = new Customer()
{
Name = txtName.Text,
MobileNumber = txtMobile.Text,
Address = txtAddress.Text,
CNIC = txtCNIC.Text
};
dc.Customers.InsertOnSubmit(c);
dc.SubmitChanges();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
if (!txtChequeNo.Text.Equals("") && !cbBankName.Text.Equals("") &&
!txtBranch.Text.Equals("") && !txtAccountNo.Text.Equals(""))
{
AllDataContext dc = new AllDataContext();
var c = new Cheque()
{
ChequeNo = Convert.ToInt32(txtChequeNo.Text),
BankName = cbBankName.Text,
Branch = txtBranch.Text,
AccountNo = txtAccountNo.Text,
Status = cbStatus.Text
};
dc.Cheques.InsertOnSubmit(c);
dc.SubmitChanges();
txtChequeNo.Text = txtBranch.Text = txtAccountNo.Text = "";
this.Hide();
}
else if (txtChequeNo.Text.Equals("") && cbBankName.Text.Equals("") &&
txtBranch.Text.Equals("") && txtAccountNo.Text.Equals(""))
{
MessageBox.Show("Please Fill Cheque Details");
}
else
{
if (txtChequeNo.Text.Equals(""))
{
errorProvider1.SetError(txtChequeNo, "Cheque No. Required");
}
else if (cbBankName.Text.Equals(""))
{
errorProvider1.SetError(cbBankName, "Select Bank Required");
}
else if (txtBranch.Text.Equals(""))
{
errorProvider1.SetError(txtBranch, "Branch Address Required");
}
else if (txtAccountNo.Text.Equals(""))
{
errorProvider1.SetError(txtAccountNo, "A/C Required");
}
}
}
private void LRefreshGrid() //Show Ledger In Grid After Adding Order
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.LegCusOrds
select cu;
dataGridView5.DataSource = q;
var CustomerName = from l in dc.Ledgers
select new { l.Customer.Id, l.Customer.Name };
listBox4.DataSource = CustomerName;
listBox4.DisplayMember = "Name";
listBox4.ValueMember = "Id";
}
private void PRefreshGrid() //Product DataGridView & ListBox
{
AllDataContext dc = new AllDataContext();
var q = from cu in dc.FastFoods
select cu;
dataGridView2.DataSource = q;
var p = from cu in dc.FastFoods
select new { cu.Name, cu.Id };
listBox2.DataSource = p;
listBox2.DisplayMember = "Name";
listBox2.ValueMember = "Id";
}
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";
}
protected Mock <Repository> GetRepoMock <T>(string name, bool setupNoTrac = false) where T : BaseEntity
{
var logger = Mock.Of <ILogger>();
var tu = Mock.Of <IPrincipal>();
var dc = new DataContext(tu, logger, test: true, testName: $"FilterByIsDeleted{name}");
var noDeletesDc = new AllDataContext(test: true, testName: $"Unfiltered{name}");
var repoM = new Mock <Repository>(dc, noDeletesDc);
if (setupNoTrac)
{
repoM.Setup(m => m.NoTracking(It.IsAny <DbSet <T> >()))
.Returns(dc.ISet <T>())
.Verifiable();
}
return(repoM);
}
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 bool IsvalidUser(string userName, string password)
{
AllDataContext ldc = new AllDataContext();
var q = from p in ldc.Logins
where p.Name == txtUserName.Text &&
p.Password == txtPassword.Text
select p;
if (q.Any())
{
return(true);
}
else
{
return(false);
}
}
private void listBox4_Click(object sender, EventArgs e)
{
try
{
if (listBox4.SelectedIndex != -1)
{
String itemSelected = listBox4.GetItemText(listBox4.SelectedItem);
AllDataContext dc = new AllDataContext();
var p = from l in dc.LegCusOrds
where l.Name == itemSelected
select l;
dataGridView5.DataSource = p;
}
}
catch (Exception ex)
{
MessageBox.Show("No Record Found!", ex.Message);
}
}
protected Repository GetRepoWithData <T>(List <T> data, string name) where T : BaseEntity
{
var logger = Mock.Of <ILogger>();
var tu = Mock.Of <IPrincipal>();
var dc = new DataContext(tu, logger, test: true, testName: $"FilterByIsDeleted{name}");
var noDeletesDc = new AllDataContext(test: true, testName: $"Unfiltered{name}");
data.ForEach(c => dc.ISet <T>().Add(c));
data.ForEach(c => { if (!c.IsDeleted)
{
noDeletesDc.ISet <T>().Add(c);
}
});
dc.SaveChanges();
noDeletesDc.SaveChanges();
var repo = new Repository(dc, noDeletesDc);
return(repo);
}
private void addOrder() //Add Order Method
{
AllDataContext dc = new AllDataContext();
Ordr o = new Ordr();
o.Id = Convert.ToInt32(lblOId.Text);
o.C_Id = q;
o.Amount = lblTAmount.Text;
o.OrderDate = label1.Text;
if (radioButton1.Checked)
{
o.Payment = radioButton1.Text;
}
else if (radioButton2.Checked)
{
o.Payment = radioButton2.Text;
}
dc.Ordrs.InsertOnSubmit(o);
dc.SubmitChanges();
t = o.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();
}
}
