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