private void button1_Click(object sender, EventArgs e) { try { DataGridViewSelectedRowCollection rows = gridView_ListPersonal.SelectedRows; foreach (DataGridViewRow row in rows) { string name = row.Cells["name"].Value.ToString(); using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { Personal personal = (from p in db.Personals where p.name == name select p).FirstOrDefault(); db.Personals.DeleteOnSubmit(personal); db.SubmitChanges(); } } ChargeDataGridview(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void deleteWrapper(DataGridViewSelectedRowCollection listSelectWrapper) { try { foreach (DataGridViewRow k in listSelectWrapper) { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { string name = k.Cells["name"].Value.ToString(); tb_capa wrapper = (from b in db.tb_capas where b.capa == name select b).FirstOrDefault(); db.tb_capas.DeleteOnSubmit(wrapper); db.SubmitChanges(); } } MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); chargeGridView(); chargeCombo(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { try { Tobacco tobaco = new Tobacco(); string name = txtNameTobacco.Text; int size = int.Parse(comboSize.SelectedValue.ToString()); int blend = int.Parse(comboBlend.SelectedValue.ToString()); int wrapper = int.Parse(comboWrapper.SelectedValue.ToString()); tobaco.size = size; tobaco.blend = blend; tobaco.wrapper = wrapper; tobaco.name = txtNameTobacco.Text; bd.Tobaccos.InsertOnSubmit(tobaco); bd.SubmitChanges(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); txtNameTobacco.Clear(); txtNameTobacco.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void chargeGridView() { using (bd = new EntrepotBDDataContext()) { //////Size var listSize = from s in bd.tb_vitolas orderby s.vitola ascending select new { name = s.vitola }; dataGridView2.DataSource = listSize.ToList(); /// //////Wrapper var listWrapper = from w in bd.tb_capas orderby w.capa ascending select new { name = w.capa }; dataGridView3.DataSource = listWrapper.ToList(); //////Blend var listBlend = from b in bd.tb_ligas select new { name = b.liga } into bX orderby bX.name select bX; dataGridView1.DataSource = listBlend.ToList(); } }
private void button1_Click(object sender, EventArgs e) { try { // DataGridViewSelectedRowCollection rows = gridView_ListTabaco.SelectedRows; foreach (DataGridViewRow row in rows) { string nameTobacco = row.Cells["name"].Value.ToString(); using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { Tobacco tobacco = (from t in db.Tobaccos where String.Equals(t.name, nameTobacco) select t).FirstOrDefault(); db.Tobaccos.DeleteOnSubmit(tobacco); db.SubmitChanges(); } } ChargeDataGridview(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { Production_Daily pDaily = new Production_Daily(); pDaily.product = (int)comboProduct.SelectedValue; pDaily.personal = (int)comboPersonal.SelectedValue; if (radioBonchero.Checked) { decimal cost = 0; if (decimal.TryParse(txtCosto.Text, out cost)) { pDaily.cost_Bonchero = cost; } } if (radioRolero.Checked) { decimal cost = 0; if (decimal.TryParse(txtCosto.Text, out cost)) { pDaily.cost_Rolero = cost; } } pDaily.Date = dateTimePicker1.Value; int quantity; if (int.TryParse(txtQuantity.Text, out quantity)) { pDaily.quantity = quantity; } bd.Production_Dailies.InsertOnSubmit(pDaily); bd.SubmitChanges(); Stock stockObj = new Stock(); stockObj.product = pDaily.product; stockObj.stock1 = pDaily.quantity; stockObj.dateE = pDaily.Date; stockObj.referDaily = pDaily.id_Prod_Daily; bd.Stocks.InsertOnSubmit(stockObj); bd.SubmitChanges(); txtCosto.Clear(); txtQuantity.Clear(); ChargeDataGridview(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void chargeCombo() { using (bd = new EntrepotBDDataContext()) { //////Size var listSize = from s in bd.tb_vitolas orderby s.vitola select s; Dictionary <int, string> sourceSize = new Dictionary <int, string>(); foreach (tb_vitola s in listSize) { sourceSize.Add(s.id_vitola, s.vitola); } comboSize.DataSource = new BindingSource(sourceSize, null); comboSize.DisplayMember = "Value"; comboSize.ValueMember = "Key"; /// //////Wrapper var listWrapper = from w in bd.tb_capas orderby w.capa select w; Dictionary <int, string> sourceWrapper = new Dictionary <int, string>(); foreach (tb_capa w in listWrapper) { sourceWrapper.Add(w.id_capa, w.capa); } comboWrapper.DataSource = new BindingSource(sourceWrapper, null); comboWrapper.DisplayMember = "Value"; comboWrapper.ValueMember = "Key"; //////Blend var listBlend = from b in bd.tb_ligas orderby b.liga select b; Dictionary <int, string> sourceBlend = new Dictionary <int, string>(); foreach (tb_liga b in listBlend) { sourceBlend.Add(b.id_liga, b.liga); } comboBlend.DataSource = new BindingSource(sourceBlend, null); comboBlend.DisplayMember = "Value"; comboBlend.ValueMember = "Key"; } }
private void button3_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection rows = dataGridProduct.SelectedRows; foreach (DataGridViewRow row in rows) { try { string productS = row.Cells["Product"].Value.ToString(); string personalS = row.Cells["Personal"].Value.ToString(); DateTime dateS = (DateTime)row.Cells["Date"].Value; using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { int product = (from p in bd.Tobaccos where p.name == productS select p.id_Tobacco).FirstOrDefault(); int personal = (from p in bd.Personals where p.name == personalS select p.id_Personal).FirstOrDefault(); Production_Daily pDaily = (from p in bd.Production_Dailies where p.product == product && p.personal == personal && p.Date == dateS select p).FirstOrDefault(); Stock objStock = (from s in bd.Stocks where s.referDaily == pDaily.id_Prod_Daily select s).FirstOrDefault(); bd.Production_Dailies.DeleteOnSubmit(pDaily); bd.Stocks.DeleteOnSubmit(objStock); bd.SubmitChanges(); // MessageBox.Show(" delete success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { } } ChargeDataGridview(); }
private void updateWrapper() { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { db.ExecuteCommand("update tb_capa set capa={0} where capa={1}", textBox1.Text, this.name); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message + ex.Source); } }
private void chargeCombo() { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { //////Product var listTobacco = from t in bd.Tobaccos select t; Dictionary <int, string> sourceTobaco = new Dictionary <int, string>(); foreach (Tobacco t in listTobacco) { sourceTobaco.Add(t.id_Tobacco, t.name); } comboProduct.DataSource = new BindingSource(sourceTobaco, null); comboProduct.DisplayMember = "Value"; comboProduct.ValueMember = "Key"; /////Personal var listPersonal = from p in bd.Personals select p; Dictionary <int, string> sourcePersonal = new Dictionary <int, string>(); foreach (Personal p in listPersonal) { sourcePersonal.Add(p.id_Personal, p.name); } comboPersonal.DataSource = new BindingSource(sourcePersonal, null); comboPersonal.DisplayMember = "Value"; comboPersonal.ValueMember = "Key"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void ChargeDataGridview() { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { var listPersonal = from p in bd.View_Personals select p; gridView_ListPersonal.DataSource = listPersonal.ToList(); } } catch (Exception ex) { MessageBox.Show(ex.Message + " " + ex.StackTrace); } }
private void ChargeGridView() { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { var list = from prod in bd.View_Stocks select prod; GridViewStock.DataSource = list; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void ChargeDataGridview() { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { var listTobaco = from t in bd.View_TobaccoCatalogs select t; gridView_ListTabaco.DataSource = listTobaco.ToList(); } } catch (Exception ex) { MessageBox.Show(ex.Message + " " + ex.StackTrace); } }
private void updateBlend() { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { db.ExecuteCommand("update tb_liga set liga={0} where liga={1}", textBox1.Text, this.name); } MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (SqlException ex) { MessageBox.Show(ex.Message); } }
public void ChargeDataGridview() { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { var listProduct = from p in bd.View_Production_Dailies orderby p.Date descending select p; dataGridProduct.DataSource = listProduct.ToList(); } } catch (Exception ex) { MessageBox.Show(ex.Message + " " + ex.StackTrace); } }
private void button1_Click(object sender, EventArgs e) { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { Personal personal = new Personal(); personal.name = textBox2.Text; personal.position = comboBox1.SelectedItem.ToString(); db.Personals.InsertOnSubmit(personal); db.SubmitChanges(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); button2.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { try { using (EntrepotBDDataContext bd = new EntrepotBDDataContext()) { DataGridViewRow row = GridViewStock.SelectedRows[0]; string productName = row.Cells["Product"].Value.ToString(); var list = from stock in bd.View_Stock_Details where stock.Product.Equals(productName) select stock; GridView_Details.DataSource = list; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button14_Click(object sender, EventArgs e) { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { tb_capa wrapper = new tb_capa(); wrapper.capa = textBox3.Text; db.tb_capas.InsertOnSubmit(wrapper); db.SubmitChanges(); chargeCombo(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox3.Clear(); chargeGridView(); textBox3.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click_1(object sender, EventArgs e) { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { tb_liga blend = new tb_liga(); blend.liga = textBox1.Text; db.tb_ligas.InsertOnSubmit(blend); db.SubmitChanges(); chargeCombo(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Clear(); chargeGridView(); textBox1.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }