public void setCTDT(CTDT ctdt)
{
this.panel_chuong_trinh_dao_tao.Controls.Clear();
Control ct = this.panel_chuong_trinh_dao_tao.Controls["header_ctdt"];
if (ct != null)
{
this.panel_chuong_trinh_dao_tao.Controls.Remove(ct);
}
listCTDTHK = ctdt.dsCTDT.ToArray <CTDT_HK>();
for (int i = 0; i < listCTDTHK.Length; i++)
{
CTDTItem item = new CTDTItem();
item.stt.Text = (listCTDTHK.Length - i).ToString();
item.ma_mon_hoc.Text = listCTDTHK[i].ma_monhoc;
item.ten_mon_hoc.Text = listCTDTHK[i].ten_monhoc;
item.so_tin_chi.Text = listCTDTHK[i].so_tin_chi;
if (listCTDTHK[i].monhoc_batbuoc == null)
{
item.loai_mon_hoc.Text = "Tự chọn";
}
else
{
item.loai_mon_hoc.Text = "Bắt buộc";
}
item.chua_dat.Text = "";
item.dat.Text = "";
if (listCTDTHK[i].diem == null)
{
item.chua_dat.Text = "x";
}
else
{
double diem;
bool converted = Double.TryParse(listCTDTHK[i].diem, out diem);
if ((converted && diem > 4.99999) || listCTDTHK[i].diem == "DT")
{
item.dat.Text = "x";
}
else
{
item.chua_dat.Text = "x";
}
}
item.diem.Text = listCTDTHK[i].diem;
item.ghi_chu.Text = "";
item.TabIndex = listCTDTHK.Length - i + 1;
item.Dock = DockStyle.Top;
this.panel_chuong_trinh_dao_tao.Controls.Add(item);
}
setupHeader();
}
public XemChuongTrinhDaoTao()
{
InitializeComponent();
this.setupHeader();
StreamReader sr = new StreamReader(PathData.ctdtData, Encoding.UTF8);
String json = sr.ReadToEnd();
sr.Close();
listCTDT = CTDT.getCTDT(json);
this.setCTDT(listCTDT[0]);
comboBox_ds_hoc_ki.Text = formatHocKy(listCTDT[0].hocky);
this.setupDSHocKy();
}
public ActionResult Create(CTDT _CTDT)
{
if (_CTDT.Ma_CTDT == null)
{
TempData["CTDT_ERR"] = "Mã chương trình đào tạo không được trống";
return(RedirectToAction("index", "CTDT"));
}
HttpPostedFileBase excelfile = Request.Files["CTDT_excelfile"];
if (excelfile.ContentLength == 0 || excelfile == null)
{
TempData["CTDT_ERR"] = "Bạn chưa chọn file";
return(RedirectToAction("index", "CTDT"));
}
else
{
if (!excelfile.FileName.EndsWith("xls") && !excelfile.FileName.EndsWith("xlsx"))
{
TempData["CTDT_ERR"] = "File không đúng định dạng ";
return(RedirectToAction("index", "CTDT"));
}
}
var _KTMon = db.CTDTs.Where(x => x.Ma_CTDT == _CTDT.Ma_CTDT).FirstOrDefault();
if (_KTMon != null)
{
TempData["CTDT_ERR"] = "Mã chương trình đào tạo đã tồn tại";
return(RedirectToAction("index", "CTDT"));
}
else
{
CTDT daotao = new CTDT();
daotao.Ma_CTDT = _CTDT.Ma_CTDT;
daotao.Ten_CTDT = _CTDT.Ten_CTDT;
db.CTDTs.InsertOnSubmit(daotao);
db.SubmitChanges();
if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
int _tc = 0;
int _tclt = 0;
int _tcth = 0;
string path = Server.MapPath("~/Content/" + excelfile.FileName);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
excelfile.SaveAs(path);
//read data from excel file
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
try
{
for (int row = 2; row <= range.Rows.Count; row++)
{
MON _mon = new MON();
_mon.Ma_HK = ((Excel.Range)range.Cells[row, 1]).Text;
_mon.Ma_Mon = ((Excel.Range)range.Cells[row, 2]).Text;
_mon.Ten_Mon = ((Excel.Range)range.Cells[row, 3]).Text;
int.TryParse(((Excel.Range)range.Cells[row, 4]).Text, out _tc);
_mon.So_TC = _tc;
int.TryParse(((Excel.Range)range.Cells[row, 5]).Text, out _tclt);
_mon.TC_LyThuyet = _tclt;
int.TryParse(((Excel.Range)range.Cells[row, 6]).Text, out _tcth);
_mon.TC_ThucHanh = _tcth;
_mon.Ghi_Chu = ((Excel.Range)range.Cells[row, 7]).Text;
_mon.Ma_CTDT = _CTDT.Ma_CTDT;
if (_mon.Ma_HK == null || _mon.Ma_Mon == null || _mon.Ten_Mon == null /*|| !IsNumber(((Excel.Range)range.Cells[row, 4]).ToString()) || !IsNumber(((Excel.Range)range.Cells[row, 5]).Text) || !IsNumber(((Excel.Range)range.Cells[row, 6]).Text)*/)
{
var DelCTDT = db.CTDTs.Where(x => x.Ma_CTDT == _CTDT.Ma_CTDT).FirstOrDefault();
db.CTDTs.DeleteOnSubmit(DelCTDT);
db.SubmitChanges();
TempData["CTDT_ERR"] = "Không thể đọc được file.";
break;
}
db.MONs.InsertOnSubmit(_mon);
db.SubmitChanges();
}
workbook.Close(false);
application.Quit();
}
catch (Exception)
{
return(RedirectToAction("index", "CTDT"));
}
}
}
return(RedirectToAction("index", "CTDT"));
}
