public string DeleteCaseStudy(long id) { try { utblCaseStudie model = db.utblCaseStudies.Find(id); db.utblCaseStudies.Remove(model); db.SaveChanges(); return("CaseStudy Removed"); } catch (Exception) { return("Error: Server error, try again later"); } }
public string SaveCaseStudy(utblCaseStudie model) { var parCaseStudyID = new SqlParameter("@CaseStudyID", model.CaseStudyID); var parCaseStudyTitle = new SqlParameter("@CaseStudyTitle", model.CaseStudyTitle); var parCaseStudyDesc = new SqlParameter("@CaseStudyDesc", model.CaseStudyDesc); var parSchoolID = new SqlParameter("@SchoolID", model.SchoolID); var parComponentID = new SqlParameter("@ComponentID", model.ComponentID); var parSubComponentID = new SqlParameter("@SubComponentID", model.SubComponentID); var parCaseStudyFilePath = new SqlParameter("@CaseStudyFilePath", model.CaseStudyFilePath); var parCaseStudyDate = new SqlParameter("@CaseStudyDate", model.CaseStudyDate); var parIsPublished = new SqlParameter("@IsPublished", model.IsPublished); var parPublishDate = new SqlParameter("@PublishedDate", DBNull.Value); if (model.PublishedDate != null) { parPublishDate = new SqlParameter("@PublishedDate", model.PublishedDate); } var parTransDate = new SqlParameter("@TransDate", model.TransDate); var parUserID = new SqlParameter("@UserID", model.UserID); return(db.Database.SqlQuery <string>("udspCaseStudySave @CaseStudyID,@CaseStudyTitle,@CaseStudyDesc,@SchoolID,@ComponentID,@SubComponentID,@CaseStudyFilePath,@CaseStudyDate,@IsPublished,@PublishedDate, @TransDate, @UserID", parCaseStudyID, parCaseStudyTitle, parCaseStudyDesc, parSchoolID, parComponentID, parSubComponentID, parCaseStudyFilePath, parCaseStudyDate, parIsPublished, parPublishDate, parTransDate, parUserID).FirstOrDefault()); }
public ActionResult Delete(long id) { utblCaseStudie cs = new utblCaseStudie(); cs = objCaseStudy.GetCaseStudyByID(id); string PrvPath = cs.CaseStudyFilePath; utblCaseStudie model = new utblCaseStudie(); model = objCaseStudy.GetCaseStudyByID(id); string result = objCaseStudy.DeleteCaseStudy(id); if (!result.ToLower().Contains("Error")) { objSite.AddAuditLog("utblCaseStudies", "Case Study Removed", IPAddressGetter.GetIPAddress(), User.Identity.Name, id); DeleteFile(model.CaseStudyFilePath); TempData["ErrMsg"] = "Success: Data Removed Succesfully !"; } else { TempData["ErrMsg"] = result; } return(RedirectToAction("index", "casestudy", new { Area = "Admin" })); }