public IActionResult insert(string DepDesc, DateTime CreateDate, string DepID, string[] getitem)
{
var identity = (ClaimsIdentity)User.Identity;
IEnumerable <Claim> claims = identity.Claims;
var userID = claims.FirstOrDefault();
var insertdep = new m_Dep
{
DepID = DepID,
DepDesc = DepDesc,
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 = userID.Value
};
_context.m_Dep.Add(insertdep);
_context.SaveChanges();
for (var i = 0; i < getitem.Length; i++)
{
var insertdepmenu = new m_DepMenu
{
DepID = DepID,
//DepDesc = DepDesc,
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 = userID.Value
};
_context.m_DepMenu.Add(insertdepmenu);
_context.SaveChanges();
}
return(Json(_context.m_Dep));
}
public IActionResult Upsert(string DepDesc, DateTime CreateDate, string DepID, string[] getitem)
{
var identity = (ClaimsIdentity)User.Identity;
IEnumerable <Claim> claims = identity.Claims;
var userID = claims.FirstOrDefault();
var menu_dep = _context.m_DepMenu.Where(m => m.DepID == DepID).ToList();
_context.m_DepMenu.RemoveRange(menu_dep); //delete ออกไปให้หมดก่อน
_context.SaveChanges();
var department = _context.m_Dep.FirstOrDefault(d => d.DepID == DepID);
department.DepDesc = DepDesc;
department.TransDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
department.ModifyBy = userID.Value;
_context.m_Dep.Update(department);
_context.SaveChanges();
for (var i = 0; i < getitem.Length; i++)
{
var insertdepmenu = new m_DepMenu
{
DepID = DepID,
//DepDesc = DepDesc,
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 = userID.Value
};
_context.m_DepMenu.Add(insertdepmenu);
_context.SaveChanges();
}
return(Json(_context.m_DepMenu));
}
