public bool ThemLop(string MaLop, string TenLop, string MaKhoa, ref string err)
{
QLSVDataContext qlSV = new QLSVDataContext();
Lop kh = new Lop();
kh.maLop = MaLop;
kh.tenLop = TenLop;
kh.maKhoa = MaKhoa;
qlSV.Lops.InsertOnSubmit(kh);
qlSV.Lops.Context.SubmitChanges();
return(true);
}
public ActionResult ThemLop(Lop LOP, HttpPostedFileBase fileupload)
{
Lop lop = db.Lops.SingleOrDefault(n => n.MaLop == LOP.MaLop);
// Lưu vào CSDL
if (ModelState.IsValid)
{
db.Lops.InsertOnSubmit(LOP);
db.SubmitChanges();
}
return(RedirectToAction("Class"));
}
public ActionResult SuaLop(string malop)
{
if (Session["ID"] == null || Session["ID"].ToString() == " ")
{
return(Redirect("/Home/Login"));
}
ViewBag.Ma_GV = new SelectList(db.GiaoViens.ToList().OrderBy(n => n.MaGiaoVien), "MaGiaoVien", "MaGiaoVien");
Lop lop = db.Lops.SingleOrDefault(n => n.MaLop == malop);
return(View(lop));
}
public IHttpActionResult PostLop(Lop lop)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Lops.Add(lop);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = lop.Id }, lop));
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (dataGridViewX1.Rows.Count > 0)
{
for (int i = 0; i < dataGridViewX1.Rows.Count; i++)
{
string makhoa, machuongtrinhhoc, magv, maphonghoc, mangayhoc, maca;
makhoa = new KhoaHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[2].Value.ToString());
machuongtrinhhoc = new ChuongTrinhHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[3].Value.ToString());
magv = new GiangVienBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[10].Value.ToString());
maphonghoc = new PhongHocBUS().GetMa_TheoTen_PhongHoc(dataGridViewX1.Rows[i].Cells[11].Value.ToString());
mangayhoc = new NgayHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[6].Value.ToString());
maca = new CaHocBUS().GetMa_TheoTen(dataGridViewX1.Rows[i].Cells[7].Value.ToString());
_objlop = new Lop(
_objlopbus.Lop_NextID(),
dataGridViewX1.Rows[i].Cells[1].Value.ToString(),
makhoa,
machuongtrinhhoc,
DateTime.Parse(dataGridViewX1.Rows[i].Cells[4].Value.ToString()),
DateTime.Parse(dataGridViewX1.Rows[i].Cells[5].Value.ToString()),
maca,
mangayhoc,
magv,
maphonghoc);
if (_objlopbus.AddLop(_objlop))
{
dataGridViewX1.Rows.Remove(dataGridViewX1.Rows[i]);
i--;
LoadData();
}
else
{
string a = dataGridViewX1.Rows[i].Cells[0].Value.ToString();
MessageBox.Show("Lưu dòng " + a + " thất bại");
}
}
if (dataGridViewX1.Rows.Count == 0)
{
MessageBox.Show("Lưu thành công");
}
dtipNgayBatDau.Text = "";
dtipNgayKetThuc.Text = "";
}
else
{
MessageBox.Show("Không có dữ liệu để lưu ! ", "Thống báo ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool Insert(Lop Lop)
{
try
{
db.Lops.Add(Lop);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public ActionResult SuaLop(string id)
{
//Lay ra doi tuong sach theo ma
Lop l = data.Lops.SingleOrDefault(n => n.MaLop.Equals(id));
if (l == null)
{
Response.StatusCode = 404;
return(null);
}
ViewBag.MaLop = l.MaLop;
return(View(l));
}
public async Task <Lop> GetLop(Lop lop)
{
var path = base_url + $"/lops?hocKy={lop.hocKy.id}&ten={lop.ten}";
List <Lop> lops = new List <Lop>();
HttpResponseMessage response = await client.GetAsync(path);
if (response.IsSuccessStatusCode)
{
lops = await response.Content.ReadAsAsync <List <Lop> >();
}
return(lops.Count > 0 ? lops[0] : null);
}
public async Task <JsonResult> SuaLop([FromBody] Lop lopUpDate)
{
var rs = await lop.SuaLop(lopUpDate);
if (rs == 0)
{
return(new JsonResult(new ThongBao(1, "Không thể sửa lớp")));
}
else
{
return(new JsonResult(new ThongBao(0, "Sửa lớp thành công")));
}
}
public async Task <JsonResult> ThemMoiLop([FromBody] Lop lopInsert)
{
var rs = await lop.ThemMoiLop(lopInsert);
if (rs == 0)
{
return(new JsonResult(new ThongBao(1, "Thêm mới không thành công")));
}
else
{
return(new JsonResult(new ThongBao(0, "thêm mới thành công")));
}
}
public ActionResult XoaLop(int id)
{
//Lấy ra đối tượng sách cần xóa theo mã
Lop lop = db.Lops.SingleOrDefault(n => n.MaLop == id);
ViewBag.MaLop = lop.MaLop;
if (lop == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(lop));
}
public ActionResult Create([Bind(Include = "Id,NameCN,ChuyenNganhId,HeDaoTaoId,NienKhoaId,SS")] Lop lop)
{
if (ModelState.IsValid)
{
db.Lops.Add(lop);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ChuyenNganhId = new SelectList(db.ChuyenNganhs, "Id", "NameCN");
ViewBag.HeDaoTaoId = new SelectList(db.HeDaoTaos, "Id", "Name");
ViewBag.NienKhoaId = new SelectList(db.NienKhoas, "Id", "Name");
return(View(lop));
}
public ActionResult Edit([Bind(Include = "MaLop,TenLop,MaKhoa,MaHeDaoTao,MaKhoaHoc")] Lop lop)
{
if (ModelState.IsValid)
{
db.Entry(lop).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHeDaoTao = new SelectList(db.HeDaoTaos, "MaHeDaoTao", "TenHeDaoTao", lop.MaHeDaoTao);
ViewBag.MaKhoaHoc = new SelectList(db.KhoaHocs, "MaKhoaHoc", "TenKhoaHoc", lop.MaKhoaHoc);
ViewBag.MaKhoa = new SelectList(db.Khoas, "MaKhoa", "TenKhoa", lop.MaKhoa);
return(View(lop));
}
//ham them lop
public bool ThemLop(Lop lop)
{
string sql = "insert into Lop(maLop, tenLop, maLT, maGVCN)" + "values (@maLop, @tenLop, @maLT, @maGVCN)";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maLop", lop.maLop),
new SqlParameter("@tenLop", lop.tenLop),
new SqlParameter("@maLT", lop.maLT),
new SqlParameter("@maGVCN", lop.maGVCN)
};
return(dal.myExecute(sql, sqlParameters));
}
private void gridLop_DoubleClick(object sender, EventArgs e)
{
btnCapNhat.Enabled = true;
btnXoa.Enabled = true;
ColumnView view = gridLop.MainView as ColumnView;
int index = view.GetSelectedRows()[0];
Lop lop = lops[index];
txtTen.Text = lop.ten; cbxChuyenNganh.Text = lop.chuyenNganh;
txtKhoa.Text = lop.khoa.ToString(); txtQuanSo.Text = lop.quanSo.ToString();
txtGiangDuong.Text = lop.giangDuong.ToString();
txtTieuDoan.Text = lop.tieuDoan;
}
public ActionResult Edit([Bind(Include = "Id,NameCN,,ChuyenNganhId,HeDaoTaoId,NienKhoaId,SS")] Lop lop)
{
if (ModelState.IsValid)
{
db.Entry(lop).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ChuyenNganhId = new SelectList(db.ChuyenNganhs, "Id", "NameCN");
ViewBag.HeDaoTaoId = new SelectList(db.HeDaoTaos, "Id", "Name");
ViewBag.NienKhoaId = new SelectList(db.NienKhoas, "Id", "Name");
return(View(lop));
}
public bool Add(Lop item)
{
try
{
db.Lops.Add(item);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//ham sua lop
public bool SuaLop(Lop lop)
{
string sql = "Update Lop set tenLop = @tenLop, maLT = @maLT, maGVCN = @maGVCN where maLop = @maLop";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maLop", lop.maLop),
new SqlParameter("@tenLop", lop.tenLop),
new SqlParameter("@maLT", lop.maLT),
new SqlParameter("@maGVCN", lop.maGVCN)
};
return(dal.myExecute(sql, sqlParameters));
}
public IHttpActionResult DeleteLop(int id)
{
Lop lop = db.Lops.Find(id);
if (lop == null)
{
return(NotFound());
}
db.Lops.Remove(lop);
db.SaveChanges();
return(Ok(lop));
}
public void UpdateLop(int ms, Lop lop)
{
Lop lop_update = GetSingleLopById(ms);
if (lop_update != null)
{
lop_update.NameLop = lop.NameLop;
db.SaveChanges();
}
else
{
Console.WriteLine("Khong ton tai lop co ma so " + ms);
}
}
void HienThi(List <HocSinh> dsHS)
{
listViewHocSinh.Items.Clear();
foreach (HocSinh hs in dsHS)
{
ListViewItem item = new ListViewItem(hs.MaHS.ToString());
item.SubItems.Add(hs.HoHS + " " + hs.TenHS);
item.SubItems.Add(hs.NgaySinh.ToString());
if (hs.GioiTinh == true)
{
item.SubItems.Add("Nam");
}
else
{
item.SubItems.Add("Nữ");
}
item.SubItems.Add(hs.QueQuan);
if (hs.TrangThai == true)
{
item.SubItems.Add("Đang đi học");
}
else
{
item.SubItems.Add("Đã nghỉ học hoặc ra trường");
}
Lop lp = db.Lops.SingleOrDefault(x => x.MaLop == hs.MaLop);
if (lp != null)
{
item.SubItems.Add(lp.TenLop);
}
else
{
item.SubItems.Add("null");
}
GiaoVien gv = db.GiaoViens.SingleOrDefault(x => x.MaGV == lp.MaGVCN);
if (gv != null)
{
item.SubItems.Add(gv.HoGV + " " + gv.TenGV);
}
else
{
item.SubItems.Add("null");
}
listViewHocSinh.Items.Add(item);
}
}
public List <Lop> GetLops(string mamonhoc)
{
List <Lop> list = new List <Lop>();
db = new MyDbContext();
var obj = db.Lop.Where(x => x.MaMonHoc == mamonhoc);
foreach (var item in obj)
{
Lop lop = item as Lop;
list.Add(lop);
}
return(list);
}
public async Task <IHttpActionResult> DeleteLop(string id)
{
Lop lop = await db.Lop.FindAsync(id);
if (lop == null)
{
return(NotFound());
}
db.Lop.Remove(lop);
await db.SaveChangesAsync();
return(Ok(lop));
}
public ActionResult Create([Bind(Include = "ID_Lop,MaChuyenNganh,MaHeDaoTao,MaKhoaHoc,TenLop")] Lop lop)
{
if (ModelState.IsValid)
{
db.Lops.Add(lop);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaChuyenNganh = new SelectList(db.ChuyenNganhs, "MaChuyenNganh", "TenChuyenNganh", lop.MaChuyenNganh);
ViewBag.MaHeDaoTao = new SelectList(db.HeDaoTaos, "MaHeDaoTao", "TenHeDaoTao", lop.MaHeDaoTao);
ViewBag.MaKhoaHoc = new SelectList(db.KhoaHocs, "MaKhoaHoc", "NamHoc", lop.MaKhoaHoc);
return(View(lop));
}
public void editLopHoc(Lop lop)
{
conn.Open();
String sql = "update Lop set name = @name, description = @description, id_nganhhoc = @id_nganhhoc" +
" where id = @id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@name", lop.name);
cmd.Parameters.AddWithValue("@description", lop.description);
cmd.Parameters.AddWithValue("@id_nganhhoc", lop.id_nganhhoc);
cmd.Parameters.AddWithValue("@id", lop.id);
cmd.ExecuteNonQuery();
conn.Close();
}
public ActionResult TimSinhVien(string hotentim)
{
SinhVien sv = new SinhVien();
var timkiem = sv.timsinhvien1(hotentim);
//var timkiem = db.Sach.Where(s => ConvertToUnSign(s.tensach).StartsWith(tensach)).ToList();
Lop l = new Lop();
ViewBag.ListLop = l.listlop();
Nganh ngh = new Nganh();
ViewBag.ListNganh = ngh.listnganh();
ViewBag.TimKiem = timkiem;
return(View());
}
private void btnSuaLopHoc_Click(object sender, EventArgs e)
{
try
{
Lop l = new Lop(txtMaLop.Text, txtTenLop.Text, txtNienKhoa.Text, int.Parse(txtSiSo.Text), cbGiaoVien.SelectedValue + "");
bulLop.suaLop(l);
MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception)
{
MessageBox.Show("Sửa thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
// thêm Sinh Viên
public bool Add(Lop info)
{
try
{
db_.Lops.Add(info);
db_.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
return(true);
}
private void dANGKIBODEGridControl_MouseClick(object sender, MouseEventArgs e)
{
DKBD = DangKyBoDe.GetDKBDByMaLop_MaMonHoc(((DataRowView)dANGKIBODEBindingSource.Current)[0].ToString(),
((DataRowView)dANGKIBODEBindingSource.Current)[1].ToString());
LOP lop = Lop.GetLopByMaLop(DKBD.MALOP);
KHOA khoa = Khoa.GetKhoaByMaKhoa(lop.MAKH);
string tenMonHoc = MonHoc.GetTenMonHocByMaMH(DKBD.MAMH);
GIANGVIEN gv = GiangVien.GetGiangVienByMa(DKBD.MAGV);
txtHoTenGV.Text = gv.HO + " " + gv.TEN;
txtMAGV.Text = gv.MAGV;
txtTenKhoa.Text = khoa.TENKH;
txtTenMonHoc.Text = tenMonHoc;
}
// GET: Lop/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Lop lop = db.Lops.Find(id);
if (lop == null)
{
return(HttpNotFound());
}
return(View(lop));
}
private void btnthemlop_Click(object sender, EventArgs e)
{
Lop formLop = new Lop();
formLop.ShowDialog();
}
public void AddToLops(Lop lop)
{
base.AddObject("Lops", lop);
}
public static Lop CreateLop(int maLop)
{
Lop lop = new Lop();
lop.MaLop = maLop;
return lop;
}
