public DataTable GetAll()
{
DataTable tbResult = new DataTable();
cNews objDAL = new cNews();
tbResult = objDAL.GetAll();
return tbResult;
}
public int Insert()
{
int nResult = 0;
cNews objInfor = new cNews();
try
{
objInfor.AddNew();
this.MappingData(objInfor);
objInfor.Save();
nResult = objInfor.NewsID;
}
catch
{
nResult = 0;
}
return nResult;
}
public int DeleteById(int ID)
{
int nResult = 0;
cNews objDAL = new cNews();
try
{
objDAL.LoadByPrimaryKey(ID);
objDAL.MarkAsDeleted();
objDAL.Save();
nResult = ID;
}
catch
{
nResult = 0;
}
return nResult;
}
public DataTable Search(int ItemView,int ItemID, string Title, int NewsCatId, int Status,
int PageIndex, int PageSize, ref int PageCount)
{
DataTable tbResult = new DataTable();
cNews objDAL = new cNews();
tbResult = objDAL.Search(ItemView,ItemID, Title, NewsCatId, Status, PageIndex, PageSize, ref PageCount);
return tbResult;
}
public void LoadById(int ID)
{
cNews objDAL = new cNews();
objDAL.LoadByPrimaryKey(ID);
ConvertData(objDAL);
}
private void MappingData(cNews objInfor)
{
try { objInfor.Title = Data.Title;}
catch { objInfor.Title ="";}
try { objInfor.MainContent = Data.MainContent; }
catch { objInfor.MainContent = ""; }
try { objInfor.InitContent = Data.InitContent; }
catch { objInfor.InitContent = ""; }
objInfor.NewsCategoryID = Data.NewsCategoryID;
objInfor.Image = Data.Image;
objInfor.PostedDate = Data.PostedDate;
objInfor.Status = Data.Status;
objInfor.Priority = Data.Priority;
try { objInfor.Image2 = Data.Image2; }
catch { objInfor.Image2 = ""; }
}
private void ConvertData(cNews objInfor)
{
try { Data.Title = objInfor.Title; }
catch { Data.Title = ""; }
try { Data.MainContent = objInfor.MainContent; }
catch { Data.MainContent = ""; }
try { Data.InitContent = objInfor.InitContent; }
catch { Data.InitContent = ""; }
try { Data.NewsCategoryID = objInfor.NewsCategoryID; }
catch { Data.NewsCategoryID = -1; }
try { Data.Image = objInfor.Image; }
catch { Data.Image = ""; }
try { Data.PostedDate = objInfor.PostedDate; }
catch { Data.PostedDate = Convert.ToDateTime("01/01/2013"); }
try { Data.Status = objInfor.Status; }
catch { Data.Status = 0; }
try { Data.Priority = objInfor.Priority; }
catch { Data.Priority = 0; }
try { Data.Image2 = objInfor.Image2; }
catch { Data.Image2 = ""; }
}
public int UpdateStatus(int ID, int Status)
{
int nResult = 0;
cNews objDAL = new cNews();
try
{
objDAL.LoadByPrimaryKey(ID);
objDAL.Status = Status;
objDAL.Save();
nResult = objDAL.NewsID;
}
catch
{
nResult = 0;
}
return nResult;
}
public int UpdatePriority(int NewsID, int Priority)
{
int nResult = 0;
cNews objDAL = new cNews();
try
{
objDAL.LoadByPrimaryKey(NewsID);
objDAL.Priority = Priority;
objDAL.Save();
nResult = objDAL.NewsID;
}
catch
{
nResult = 0;
}
return nResult;
}
//Update nhung cai ma eNews Data dang nam giu thong qua cNews objInfor
public int Update(int ID)
{
int nResult = 0;
cNews objInfor = new cNews();
try
{
objInfor.LoadByPrimaryKey(ID);
this.MappingData(objInfor);
objInfor.Save();
nResult = ID;
}
catch
{
nResult = 0;
}
return nResult;
}