private void button2_Click(object sender, EventArgs e) { string descriptions; int ammounts; DateTime date; try { int id = int.Parse(textBox1.Text); Daily_consumption dd = db.Daily_consumptions.SingleOrDefault(x => x.Serial_No == id); descriptions = description.Text; ammounts = Convert.ToInt32(this.ammount.Text); date = dateTimePicker1.Value; dd.Description = descriptions; dd.Ammount = ammounts; dd.Dates = date; db.SubmitChanges(); MessageBox.Show("data updated"); } catch (Exception ex) { MessageBox.Show("Please Select The Id Then Edit In the textbox Thank You"); } }
private void button5_Click(object sender, EventArgs e) { try { DataClasses1DataContext db = new DataClasses1DataContext(); int id = int.Parse(textBox1.Text); Daily_consumption prod = db.Daily_consumptions.SingleOrDefault(x => x.Serial_No == id); db.Daily_consumptions.DeleteOnSubmit(prod); db.SubmitChanges(); MessageBox.Show("data deleted"); } catch (Exception ex) { MessageBox.Show("Please Select The Id Then Edit In the textbox Thank You"); } }
/* private void button1_Click(object sender, EventArgs e) * { * try * { * Daily_consumption s = new Daily_consumption(); * s.Description = description.Text; * s.Ammount = Convert.ToInt32(this.ammount.Text); * s.Dates = dateTimePicker1.Value; * db.Daily_consumptions.InsertOnSubmit(s); * db.SubmitChanges(); * MessageBox.Show("Data Inseretd Succesfully"); * } * catch (Exception ex) * { * MessageBox.Show("Fill all field correctly"); * } */ private void button1_Click_1(object sender, EventArgs e) { int serial; int ammounts; string descriptions; DateTime date; Daily_consumption s = new Daily_consumption(); try { serial = int.Parse(textBox2.Text); var se = from a in db.Daily_consumptions select a; foreach (var a in se) { if (a.Serial_No == serial) { MessageBox.Show("serial number already exits"); goto last; } } descriptions = description.Text; ammounts = Convert.ToInt32(this.ammount.Text); date = dateTimePicker1.Value; s.Serial_No = serial; s.Description = descriptions; s.Ammount = ammounts; s.Dates = date; db.Daily_consumptions.InsertOnSubmit(s); db.SubmitChanges(); MessageBox.Show("Data Inseretd Succesfully"); } catch (Exception ex) { MessageBox.Show("Please Fill Up The Cells Thank You"); } last: { } }
private void button3_Click(object sender, EventArgs e) { try { DataClasses1DataContext db = new DataClasses1DataContext(); int id = int.Parse(textBox1.Text); Daily_consumption dd = db.Daily_consumptions.SingleOrDefault(x => x.Serial_No == id); if (dd != null) { textBox2.Text = Convert.ToString(dd.Serial_No); description.Text = dd.Description; ammount.Text = dd.Ammount.ToString(); dateTimePicker1.Text = dd.Dates.ToString(); } else { MessageBox.Show("data not found"); } } catch (Exception ex) { MessageBox.Show("Please Select The Id Then Edit In the textbox Thank You"); } }
partial void DeleteDaily_consumption(Daily_consumption instance);
partial void UpdateDaily_consumption(Daily_consumption instance);
partial void InsertDaily_consumption(Daily_consumption instance);