/// <summary>
/// Kiểm tra và thêm mới NewsCategory
/// </summary>
/// <param name="entity">Entity</param>
/// <returns>Int32: ID của NewsCategory Mới Thêm Vào</returns>
public static Int32 Add(NewsCategoryEntity entity)
{
checkLogic(entity);
checkDuplicate(entity, false);
checkFK(entity);
return NewsCategoryDAL.Add(entity);
}
/// <summary>
/// Kiểm tra và chỉnh sửa NewsCategory
/// </summary>
/// <param name="entity">NewsCategoryEntity</param>
/// <returns>bool:kết quả thực hiện</returns>
public static bool Edit(NewsCategoryEntity entity)
{
checkExist(entity);
checkLogic(entity);
checkDuplicate(entity, true);
checkFK(entity);
return NewsCategoryDAL.Edit(entity);
}
/// <summary> setups the sync logic for member _newsCategory</summary>
/// <param name="relatedEntity">Instance to set as the related entity of type entityType</param>
private void SetupSyncNewsCategory(IEntityCore relatedEntity)
{
if (_newsCategory != relatedEntity)
{
DesetupSyncNewsCategory(true, true);
_newsCategory = (NewsCategoryEntity)relatedEntity;
this.PerformSetupSyncRelatedEntity(_newsCategory, new PropertyChangedEventHandler(OnNewsCategoryPropertyChanged), "NewsCategory", MonoSoftware.MonoX.DAL.RelationClasses.StaticNewsCategoryTemplateRelations.NewsCategoryEntityUsingIdStatic, true, new string[] { });
}
}
protected NewsCategoryTemplateEntity(SerializationInfo info, StreamingContext context) : base(info, context)
{
if (SerializationHelper.Optimization != SerializationOptimization.Fast)
{
_newsCategory = (NewsCategoryEntity)info.GetValue("_newsCategory", typeof(NewsCategoryEntity));
if (_newsCategory != null)
{
_newsCategory.AfterSave += new EventHandler(OnEntityAfterSave);
}
this.FixupDeserialization(FieldInfoProviderSingleton.GetInstance());
}
// __LLBLGENPRO_USER_CODE_REGION_START DeserializationConstructor
// __LLBLGENPRO_USER_CODE_REGION_END
}
public static Int32 Add(int iUserID,string sTitle, string sDesc, string sImage, string sTag, DateTime tNgaydang, string sContent, bool bVerified, params int[] arrCategory)
{
NewsEntity entity = new NewsEntity();
entity.sTitle = sTitle;
entity.sDesc = sDesc;
entity.sImage = sImage;
entity.sTag = sTag;
entity.tDate = tNgaydang;
entity.sContent = sContent;
entity.bVerified = bVerified;
entity.iViews = 0;
entity.iUserID = iUserID;
checkLogic(entity);
checkDuplicate(entity, true);
int iNewsID = NewsDAL.Add(entity);
foreach (int iCatID in arrCategory)
{
NewsCategoryEntity oNewsCat = new NewsCategoryEntity();
oNewsCat.iNewsID = iNewsID;
oNewsCat.iCategoryID = iCatID;
NewsCategoryDAL.Add(oNewsCat);
}
return iNewsID;
}
/// <summary> Removes the sync logic for member _newsCategory</summary>
/// <param name="signalRelatedEntity">If set to true, it will call the related entity's UnsetRelatedEntity method</param>
/// <param name="resetFKFields">if set to true it will also reset the FK fields pointing to the related entity</param>
private void DesetupSyncNewsCategory(bool signalRelatedEntity, bool resetFKFields)
{
this.PerformDesetupSyncRelatedEntity(_newsCategory, new PropertyChangedEventHandler(OnNewsCategoryPropertyChanged), "NewsCategory", MonoSoftware.MonoX.DAL.RelationClasses.StaticNewsCategoryTemplateRelations.NewsCategoryEntityUsingIdStatic, true, signalRelatedEntity, "NewsCategoryTemplate", false, new int[] { (int)NewsCategoryTemplateFieldIndex.Id });
_newsCategory = null;
}
/// <summary>
/// Update dữ liệu bảng NewsCategory
/// </summary>
/// <param name="newsID">int: Tin tức ID</param>
/// <param name="arrCategory">int[]: Mảng số nguyên Nhóm tin ID</param>
private static void updateNewsCategory(int newsID, params int[] arrCategory)
{
List<NewsCategoryEntity> lstNewsCategory = NewsCategoryDAL.GetByiNewsID(newsID);
foreach (int iCategoryID in arrCategory)
{
try
{
lstNewsCategory.ForEach(
delegate(NewsCategoryEntity oNewsCategory)
{
if (iCategoryID != oNewsCategory.iCategoryID)
{
NewsCategoryDAL.Remove(oNewsCategory.iNewsCategoryID);
}
}
);
}
catch { }
}
lstNewsCategory.Clear();
foreach (int iCategoryID in arrCategory)
{
try
{
NewsCategoryEntity newsCatEntity = new NewsCategoryEntity();
newsCatEntity.iNewsID = newsID;
newsCatEntity.iCategoryID = iCategoryID;
NewsCategoryDAL.Add(newsCatEntity);
}
catch { }
}
}
/// <summary>
/// Kiểm tra logic Entity
/// </summary>
/// <param name="entity">NewsCategoryEntity: entity</param>
private static void checkLogic(NewsCategoryEntity entity)
{
if (entity.iCategoryID < 0)
throw new Exception(EX_ICATEGORYID_INVALID);
if (entity.iNewsID < 0)
throw new Exception(EX_INEWSID_INVALID);
}
/// <summary>
/// Kiểm tra tồn tại khóa ngoại
/// </summary>
/// <param name="entity">NewsCategoryEntity:entity</param>
private static void checkFK(NewsCategoryEntity entity)
{
CategoryEntity oCategory = CategoryDAL.GetOne(entity.iCategoryID);
if (oCategory!=null)
{
throw new Exception("Không tìm thấy chủ đề này");
}
NewsEntity oNews = NewsDAL.GetOne(entity.iNewsID);
if (oNews!=null)
{
throw new Exception("Không tìm thấy tin tức này");
}
}
private static void checkExist(NewsCategoryEntity entity)
{
NewsCategoryEntity oNewsCategory=NewsCategoryDAL.GetOne(entity.iNewsCategoryID);
if(oNewsCategory==null)
throw new Exception(EX_NOT_EXIST);
}
/// <summary>
/// Kiểm tra trùng lặp bản ghi
/// </summary>
/// <param name="entity">NewsCategoryEntity: NewsCategoryEntity</param>
private static void checkDuplicate(NewsCategoryEntity entity,bool CheckInsert)
{
List<NewsCategoryEntity> list = NewsCategoryDAL.GetAll();
if (list.Exists(
delegate(NewsCategoryEntity oldEntity)
{
bool result= oldEntity.iCategoryID == entity.iCategoryID && oldEntity.iNewsID == entity.iNewsID;
if (!CheckInsert)
result = result && oldEntity.iNewsCategoryID != entity.iNewsCategoryID;
return result;
}
))
{
list.Clear();
throw new Exception(EX_NEWSCAT_EXISTED);
}
}
/// <summary>
/// Kiểm tra và xoá NewsCategory
/// </summary>
/// <param name="entity">NewsCategoryEntity</param>
/// <returns>bool:kết quả thực hiện</returns>
public static bool Remove(NewsCategoryEntity entity)
{
checkExist(entity);
checkFK(entity);
return NewsCategoryDAL.Remove(entity.iNewsCategoryID);
}
