//
// GET: /LopHoc/
public ActionResult DanhSach()
{
string username = Session["Username"] == null ? "" : Session["Username"].ToString();
List <LopHoc> l_LopHoc = new LopHoc().GetList("", 0, "1", 0, username);
List <MonHoc> l_MonHoc = new MonHoc().GetList();
ViewModels vm = new ViewModels();
vm.l_LopHoc = l_LopHoc;
vm.l_MonHoc = l_MonHoc;
return(View(vm));
}
public static void Them(MonHoc mh)
{
try
{
db.MonHocs.InsertOnSubmit(mh);
}
catch (Exception ex)
{
throw ex;
}
}
public int SuaMonHoc(MonHoc monhoc)
{
try
{
return(_monhocDAO.SuaMocHoc(monhoc));
}
catch (Exception)
{
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MonHoc mon = (MonHoc)Session["monhoc"];
txtMaMon.Text = mon.id + "";
txtTenMon.Text = mon.name;
txtSoTinChi.Text = mon.sotinchi + "";
txtMoTa.Text = mon.description;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string MaMH = "";
if (Request.QueryString["MaSV"] != null)
{
MaMH = Request.QueryString["MaSV"];
}
MonHoc.DelMon(Convert.ToInt32(MaMH));
Response.Redirect("CourseManagement.aspx");
}
public MonHoc ThongTinMonHoc(int MaMon)
{
string query = @"select * MonHoc where MaMon = @mamon";
DataTable dt = DataProvider.Instance.ExcuteQuery(query, new object[] { MaMon });
MonHoc monHoc = new MonHoc();
monHoc.MaMonHoc = int.Parse(dt.Rows[0][0].ToString());
monHoc.TenMon = dt.Rows[0][1].ToString();
monHoc.SoTiet = int.Parse(dt.Rows[0][2].ToString());
return(monHoc);
}
public int ThemMonHoc(MonHoc monhoc)
{
try
{
return(_monhocDAO.ThemMonHoc(monhoc));
}
catch (Exception ex)
{
throw ex;
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (curClass != null)
{
//db.LopHocs.Where(lh => lh.Ma == curClass.Ma).FirstOrDefault();
db.MonHocs.Remove(curClass);
db.SaveChanges();
curClass = null;
BoundDataSource();
}
}
public ActionResult DanhSachDeThi(int id) // truyền vào mã môn học
{
using (ELearningDB db = new ELearningDB())
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
MonHoc mh = db.MonHocs.Find(id);
ViewBag.MaMonHoc = id;
ViewBag.TenMon = mh.TenMonHoc;
return(View());
}
}
public ActionResult Create([Bind(Include = "MaMH,TenMH")] MonHoc monHoc)
{
if (ModelState.IsValid)
{
db.MonHocs.Add(monHoc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(monHoc));
}
public async Task <IActionResult> Create([Bind("Mamon,Tenmon,Sotinhi")] MonHoc monHoc)
{
if (ModelState.IsValid)
{
_context.Add(monHoc);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(monHoc));
}
public int SuaMH(MonHoc MH)
{
try
{
return(new MonHocDao().SuaMH(MH));
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult GetMonHoc(int id)
{
MonHoc monHoc = db.MonHocs.Find(id);
if (monHoc == null)
{
return(NotFound());
}
return(Ok(monHoc));
}
public void XoaMonHoc(List <string> mamh)
{
QLTTDayThem db = new QLTTDayThem();
for (int i = 0; i < mamh.Count; i++)
{
MonHoc mh = db.MonHocs.Find(mamh[i]);
db.MonHocs.Remove(mh);
db.SaveChanges();
}
}
public Form1()
{
InitializeComponent();
mh = MonHoc.GetListFromDB();
foreach (MonHoc s in mh)
{
cmbMonhoc.Items.Add(s.tenmh);
}
cmbMonhoc.SelectedIndex = 0;
Load1();
}
public async Task <IActionResult> Create([Bind("MaMon,TenMon,SoTinChi,MaKhoa")] MonHoc monHoc)
{
if (ModelState.IsValid)
{
_context.Add(monHoc);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MaKhoa"] = new SelectList(_context.Khoas, "MaKhoa", "TenKhoa", monHoc.MaKhoa);
return(View(monHoc));
}
public async Task <string> InsertLesson(MonHoc lesson)
{
try
{
db.MonHocs.Add(lesson);
await db.SaveChangesAsync();
}
catch (Exception ex)
{
}
return("");
}
protected void btnEdit_Click(object sender, EventArgs e)
{
string MaMH = "";
if (Request.QueryString["MaMH"] != null)
{
MaMH = Request.QueryString["MaMH"];
}
MonHoc.MonHoc_Update(txtTenKhoa.Text, Convert.ToInt32(txtTinChi.Text), Convert.ToInt32(MaMH));
Response.Redirect("Coursemanagement.aspx");
Response.Write("<script>alert('Sửa thành công')</script>");
}
public List <MonHoc> getListMonHoc()
{
DataTable data = MonHocDAO.Instance.getListMonHoc();
List <MonHoc> list = new List <MonHoc>();
foreach (DataRow item in data.Rows)
{
MonHoc monHoc = new MonHoc(item);
list.Add(monHoc);
}
return(list);
}
public int Update(MonHoc h)
{
if (checkmaMonHoc_ID(h.Mamonhoc) != 0)
{
h.Tenmonhoc = Tools.ChuanHoaXau(h.Tenmonhoc);
return(dal.Update(h));
}
else
{
return(-1);
}
}
public MonHoc Update(MonHoc monhoc)
{
var exting = monHocrepository.GetById(monhoc.MonhocId);
if (exting != null)
{
exting.TenMonHoc = monhoc.TenMonHoc;
exting.Sotinchi = monhoc.Sotinchi;
monHocrepository.Update(exting);
}
return(null);
}
public DataTable hienthiDSDiemMH_Lop(NamHoc n, HocKy h, MonHoc m, Lop l)
{
string a = "exec hienthidsDiemMHLOP N'" + n.TenNH + "', N'" + h.TenHK + "', N'" + m.tenMH + "', N'" + l.TenLop + "'";
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(a, conn);
DataTable dt = new DataTable();
da.Fill(dt);// đổ dữ liệu từ sql vào
conn.Close();
return(dt);
}
public void addMonHoc(MonHoc mon)
{
conn.Open();
String sql = "insert into MonHoc values(@name, @description, @sotinchi)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@name", mon.name);
cmd.Parameters.AddWithValue("@description", mon.description);
cmd.Parameters.AddWithValue("@sotinchi", mon.sotinchi);
cmd.ExecuteNonQuery();
conn.Close();
}
private void dgvContent_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex >= dgvContent.RowCount)
{
return;
}
var classId = int.Parse(dgvContent.Rows[e.RowIndex].Cells[0].Value.ToString());
curClass = db.MonHocs.Where(mtt => mtt.Ma == classId).FirstOrDefault();
tbTMH.Text = curClass.Ten.ToString();
tbSLGV.Text = curClass.SoLuongGiaoVien.ToString();
}
public bool AddMonHoc(MonHoc monHoc)
{
try
{
_context.Set <MonHoc>().Add(monHoc);
return(true);
}
catch (Exception)
{
return(false);
}
}
public async Task <MonHoc> CheckMonHoc(MonHoc monHoc)
{
var path = base_url + "/mon-hocs/check";
var json = JsonConvert.SerializeObject(monHoc);
var data = new StringContent(json, Encoding.UTF8, "application/json");
var response = await client.PostAsync(path, data);
string result = response.Content.ReadAsStringAsync().Result;
JObject jObject = JObject.Parse(result);
return(jObject.ToObject <MonHoc>());
}
public int Insert(MonHoc h)
{
if (checkmaMonHoc_ID(h.Mamonhoc) == 0)
{
h.Tenmonhoc = Tools.ChuanHoaXau(h.Tenmonhoc);
return(dal.Insert(h));
}
else
{
return(-1);
}
}
public async Task <List <Lessons.Lesson> > TestLesson(string id)
{
urlConnect = urlAddress + "/GetCourses?lecturerID={0}";
urlConnect = string.Format(urlConnect, id);
data = Url(urlConnect);
if (data != "")
{
//parse data json
var coure = new List <Lessons.Lesson>();
//get data json type array
Lessons Courses = JsonConvert.DeserializeObject <Lessons>(data);
foreach (var item in Courses.data)
{
coure.Add(item);
if (da.checkLesson(UPPER(item.Name)) > 0)
{
continue;
}
else
{
MonHoc mh = new MonHoc();
mh.MaMH = UPPER(item.Name);
mh.TenMH = item.Name;
await da.InsertLesson(mh);
}
}
foreach (var item in Courses.data)
{
if (da.checkCourse(item.Id) > 0)
{
continue;
}
else
{
KhoaHoc cr = new KhoaHoc();
cr.Ma = id;
cr.MaKH = item.Id;
cr.TenKH = item.Name;
cr.MaMH = UPPER(item.Name);
await da.InsertCourse(cr);
}
}
return(coure);
}
return(null);
}
public MonHoc TimMonHoc(string maMonHoc)
{
string query = "select * from MonHoc where maMonHoc = '" + maMonHoc + "';";
DataTable dt = DataProvider.Instance.ExcuteQuery(query);
MonHoc mh = null;
if (dt.Rows.Count > 0)
{
mh = new MonHoc(dt.Rows[0]["maMonHoc"] + "", dt.Rows[0]["tenMonHoc"] + "");
}
return(mh);
}
private void LoadThongTinMonHoc(int MaMH)
{
DataTable data = MonHoc.LoadMHByMa(MaMH);
if (data.Rows.Count > 0)
{
txtMaMon.ReadOnly = true;
txtMaMon.Text = data.Rows[0]["iMaMon"].ToString();
txtTenKhoa.Text = data.Rows[0]["sTenSV"].ToString();
txtTinChi.Text = data.Rows[0]["sLop"].ToString();
}
}
public void AddToMonHocs(MonHoc monHoc)
{
base.AddObject("MonHocs", monHoc);
}
public static MonHoc CreateMonHoc(int maMonHoc)
{
MonHoc monHoc = new MonHoc();
monHoc.MaMonHoc = maMonHoc;
return monHoc;
}
