public ActionResult EditTutorial(TutorialsModel FormData) { HttpPostedFileBase DP = FormData.Doc; TutorialsDataContext UploadContext = new TutorialsDataContext(); var file = ""; var path = Request.PhysicalApplicationPath; if (DP != null && (DP.ContentLength <= 10240000 && DP.ContentType == "application/docx" || DP.ContentType == "application/pdf" || DP.ContentType == "text/plain")) { file = DP.FileName; if (!Directory.Exists(path + "Uploads")) { Directory.CreateDirectory(path + "Uploads"); } if (System.IO.File.Exists(DP.FileName)) { System.IO.File.Move(DP.FileName, DP.FileName + "old"); } DP.SaveAs(path + "Uploads/" + DP.FileName); } else { file = FormData.DocName; } UploadContext.EditTutorial(Session["UserID"], FormData.TutorialsID, file, path, FormData.Subject, FormData.Category, FormData.Description); return(RedirectToAction("Index", "Tutorials")); }
public ActionResult DelTutorials(decimal TutorialsID) { TutorialsDataContext UploadContext = new TutorialsDataContext(); TutorialsModel lotutorials = new TutorialsModel(); lotutorials.loTutorialsData = UploadContext.DelTutorial(TutorialsID); return(View("~/Areas/Admin/Views/Tutorials/_GetTutorialsBySearch.cshtml", lotutorials)); }
public List <TutorialsModel> GetTutorialsBySearch(string Subject, string Category, string Keywords) { List <SqlParameter> ProcParam = new List <SqlParameter>(); TutorialsDataContext sqldb = new TutorialsDataContext(); ProcParam.Add(new SqlParameter("Subject", Subject.handleDBNull())); ProcParam.Add(new SqlParameter("Category", Category.handleDBNull())); ProcParam.Add(new SqlParameter("Keywords", Keywords.handleDBNull())); return(new AdminDataContext().Database.SqlQuery <TutorialsModel>("GetTutorialsBySearch".getSql(ProcParam), ProcParam.ToArray()).ToList()); }
public ActionResult NotesUpload(TutorialsModel FormData) { HttpPostedFileBase DP = FormData.Doc; if (DP != null && (DP.ContentLength <= 10240000 && DP.ContentType == "application/docx" || DP.ContentType == "application/pdf" || DP.ContentType == "text/plain")) { TutorialsDataContext UploadContext = new TutorialsDataContext(); var path = Request.PhysicalApplicationPath; if (!Directory.Exists(path + "Uploads")) { Directory.CreateDirectory(path + "Uploads"); } DP.SaveAs(path + "Uploads/" + DP.FileName); UploadContext.Upload(Session["UserID"], DP.FileName, path, FormData.Subject, FormData.Category, FormData.Description); ViewBag.msg = path; ViewData["msg"] = path; } else { ViewBag.msg = "Error occured"; ViewData["msg"] = "Error Occured"; } return(RedirectToAction("Index", "Tutorials", new { area = "Admin" })); }