private void bunifuFlatButton1_Click(object sender, EventArgs e) { if (check()) { var temp = comboboxDoDoc.Text; Dictionary <string, string> d; using (QLNTEntities1 db = new QLNTEntities1()) { d = ( from z in db.DoDoc select new { z.MaDoc, z.MucDoDoc } ).ToDictionary(z => z.MaDoc, z => z.MucDoDoc); } var kq = d.Keys.ToString(); foreach (var k in d) { if (k.Value.ToString() == temp.ToString()) { kq = k.Key.ToString(); break; } } o = new ThuocBaoVeTV() { MaThuoc = this.id, TenThuoc = textTenThuoc.Text, Dang = comboboxDang.Text, SoLuong = Convert.ToInt32(textSoLuong.Text), ThoiGianCachLy = Convert.ToInt32(textThoiGianCachLy.Text), NoiSX = textNoiSX.Text, CongDung = textCongDung.Text, NgaySX = DatepickerSX.Value.Date, HanSD = DatepickerHSD.Value.Date, MaDoc = kq }; bus.Edit(o); MessageBox.Show("Sửa thành công"); Dialog_close(); } }
private void button_add_Click(object sender, EventArgs e) { if (check()) { var temp = comboboxDoDoc.Text; Dictionary <string, string> d; using (QLNTEntities1 db = new QLNTEntities1()) { d = ( from z in db.DoDoc select new { z.MaDoc, z.MucDoDoc } ).ToDictionary(z => z.MaDoc, z => z.MucDoDoc); } var kq = d.Keys.ToString(); foreach (var k in d) { if (k.Value.ToString() == temp.ToString()) { kq = k.Key.ToString(); break; } } o = new ThuocBaoVeTV() { TenThuoc = textTenThuoc.Text, Dang = comboboxDang.Text, SoLuong = Convert.ToInt32(textSoLuong.Text), ThoiGianCachLy = Convert.ToInt32(textThoiGianCachLy.Text), NoiSX = textNoiSX.Text, CongDung = textCongDung.Text, NgaySX = DatepickerSX.Value.Date, HanSD = DatepickerHSD.Value.Date, MaDoc = kq }; bus.Add(o); MessageBox.Show("Thêm thành công"); Dialog_close(); } #region kt //string t="Tên phân bón : {0} \n Loại: {1} \n Ngày sx: {2} \n hạn sử dụng: {3}"; //string msg = string.Format(t,o.TenPB,o.Loai,o.NgaySX.ToString("dd//MM/yyyy"), o.HanSD.ToString("dd//MM/yyyy")); //MessageBox.Show(msg); //DatepickerSX.Value.ToString("dd/MM/yyyy") //MessageBox.Show(textTenPB.Text+" " + comboBoxLoai.Text ); //MessageBox.Show("thành công"); #endregion }
public Diablog_TBV(string id) { InitializeComponent(); border(); ThuocBaoVeTVDB db = new ThuocBaoVeTVDB(); List <string> l = new List <string>() { "Dung dịch", "Hạt", "Bột", "Viên", "Nhũ dầu", "Huyền phù", "Thuốc phun bột" }; comboboxDang.DataSource = l; Dictionary <string, string> dic; using (QLNTEntities1 db1 = new QLNTEntities1()) { dic = ( from c in db1.DoDoc select new { c.MaDoc, c.MucDoDoc } ).ToDictionary(c => c.MaDoc, c => c.MucDoDoc); } comboboxDoDoc.DataSource = dic.Values.ToList(); #region gắn giá trị this.id = Convert.ToInt32(id); o = db.GetThuocBaoVeTV(id); textTenThuoc.Text = o.TenThuoc; textThoiGianCachLy.Text = o.ThoiGianCachLy.ToString(); textNoiSX.Text = o.NoiSX; comboboxDang.Text = o.Dang; textSoLuong.Text = o.SoLuong.ToString(); textCongDung.Text = o.CongDung; DatepickerSX.Value = o.NgaySX; DatepickerSX.Value.ToString("dd/MM/yyyy"); DatepickerHSD.Value = o.HanSD; DatepickerHSD.Value.ToString("dd/MM/yyyy"); var temp = o.MaDoc; Dictionary <string, string> d; using (QLNTEntities1 db1 = new QLNTEntities1()) { d = ( from z in db1.DoDoc select new { z.MaDoc, z.MucDoDoc } ).ToDictionary(z => z.MaDoc, z => z.MucDoDoc); } var kq = d.Values.ToString(); foreach (var k in d) { if (k.Key.ToString() == temp.ToString()) { kq = k.Value.ToString(); break; } } comboboxDoDoc.Text = kq; #endregion // An button add button_add.Enabled = false; button_add.Visible = false; //Hien button luu button_luu.Visible = true; //button_luu.Enabled = false; }
public void Edit(ThuocBaoVeTV o) { ThuocBaoVeTVDB db = new ThuocBaoVeTVDB(); db.Edit(o); }
public void Add(ThuocBaoVeTV o) { ThuocBaoVeTVDB db = new ThuocBaoVeTVDB(); db.Add(o); }