Пример #1
0
 public DataTable GetAll()
 {
     DataTable tbResult = new DataTable();
     cNews objDAL = new cNews();
     tbResult = objDAL.GetAll();
     return tbResult;
 }
Пример #2
0
 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;
 }
Пример #3
0
 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;
 }
Пример #4
0
 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;
 }
Пример #5
0
 public void LoadById(int ID)
 {
     cNews objDAL = new cNews();
     objDAL.LoadByPrimaryKey(ID);
     ConvertData(objDAL);
 }
Пример #6
0
        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 = ""; }
        }
Пример #7
0
        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 = ""; }
        }
Пример #8
0
        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;
        }
Пример #9
0
        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;
        }
Пример #10
0
 //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;
 }