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));
}
