public async Task <IActionResult> Edit(string id, [Bind("Mahp,Tenmon,Siso,Phonghoc,Tiethoc,Thu,Ngaybd,Ngaykt")] HocPhan hocPhan)
{
if (id != hocPhan.Mahp)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(hocPhan);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HocPhanExists(hocPhan.Mahp))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(hocPhan));
}
public async Task <ActionResult <BaseResponse> > PutHocPhan(int id, HocPhan hocPhan)
{
var hocPhanSua = await _context.HocPhans.FindAsync(id);
if (hocPhanSua == null)
{
return(new BaseResponse
{
ErrorCode = 1,
Message = "Không tìm thấy"
});
}
hocPhanSua.DonViQuanLyId = hocPhan.DonViQuanLyId;
hocPhanSua.DonViRaDeId = hocPhan.DonViRaDeId;
hocPhanSua.MaHP = hocPhan.MaHP;
hocPhanSua.SoTinChi = hocPhan.SoTinChi;
hocPhanSua.TenHP = hocPhan.TenHP;
_context.HocPhans.Update(hocPhanSua);
await _context.SaveChangesAsync();
return(new BaseResponse
{
Message = "Cập nhật thành công",
Data = hocPhan
});
}
public async Task <List <HocPhanExtend> > getListUnRegistableAsync()
{
try
{
List <HocPhanExtend> listHocPhan = new List <HocPhanExtend>();
BaseConnector connector = BaseConnector.getInstance();
BaseResponse res = await connector.GetObject(DeployEnvironment.GetEnvironment().GetUnEnrolablePath());
if (res.status)
{
JsonAttributes jsonAttr = JsonAttributeGetter.GetJsonAttributes();
List <Object> listO = JsonGetter.getList(res.obj.ToString(), jsonAttr.RES_RESULT());
for (int i = 0; i < listO.Count; i++)
{
HocPhanExtend hocPhan = new HocPhanExtend()
{
hocPhan = HocPhan.Parse(JsonGetter.getObject(listO[i].ToString(), jsonAttr.RES_SUBJECT())),
lyDo = JsonGetter.getString(listO[i].ToString(), jsonAttr.RES_REASON())
};
listHocPhan.Add(hocPhan);
}
}
return(listHocPhan);
}
catch (Exception ex)
{
LogHelper.Log("ERROR: " + ex);
return(null);
}
}
public async Task <HocPhan> UpdateHocPhan(HocPhan hocPhan)
{
_context.HocPhanContext.Update(hocPhan);
await _context.SaveChangesAsync();
return(hocPhan);
}
public async Task <HocPhan> CreateHocPhan(HocPhan hocPhan)
{
await _context.HocPhanContext.AddAsync(hocPhan);
await _context.SaveChangesAsync();
return(hocPhan);
}
public ActionResult EditHocPhan(HocPhan hocPhan, string Id_MonHoc, int position_hocphan, string id_hocphan)
{
MonHoc monHoc = model.find(Id_MonHoc);
hocPhan.Id = ObjectId.Parse(id_hocphan);
monHoc.DanhSachHocPhan[position_hocphan] = hocPhan;
model.update(monHoc);
return(RedirectToAction(Id_MonHoc, "MonHoc/XemDanhSachHocPhan"));
}
//ham xoa hoc phan
public bool XoaHP(HocPhan hp)
{
string sql = "delete HocPhan where maHP = @maHP";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maHP", hp.maHP)
};
return(dal.myExecute(sql, sqlParameters));
}
private void button9_Click(object sender, EventArgs e)
{
DataDAO dataDAO = new DataDAO();
HocPhan hocPhan = new HocPhan();
hocPhan.Ma_HP = textBox8.Text;
hocPhan.Ten_HP = textBox9.Text;
dataDAO.UpdateHP(textBox8.Text, hocPhan);
Deletetextbox();
}
public async Task <IActionResult> Create([Bind("Mahp,Tenmon,Siso,Phonghoc,Tiethoc,Thu,Ngaybd,Ngaykt")] HocPhan hocPhan)
{
if (ModelState.IsValid)
{
_context.Add(hocPhan);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(hocPhan));
}
protected void btnCreate_Click(object sender, EventArgs e)
{
SaveCheckedValues();
grvCourse.AllowPaging = false;
grvCourse.DataBind();
MoodleCourse course;
XmlDocument doc = new XmlDocument();
ArrayList arrIDs = ConvertToArrayList(txtListId.Text);
string idnum = "0";
DCVimaruDataContext dc = new DCVimaruDataContext();
HocPhan hocphan = dc.HocPhans.Single(t => t.MaHP == cboFilterSubject.SelectedValue);
int parent = Convert.ToInt32(hocphan.Id);
foreach (GridViewRow row in grvCourse.Rows)
{
idnum = grvCourse.DataKeys[row.RowIndex]["STT"].ToString();
if (arrIDs.Contains(idnum))
{
if (row.Cells[2].Text != "0")
{
continue;
}
string fullname = HttpUtility.HtmlDecode(row.Cells[4].Text + " " + row.Cells[5].Text + "-" + row.Cells[6].Text);
course = new MoodleCourse(
fullname,
fullname,
parent,
MoodleUtilites.GetIdNumber(fullname),
fullname,
MoodleUtilites.ConvertToTimestamp(row.Cells[6].Text)
);
List <MoodleCourse> list = new List <MoodleCourse>();
list.Add(course);
doc.LoadXml(MoodleCourse.CreateCourses(list, (string)Session["token"]));
doc.Save("D:\\course_create_" + row.Cells[3].Text + ".xml");
if (doc.DocumentElement.Name == "RESPONSE")
{
long id = (long)Convert.ToUInt32(doc.DocumentElement.ChildNodes[0].ChildNodes[0].ChildNodes[0].ChildNodes[0].InnerText);
ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(row.Cells[3].Text));
tkb.Id = id;
dc.SubmitChanges();
}
}
}
grvCourse.AllowPaging = true;
}
public List <HocPhan> GetListHocPhan()
{
List <HocPhan> list = new List <HocPhan>();
DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetHocPhanList");
foreach (DataRow item in data.Rows)
{
HocPhan hocphan = new HocPhan(item);
list.Add(hocphan);
}
return(list);
}
/// <summary>
/// Lấy Học phần bởi mã giảng viên và mã học phần, trả về danh sách HOCPHAN
/// </summary>
/// <param name="id">Mã giảng viên</param>
/// <param name="Mahp">Mã học phần</param>
/// <returns></returns>
public List <HocPhan> getListHocPhanByIDGiangVienAndMaHP(String id, String Mahp)
{
List <HocPhan> result = new List <HocPhan>();
String sqlString = @"EXEC getListHocPhanByIDGiangVienAndMaHP '" + id + "', '" + Mahp + "'";
DataTable dt = DataProvider.Instance.LoadAllTable(sqlString);
foreach (DataRow i in dt.Rows)
{
HocPhan hp = new HocPhan(i);
result.Add(hp);
}
return(result);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
SaveCheckedValues();
grvSubject.AllowPaging = false;
grvSubject.DataBind();
MoodleCategory category;
XmlDocument doc = new XmlDocument();
ArrayList arrIDs = ConvertToArrayList(txtListId.Text);
string idnum = "0";
DCVimaruDataContext dc = new DCVimaruDataContext();
BoMon bomon = dc.BoMons.Single(t => t.MaBoMon == Convert.ToInt32(cboFilterDepartment.SelectedValue));
int parent = Convert.ToInt32(bomon.Id);
foreach (GridViewRow row in grvSubject.Rows)
{
if (row.Cells[2].Text != "0")
{
continue;
}
idnum = grvSubject.DataKeys[row.RowIndex]["MaHP"].ToString();
if (arrIDs.Contains(idnum))
{
category = new MoodleCategory
{
Name = HttpUtility.HtmlDecode(row.Cells[4].Text),
Parent = parent,
IdNumber = HttpUtility.HtmlDecode(row.Cells[3].Text),
Description = HttpUtility.HtmlDecode(row.Cells[4].Text),
DescriptionFormat = 1,
Theme = null
};
List <MoodleCategory> lst = new List <MoodleCategory>();
lst.Add(category);
doc.LoadXml(MoodleCategory.CreateCategories(lst, (string)Session["token"]));
doc.Save("D:\\subject_" + category.IdNumber + ".xml");
if (doc.DocumentElement.Name == "RESPONSE")
{
long id = (long)Convert.ToUInt32(doc.DocumentElement.ChildNodes[0].ChildNodes[0].ChildNodes[0].ChildNodes[0].InnerText);
HocPhan hocphan = dc.HocPhans.Single(t => t.MaHP == category.IdNumber);
hocphan.Id = id;
dc.SubmitChanges();
}
}
}
grvSubject.AllowPaging = true;
}
/// <summary>
/// Lấy học phần bởi mã giảng viên, trả về sanh sách HOCPHAN
/// </summary>
/// <param name="id">Mã giảng viên</param>
/// <returns></returns>
public List <HocPhan> getListHocPhanByIDGiangVien(String id)
{
List <HocPhan> result = new List <HocPhan>();
String sqlString = string.Format(@"EXEC getListNhomHocPhanByIDGiangVien '{0}'", id);
DataTable dt = DataProvider.Instance.LoadAllTable(sqlString);
foreach (DataRow i in dt.Rows)
{
HocPhan hp = new HocPhan(i);
result.Add(hp);
}
return(result);
}
public void capnhathocphan(HocPhan HocPhan, IClientSessionHandle session)
{
HocPhanCollection.UpdateOne(session,
Builders <HocPhan> .Filter.Eq("_id", ObjectId.Parse(HocPhan.Id.ToString())),
Builders <HocPhan> .Update
.Set("id_LopHoc", HocPhan.id_LopHoc)
.Set("SiSo", HocPhan.SiSo)
.Set("LyThuyet", HocPhan.LyThuyet)
.Set("ThucHanh", HocPhan.ThucHanh)
.Set("DanhSachSinhVien", HocPhan.DanhSachSinhVien)
.Set("Status", HocPhan.Status)
);
}
private void button1_Click(object sender, EventArgs e)
{
DataDAO dataDAO = new DataDAO();
HocPhan hocPhan = new HocPhan();
hocPhan.Ma_HP = textBox1.Text;
hocPhan.Ten_HP = textBox2.Text;
hocPhan.Ma_D = "";
hocPhan.Ma_SV = "";
hocPhan.ID_Khoa = MaKhoa(comboBox1.Text);
dataDAO.Insert(hocPhan);
Deletetextbox();
Close();
}
public List <HocPhan> SearchHPByTenKhoa(string makhoa)
{
List <HocPhan> list = new List <HocPhan>();
string query = string.Format("select * from HOCPHAN where [dbo].[GetUnsignString](MAKHOA) " +
"like N'%'+[dbo].[GetUnsignString](N'{0}')+'%' ", makhoa);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
HocPhan hocphan = new HocPhan(item);
list.Add(hocphan);
}
return(list);
}
//ham sua giao vien
public bool SuaHP(HocPhan hp)
{
string sql = "Update HocPhan set tenHP = @tenHP, soTC = @soTC, soDVHT = @soDVHT, maGV = @maGV where maHP = @maHP";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maHP", hp.maHP),
new SqlParameter("@tenHP", hp.tenHP),
new SqlParameter("@soTC", hp.soTC),
new SqlParameter("@soDVHT", hp.soDVHT),
new SqlParameter("@maGV", hp.maGV)
};
return(dal.myExecute(sql, sqlParameters));
}
public HocPhan GetHPByMaHP(string mahocphan)
{
HocPhan hocphan = null;
string query = "select * from HOCPHAN where MAHOCPHAN = " + mahocphan;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
hocphan = new HocPhan(item);
return(hocphan);
}
return(hocphan);
}
//ham them hoc phan
public bool ThemHP(HocPhan hp)
{
string sql = "insert into HocPhan(maHP, tenHP, soTC, soDVHT, maGV)" + "values (@maHP, @tenHP, @soTC, @soDVHT, @maGV)";
SqlParameter[] sqlParameters =
{
new SqlParameter("@maHP", hp.maHP),
new SqlParameter("@tenHP", hp.tenHP),
new SqlParameter("@soTC", hp.soTC),
new SqlParameter("@soDVHT", hp.soDVHT),
new SqlParameter("@maGV", hp.maGV)
};
return(dal.myExecute(sql, sqlParameters));
}
public async Task <Response <HocPhan> > TaoHocPhan(TaoHocPhanRequest request)
{
var hocPhan = new HocPhan
{
TenHocPhan = request.TenHocPhan
};
var newHocPhan = await _hocPhanRepo.CreateHocPhan(hocPhan);
return(new Response <HocPhan>
{
StatusCode = 201,
Success = true,
Errors = null,
Data = newHocPhan
});
}
public ActionResult ThemHocPhan(HocPhan objectname, string id_monhoc)
{
MonHoc monHoc = model.find(id_monhoc);
if (monHoc.DanhSachHocPhan == null)
{
monHoc.DanhSachHocPhan = new List <HocPhan>();
}
ViewBag.id_monhoc = id_monhoc;
monHoc.DanhSachHocPhan.Add(objectname);
objectname.Id = ObjectId.GenerateNewId();
model.update(monHoc);
return(RedirectToAction(id_monhoc, "MonHoc/XemDanhSachHocPhan"));
}
/// <summary>
/// Lấy học phần bởi mã học phần, trả về Kiểu HOCPHAN
/// </summary>
/// <param name="ID">Mã học phần</param>
/// <returns></returns>
public HocPhan getHocPhanByID(String ID)
{
HocPhan hp = new HocPhan();
String sqlString = "Exec getHocPhanByID " + "'" + ID + "'";
try
{
DataTable dt = DataProvider.Instance.LoadAllTable(sqlString);
hp = new HocPhan(dt.Rows[0]);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(hp);
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
else if (model.find(id) == null)
{
return(RedirectToAction("Index"));
}
ViewBag.giangviens = new GiangVienModel().findAll();
ViewBag.lophocs = new LopHocModel().findAll();
ViewBag.id = id;
HocPhan hocPhan = model.find(id);
return(View("Edit", model.find(id)));
}
public void UpdateHP(string s, HocPhan hocPhan)
{
var sql = "Update [SinhVien_BT].[dbo].[HocPhan] set Ten_HP = @Ten_HP ,Ma_HP = @Ma_HP where Ma_HP = '" + s + "'";
using (sqlConnection = new SqlConnection(Connect))
{
try
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
sqlCommand.Parameters.AddWithValue("Ten_HP", hocPhan.Ten_HP);
sqlCommand.Parameters.AddWithValue("Ma_HP", hocPhan.Ma_HP);
sqlCommand.ExecuteNonQuery();
}
catch (Exception)
{
MessageBox.Show("Nhap Lai Thong Tin");
}
}
}
private void txbMaLopHP_TextChanged(object sender, EventArgs e)
{
if (dtgvLopHP.SelectedCells.Count > 0)
{
string mahocphan = Convert.ToString(dtgvLopHP.SelectedCells[0].OwningRow.Cells["MaHocPhan"].Value);
HocPhan hocphan = HocPhanDAO.Instance.GetHPByMaHP(mahocphan);
cbHP.SelectedItem = mahocphan;
int index = -1;
int i = 0;
foreach (HocPhan item in cbHP.Items)
{
if (item.MaHocPhan == hocphan.MaHocPhan)
{
index = i;
break;
}
i++;
}
cbHP.SelectedIndex = index;
}
}
public async Task <ActionResult <BaseResponse> > PostHocPhan(HocPhan hocPhan)
{
try
{
_context.HocPhans.Add(hocPhan);
await _context.SaveChangesAsync();
return(new BaseResponse
{
Message = "Thêm mới thành công",
Data = hocPhan
});
}
catch
{
return(new BaseResponse
{
ErrorCode = 1,
Message = "Thêm mới thất bại"
});
}
}
public void Insert(HocPhan hocPhan)
{
var sql = @"insert into [SinhVien_BT].[dbo].[HocPhan] values(@Ma_HP,@Ten_HP,@Ma_SV,@Ma_D,@ID_Khoa)";
using (sqlConnection = new SqlConnection(Connect))
{
sqlConnection.Open();
try
{
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
sqlCommand.Parameters.AddWithValue("Ma_HP", hocPhan.Ma_HP);
sqlCommand.Parameters.AddWithValue("Ten_HP", hocPhan.Ten_HP);
sqlCommand.Parameters.AddWithValue("Ma_SV", hocPhan.Ma_SV);
sqlCommand.Parameters.AddWithValue("Ma_D", hocPhan.Ma_D);
sqlCommand.Parameters.AddWithValue("ID_Khoa", hocPhan.ID_Khoa);
sqlCommand.ExecuteNonQuery();
}
catch (Exception)
{
MessageBox.Show("Nhap Lai Thong Tin ");
}
}
}
private void SetUpComboBoxWithData()
{
cb_ky.Items.Clear();
cb_nam.Items.Clear();
InitComboBox();
List <int> listNam = new List <int>();
foreach (DangKyHocPhan d in data)
{
HocPhan h = d.hocPhan;
for (int tiet = h.thoiGian.tietBatDau; tiet <= h.thoiGian.tietKetThuc; tiet++)
{
try
{
int nam = h.nam;
int ky = h.hocKy;
if (!listNam.Contains(nam))
{
listNam.Add(nam);
}
}
catch (IndexOutOfRangeException e)
{
LogHelper.Log("ERROR KetQuaUC: " + e);
}
}
}
listNam.Sort();
listNam.Reverse();
foreach (int nam in listNam)
{
cb_nam.Items.Add(nam);
}
cb_nam.SelectedIndex = 0;
}
public ActionResult EditHocPhan(string Id_MonHoc, int position_hocphan)
{
if (Id_MonHoc == null)
{
return(RedirectToAction("Index"));
}
else if (model.find(Id_MonHoc) == null)
{
return(RedirectToAction("Index"));
}
MonHoc mon = model.find(Id_MonHoc);
HocPhan hoc = mon.DanhSachHocPhan[position_hocphan];
ViewBag.position_hocphan = position_hocphan;
ViewBag.Id_MonHoc = Id_MonHoc;
ViewBag.TenMonHoc = mon.TenMonHoc;
ViewBag.giangviens = new GiangVienModel().findAll();
ViewBag.lophocs = new LopHocModel().findAll();
ViewBag.id_hocphan = hoc.Id;
return(View(hoc));
}
