public UserListsModel getUsers()
{
UserListsModel userlist = new UserListsModel();
using (SqlConnection conn = new SqlConnection(connection))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM [localb].[dbo].[mscrudgoalProfile] A WITH(NOLOCK) "
+ "JOIN [localb].[dbo].[mscrudgoal] B ON A.employeeID = B.employeeID ";
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
User users = new User();
users.employeeID = rdr["employeeID"].ToString();
users.fullname = rdr["firstname"].ToString() + ' ' + rdr["middlename"].ToString() + ' ' + rdr["lastname"].ToString();
users.registrationDate = Convert.ToDateTime(rdr["registDate"].ToString()).ToString("MMMM dd, yyyy");
userlist.Lists.Add(users);
}
}
else
{
ViewBag.msg = "No Employee's Registered";
}
}
}
return(userlist);
}
public ActionResult Index()
{
try
{
if (HttpContext.Session["eid"] != null)
{
UserProfileInfoModel userprofile = getProfile(Session["eid"].ToString());
Session["fname"] = userprofile.FirstName;
Session["lname"] = userprofile.LastName;
UserListsModel userlist = getUsers();
return(View("Index", userlist));
}
}
catch (Exception ex)
{
ViewBag.msg = ex.Message.ToString();
}
return(View("Login"));
}
