public JsonResult Update(Post_Model postobj)
{
string status = "";
Services.Post_Service postService = new Services.Post_Service();
if (ModelState.IsValid)
{
status = postService.Update(postobj);
}
else
{
status = "PostDataError";
}
return(Json(status, JsonRequestBehavior.AllowGet));
}
protected void btn_send_Click(object sender, EventArgs e)
{
//CMD.Parameters.AddWithValue("@Category_Id", P_Model.Category_Id);
//CMD.Parameters.AddWithValue("@User_Id", P_Model.User_Id);
//CMD.Parameters.AddWithValue("@Title", P_Model.Title);
//CMD.Parameters.AddWithValue("@Description", P_Model.Description);
//CMD.Parameters.AddWithValue("@User_id", P_Model.User_Id);
//CMD.Parameters.AddWithValue("@Post_TXT", P_Model.Details_lst[0].Post_TXT);
//CMD.Parameters.AddWithValue("@Post_TypeID", (int)Post_Type.Post);
if (string.IsNullOrEmpty(Category_Id))
{
AlertwithRedirect("Error", "Try Again and if this error still hapen please contact Admin", "/Pages/Default.aspx");
return;
}
Post_Model Post_M_Object = new Post_Model();
Post_M_Object.Category_Id = int.Parse(Category_Id.Trim());
Post_M_Object.User_Id = UserOBJ.ID;
Post_M_Object.Title = inputTitle.Value;
Post_M_Object.Description = "";
List <Post_Details_Model> PD_List = new List <Post_Details_Model>();
Post_Details_Model PD_Model = new Post_Details_Model();
PD_Model.User_Id = UserOBJ.ID;
PD_Model.Post_TXT = Editor1.Content;
PD_Model.Post_TypeID = Post_Type.Post;
PD_List.Add(PD_Model);
Post_M_Object.Details_lst = PD_List;
int Res = Post.InsertPost(Post_M_Object);
if (Res > 0)
{
AlertwithRedirect("Attention", "You have added new post successfully..", "/Pages/Post_View.aspx?pageindex=1&ID=" + Res);
return;
}
else
{
Alert("Error", "Try Again and if this error still hapen please contact Admin");
return;
}
}
public string Update(Post_Model model)
{
string status = "failed";
try
{
DataTable dt = new DataTable();
dt.Columns.Add("category_name");
dt.Columns.Add("category_desc");
int i = 0;
foreach (var element in model.categoryList)
{
DataRow dr = dt.NewRow();
dr["category_name"] = element.categoryName.ToString().ToLower();
dr["category_desc"] = element.categoryDesc;
dt.Rows.Add(dr);
}
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "tmp_prc_UpdatePostData";
cmd.Parameters.AddWithValue("@post_url", model.postUrl);
cmd.Parameters.AddWithValue("@post_content", model.postContent);
cmd.Parameters.AddWithValue("@post_icon_image", model.fileAttachmentCode);
cmd.Parameters.AddWithValue("@post_category", dt);
cmd.Parameters.AddWithValue("@shortname", model.shortName);
cmd.Parameters.AddWithValue("@seotitle", model.seoTitle);
cmd.Parameters.AddWithValue("@seodesc", model.seoDescription);
cmd.Parameters.AddWithValue("@seo_url", model.seoUrl.Replace(" ", "-"));
cmd.ExecuteNonQuery();
}
status = "Updated";
}
catch (Exception ex)
{
status = ex.Message;
}
return(status);
}
protected void RadGrid1_BatchEditCommand(object sender, GridBatchEditingEventArgs e)
{
foreach (GridBatchEditingCommand command in e.Commands)
{
Hashtable newValues = command.NewValues;
Hashtable oldValues = command.OldValues;
string New_status = newValues["status"].ToString();
string Post_ID = oldValues["Id"].ToString();
Post_Model P_ModelOBJ = new Post_Model();
P_ModelOBJ.Status = Convert.ToBoolean(New_status);
P_ModelOBJ.ID = Convert.ToInt32(Post_ID);
bool _res = Post.UpdatePost_status(P_ModelOBJ);
if (!_res)
{
Alert("Error", "Status has not been saved! Please try again");
}
}
}
public Get_Post_List PostGetLatestPosts(int start, int pageIndex)
{
string status = "failed";
Get_Post_List list = new Get_Post_List();
try
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@start", start);
param[1] = new SqlParameter("@pageIndex", pageIndex);
param[2] = new SqlParameter("@isAll", 1);
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
DataSet ds = new DataSet();
con.Open();
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmp_prc_getPostData", param);
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow dr in dt.Rows)
{
Post_Model obj = new Post_Model();
if (!string.IsNullOrEmpty(dr["post_id"].ToString()))
{
obj.postId = Convert.ToInt32(dr["post_id"].ToString());
}
else
{
obj.postId = 0;
}
if (!string.IsNullOrEmpty(dr["post_url"].ToString()))
{
obj.postUrl = dr["post_url"].ToString();
}
else
{
obj.postUrl = "";
}
if (!string.IsNullOrEmpty(dr["seo_url"].ToString()))
{
obj.seoUrl = dr["seo_url"].ToString();
}
else
{
obj.seoUrl = "";
}
if (!string.IsNullOrEmpty(dr["category_name"].ToString()))
{
obj.category = dr["category_name"].ToString();
}
else
{
obj.category = "";
}
list.list.Add(obj);
}
}
}
list.message = "fetched";
}
catch (Exception ex)
{
list.message = ex.Message;
}
return(list);
}
public Get_Post_List PostGetContent(string id)
{
string status = "failed";
Get_Post_List list = new Get_Post_List();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
DataSet ds = new DataSet();
Post_Model obj = new Post_Model();
con.Open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@seo_url", id);
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmp_prc_getPostData", param);
using (DataTable dt = ds.Tables[0])
{
foreach (DataRow dr in dt.Rows)
{
//if (!string.IsNullOrEmpty(dr["post_id"].ToString()))
//{
// obj.postId = Convert.ToInt32(dr["post_id"].ToString());
//}
//else
//{
// obj.postId = 0;
//}
if (!string.IsNullOrEmpty(dr["post_url"].ToString()))
{
obj.postUrl = dr["post_url"].ToString();
}
else
{
obj.postUrl = "";
}
if (!string.IsNullOrEmpty(dr["file_name"].ToString()))
{
obj.postIconImage = dr["file_name"].ToString();
}
else
{
obj.postIconImage = "";
}
if (!string.IsNullOrEmpty(dr["file_path"].ToString()))
{
obj.postIconImagePath = dr["file_path"].ToString();
}
else
{
obj.postIconImagePath = "";
}
//if (!string.IsNullOrEmpty(dr["post_category"].ToString()))
//{
// obj.category = dr["post_category"].ToString();
//}
//else
//{
// obj.category = "";
//}
if (!string.IsNullOrEmpty(dr["post_content"].ToString()))
{
obj.postContent = dr["post_content"].ToString();
}
else
{
obj.postContent = "";
}
if (!string.IsNullOrEmpty(dr["seo_url"].ToString()))
{
obj.seoUrl = dr["seo_url"].ToString();
}
else
{
obj.seoUrl = "";
}
if (!string.IsNullOrEmpty(dr["seo_title"].ToString()))
{
obj.seoTitle = dr["seo_title"].ToString();
}
else
{
obj.seoTitle = "";
}
if (!string.IsNullOrEmpty(dr["seo_description"].ToString()))
{
obj.seoDescription = dr["seo_description"].ToString();
}
else
{
obj.seoDescription = "";
}
if (!string.IsNullOrEmpty(dr["shortname"].ToString()))
{
obj.shortName = dr["shortname"].ToString();
}
else
{
obj.shortName = "";
}
//if (!string.IsNullOrEmpty(dr["categorycaption"].ToString()))
//{
// obj.categoryName = dr["categorycaption"].ToString();
//}
//else
//{
// obj.categoryName = "";
//}
if (!string.IsNullOrEmpty(dr["file_attachment_code"].ToString()))
{
obj.fileAttachmentCode = dr["file_attachment_code"].ToString();
}
else
{
obj.fileAttachmentCode = "";
}
list.list.Add(obj);
}
}
using (DataTable dt = ds.Tables[1])
{
foreach (DataRow dr in dt.Rows)
{
Category_Model model = new Category_Model();
if (!string.IsNullOrEmpty(dr["category_name"].ToString()))
{
model.categoryName = dr["category_name"].ToString();
}
else
{
model.categoryName = "";
}
if (!string.IsNullOrEmpty(dr["category_desc"].ToString()))
{
model.categoryDesc = dr["category_desc"].ToString();
}
else
{
model.categoryDesc = "";
}
if (!string.IsNullOrEmpty(dr["category_id"].ToString()))
{
model.categoryId = Convert.ToInt32(dr["category_id"]);
}
else
{
model.categoryId = 0;
}
list.categoryList.Add(model);
}
}
}
list.message = "fetched";
}
catch (Exception ex)
{
list.message = ex.Message;
}
return(list);
}
public Get_Post_List SearchService(string searchStr)
{
string status = "failed";
Get_Post_List list = new Get_Post_List();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
DataSet ds = new DataSet();
con.Open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@strSearch", searchStr);
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmpprcsearch", param);
foreach (DataTable dt in ds.Tables)
{
foreach (DataRow dr in dt.Rows)
{
Post_Model obj = new Post_Model();
if (!string.IsNullOrEmpty(dr["post_id"].ToString()))
{
obj.postId = Convert.ToInt32(dr["post_id"].ToString());
}
else
{
obj.postId = 0;
}
if (!string.IsNullOrEmpty(dr["post_url"].ToString()))
{
obj.postUrl = dr["post_url"].ToString();
}
else
{
obj.postUrl = "";
}
if (!string.IsNullOrEmpty(dr["file_name"].ToString()))
{
obj.postIconImage = dr["file_name"].ToString();
}
else
{
obj.postIconImage = "";
}
if (!string.IsNullOrEmpty(dr["file_path"].ToString()))
{
obj.postIconImagePath = dr["file_path"].ToString();
}
else
{
obj.postIconImagePath = "";
}
if (!string.IsNullOrEmpty(dr["category_name"].ToString()))
{
obj.category = dr["category_name"].ToString();
}
else
{
obj.category = "";
}
if (!string.IsNullOrEmpty(dr["seo_url"].ToString()))
{
obj.seoUrl = dr["seo_url"].ToString();
}
else
{
obj.seoUrl = "";
}
if (!string.IsNullOrEmpty(dr["post_category"].ToString()))
{
obj.categoryName = dr["post_category"].ToString();
}
else
{
obj.categoryName = "";
}
list.list.Add(obj);
}
}
}
list.message = "fetched";
}
catch (Exception ex)
{
list.message = ex.Message;
}
return(list);
}
public Get_Post_List PostGetAll(int pageIndex)
{
string status = "failed";
Get_Post_List list = new Get_Post_List();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString()))
{
DataSet dset = new DataSet();
con.Open();
SqlParameter[] param = new SqlParameter[3];
dset = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmp_prc_getPostData", param);
DataTable dtable = Post_Service.SetPgination(dset, pageIndex);
//DataTable dtable = dset.Tables[0];
using (DataTable dt = dtable)
{
foreach (DataRow dr in dt.Rows)
{
Post_Model obj = new Post_Model();
if (!string.IsNullOrEmpty(dr["post_id"].ToString()))
{
obj.postId = Convert.ToInt32(dr["post_id"].ToString());
}
else
{
obj.postId = 0;
}
if (!string.IsNullOrEmpty(dr["post_url"].ToString()))
{
obj.postUrl = dr["post_url"].ToString();
}
else
{
obj.postUrl = "";
}
if (!string.IsNullOrEmpty(dr["file_name"].ToString()))
{
obj.postIconImage = dr["file_name"].ToString();
}
else
{
obj.postIconImage = "";
}
if (!string.IsNullOrEmpty(dr["file_path"].ToString()))
{
obj.postIconImagePath = dr["file_path"].ToString();
}
else
{
obj.postIconImagePath = "";
}
if (!string.IsNullOrEmpty(dr["category_name"].ToString()))
{
obj.category = dr["category_name"].ToString();
}
else
{
obj.category = "";
}
if (!string.IsNullOrEmpty(dr["seo_url"].ToString()))
{
obj.seoUrl = dr["seo_url"].ToString();
}
else
{
obj.seoUrl = "";
}
if (!string.IsNullOrEmpty(dr["post_category"].ToString()))
{
obj.categoryName = dr["post_category"].ToString();
}
else
{
obj.categoryName = "";
}
list.list.Add(obj);
}
}
using (DataTable dt = dset.Tables[1])
{
foreach (DataRow dr in dt.Rows)
{
PostCount_Model countObj = new PostCount_Model();
if (!string.IsNullOrEmpty(dr["category_id"].ToString()))
{
countObj.categoryId = Convert.ToInt32(dr["category_id"]);
}
else
{
countObj.categoryId = 0;
}
if (!string.IsNullOrEmpty(dr["category"].ToString()))
{
countObj.category = dr["category"].ToString();
}
else
{
countObj.category = "";
}
if (!string.IsNullOrEmpty(dr["no_of_posts"].ToString()))
{
countObj.noOfPosts = Convert.ToInt32(dr["no_of_posts"]);
}
else
{
countObj.noOfPosts = 0;
}
list.postCountList.Add(countObj);
}
}
}
list.message = "fetched";
}
catch (Exception ex)
{
list.message = ex.Message;
}
return(list);
}
