public PhongHoc AddClassRoom(PhongHoc phongHoc) { db = new GDUDataConnectionsDataContext(); db.PhongHocs.InsertOnSubmit(phongHoc); db.SubmitChanges(); return(phongHoc); }
private void btnLuu_Click(object sender, EventArgs e) { try { PhongHoc p = new PhongHoc(); if (!string.IsNullOrEmpty(txtMaPhong.Text)) { p.MaPhong = txtMaPhong.Text; } else { MsgboxUtil.Exclamation("Mã phòng không được rỗng"); return; } if (!string.IsNullOrEmpty(txtChucNang.Text)) { p.ChucNang = txtChucNang.Text; } if (!string.IsNullOrEmpty(txtDiaChi.Text)) { p.DiaChi = txtDiaChi.Text; } p.SucChua = (int)numSucChua.Value; PhongHocBUS.Them(p); StaticClass.LuuThayDoi(); StaticClass.Log.GhiFile("Thêm mới phòng học: " + p.MaPhong); MsgboxUtil.Success("Thành công!"); ClearText(); } catch (Exception ex) { ExceptionUtil.ThrowMsgBox(ex.Message); } }
public JsonResult Delete(int id) { PhongHoc obj = db.PhongHocs.Find(id); obj.Active = false; return(Json(db.SaveChanges())); }
private void btnLuu_Click(object sender, EventArgs e) { if (!txtMaPH.Text.Trim().Equals("")) { if (them) { try { XepThoiKhoaBieuDataContext dbs = new XepThoiKhoaBieuDataContext(); PhongHoc gv = new PhongHoc(); gv.MaPH = Convert.ToInt32(txtMaPH.Text); gv.TenPH = txtTenPH.Text; gv.DungLuong = Convert.ToInt32(txtDungLuong.Text); dbs.PhongHocs.InsertOnSubmit(gv); dbs.SubmitChanges(); LoadData(); MessageBox.Show("Đã thêm Xong"); } catch (Exception) { MessageBox.Show("Không thêm được!!", "lỗi rồi!"); } } else { try { // Thứ tự dòng hiện hành int r = dgvPhongHoc.CurrentCell.RowIndex; // MaKH hiện hành string Ma = dgvPhongHoc.Rows[r].Cells[0].Value.ToString(); // Câu lệnh SQL XepThoiKhoaBieuDataContext dbs = new XepThoiKhoaBieuDataContext(); var gv = (from gv1 in dbs.PhongHocs where gv1.MaPH.ToString() == Ma select gv1).SingleOrDefault(); if (gv != null) { gv.TenPH = txtTenPH.Text; gv.DungLuong = Convert.ToInt32(txtDungLuong.Text); dbs.SubmitChanges(); LoadData(); } LoadData(); MessageBox.Show("Đã sửa xong"); } catch (Exception) { MessageBox.Show("Không sửa được", "lỗi rồi!!"); } } } else { MessageBox.Show("Phòng chưa có.Lỗi rồi!!"); txtMaPH.Focus(); } LoadData(); }
public PhongHoc GetPhongHocByMaPhongHoc(string maPhongHoc) { db = new GDUDataConnectionsDataContext(); PhongHoc ph = new PhongHoc(); ph = db.PhongHocs.Single(p => p.MaPhongHoc == maPhongHoc); return(ph); }
public void DeleteClassRoom(string maPH) { db = new GDUDataConnectionsDataContext(); PhongHoc ph = new PhongHoc(); ph = db.PhongHocs.Single(x => x.MaPhongHoc == maPH); db.PhongHocs.DeleteOnSubmit(ph); db.SubmitChanges(); }
public void UpdateClassRoom(PhongHoc phongHoc) { db = new GDUDataConnectionsDataContext(); PhongHoc ph = new PhongHoc(); ph = db.PhongHocs.Single(p => p.MaPhongHoc == phongHoc.MaPhongHoc); ph.GhiChu = phongHoc.GhiChu; db.SubmitChanges(); }
public static void Them(PhongHoc p) { try { db.PhongHocs.InsertOnSubmit(p); } catch (Exception ex) { throw ex; } }
private void btnUpdateRoom_Click(object sender, EventArgs e) { PhongHoc ph = new PhongHoc(); ph.MaPhongHoc = txtPhongHoc.Text.Trim(); ph.GhiChu = txtNote.Text.Trim(); phongHocService.UpdateClassRoom(ph); LoadDanhSachPhongHocToDgv(); btnSaveRoom.Enabled = false; btnUpdateRoom.Enabled = true; btnDeleteRoom.Enabled = true; }
public ActionResult Edit(PhongHoc obj) { if (obj.IDPhongHoc > 0) { db.Entry(obj).State = EntityState.Modified; } else { db.PhongHocs.Add(obj); } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(int?id) { PhongHoc obj = new PhongHoc(); if (id.HasValue) { obj = db.PhongHocs.Find(id); } if (obj == null) { return(HttpNotFound()); } return(View(obj)); }
private void btnSua_Click(object sender, EventArgs e) { _objphonghoc = new PhongHoc(dgvDSPhongHoc.CurrentRow.Cells[0].Value.ToString(), txtPhong.Text, txtDiaDiem.Text); if (_objphonghocbus.EditPhongHoc(_objphonghoc)) { MessageBox.Show("Cập nhật thành công ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadData(); txtDiaDiem.Text = ""; txtPhong.Text = ""; } else { MessageBox.Show("Cập Nhật thất bại", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnSaveRoom_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtPhongHoc.Text)) { MessageBox.Show("Chưa nhập phòng học...", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtPhongHoc.Focus(); } else { PhongHoc ph = new PhongHoc(); ph.MaPhongHoc = txtPhongHoc.Text.Trim(); ph.GhiChu = txtNote.Text.Trim(); phongHocService.AddClassRoom(ph); LoadDanhSachPhongHocToDgv(); btnSaveRoom.Enabled = false; btnUpdateRoom.Enabled = true; btnDeleteRoom.Enabled = true; } }
private void btnLuu_Click(object sender, EventArgs e) { if (dgvDSPhongHoc.Rows.Count > 0) { for (int i = 0; i < dgvDSPhongHoc.Rows.Count; i++) { string maphong, tenphong, diadiem; maphong = _objphonghocbus.NextID(); tenphong = dgvDSPhongHoc.Rows[i].Cells[1].Value.ToString(); diadiem = dgvDSPhongHoc.Rows[i].Cells[2].Value.ToString(); _objphonghoc = new PhongHoc(maphong, tenphong, diadiem); if (_objphonghocbus.AddPhongHoc(_objphonghoc)) { dgvDSPhongHoc.Rows.Remove(dgvDSPhongHoc.Rows[i]); i--; LoadData(); } else { string a = dgvDSPhongHoc.Rows[i].Cells[0].Value.ToString(); MessageBox.Show("Lưu dòng " + a + " thất bại"); } } if (dgvDSPhongHoc.Rows.Count == 0) { MessageBox.Show("Lưu thành công"); } reset(); } else { MessageBox.Show("Không có dữ liệu để lưu ! ", "Thống báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool EditPhongHoc(PhongHoc objphonghoc) { try { if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand cmd = new SqlCommand("PhongHoc_Edit", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MaPhong", SqlDbType.VarChar).Value = objphonghoc._maphong; cmd.Parameters.Add("@TenPhong", SqlDbType.NVarChar).Value = objphonghoc._tenphong; cmd.Parameters.Add("@DiaDiem", SqlDbType.NVarChar).Value = objphonghoc._diadiem; cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); Console.WriteLine(e); return(false); } }
public bool AddPhongHoc(PhongHoc ph) { return(objPhongHoc.AddPhongHoc(ph)); }
public bool EditPhongHoc(PhongHoc ph) { return(objPhongHoc.EditPhongHoc(ph)); }
public PhongHoc AddClassRoom(PhongHoc phongHoc) { return(phongHocIdao.AddClassRoom(phongHoc)); }
public int CapNhatThongTinPhong(PhongHoc P) { return(1); }
public void UpdateClassRoom(PhongHoc phongHoc) { phongHocIdao.UpdateClassRoom(phongHoc); }
/// <summary> /// delete PhongHoc /// </summary> /// <param name="entity">PhongHoc</param> public void Delete(PhongHoc entity) { _PhongHocRepository.Delete(entity); }
/// <summary> /// add PhongHoc /// </summary> /// <param name="entity">PhongHoc</param> public void Insert(PhongHoc entity) { _PhongHocRepository.Insert(entity); }
/// <summary> /// set PhongHoc to unactive /// </summary> /// <param name="entity">PhongHoc</param> public void FakeDelete(PhongHoc entity) { _PhongHocRepository.FakeDelete(entity); }
public int ThemPhong(PhongHoc P) { return(1); }
/// <summary> /// update PhongHoc /// </summary> /// <param name="entity">PhongHoc</param> public void Update(PhongHoc entity) { _PhongHocRepository.Update(entity); }
public XepThoiKhoaBieu() { XepThoiKhoaBieuDataContext xl = new XepThoiKhoaBieuDataContext(); List <GiaoVien> GV = new List <GiaoVien>(); List <MonHoc> MH = new List <MonHoc>(); List <Lop> LOP = new List <Lop>(); List <PhongHoc> PHONG = new List <PhongHoc>(); gvmonhoc = new List <Gv_MonHoc>(); lopphong = new List <Lop_Phong>(); int g; int m; int l; int p; var gvien = from d in xl.GiaoViens select d; var mhoc = from d in xl.MonHocs select d; var lop = from d in xl.Lops select d; var phong = from d in xl.PhongHocs select d; foreach (var b in gvien) { g = 0; GiaoVien gv = new GiaoVien(); gv.MaGV = b.MaGV; gv.TenGV = b.TenGV; gv.MaBM = b.MaBM; GV.Add(gv); g++; } foreach (var b in mhoc) { m = 0; MonHoc mh = new MonHoc(); mh.MaMH = b.MaMH; mh.TenMH = b.TenMH; mh.MaBM = b.MaBM; MH.Add(mh); m++; } foreach (var b in lop) { l = 0; Lop lo = new Lop(); lo.MaLop = b.MaLop; lo.TenLop = b.TenLop; LOP.Add(lo); l++; } foreach (var b in phong) { p = 0; PhongHoc ph = new PhongHoc(); ph.MaPH = b.MaPH; ph.TenPH = b.TenPH; PHONG.Add(ph); p++; } }