public string DeleteTestimonial(long id)
{
try
{
utblTestimonial model = db.utblTestimonials.Find(id);
db.utblTestimonials.Remove(model);
db.SaveChanges();
return("Tetimonial Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
public string SaveTestimonial(utblTestimonial model)
{
var parTestimonialID = new SqlParameter("@TestimonialID", model.TestimonialsID);
var parName = new SqlParameter("@Name", model.Name);
var parAddress = new SqlParameter("@Address", model.Address);
var parImagePath = new SqlParameter("@ImagePath", model.ImagePath);
var parRemarks = new SqlParameter("@Remarks", model.Remarks);
var parSchoolID = new SqlParameter("@SchoolID", model.SchoolID);
var parTestimonialDate = new SqlParameter("@TestimonialDate", model.TestimonialDate);
var parComponentID = new SqlParameter("@ComponentID", model.ComponentID);
var parSubComponentID = new SqlParameter("@SubComponentID", model.SubComponentID);
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>("udspTestimonialSave @TestimonialID,@Name,@Address,@ImagePath, @Remarks,@SchoolID, @TestimonialDate,@ComponentID,@SubComponentID,@IsPublished,@PublishedDate, @TransDate, @UserID",
parTestimonialID, parName, parAddress, parImagePath, parRemarks, parSchoolID, parTestimonialDate, parComponentID, parSubComponentID, parIsPublished, parPublishDate, parTransDate, parUserID).FirstOrDefault());
}
