public ActionResult UserProfile(string UserNo) { var dal = new DAL.DAL(); var user = @"select * from Users_Auth where EMPLOYEE_ID ='" + UserNo + "'"; var ds_user = dal.GetDataSet(user); var listUser = new List <Models.DataModel.ModelUsersAuth>(); if (ds_user.Tables[0].Rows.Count > 0) { foreach (System.Data.DataRow druser in ds_user.Tables[0].Rows) { var status_Adduser = new Models.DataModel.ModelUsersAuth() { FIRSTNAME = druser["FIRSTNAME"].ToString(), LASTNAME = druser["LASTNAME"].ToString() }; listUser.Add(status_Adduser); } } var model = new Models.UserManagement() { ListUser = listUser }; return(View(model)); }
public User() { //ds = dal.GetDataSet("select * from Users_Auth"); //DataTable dt = ds.Tables[0]; //if (dt != null) //{ // var listUsers = new List<Models.DataModel.ModelUsersAuth>(); // foreach (System.Data.DataRow dr in dt.Rows) // { // var user = new Models.DataModel.ModelUsersAuth() // { // //CREATE_BY = dr["CREATE_BY"].ToString(), // //CREATE_DATE = Convert.ToDateTime(dr["CREATE_DATE"]), // FIRSTNAME = dr["FIRSTNAME"].ToString() // }; // listUsers.Add(user); // } //} try { using (var conn = new OracleConnection(dal.ConnectionString)) { conn.Open(); using (OracleCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select * from Users_Auth"; using (OracleDataReader reader = cmd.ExecuteReader()) { var dataTable = new DataTable(); dataTable.Load(reader); if (dataTable != null) { var listUsers = new List<Models.DataModel.ModelUsersAuth>(); foreach (System.Data.DataRow dr in dataTable.Rows) { var user = new Models.DataModel.ModelUsersAuth() { //CREATE_BY = dr["CREATE_BY"].ToString(), //CREATE_DATE = Convert.ToDateTime(dr["CREATE_DATE"]), FIRSTNAME = dr["FIRSTNAME"].ToString() }; listUsers.Add(user); } } Console.WriteLine("VisibleFieldCount: {0}", reader.VisibleFieldCount); Console.WriteLine("HiddenFieldCount: {0}", reader.HiddenFieldCount); } } } } catch (Exception ex) { Console.WriteLine("Error:{0}", ex.Message); } }//user
// // GET: /Admin/ public ActionResult UserManagement() { var dal = new DAL.DAL(); var ds = dal.GetDataSet("SELECT A.EMPLOYEE_ID, A.FIRSTNAME, A.LASTNAME, A.EMAIL, R.ROLE_NAME, G.GROUP_NAME, A.CREATE_DATE, A.CREATE_BY, A.ROLE_ID FROM USERS_AUTH A LEFT JOIN USERS_GROUP G ON A.GROUP_ID = G.GROUP_ID LEFT JOIN USERS_ROLE R ON A.ROLE_ID = R.ROLE_ID ORDER BY CREATE_DATE DESC"); var dt = ds.Tables[0]; var listUsers = new List <Models.DataModel.ModelUsersAuth>(); foreach (System.Data.DataRow dr in dt.Rows) { var user = new Models.DataModel.ModelUsersAuth() { EMPLOYEE_ID = dr["EMPLOYEE_ID"].ToString(), FIRSTNAME = dr["FIRSTNAME"].ToString(), LASTNAME = dr["LASTNAME"].ToString(), EMAIL = dr["EMAIL"].ToString(), ROLE_ID = Convert.ToInt32(dr["ROLE_ID"].ToString()), ROLE_NAME = dr["ROLE_NAME"].ToString(), CREATE_DATE = dr["CREATE_DATE"].GetDate(),// Convert.ToDateTime(dr["CREATE_DATE"].ToString()), CREATE_BY = dr["CREATE_BY"].ToString(), GROUP_NAME = dr["GROUP_NAME"].ToString(), //GROUP_ID = Convert.ToInt32(dr["GROUP_ID"].ToString()) }; listUsers.Add(user); } var d_role = dal.GetDataSet("select ROLE_ID ,ROLE_NAME from USERS_ROLE"); var dt_role = d_role.Tables[0]; var listRole = new List <Models.DataModel.ModelUsersRole>(); foreach (System.Data.DataRow drole in dt_role.Rows) { var role = new Models.DataModel.ModelUsersRole() { ROLE_ID = Convert.ToInt32(drole["ROLE_ID"].ToString()), ROLE_NAME = drole["ROLE_NAME"].ToString() }; listRole.Add(new Models.DataModel.ModelUsersRole { ROLE_NAME = role.ROLE_NAME, ROLE_ID = role.ROLE_ID }); } ViewBag.seRoleEdit = listRole; ViewBag.seCreateRole = listRole; var model = new Models.UserManagement() { ModelUsersAuth = listUsers, ModelUsersRole = listRole }; return(View(model)); }