public ReturnData AJAX_Updates(int idPageCategory, string name, string description)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
TBPageCategory pageCategory = db.TBPageCategories.Where(x => !x.Deflag && x.IDPageCategory == idPageCategory).FirstOrDefault();
if (pageCategory == null)
{
return(ReturnData.MessageFailed("Page Category not found", null));
}
pageCategory.Name = name;
pageCategory.Description = description;
pageCategory.DateLastUpdate = DateTime.Now;
db.SubmitChanges();
return(ReturnData.MessageSuccess("Data updated successfully", null));
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(ReturnData.MessageFailed(ex.Message, null));
}
}
public ReturnData AJAX_Insert(string name, string description, int idPage)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
if (!ValidationName_Insert(db, name, idPage))
{
return(ReturnData.MessageFailed(name + " already exists.", null));
}
TBPageCategory _newData = new TBPageCategory
{
IDPage = idPage,
Name = name,
Description = description,
Deflag = false,
DateInsert = DateTime.Now,
DateLastUpdate = DateTime.Now
};
db.TBPageCategories.InsertOnSubmit(_newData);
db.SubmitChanges();
if (_newData != null)
{
return(ReturnData.MessageSuccess(name + " has been successfully inserted.", null));
}
return(ReturnData.MessageFailed(name + " failed to insert.", null));
}
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(ReturnData.MessageFailed(ex.Message, null));
}
}
public ReturnData AJAX_Update_Categories(int idPost, int idPage, int[] categories)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
if (categories.Count() == 0)
{
return(ReturnData.MessageFailed("No selected category to insert.", null));
}
dynamic _post = Dynamic_GetDetail_Information(db, idPost);
if (_post == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
TBPageCategory_Post[] _oldCategories = GetData_PageCategory_ByIDPost(db, _post.IDPost);
List <TBPageCategory> _pageCategories = new List <TBPageCategory>();
Class_Page_Category _pageCategory = new Class_Page_Category();
foreach (int item in categories)
{
if (_oldCategories.AsEnumerable().Where(x => x.IDPageCategory == item).FirstOrDefault() == null)
{
TBPageCategory _newData = _pageCategory.GetDetail(db, item);
if (_pageCategories == null)
{
return(ReturnData.MessageFailed("Some category does not exists.", null));
}
_pageCategories.Add(_newData);
}
}
foreach (TBPageCategory_Post item in _oldCategories)
{
dynamic _item = categories.Where(x => x == item.IDPageCategory).FirstOrDefault();
if (_item == 0)
{
db.TBPageCategory_Posts.DeleteOnSubmit(item);
}
}
db.SubmitChanges();
foreach (dynamic item in _pageCategories)
{
TBPageCategory_Post _newData = GetData_PageCategory_ByIDPost(db, idPost).Where(x => x.IDPageCategory == item.IDPageCategory).FirstOrDefault();
if (_newData == null)
{
_newData = new TBPageCategory_Post
{
IDPost = idPost,
IDPageCategory = item.IDPageCategory,
};
db.TBPageCategory_Posts.InsertOnSubmit(_newData);
}
}
db.SubmitChanges();
Dictionary <string, dynamic> _result = new Dictionary <string, dynamic>();
_result.Add("SelectedCategories", Dynamic_GetData_PageCategories_ByIDPost(db, idPost));
_result.Add("TreeCategories", GetTree_PageCategory(db, idPage, idPost));
return(ReturnData.MessageSuccess(categories.Count() + " categories has been successfully updated.", _result));
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(ReturnData.MessageFailed(ex.Message, null));
}
}
