public IActionResult Print(string RowNumber) { IPHostEntry heserver = Dns.GetHostEntry(Dns.GetHostName()); var ip = heserver.AddressList[1].ToString(); var Log_Select_Print = _context.Log_Select_Print.Where(w => w.opt == "PrintWIPStatus"); //List<VW_MFC_ProductionDailyReport1> pdr = _context.VW_MFC_ProductionDailyReport1.ToList(); //List<VW_MFC_ProductionDailyReport1> pdr = _context.VW_MFC_ProductionDailyReport1.ToList(); var flag = false; if (RowNumber != null) { //HttpContext.Session.SetString("Test", FCode); // HttpContext.Session.SetString("fcode", FCode); flag = true; if (Log_Select_Print.Count() > 0) { var oldipaddress = Log_Select_Print.Where(w => w.opt == "PrintWIPStatus" && w.ipaddress == ip); if (oldipaddress.Count() > 0) { var pp_update = _context.Log_Select_Print.FirstOrDefault(f => f.opt == "PrintWIPStatus" && f.ipaddress == ip); pp_update.name = RowNumber; pp_update.ipaddress = ip; _context.Log_Select_Print.Update(pp_update); } else { var pp_insert = new Log_Select_Print { opt = "PrintWIPStatus", name = RowNumber, ipaddress = ip }; _context.Log_Select_Print.Add(pp_insert); } _context.SaveChanges(); } else { var pp_insert = new Log_Select_Print { opt = "PrintWIPStatus", name = RowNumber, ipaddress = ip }; _context.Log_Select_Print.Add(pp_insert); _context.SaveChanges(); } } //return View(pdr); return(Json(flag)); }
public IActionResult PrintProductionDailyReport1(string RowNumber, string fromdate, string todate) { IPHostEntry heserver = Dns.GetHostEntry(Dns.GetHostName()); var ip = heserver.AddressList[1].ToString(); var Log_Select_Print = _context.Log_Select_Print.Where(w => w.opt == "PrintProduction1"); var flag = false; if (RowNumber != null) { flag = true; if (Log_Select_Print.Count() > 0) { var oldipaddress = Log_Select_Print.Where(w => w.opt == "PrintProduction1" && w.ipaddress == ip); if (oldipaddress.Count() > 0) { var pp_update = _context.Log_Select_Print.FirstOrDefault(f => f.opt == "PrintProduction1" && f.ipaddress == ip); pp_update.name = RowNumber; pp_update.ipaddress = ip; _context.Log_Select_Print.Update(pp_update); } else { var pp_insert = new Log_Select_Print { opt = "PrintProduction1", name = RowNumber, ipaddress = ip }; _context.Log_Select_Print.Add(pp_insert); } _context.SaveChanges(); } else { var pp_insert = new Log_Select_Print { opt = "PrintFGMovement", name = RowNumber, ipaddress = ip }; _context.Log_Select_Print.Add(pp_insert); _context.SaveChanges(); } } //return View(pdr); return(Json(flag)); //return RedirectToAction("Index", "PrintProduction1"); //return Content("window.open('PrintProduction1/Index')"); }
public static bool Log_Print(string RowNumber, string string_process, string token, string username, NittanDBcontext _context) { var Log_Select_Print = _context.Log_Select_Print.Where(w => w.opt == string_process); var flag = false; if (RowNumber != null) { flag = true; if (Log_Select_Print.Count() > 0) { var oldipaddress = Log_Select_Print.Where(w => w.opt == string_process && w.username == username); if (oldipaddress.Count() > 0) { var pp_update = _context.Log_Select_Print.FirstOrDefault(f => f.opt == string_process && f.username == username); pp_update.name = RowNumber; pp_update.token = token; pp_update.username = username; _context.Log_Select_Print.Update(pp_update); } else { var pp_insert = new Log_Select_Print { opt = string_process, name = RowNumber, token = token, username = username }; _context.Log_Select_Print.Add(pp_insert); } _context.SaveChanges(); } else { var pp_insert = new Log_Select_Print { opt = string_process, name = RowNumber, token = token, username = username }; _context.Log_Select_Print.Add(pp_insert); _context.SaveChanges(); } } return(flag); }