public static List <UserActivityDTO> getUserActivity(string user_id)
{
List <UserActivityDTO> personaAttributeList = new List <UserActivityDTO>();
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_get_userActivity", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@user_id", SqlDbType.Int);
command.Parameters["@user_id"].Value = user_id;
command.Connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
UserActivityDTO userActivity = new UserActivityDTO();
userActivity.user_id = rdr["user_id"].ToString();
userActivity.task_id = rdr["task_id"].ToString();
userActivity.isConfirmed = rdr["isConfirmed"].ToString();
userActivity.confirm_date = rdr["confirm_date"].ToString();
userActivity.task_name = rdr["task_name"].ToString();
userActivity.stage_name = rdr["stage_name"].ToString();
userActivity.stage_id = rdr["stage_id"].ToString();
userActivity.process_id = rdr["process_id"].ToString();
userActivity.process_name = rdr["process_name"].ToString();
userActivity.isConfirmation = rdr["isConfirmation"].ToString();
personaAttributeList.Add(userActivity);
}
};
return(personaAttributeList);
}
UserActivityDTO ReadUserActivityDTO([NotNull] IDataRecord r)
{
UserActivityDTO x = new UserActivityDTO();
x.UserActivityId = (int) r["UserActivityId"];
x.UserId = (int) r["UserId"];
x.IsChangePsw = (bool) r["IsChangePsw"];
x.CreatedDate = (DateTime) r["CreatedDate"];
x.RawUrl = GetNullableRef<string>(r["RawUrl"]);
x.Browser = GetNullableRef<string>(r["Browser"]);
x.UserHostAddress = GetNullableRef<string>(r["UserHostAddress"]);
x.IsPostBack = (bool) r["IsPostBack"];
PostReadUserActivityDTO(x,r);
return x;
}
