public void InsertSystemLog(NhatKyDTO _nhatKyDTO)
{
List <SqlParameter> paramlist = new List <SqlParameter>();
SqlParameter item = new SqlParameter();
item = new SqlParameter("@MaNguoiDung", SqlDbType.NChar)
{
Value = _nhatKyDTO.MaNguoiDung
};
paramlist.Add(item);
item = new SqlParameter("@ThoiGian", SqlDbType.DateTime)
{
Value = _nhatKyDTO.ThoiGian
};
paramlist.Add(item);
item = new SqlParameter("@ChucNang", SqlDbType.NVarChar)
{
Value = _nhatKyDTO.ChucNang
};
paramlist.Add(item);
item = new SqlParameter("@HanhDong", SqlDbType.NVarChar)
{
Value = _nhatKyDTO.HanhDong
};
paramlist.Add(item);
item = new SqlParameter("@ThoiGianSearch", SqlDbType.NVarChar)
{
Value = _nhatKyDTO.ThoiGianSearch
};
paramlist.Add(item);
this.dbHelper.ExecuteNonQuery("NhatKy_SetDateLoginUser", paramlist);
}
public DataTable NhatKyHeThong_Search(NhatKyDTO _nhatKyDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@ThoiGianSearch", _nhatKyDTO.ThoiGianSearch)
};
return(base.executeNonQuerya("NhatKyHeThong_Search", sqlParams));
}
public void NhatKyHeThong_DeleteByThoiGian(NhatKyDTO _nhatKyDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@ThoiGianSearch", _nhatKyDTO.ThoiGianSearch)
};
base.Procedure("NhatKyHeThong_deleteByThoiGian", sqlParams);
}
public DataTable NhatKyHeThong_ThoiGian(NhatKyDTO _nhatKyDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@FromDate", _nhatKyDTO.FromDate),
new SqlParameter("@ToDate", _nhatKyDTO.ToDate)
};
return(base.executeNonQuerya("NhatKyHeThong_getallByThoiGian", sqlParams));
}
public NhatKyDTO SelectLastLoginUser(string _MaNguoiDung)
{
List <SqlParameter> paramlist = new List <SqlParameter>();
SqlParameter item = new SqlParameter();
item = new SqlParameter("@MaNguoiDung", SqlDbType.NChar)
{
Value = _MaNguoiDung
};
paramlist.Add(item);
SqlDataReader reader = null;
reader = this.dbHelper.ExecuteQuery("NhatKy_GetLastLoginUser", paramlist);
if (reader.Read())
{
NhatKyDTO ydto = new NhatKyDTO(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2).ToString(), reader.GetString(3), reader.GetString(4), DateTime.Now.ToString());
reader.Close();
return(ydto);
}
reader.Close();
return(null);
}
public DataTable NhatKyHeThongThoiGian(NhatKyDTO _nhatKyDTO)
{
return(this._nhatKyDAL.NhatKyHeThong_ThoiGian(_nhatKyDTO));
}
public DataTable NhatKyHeThongSearch(NhatKyDTO _nhatKyDTO)
{
return(this._nhatKyDAL.NhatKyHeThong_Search(_nhatKyDTO));
}
public void NhatKyHeThongDeleteByThoiGian(NhatKyDTO _nhatKyDTO)
{
this._nhatKyDAL.NhatKyHeThong_DeleteByThoiGian(_nhatKyDTO);
}
public void NhatKyDelete(NhatKyDTO _nhatKyDTO)
{
this._nhatKyDAL.NhatKy_Delete(_nhatKyDTO);
}
public void SetSystemLog(NhatKyDTO _nhatKyDTO)
{
this._nguoiDungDAL.InsertSystemLog(_nhatKyDTO);
}
public void NhatKy_Delete(NhatKyDTO _nhatKyDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
base.Procedure("NhatKyHeThong_deleteAll", sqlParams);
}
public void SetSystemLog(NhatKyDTO _nhatKyDTO)
{
this._userDAL.InsertSystemLog(_nhatKyDTO);
}
