private void btnSignin_Click(object sender, EventArgs e) { OnlineCommerceEntities2 db = new OnlineCommerceEntities2(); if (rdbAdmin.Checked) { Accounts ac = db.Accounts.Where(x => x.Username == txtUsername.Text && x.Password == txtPassword.Text && x.AccountTypeID == 3).SingleOrDefault(); if (ac == null) { MessageBox.Show("No admin found", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { AdminForm admin = new AdminForm(); admin.ShowDialog(); } } else { Accounts ac = db.Accounts.Where(x => x.Username == txtUsername.Text && x.Password == txtPassword.Text && x.AccountTypeID == 1).SingleOrDefault(); if (ac == null) { MessageBox.Show("No customer found", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { Companies company = db.Companies.Where(x => x.AccountID == ac.ID).SingleOrDefault(); proform.company_id = company.ID; proform.ShowDialog(); } } }
private void btnSave_Click(object sender, EventArgs e) { companies.Name = txtName.Text.Trim(); companies.Phone = txtPhone.Text.Trim(); companies.Mail = txtMail.Text.Trim(); companies.Fax = txtFax.Text.Trim(); companies.Address = txtAdres.Text.Trim(); companies.AccountID = 18; using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { if (companies.ID == 0) { db.Companies.Add(companies); } else { db.Entry(companies).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } MessageBox.Show("Succesfully"); Clear(); companies.ID = 0; PopulateDataGridView(); }
private void btn_Save_Click(object sender, EventArgs e) { OnlineCommerceEntities2 db = new OnlineCommerceEntities2(); Categories category = db.Categories.Where(x => x.Name == cmb_Categories.Text).SingleOrDefault(); productModel.CategoryID = category.ID; productModel.CompanyID = company_id; productModel.Name = txt_Name.Text.Trim(); productModel.Cost = decimal.Parse(txt_Cost.Text.Trim()); productModel.Price = decimal.Parse(txt_Price.Text.Trim()); productModel.Stock = decimal.Parse(txt_Stock.Text.Trim()); productModel.Image = txt_imageLocation.Text; if (productModel.ID == 0) { db.Products.Add(productModel); } else { db.Entry(productModel).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); Clear(); PopulateDataGridView(); productModel.ID = 0; MessageBox.Show("Succesfully"); }
void PopulateDataGridView() { dgvCompanies.AutoGenerateColumns = false; using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { dgvCompanies.DataSource = db.Companies.ToList <Companies>(); } }
public void CategoryIdControl() { OnlineCommerceEntities2 db = new OnlineCommerceEntities2(); if (categoryId != -1) { Categories categories = db.Categories.Where(x => x.ID == productModel.CategoryID).SingleOrDefault(); cmb_Categories.Text = categories.Name; } }
private void dgvCategory_DoubleClick(object sender, EventArgs e) { if (dgvCategory.CurrentRow.Index != -1) { categoryModel.ID = Convert.ToInt32(dgvCategory.CurrentRow.Cells["ID"].Value); using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { categoryModel = db.Categories.Where(x => x.ID == categoryModel.ID).FirstOrDefault(); txt_Name.Text = categoryModel.Name; } btn_Save.Text = "Update"; btn_Delete.Enabled = true; } }
void PopulateDataGridView() { dgvProduct.AutoGenerateColumns = false; using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { dgvProduct.DataSource = db.Products.Where(x => x.CompanyID == company_id).ToList <Products>(); for (int i = 0; i < dgvProduct.RowCount; i++) { DataGridViewRow a = new DataGridViewRow(); int tempCategoryID = Convert.ToInt32(dgvProduct.Rows[i].Cells[5].Value); Categories category = db.Categories.Where(x => x.ID == tempCategoryID).SingleOrDefault(); dgvProduct.Rows[i].Cells[6].Value = category.Name; } } }
void PopulateComboBox() { using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { var tempList = (from x in db.Categories select new { x.ID, x.Name }).ToList(); cmb_Categories.DataSource = tempList; cmb_Categories.DisplayMember = "Name"; cmb_Categories.ValueMember = "ID"; } }
private void btnSave_Click(object sender, EventArgs e) { comp.Name = txtName.Text.Trim(); comp.Mail = txtMail.Text.Trim(); comp.Phone = txtPhone.Text.Trim(); comp.Fax = txtFax.Text.Trim(); comp.Address = txtAdress.Text.Trim(); using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { db.Companies.Add(comp); db.SaveChanges(); } MessageBox.Show("Succsesfully"); proForm.company_id = comp.ID; proForm.Show(); }
private void dgvCompanies_DoubleClick(object sender, EventArgs e) { if (dgvCompanies.CurrentRow.Index != -1) { companies.ID = Convert.ToInt32(dgvCompanies.CurrentRow.Cells["ID"].Value); using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { companies = db.Companies.Where(x => x.ID == companies.ID).FirstOrDefault(); txtName.Text = companies.Name; txtPhone.Text = companies.Phone; txtMail.Text = companies.Mail; txtAdres.Text = companies.Address; txtFax.Text = companies.Fax; } btnSave.Text = "Update"; btnDelete.Enabled = true; } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure to delete this record ?", "Warning", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { var entry = db.Entry(companies); if (entry.State == System.Data.Entity.EntityState.Detached) { db.Companies.Attach(companies); } db.Companies.Remove(companies); db.SaveChanges(); PopulateDataGridView(); Clear(); companies.ID = 0; MessageBox.Show("Deleted succesfully."); } } }
private void btn_Save_Click(object sender, EventArgs e) { categoryModel.Name = txt_Name.Text.Trim(); using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { if (categoryModel.ID == 0) { db.Categories.Add(categoryModel); } else { db.Entry(categoryModel).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } Clear(); PopulateDataGridView(); categoryModel.ID = 0; MessageBox.Show("Succesfully"); }
private void dgvProduct_DoubleClick(object sender, EventArgs e) { if (dgvProduct.CurrentRow.Index != -1) { productModel.ID = Convert.ToInt32(dgvProduct.CurrentRow.Cells["ID"].Value); using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { productModel = db.Products.Where(x => x.ID == productModel.ID).FirstOrDefault(); txt_Name.Text = productModel.Name; txt_Cost.Text = productModel.Cost.ToString(); txt_Price.Text = productModel.Price.ToString(); txt_Stock.Text = productModel.Stock.ToString(); categoryId = Convert.ToInt32(productModel.CategoryID); txt_imageLocation.Text = productModel.Image.ToString(); image.ImageLocation = productModel.Image; } CategoryIdControl(); btn_Save.Text = "Update"; btn_Delete.Enabled = true; } }
private void btnSignup_Click(object sender, EventArgs e) { accounts.Username = txtUsername.Text.Trim(); accounts.Password = txtPassword.Text.Trim(); accounts.AccountTypeID = 1; if (txtUsername.Text == "" || txtPassword.Text == "") { MessageBox.Show("Please fill in the boxes"); } else { using (OnlineCommerceEntities2 db = new OnlineCommerceEntities2()) { db.Accounts.Add(accounts); db.SaveChanges(); } signUpfrm.comp.AccountID = accounts.ID; signUpfrm.Show(); } }