public int DeleteById(int ID)
{
int nResult = 0;
cAdv objDAL = new cAdv();
try
{
objDAL.LoadByPrimaryKey(ID);
objDAL.MarkAsDeleted();
objDAL.Save();
nResult = ID;
}
catch
{
nResult = 0;
}
return nResult;
}
public int Insert()
{
int nResult = 0;
cAdv objInfor = new cAdv();
try
{
objInfor.AddNew();
this.MappingData(objInfor);
objInfor.Save();
nResult = 1;
}
catch
{
nResult = 0;
}
return nResult;
}
public DataTable SearchAll()
{
DataTable tbResult = new DataTable();
cAdv objDAL = new cAdv();
tbResult = objDAL.SearchAll();
return tbResult;
}
public DataTable Search(int ItemView, string Title, int AdvPositionID, int AdvTypeID, int Status, int PageIndex, int PageSize, ref int PageCount)
{
DataTable tbResult = new DataTable();
cAdv objDAL = new cAdv();
tbResult = objDAL.Search( ItemView, Title, AdvPositionID, AdvTypeID, Status, PageIndex, PageSize, ref PageCount );
return tbResult;
}
public void LoadById(int ID)
{
cAdv objDAL = new cAdv();
objDAL.LoadByPrimaryKey(ID);
ConvertData(objDAL);
}
private void MappingData(cAdv objInfor)
{
objInfor.PartnerName = Data.PartnerName;
objInfor.AdvURL = Data.AdvURL;
objInfor.AdvTypeID = Data.AdvTypeID;
objInfor.AdvPositionID = Data.AdvPositionID;
objInfor.Status = Data.Status;
objInfor.Priority = Data.Priority;
objInfor.CreatedDate = Data.CreatedDate;
objInfor.ExpiredDate = Data.ExpiredDate;
objInfor.Description = Data.Description;
objInfor.AdvFile = Data.AdvFile;
}
private void ConvertData(cAdv objInfor)
{
Data.PartnerName = objInfor.PartnerName;
Data.AdvURL = objInfor.AdvURL;
Data.AdvTypeID = objInfor.AdvTypeID;
Data.AdvPositionID = objInfor.AdvPositionID;
Data.Status = objInfor.Status;
Data.Priority = objInfor.Priority;
//Data.CreatedDate = objInfor.CreatedDate;
//Data.ExpiredDate = objInfor.ExpiredDate;
Data.Description = objInfor.Description;
try { Data.AdvFile = objInfor.AdvFile; }
catch { Data.AdvFile = ""; }
}
public int UpdateStatus(int ID, int Status)
{
int nResult = 0;
cAdv objDAL = new cAdv();
try
{
objDAL.LoadByPrimaryKey(ID);
objDAL.Status = Status;
objDAL.Save();
nResult = objDAL.AdvID;
}
catch
{
nResult = 0;
}
return nResult;
}
public int UpdatePriority(int AdvID, int Priority)
{
int nResult = 0;
cAdv objDAL = new cAdv();
try
{
objDAL.LoadByPrimaryKey(AdvID);
objDAL.Priority = Priority;
objDAL.Save();
nResult = objDAL.AdvID;
}
catch
{
nResult = 0;
}
return nResult;
}
public int Update(int ID)
{
int nResult = 0;
cAdv objInfor = new cAdv();
try
{
objInfor.LoadByPrimaryKey(ID);
this.MappingData(objInfor);
objInfor.Save();
nResult = ID;
}
catch
{
nResult = 0;
}
return nResult;
}