public string Delete(string BlogID)
{
SPErrorViewModel objStatus = new SPErrorViewModel();
var parBlogID = new SqlParameter("@BlogID", BlogID);
objStatus = objDB.Database.SqlQuery <SPErrorViewModel>("udspBlogDelete @BlogID", parBlogID).FirstOrDefault();
return(objStatus.ErrorCode + objStatus.ErrorMessage);
}
public string Edit(utblBlog model, string CreatedBy)
{
DateTime dt = DateTime.Now;
var CurrentYear = dt.ToString("yyyy");
SPErrorViewModel objStatus = new SPErrorViewModel();
var parBlogID = new SqlParameter("@BlogID", model.BlogID);
var parBlogTitle = new SqlParameter("@Title", model.BlogTitle);
var parBlogDescription = new SqlParameter("@Description", model.BlogDescription);
var parBlogContent = new SqlParameter("@Content", model.BlogContent);
var parCreatedBy = new SqlParameter("@CreatedBy", CreatedBy);
var parBlogFile = new SqlParameter("@BlogFile", DBNull.Value);
if (model.BlogFile != null)
{
parBlogFile = new SqlParameter("@BlogFile", model.BlogFile);
}
objStatus = objDB.Database.SqlQuery <SPErrorViewModel>("udspBlogUpdate @BlogID,@Title,@Description,@Content,@BlogFile,@CreatedBy", parBlogID, parBlogTitle, parBlogDescription, parBlogContent, parBlogFile, parCreatedBy).FirstOrDefault();
return(objStatus.ErrorCode + objStatus.ErrorMessage);
}
public string ArticleEnquire(utblMstArticleEnquire Item)
{
SPErrorViewModel objStatus = new SPErrorViewModel();
Item.Name = Regex.Replace(Item.Name.Trim(), @"\s+", " ");
var parName = new SqlParameter("@Name", Item.Name);
var parEmail = new SqlParameter("@Email", Item.Email);
var parPhone = new SqlParameter("@Phone", "");
if (Item.Phone != null)
{
parPhone = new SqlParameter("@Phone", Item.Phone);
}
var parMessage = new SqlParameter("@Message", Item.Message);
var parPostedOn = new SqlParameter("@PostedOn", System.DateTime.Now);
objStatus = objDB.Database.SqlQuery <SPErrorViewModel>("udspMstArticleEnquireInsert @Name,@Email,@Phone,@Message,@PostedOn", parName, parEmail, parPhone, parMessage, parPostedOn).FirstOrDefault();
return(objStatus.ErrorCode + objStatus.ErrorMessage);
}
