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++;
}
}
