private void update_btn_Click_1(object sender, EventArgs e) { Model2 db = new Model2(); var updata = (from data in db.Products where data.EAN.ToString() == textBoxX9.Text select data).First(); updata.Title = textBoxX1.Text; updata.Quantity = int.Parse(textBoxX3.Text); updata.Price = Convert.ToDecimal(textBoxX4.Text); // updata.MinPrice = Convert.ToDecimal(textBoxX5.Text); updata.WholesalePrice = Convert.ToDecimal(textBoxX6.Text); updata.SouqPS = Convert.ToDouble(textBoxX7.Text); updata.SellerPS = Convert.ToDouble(textBoxX8.Text); decimal price = Convert.ToDecimal(textBoxX4.Text); double souqps = Convert.ToDouble(textBoxX7.Text); decimal souqprice = price * Convert.ToDecimal(souqps); decimal sellerprice = price * Convert.ToDecimal(textBoxX8.Text); decimal wholesale = Convert.ToDecimal(textBoxX6.Text); updata.MinPrice = souqprice + sellerprice + wholesale; updata.SouqPrice = souqprice; updata.SellerPrice = sellerprice; updata.EAN = textBoxX9.Text; updata.Sku = textBoxX10.Text; // updata.CategoryType = int.Parse(textBoxX11.Text); string cate = textBoxX10.Text; string catetype = cate.Substring(0, cate.IndexOf(".")); updata.CategoryType = int.Parse(catetype); db.SaveChanges(); textBoxX1.Text = textBoxX2.Text = textBoxX3.Text = textBoxX4.Text = textBoxX5.Text = textBoxX6.Text = textBoxX7.Text = textBoxX8.Text = textBoxX9.Text = textBoxX10.Text = textBoxX11.Text = ""; }
private void add_btn_Click(object sender, EventArgs e) { Model2 db = new Model2(); Product product = new Product(); product.Title = textBoxX1.Text; // product.Img = textBoxX2.Text product.Quantity = int.Parse(textBoxX3.Text); product.Price = Convert.ToDecimal(textBoxX4.Text); // updata.MinPrice = Convert.ToDecimal(textBoxX5.Text); product.WholesalePrice = Convert.ToDecimal(textBoxX6.Text); product.SouqPS = Convert.ToDouble(textBoxX7.Text); product.SellerPS = Convert.ToDouble(textBoxX8.Text); decimal price = Convert.ToDecimal(textBoxX4.Text); double souqps = Convert.ToDouble(textBoxX7.Text); decimal souqprice = price * Convert.ToDecimal(souqps); decimal sellerprice = price * Convert.ToDecimal(textBoxX8.Text); decimal wholesale = Convert.ToDecimal(textBoxX6.Text); product.MinPrice = souqprice + sellerprice + wholesale; product.SouqPrice = souqprice; product.SellerPrice = sellerprice; product.EAN = textBoxX9.Text; product.Sku = textBoxX10.Text; // product.CategoryType = int.Parse(textBoxX11.Text); string cate = textBoxX10.Text; string catetype = cate.Substring(0, cate.IndexOf(".")); product.CategoryType = int.Parse(catetype); db.Products.Add(product); db.SaveChanges(); textBoxX1.Text = textBoxX2.Text = textBoxX3.Text = textBoxX4.Text = textBoxX5.Text = textBoxX6.Text = textBoxX7.Text = textBoxX8.Text = textBoxX9.Text = textBoxX10.Text = textBoxX11.Text = ""; }
//excel sheet btn private void buttonX1_Click(object sender, EventArgs e) { string fname = ""; OpenFileDialog fdlg = new OpenFileDialog(); fdlg.Title = "Excel File Dialog"; fdlg.InitialDirectory = @"c:\"; fdlg.Filter = "All files (*.*)|*.*|All files (*.*)|*.*"; fdlg.FilterIndex = 2; fdlg.RestoreDirectory = true; if (fdlg.ShowDialog() == DialogResult.OK) { fname = fdlg.FileName; } Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(fname); Microsoft.Office.Interop.Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1]; Microsoft.Office.Interop.Excel.Range xlRange = xlWorksheet.UsedRange; int rowCount = xlRange.Rows.Count; // int colCount = xlRange.Columns.Count; // dataGridProducts.ColumnCount = colCount; dataGridProducts.RowCount = rowCount; Model2 m = new Model2(); Product pro = new Product(); for (int i = 1; i <= rowCount - 1; i++) { for (int j = 1; j <= dataGridProducts.ColumnCount; j++) { if (xlRange.Cells[i, j] != null && xlRange.Cells[i, j].Value2 != null) { // dataGridProducts.Rows[i - 1].Cells[j - 1].Value = xlRange.Cells[i, j].Value2.ToString(); dataGridProducts.Rows[i - 1].Cells[0].Value = xlRange.Cells[i + 1, 4].Value2.ToString(); dataGridProducts.Rows[i - 1].Cells[2].Value = xlRange.Cells[i + 1, 9].Value2.ToString(); dataGridProducts.Rows[i - 1].Cells[3].Value = xlRange.Cells[i + 1, 8].Value2.ToString(); dataGridProducts.Rows[i - 1].Cells[10].Value = xlRange.Cells[i + 1, 1].Value2.ToString(); dataGridProducts.Rows[i - 1].Cells[11].Value = xlRange.Cells[i + 1, 2].Value2.ToString(); } } pro.Title = dataGridProducts.Rows[i - 1].Cells[0].Value.ToString(); pro.Quantity = int.Parse(dataGridProducts.Rows[i - 1].Cells[2].Value.ToString()); pro.Price = Convert.ToDecimal(dataGridProducts.Rows[i - 1].Cells[3].Value.ToString()); pro.EAN = dataGridProducts.Rows[i - 1].Cells[10].Value.ToString(); pro.Sku = dataGridProducts.Rows[i - 1].Cells[11].Value.ToString(); m.Products.Add(pro); m.SaveChanges(); } //cleanup GC.Collect(); GC.WaitForPendingFinalizers(); Marshal.ReleaseComObject(xlRange); Marshal.ReleaseComObject(xlWorksheet); //close and release xlWorkbook.Close(); Marshal.ReleaseComObject(xlWorkbook); //quit and release xlApp.Quit(); Marshal.ReleaseComObject(xlApp); }