/// <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); }