public IActionResult update(string[] getitem, int getuserid, string UserName, string UserPassword, string FirstName, string LastName, string UserEmail, string DepID, string Status)
{
var identity = (ClaimsIdentity)User.Identity;
IEnumerable <Claim> claims = identity.Claims;
var userLogin = claims.FirstOrDefault();
var result = 1;
var UserId = "";
if (DepID == null)
{
result = 0;
}
else
{
switch (Status)
{
default:
Status = "I";
break;
case "Active":
Status = "A";
break;
case "Inactive":
Status = "I";
break;
}
//check edit m_UserMaster
var usermaster = _context.m_UserMaster.FirstOrDefault(u => u.UserId == getuserid);
usermaster.UserName = UserName;
//usermaster.UserPassword = HelperClass.EncodePassword(UserPassword, "P@ssw0rd");
usermaster.FirstName = FirstName;
usermaster.LastName = LastName;
usermaster.UserEmail = UserEmail;
usermaster.DepID = DepID;
usermaster.Status = Status;
usermaster.TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
usermaster.LastSignedin = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
usermaster.ModifyBy = userLogin.Value;
_context.m_UserMaster.Update(usermaster);
_context.SaveChanges();
var m_UM = _context.m_UserMaster.Where(u => u.UserId == getuserid).ToList();
//result = m_UM;
UserId = Convert.ToString(getuserid);
//end check edit m_UserMaster
//check edit UserPermiss
var permissquery = _context.m_UserPermiss.Where(m => m.UserId == UserId).ToList();
_context.m_UserPermiss.RemoveRange(permissquery);//delete ออกไปให้หมดก่อน
_context.SaveChanges();
for (var i = 0; i < getitem.Length; i++) //Loop insert m_UserPermiss
{
var insertper = new m_UserPermiss
{
UserId = UserId,
MenuIdentity = Convert.ToInt32(getitem[i].ToString()),
TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
CreateDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
ModifyBy = userLogin.Value
};
_context.m_UserPermiss.Add(insertper);
_context.SaveChanges();
}
result = 1;
}
return(Json(result));
}
public IActionResult Insert(string[] getitem, string UserName, string UserPassword, string FirstName, string LastName, string UserEmail, string DepID, string Status)
{
var identity = (ClaimsIdentity)User.Identity;
IEnumerable <Claim> claims = identity.Claims;
var userLogin = claims.FirstOrDefault();
//List<m_UserMaster> result = new List<m_UserMaster>();
var result = 0;
var UserId = "";
switch (Status)
{
default:
Status = "I";
break;
case "Active":
Status = "A";
break;
case "Inactive":
Status = "I";
break;
}
//check insert m_UserMaster
var m_UM = _context.m_UserMaster.Where(u => u.UserName == UserName).ToList(); //เช็คusername ก่อน insert m_UserMaster
if (m_UM.Count > 0) //username ซํ้า
{
result = 0;
}
else
{
var insertdep = new m_UserMaster //ถ้าไม่ซํ้าให้ insert User
{
UserName = UserName,
UserPassword = HelperClass.EncodePassword(UserPassword, "P@ssw0rd"),
FirstName = FirstName,
LastName = LastName,
UserEmail = UserEmail,
DepID = DepID,
Status = Status,
TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
CreateDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
LastSignedin = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
ModifyBy = userLogin.Value,
UserRoll = "USER"
};
_context.m_UserMaster.Add(insertdep);
_context.SaveChanges();
UserId = Convert.ToString(insertdep.UserId);
m_UM = _context.m_UserMaster.Where(u => u.UserId == Convert.ToInt32(UserId)).ToList();
result = 1;
//end check insert m_UserMaster
//default insert m_UserPermiss dashboard
//var dashboard = _context.MenuMaster.SingleOrDefault(d => d.MenuID == "DashBoard" && d.Parent_MenuID == "*");
//var defaultinsertper = new m_UserPermiss //default view dashboard
//{
// UserId = UserId,
// MenuIdentity = dashboard.MenuIdentity,
// TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
// CreateDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
// ModifyBy = userLogin.Value
//};
//_context.m_UserPermiss.Add(defaultinsertper);
//_context.SaveChanges();
//check insert m_UserPermiss
for (var a = 0; a < getitem.Length; a++)
{
var insertper = new m_UserPermiss
{
UserId = UserId,
MenuIdentity = Convert.ToInt32(getitem[a].ToString()),
TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
CreateDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
ModifyBy = userLogin.Value
};
_context.m_UserPermiss.Add(insertper);
_context.SaveChanges();
}
}//end insert m_UserPermiss
return(Json(result));
}
