public JsonResult UpdateDetail(int ID, string COLUMN, string VALUE)
{
HIS_DETAIL his = new HIS_DETAIL();
var result = his.Update(ID, COLUMN, VALUE);
return(Json(result));
}
public JsonResult Assign(string MENTOR, int COURSE_ID, List <EMPLOYEE> IDS)
{
var result = 0;
HISTORY his = new HISTORY();
HIS_DETAIL detail = new HIS_DETAIL();
EMPLOYEE em = new EMPLOYEE();
foreach (var id in IDS)
{
HISTORY last = his.GetLastId(COURSE_ID, id.ID, MENTOR);
int isMentor = em.IsMentor(COURSE_ID, id.ID);
if (last == null && isMentor == 0)
{
result = his.Insert(COURSE_ID, id.ID, MENTOR);
if (result > 0)
{
last = his.GetLastId(COURSE_ID, id.ID, MENTOR);
if (last != null)
{
for (int i = 0; i < 5; i++)
{
result = detail.Insert(last.ID, COURSE_ID, id.ID, MENTOR, "Unconfirmed", id.DEPARTMENT);
}
}
}
}
}
return(Json(result));
}
public ActionResult Upload(HttpPostedFileBase OUTCOME_RESULT, int ID)
{
var allowedExtensions = new[] { ".ppt", ".pptx" };
var ext = Path.GetExtension(OUTCOME_RESULT.FileName).ToLower();
if (!allowedExtensions.Contains(ext))
{
TempData["message"] = "Upload fail. Please select ppt/pptx file";
return(Redirect(Request.UrlReferrer.ToString()));
}
HIS_DETAIL detail = new HIS_DETAIL();
var mypath = "~/Upload/File/" + ID.ToString();
var path = Server.MapPath(mypath);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
DirectoryInfo di = new DirectoryInfo(path);
foreach (FileInfo file in di.GetFiles())
{
file.Delete();
}
string savedFileName = Path.Combine(path, Path.GetFileName(OUTCOME_RESULT.FileName));
OUTCOME_RESULT.SaveAs(savedFileName);
string fileName = Path.GetFileName(OUTCOME_RESULT.FileName);
var result = detail.Update(ID, "OUTCOME_RESULT", mypath + "/" + fileName);
if (result > 0)
{
TempData["message"] = "Upload success";
}
else
{
TempData["message"] = "Upload fail";
}
return(Redirect(Request.UrlReferrer.ToString()));
}