private void btnThem_Click(object sender, EventArgs e) { if (KiemTraHopLeVaThongBao(0,cbDoanTau.SelectedValue as string,tbTenLichTrinh.Text,dtNgayKhoiHanh.Value, dtNgayDenNoi.Value,true,null )) { var lichTrinh = new LichTrinh { TenLichTrinh = tbTenLichTrinh.Text, DoanTauId = cbDoanTau.SelectedValue as string, GioChay = dtNgayKhoiHanh.Value, GioDen = dtNgayDenNoi.Value, LichTrinhMau = false, TrangThai = 1 }; if (LichTrinhDal.Them(lichTrinh) > 0) { if (chkThemChiTiet.Checked) { var listTuyenDuong = LichTrinhTuyenDuongDal.LayLichTrinh((int) cbLichTrinhMau.SelectedValue); LichTrinhTuyenDuongDal.CapNhatLichTrinhTuyenDuong(lichTrinh.Id, listTuyenDuong); } MessageBox.Show(Resources.TaoDoiTuong + Resources.thanhCong, Resources.MThanhCong); CapNhatGv(); } else { MessageBox.Show(Resources.TaoDoiTuong + Resources.thatBai, Resources.MThatBai); } } }
public static int CapNhat(LichTrinh obj) { using (var context = new VeTauEntities(false)) { var tarGetObject = context.LichTrinhs.SingleOrDefault(i => i.Id == obj.Id); if (tarGetObject != null) { tarGetObject.LichTrinhMau = obj.LichTrinhMau; tarGetObject.DoanTauId = obj.DoanTauId; tarGetObject.GioDen = obj.GioDen; tarGetObject.GioChay = obj.GioChay; tarGetObject.TenLichTrinh = obj.TenLichTrinh; tarGetObject.TrangThai = obj.TrangThai; } return context.SaveChanges(); } }
public static int Them(LichTrinh ojb) { using (var context = new VeTauEntities(false)) { context.LichTrinhs.Add(ojb); context.SaveChanges(); return ojb.Id; } }
private void btGridSave_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { var id = (int)gridView.GetFocusedRowCellValue("Id"); var doanTauId = (string)gridView.GetFocusedRowCellValue("DoanTauId"); var gioChay = (DateTime)gridView.GetFocusedRowCellValue("GioChay"); var gioDen = (DateTime)gridView.GetFocusedRowCellValue("GioDen"); var tenLichTrinh = (string)gridView.GetFocusedRowCellValue("TenLichTrinh"); var trangThai = (int)gridView.GetFocusedRowCellValue("TrangThai"); if (KiemTraHopLeVaThongBao(id,doanTauId, tenLichTrinh, gioChay, gioDen, false,trangThai)) { var obj = new LichTrinh { Id = id, DoanTauId = doanTauId, GioDen = gioDen, GioChay = gioChay, TenLichTrinh = tenLichTrinh, TrangThai = trangThai, LichTrinhMau = false }; if (LichTrinhDal.CapNhat(obj) > 0) { MessageBox.Show(Resources.LuuDoiTuong + Resources.thanhCong, Resources.MThanhCong); CapNhatGv(); } else { MessageBox.Show(Resources.LuuDoiTuong + Resources.thatBai, Resources.MThatBai); } } }
public static bool CapNhatLichTrinhTuyenDuongMau(string doanTauId, string tenLichTrinh, List<LichTrinhTuyenDuongModelcs> listTuyenDuong) { LichTrinh lichTrinh = new LichTrinh() { DoanTauId = doanTauId, GioChay = DateTime.Now, GioDen = DateTime.Now, LichTrinhMau = true, TenLichTrinh = tenLichTrinh, TrangThai = 1, }; var id = LichTrinhDal.Them(lichTrinh); listTuyenDuong.ForEach(i => i.Id = 0); return CapNhatLichTrinhTuyenDuong(id, listTuyenDuong); }