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 string DeleteUser(string DeleteID)
{
string Str = "刪除失敗";
try
{
if (!string.IsNullOrWhiteSpace(DeleteID))
{
string[] DeleteIDList = null;
DeleteID = DeleteID.Replace("jqg_grid_gb1_", "").TrimEnd(',');
DeleteIDList = DeleteID.Split(',');
foreach (var item in DeleteIDList)
{
Models.UserManagement User = _db.MXIC_UserManagements.Where(x => x.DeleteID.ToString() == item).FirstOrDefault();
//User.UserDisable = false;
_db.MXIC_UserManagements.Remove(User);
}
_db.SaveChanges();
Str = "刪除成功";
}
else
{
Str = "刪除失敗!請勾選刪除資料。";
}
}
catch (Exception e)
{
Str = e.ToString();
}
return(Str);
}
//
// 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));
}
public string AddUser(string DepNo, string DepName, string UserID, string UserName, string Admin, string PassWord)
{
string Str = "新增成功";
if (!string.IsNullOrWhiteSpace(DepNo) && !string.IsNullOrWhiteSpace(DepName) && !string.IsNullOrWhiteSpace(UserID) && !string.IsNullOrWhiteSpace(UserName) && !string.IsNullOrWhiteSpace(PassWord))
{
var OriginalUser = _db.MXIC_UserManagements.Where(x => x.UserID == UserID);
if (OriginalUser.Any())
{
Str = "此人員編號已存在";
}
else
{
//SHA1加密
string Hash = GetSHA1.GetSHA1Hash(PassWord);
var AddUser = new Models.UserManagement()
{
UserListID = Guid.NewGuid(),
DepNo = DepNo,
DepName = DepName,
UserID = UserID,
UserName = UserName,
Admin = Admin,
PassWord = Hash,
UserDisable = true,
EditID = Guid.NewGuid(),
DeleteID = Guid.NewGuid()
};
_db.MXIC_UserManagements.Add(AddUser);
_db.SaveChanges();
}
}
else
{
Str = "新增失敗，請輸入所有資料。";
}
return(Str);
}
