private void toolStripImport_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); if (dlg.ShowDialog(this) == DialogResult.OK) { object missing = Type.Missing; Excel.Range range; Excel.Worksheet sheet = null; Excel.Workbook wb = null; Excel.Application excelApp = new Excel.Application(); wb = excelApp.Workbooks.Open(dlg.FileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); sheet = (Excel.Worksheet)wb.Worksheets[1]; range = sheet.UsedRange; if (range != null) { using (var db = new SMEntities()) { // Bind DataSource int nRows = range.Rows.Count; int num; decimal d; bool parsed; for (int iRow = 2; iRow <= nRows; iRow++) { Product p = new Product(); // Get ID range = (Excel.Range)sheet.Cells[iRow, 2]; p.prod_id = range.Text; // Get Name range = (Excel.Range)sheet.Cells[iRow, 3]; p.prod_name = range.Text; // Get Quality_control range = (Excel.Range)sheet.Cells[iRow, 4]; parsed = int.TryParse(range.Text, out num); if (parsed) { p.quantity_control = num; } else p.quantity_control = 1; // Get Sale_price_by_stock range = (Excel.Range)sheet.Cells[iRow, 5]; parsed = decimal.TryParse(range.Text, out d); if (parsed) { p.sale_price_by_stock = d; } else p.sale_price_by_stock = 0; // Set sale_price_by_unit range = (Excel.Range)sheet.Cells[iRow, 6]; parsed = decimal.TryParse(range.Text, out d); if (parsed) { p.sale_price_by_unit = d; } else p.sale_price_by_unit = 0; // Check as if product has been existed var prod = db.Products.Where(t => t.prod_id.Equals(p.prod_id)); if (!prod.Any())//Not exist { db.Products.Add(p); db.SaveChanges(); } } } } wb.Close(); excelApp.Quit(); Marshal.ReleaseComObject(wb); Marshal.ReleaseComObject(sheet); } }
private void btnCreateNew_Click(object sender, EventArgs e) { using(var db = new SMEntities()){ DialogResult result = MessageBox.Show("Bạn muốn tạo mới khách hàng với thông tin như trên?", "Confirmation", MessageBoxButtons.YesNoCancel); if(result == DialogResult.Yes) { if (txtCustName.Text == String.Empty || txtAddress.Text == String.Empty) { MessageBox.Show("Nhập thiếu thông tin khách hàng"); return; } Customer c = db.Customers.Create(); c.cust_name = txtCustName.Text; c.cust_phone = txtPhone.Text; c.cust_address = txtAddress.Text; db.Customers.Add(c); db.SaveChanges(); } } }
private void toolStripButton1_Click(object sender, EventArgs e) { if(txtId.Text == string.Empty || txtName.Text == string.Empty || txtQC.Text == string.Empty || txtSalePriceStock.Text == string.Empty) { MessageBox.Show("Chưa nhập đủ dữ liệu sản phẩm"); return; } using (var db = new SMEntities()) { // Bind DataSource Product p = new Product(); p.prod_id = txtId.Text.ToString(); p.prod_name = txtName.Text.ToString(); p.quantity_control = int.Parse(txtQC.Text.ToString()); p.sale_price_by_stock = decimal.Parse(txtSalePriceStock.Text.ToString()); p.sale_price_by_unit = decimal.Parse(txtSalePriceUnit.Text.ToString()); // Get default values p.quantity_by_stock = 0; p.quantity_by_unit = 0; p.date_added = DateTime.Now; p.date_modified = p.date_added; // Check as if products has been existed var query = db.Products.Where(t => t.prod_id.Equals(p.prod_id)); if (!query.Any())// Not exist { db.Products.Add(p); db.SaveChanges(); clearEntries(); } else { // Accept change Name and sale price var result = MessageBox.Show(this, "Sản phẩm đã có trong dữ liệu.\n Bạn có muốn lưu tên và giá bán hiện tại?", "Lưu sản phẩm hàng", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { Product updatePro = query.First(); updatePro.prod_name = p.prod_name; updatePro.sale_price_by_stock = p.sale_price_by_stock; updatePro.sale_price_by_unit = p.sale_price_by_unit; db.SaveChanges(); clearEntries(); } } } }