private void SetViewBag(KanbanRequest data)
{
if (LoginInfo.RoleId == 2) //user manufacture
{
ViewBag.PartFGList = FrmHelp.GetPartFGListByLine((int)LoginInfo.LineId); //hanya dapat menampilkan part FG dari line nya
}
else
{
ViewBag.PartFGList = FrmHelp.GetPartFGList(); //menampilkan semua part FG
}
ViewBag.PartFGName = "";
ViewBag.LineNo = "";
ViewBag.LineName = "";
MsPartFG partFG = DbContext.MsPartFG.Where(a => a.PartFGId == data.PartFGId).FirstOrDefault();
if (partFG != null)
{
ViewBag.PartFGNo = partFG.PartFGNo;
ViewBag.PartFGName = partFG.PartFGName;
MsLine line = DbContext.MsLine.Where(a => a.LineId == partFG.LineId).FirstOrDefault();
if (line != null)
{
ViewBag.LineNo = line.LineNo;
ViewBag.LineName = line.LineName;
}
ViewBag.Action = "edit";
ViewBag.KanbanReqId = data.KanbanReqId;
}
else
{
ViewBag.Action = "add";
}
}
public string GetLineName(int?id)
{
var name = "-";
if (id != null)
{
MsLine data = Db.MsLine.Where(a => a.LineId == id).FirstOrDefault();
if (data != null)
{
name = data.LineName;
}
}
return(name);
}
public void Initialize(string authorizationToken)
{
lock (locker)
{
List <KanbanRequest> reqList = DbContext.KanbanRequest.Where(a => a.StatusId == 3).ToList();
List <KanbanItem> reqItems = new List <KanbanItem>();
foreach (KanbanRequest request in reqList)
{
short lineNo = 0;
string lineName = "";
MsPartFG fg = DbContext.MsPartFG.Where(a => a.PartFGId == request.PartFGId).FirstOrDefault();
if (fg != null)
{
MsLine line = DbContext.MsLine.Where(a => a.LineId == fg.LineId).FirstOrDefault();
if (line != null)
{
lineNo = line.LineNo;
lineName = line.LineName;
}
}
List <KanbanReqItem> items = DbContext.KanbanReqItem.Where(a => a.KanbanReqId == request.KanbanReqId).ToList();
foreach (KanbanReqItem item in items)
{
MsPart part = DbContext.MsPart.Where(a => a.PartId == item.PartId).FirstOrDefault();
if (part != null)
{
KanbanItem kanbanItem = new KanbanItem();
kanbanItem.ReqItemId = item.ReqItemId;
kanbanItem.KanbanReqId = request.KanbanReqId;
kanbanItem.RequestNo = request.TagRequestNo;
kanbanItem.RequestDate = request.RequestDateTime.AddMilliseconds(-request.RequestDateTime.Millisecond);
kanbanItem.ReqNo = request.TagRequestNo;
kanbanItem.PartId = item.PartId;
kanbanItem.PartNo = part.PartNo;
kanbanItem.LotSize = part.LotSize;
kanbanItem.Zone = part.Zone;
kanbanItem.LineNo = lineNo;
kanbanItem.LineName = lineName;
kanbanItem.OrderQty = item.ReqKanban;
reqItems.Add(kanbanItem);
}
}
}
ReqItems.Add(authorizationToken,
Tuple.Create(DateTime.UtcNow.AddHours(1), reqItems));
}
}
public async Task <IActionResult> Login(LoginViewModel model)
{
string encPassword = EncryptHelper.ConvertToEncrypt(model.Password);
SyUser user = new SyUser();
try
{
user = await DbContext.SyUser.FirstOrDefaultAsync(u => u.UserName == model.UserName && u.Password == encPassword);
if (user == null)
{
ModelState.AddModelError(string.Empty, "Invalid username or password");
}
else if (user.IsActive == false)
{
ModelState.AddModelError(string.Empty, "User " + user.UserName + " is not active");
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
if (ModelState.IsValid)
{
//store user info in session
SyRole role = DbContext.SyRole.FirstOrDefault(a => a.RoleId == user.RoleId);
MsLine line = DbContext.MsLine.FirstOrDefault(a => a.LineId == user.LineId);
var loginInfo = new LoginInfo
{
UserId = user.UserId,
UserName = user.UserName,
RealName = user.RealName,
RoleId = user.RoleId,
RoleName = role == null ? "-" : role.RoleName,
LineId = user.LineId,
LineName = line == null ? "-" : line.LineName
};
var serialisedLoginInfo = JsonConvert.SerializeObject(loginInfo);
HttpContext.Session.SetString("LoginInfo", serialisedLoginInfo);
//redirect to home
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public IActionResult GetPartFGData(int partFGId)
{
string partFGName = "";
string lineNo = "";
string lineName = "";
MsPartFG partFG = DbContext.MsPartFG.Where(a => a.PartFGId == partFGId).FirstOrDefault();
if (partFG != null)
{
partFGName = partFG == null ? "" : partFG.PartFGName;
MsLine line = DbContext.MsLine.Where(a => a.LineId == partFG.LineId).FirstOrDefault();
if (line != null)
{
lineNo = line.LineNo.ToString();
lineName = line.LineName;
}
}
return(Json(new { partFGName, lineNo, lineName }));
}
public async Task <IActionResult> Delete(int id)
{
KanbanRequest model = await DbContext.KanbanRequest.Where(a => a.KanbanReqId == id).FirstOrDefaultAsync();
try
{
ViewBag.PartFGNo = "";
ViewBag.PartFGName = "";
ViewBag.LineNo = "";
ViewBag.LineName = "";
ViewBag.StatusName = "";
if (model != null)
{
MsPartFG partFG = DbContext.MsPartFG.Where(a => a.PartFGId == model.PartFGId).FirstOrDefault();
if (partFG != null)
{
ViewBag.PartFGNo = partFG.PartFGNo;
ViewBag.PartFGName = partFG.PartFGName;
MsLine line = DbContext.MsLine.Where(a => a.LineId == partFG.LineId).FirstOrDefault();
if (line != null)
{
ViewBag.LineNo = line.LineNo;
ViewBag.LineName = line.LineName;
}
}
ViewBag.StatusName = FrmHelp.GetKanbanStatusName(model.StatusId);
}
else
{
return(NotFound());
}
}
catch (Exception e)
{
LogHelp.WriteErrorLog(e);
}
return(View(model));
}
