/// <summary>
/// lay danh sach tap tin trong quan ly cong viec
/// </summary>
/// <param name="clParam"></param>
/// <returns></returns>
public List <TapTinCongViecModels> SelectRows(TapTinCongViecModels clParam)
{
logger.Start("SelectRows");
List <TapTinCongViecModels> lstResult = new List <TapTinCongViecModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("cv_congviec_taptin.SelectRows", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <TapTinCongViecModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRows");
return(lstResult);
}
/// <summary>
/// cap nhat thong tin tap tin dinh kem
/// </summary>
/// <param name="clParam"></param>
/// <returns></returns>
public bool UpdateRow(TapTinCongViecModels clParam)
{
logger.Start("UpdateRow");
bool bResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("cv_congviec_taptin.UpdateRow", param);
sqlMap.CommitTransaction();
bResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
bResult = false;
logger.Error(ex.Message);
}
logger.End("UpdateRow");
return(bResult);
}
/// <summary>
/// them moi tap tin dinh kem
/// </summary>
/// <param name="clParam"></param>
/// <returns></returns>
public bool InsertRow(TapTinCongViecModels clParam)
{
logger.Start("InsertRow");
bool result = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
param["mataptin"] = DateTime.Now.ToLongTimeString().Replace(" ", "").Replace(":", "");
sqlMap.Insert("cv_congviec_taptin.InsertRow", param);
sqlMap.CommitTransaction();
result = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
result = false;
logger.Error(ex.Message);
}
logger.End("InsertRow");
return(result);
}
