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)); } }