public ActionResult AddSubmittion(ParamInputCreateModel param) { int resCode = 0; try { var newSubmitID = dataAccess.CreateIDAuto("SM"); //var userInfo = dataAccess.GetUserInfoByID(2); var userInfo = (UserLoginModel)Session[Helper.Commons.USER_SEESION]; param.description = HttpUtility.HtmlDecode(RemoveHtmlTag(HttpUtility.HtmlDecode(param.description).Replace("<br />", "\n").Replace("</li>", "\n").Replace(" ", ""))); // lưu submittion var inforSubmit = new SUBMITTION() { Sub_Title = param.title, Sub_Description = param.description, Created_Date = DateTime.Now, Sub_Code = newSubmitID, Created_By = userInfo.UserID, IsPublic = 0 }; var newID = dataAccess.AddSubmits(inforSubmit); // lưu file của submitton if (param.files.Count() > 0) { string path = Server.MapPath("~/Uploads/FilesSubmitted/"); foreach (var item in param.files) { if (item != null) { var files = new FILE(); string fileName = string.Format("{0}_{1}_{2}{3}", userInfo.Username, newSubmitID, DateTime.Now.Ticks.ToString(), System.IO.Path.GetExtension(item.FileName)); files.File_Name = item.FileName; files.File_Path = fileName; files.Sub_Code = newSubmitID; files.Sub_ID = newID; // lưu file vào folder item.SaveAs(path + fileName); var insertFile = dataAccess.InsertFile(files); } } } Task.Run(() => Helper.SendMail.SendEmailWhenAddNewSubmittion(userInfo.UserID.ToString(), userInfo.Username, userInfo.Department, userInfo.Email, param.title, param.files.Count())); resCode = 1; } catch (Exception) { resCode = -1; throw; } return(Json(resCode, JsonRequestBehavior.AllowGet)); }
public ActionResult EditSubmission(ParamInputCreateModel param) { int res = 0; var userInfor = (UserLoginModel)Session[Helper.Commons.USER_SEESION]; var subInfor = dataAccess.GetSubmittionByID(param.Sub_ID); param.description = HttpUtility.HtmlDecode(RemoveHtmlTag(HttpUtility.HtmlDecode(param.description).Replace("<br />", "\n").Replace("</li>", "\n").Replace(" ", ""))); var inforSubmit = new SUBMITTION() { Sub_ID = param.Sub_ID, Sub_Title = param.title, Sub_Description = param.description, Updated_Date = DateTime.Now, Updated_By = userInfor.UserID }; res = dataAccess.EditSubmission(inforSubmit); var listOwnFile = dataAccess.GetFilesBySubCode(param.SubCode); if (param.files.Count() > 0) // if student has file change { // xoa file cũ trong Folder va DB var rootFolder = Server.MapPath("~/Uploads/FilesSubmitted/"); foreach (var item in listOwnFile) { if (System.IO.File.Exists(Path.Combine(rootFolder, item.File_Path))) { System.IO.File.Delete(Path.Combine(rootFolder, item.File_Path)); } var delete = dataAccess.DeleteFile(item.File_ID); } // edit file in DbContext and save new file foreach (var item in param.files) { var newFile = new FILE(); string filename = string.Format("{0}_{1}_{2}{3}", userInfor.Username, param.SubCode, DateTime.Now.Ticks.ToString(), System.IO.Path.GetExtension(item.FileName)); newFile.Sub_ID = param.Sub_ID; newFile.Sub_Code = param.SubCode; newFile.File_Name = item.FileName; newFile.File_Path = filename; item.SaveAs(rootFolder + filename); res = dataAccess.InsertFile(newFile); } } return(Json(res, JsonRequestBehavior.AllowGet)); }
public int AddSubmits(SUBMITTION input) { try { db.SUBMITTIONS.Add(input); db.SaveChanges(); var id = db.SUBMITTIONS.Where(x => x.Sub_Code == input.Sub_Code).FirstOrDefault(); return(id.Sub_ID); } catch (Exception ex) { return(-1); } }
public int EditPublicStatus(SUBMITTION entity) { try { var data = db.SUBMITTIONS.Find(entity.Sub_ID); data.IsPublic = entity.IsPublic; db.SaveChanges(); return(1); } catch (Exception e) { return(-1); throw; } }
public int EditSubmission(SUBMITTION entity) { try { var submission = db.SUBMITTIONS.Find(entity.Sub_ID); submission.Sub_Title = entity.Sub_Title; submission.Sub_Description = entity.Sub_Description; submission.Updated_By = entity.Updated_By; submission.Updated_Date = entity.Updated_Date; db.SaveChanges(); return(1); } catch (Exception ex) { return(-1); } }
public ActionResult EditSubmission(ParamInputCreateModel param) { int res = 0; var userInfor = (UserLoginModel)Session[Helper.Commons.USER_SEESION_ADMIN]; var inforSubmit = new SUBMITTION() { Sub_ID = param.Sub_ID, Sub_Title = param.title, Sub_Description = param.description, Updated_Date = DateTime.Now, Updated_By = userInfor.UserID }; res = dataAccess.EditSubmission(inforSubmit); return(Json(res, JsonRequestBehavior.AllowGet)); }
public ActionResult PublicFiles(List <int> listSubmiss) { var model = new SUBMITTION(); int resCode = 0; foreach (var item in listSubmiss) { model.Sub_ID = item; model.IsPublic = 1; try { var resDB = dataAccess.EditPublicStatus(model); resCode = 1; } catch (Exception e) { resCode = -1; return(Json(resCode, JsonRequestBehavior.AllowGet)); } } return(Json(resCode, JsonRequestBehavior.AllowGet)); }