public ResponseResult ThemHocPhanTheoCTDT(HocPhanTheoCTDTModel model)
{
ResponseResult res = null;
try
{
model.NguoiTao = AccountUtils.CurrentUsername();
res = HocPhanTheoCTDT_DA.ThemHocPhanTheoCTDT(model);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public ResponseResult ThemHocPhanTheoCTDT(HocPhanTheoCTDTModel model)
{
ResponseResult res = null;
try
{
List <SqlParameter> listParameter = new List <SqlParameter>();
listParameter.Add(new SqlParameter("@CTDTID", model.ChuongTrinhDaoTaoID));
listParameter.Add(new SqlParameter("@MaHP", model.MaHP));
listParameter.Add(new SqlParameter("@HocKi", model.HocKi));
listParameter.Add(new SqlParameter("@NguoiTao", model.NguoiTao));
res = DBUtils.ExecuteSP <ResponseResult>("SP_HocPhanTheoCTDT_Them", listParameter);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public ResponseResult Import(HttpPostedFileBase file, int CTDTID)
{
ResponseResult res = null;
string s = "";
try
{
List <HocPhanTheoCTDTModel> dt = new List <HocPhanTheoCTDTModel>();
file.InputStream.Position = 0;
var memoryStream = new MemoryStream();
file.InputStream.CopyTo(memoryStream);
using (XLWorkbook workBook = new XLWorkbook(memoryStream))
{
//Read the first Sheet from Excel file.
IXLWorksheet workSheet = workBook.Worksheet(1);
foreach (IXLRow row in workSheet.Rows())
{
int i = 0;
string check = row.Cell(3).Value.ToString();
if (!String.IsNullOrEmpty(check) && int.TryParse(check, out i) && int.Parse(check) > 0)
{
var a = new HocPhanTheoCTDTModel();
a.ChuongTrinhDaoTaoID = CTDTID;
a.MaHP = row.Cell(3).Value.ToString();
a.HocKi = "";
if (!String.IsNullOrEmpty(row.Cell(5).Value.ToString()))
{
a.HocKi += "1,";
}
if (!String.IsNullOrEmpty(row.Cell(6).Value.ToString()))
{
a.HocKi += "2,";
}
if (!String.IsNullOrEmpty(row.Cell(7).Value.ToString()))
{
a.HocKi += "3,";
}
if (!String.IsNullOrEmpty(row.Cell(8).Value.ToString()))
{
a.HocKi += "4,";
}
if (!String.IsNullOrEmpty(row.Cell(9).Value.ToString()))
{
a.HocKi += "5,";
}
if (!String.IsNullOrEmpty(row.Cell(10).Value.ToString()))
{
a.HocKi += "6,";
}
if (!String.IsNullOrEmpty(row.Cell(11).Value.ToString()))
{
a.HocKi += "7,";
}
if (!String.IsNullOrEmpty(row.Cell(12).Value.ToString()))
{
a.HocKi += "8,";
}
if (!String.IsNullOrEmpty(row.Cell(13).Value.ToString()))
{
a.HocKi += "9,";
}
if (a.HocKi != "")
{
a.HocKi = a.HocKi.Remove(a.HocKi.LastIndexOf(','));
}
a.NguoiTao = AccountUtils.CurrentUsername();
if (dt.Where(x => x.MaHP == a.MaHP) != null)
{
dt.Add(a);
}
foreach (var item in dt)
{
if (dt.Where(x => x.MaHP == a.MaHP) != null)
{
item.HocKi = a.HocKi;
break;
}
}
}
}
}
foreach (var item in dt)
{
res = HocPhanTheoCTDT_DA.ThemHocPhanTheoCTDT(item);
if (res.ResponseMessage != null)
{
s += res.ResponseMessage + ", ";
}
else if (res == null && dt.Count > 0)
{
break;
}
}
if (s != "")
{
s = s.Remove(s.LastIndexOf(','));
if (res != null)
{
res.ResponseMessage = s;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(res);
}