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