public static List<PostDataModel> Filter(PostDataModel model)
{
List<PostDataModel> items = new List<PostDataModel>();
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[Plenum.Data.Constants.AppSetting]);
string FilterSelect = "" +
" SELECT ID, Title, Description, SkillPageID, FromExpertID, DateCreated " +
" FROM post " +
" WHERE ID LIKE '%" + model.ID.ToString() + "%'";
MySqlDataAdapter adapter = new MySqlDataAdapter(FilterSelect, connection);
adapter.SelectCommand.CommandType = CommandType.Text;
DataTable results = new DataTable();
adapter.Fill(results);
foreach (DataRow row in results.Rows)
{
PostDataModel item = MapItem(row);
items.Add(item);
}
return items;
}
public override int CreateOrUpdate(PostDataModel item)
{
if(item.ID == null){
item.DateCreated = DateTime.Now;
}
item.ID = base.CreateOrUpdate(item);
return Convert.ToInt32(item.ID);
}
public virtual int CreateOrUpdate(PostDataModel item)
{
if (item.ID > 0)
{
PostDAL.Update(item);
}
else
{
item.ID = PostDAL.Create(item);
}
return Convert.ToInt32(item.ID);
}
public static int Create(PostDataModel item)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[Plenum.Data.Constants.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_CreatePost", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramID = new MySqlParameter("pID", item.ID);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
MySqlParameter paramTitle = new MySqlParameter("pTitle", item.Title);
paramTitle.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramTitle);
MySqlParameter paramDescription = new MySqlParameter("pDescription", item.Description);
paramDescription.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramDescription);
MySqlParameter paramSkillPageID = new MySqlParameter("pSkillPageID", item.SkillPageID);
paramSkillPageID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramSkillPageID);
MySqlParameter paramFromExpertID = new MySqlParameter("pFromExpertID", item.FromExpertID);
paramFromExpertID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramFromExpertID);
MySqlParameter paramDateCreated = new MySqlParameter("pDateCreated", item.DateCreated);
paramDateCreated.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramDateCreated);
DataTable results = new DataTable();
adapter.Fill(results);
if (results.Rows.Count > 0)
{
return Convert.ToInt32(results.Rows[0]["ID"]);
}
else
{
throw new Exception("Error creating Post");
}
}
public virtual List<PostDataModel> Filter(PostDataModel model)
{
return PostDAL.Filter(model);
}
public static void Update(PostDataModel item)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[Plenum.Data.Constants.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_UpdatePost", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramID = new MySqlParameter("pID", item.ID);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
MySqlParameter paramTitle = new MySqlParameter("pTitle", item.Title);
paramTitle.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramTitle);
MySqlParameter paramDescription = new MySqlParameter("pDescription", item.Description);
paramDescription.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramDescription);
MySqlParameter paramSkillPageID = new MySqlParameter("pSkillPageID", item.SkillPageID);
paramSkillPageID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramSkillPageID);
MySqlParameter paramFromExpertID = new MySqlParameter("pFromExpertID", item.FromExpertID);
paramFromExpertID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramFromExpertID);
MySqlParameter paramDateCreated = new MySqlParameter("pDateCreated", item.DateCreated);
paramDateCreated.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramDateCreated);
DataTable results = new DataTable();
adapter.Fill(results);
}
public static PostDataModel MapItem(DataRow row)
{
PostDataModel item = null;
item = new PostDataModel();
if (row["ID"].GetType() != typeof(DBNull))
{
item.ID = Convert.ToInt32(row["ID"]);
}
if (row["Title"].GetType() != typeof(DBNull))
{
item.Title = Convert.ToString(row["Title"]);
}
if (row["Description"].GetType() != typeof(DBNull))
{
item.Description = Convert.ToString(row["Description"]);
}
if (row["SkillPageID"].GetType() != typeof(DBNull))
{
item.SkillPageID = Convert.ToInt32(row["SkillPageID"]);
}
if (row["FromExpertID"].GetType() != typeof(DBNull))
{
item.FromExpertID = Convert.ToInt32(row["FromExpertID"]);
}
if (row["DateCreated"].GetType() != typeof(DBNull))
{
item.DateCreated = Convert.ToDateTime(row["DateCreated"]);
}
return item;
}
public JsonResult Update(PostDataModel post)
{
PostBO.GetInstance().CreateOrUpdate(post);
return Json(new { success = true }, JsonRequestBehavior.AllowGet);
}
