public DataSet INSERT_UPDATE_BLOGPOST(mBlogPost _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("INSERT_UPDATE_BLOGPOST", _cn);
_cmd.Parameters.AddWithValue("@Blog_Id", _obj.Blog_Id);
_cmd.Parameters.AddWithValue("@BlogTitle", _obj.BlogTitle);
_cmd.Parameters.AddWithValue("@UniqueCode", _obj.UniqueCode);
_cmd.Parameters.AddWithValue("@BlogContent", _obj.BlogContent);
_cmd.Parameters.AddWithValue("@BlogImage", _obj.BlogImage);
_cmd.Parameters.AddWithValue("@BlogTag", _obj.BlogTag);
_cmd.Parameters.AddWithValue("@BlogMetaTags", _obj.BlogMetaTags);
_cmd.Parameters.AddWithValue("@BlogMetaDescription", _obj.BlogMetaDescription);
_cmd.Parameters.AddWithValue("@CreatedBy", _obj.CreatedBy);
_cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP);
_cmd.CommandTimeout = 300;
_cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
public DataSet SELECT_BLOGPOST(mBlogPost _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("SELECT_BLOGPOST", _cn);
_cmd.Parameters.AddWithValue("@Blog_Id", _obj.Blog_Id);
_cmd.CommandTimeout = 300;
_cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
public JsonResult SelectBlog(mBlogPost _obj)
{
string Message = string.Empty, Code = string.Empty;
List <mBlogPost> _list = new List <mBlogPost>();
try
{
BlogPost_Repository _objRepo = new BlogPost_Repository();
DataSet _ds = _objRepo.SELECT_BLOGPOST(_obj);
if (_ds != null)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mBlogPost
{
Blog_Id = _dr["Blog_Id"].ToString(),
BlogTitle = _dr["BlogTitle"].ToString(),
UniqueCode = _dr["UniqueCode"].ToString(),
BlogContent = _dr["BlogContent"].ToString(),
BlogImage = _dr["BlogImage"].ToString(),
BlogTag = _dr["BlogTag"].ToString(),
BlogMetaTags = _dr["BlogMetaTags"].ToString(),
BlogMetaDescription = _dr["BlogMetaDescription"].ToString(),
CreatedBy = _dr["CreatedBy"].ToString()
});
}
}
}
catch (NullReferenceException)
{
}
catch (Exception)
{
}
var jsonResult = Json(new
{
m = Message,
c = Code,
List = _list
}, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
public JsonResult SaveBlog(mBlogPost _obj)
{
bool flag = false;
string path = "";
string filename = "";
string fname = "";
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
try
{
if (Request.Files.Count > 0)
{
if (Request.Files[0].ContentLength > 0)
{
HttpFileCollectionBase files = Request.Files;
path = AppDomain.CurrentDomain.BaseDirectory + "img/blogs/";
filename = _obj.UniqueCode + Path.GetExtension(Request.Files[0].FileName);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
else
{
string[] curentfiles = Directory.GetFiles(path);
//Directory.Delete(path + "/" + filename);
}
HttpPostedFileBase file = files[0];
filename = _obj.UniqueCode + Path.GetExtension(file.FileName);
fname = Path.Combine(Server.MapPath("~/img/blogs/"), filename);
file.SaveAs(fname);
_obj.BlogImage = "img/blogs/" + filename;
}
else
{
_obj.BlogImage = "";
}
}
else
{
_obj.BlogImage = "";
}
_obj.CreatedBy = Session["User_id"].ToString();
_obj.CreatedIP = Session["localIP"].ToString();
BlogPost_Repository _objRepo = new BlogPost_Repository();
DataSet _ds = _objRepo.INSERT_UPDATE_BLOGPOST(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "1")
{
Message = "Blog details has been successfully saved!";
Code = "success";
flag = true;
}
else if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "-1")
{
Message = "Blog's unique code details are already exists!";
Code = "alreadyexists";
}
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
}
catch (NullReferenceException ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
flag = flag,
m = Message,
c = Code,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
