public ActionResult Create(AssetModel asset)
{
if (ModelState.IsValid)
{
asset.AssetNo = asset.AssetNo.Trim();
if (_context.BMEDAssets.Find(asset.AssetNo) != null)
{
throw new Exception("財產編號已經存在!!");
}
try
{
asset.DelivEmp = asset.DelivUid == null ? "" : _context.AppUsers.Find(asset.DelivUid).FullName;
asset.AssetEngName = asset.AssetEngId == 0 ? "" : _context.AppUsers.Find(asset.AssetEngId).FullName;
_context.BMEDAssets.Add(asset);
if (_context.BMEDAssetKeeps.Find(asset.AssetNo) == null)
{
AssetKeepModel ak = new AssetKeepModel();
ak.AssetNo = asset.AssetNo;
_context.BMEDAssetKeeps.Add(ak);
}
_context.SaveChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(new JsonResult(asset)
{
Value = new { success = true, error = "", id = asset.AssetNo }
});
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
//List<SelectListItem> listItem = new List<SelectListItem>();
//db.Departments.ToList().ForEach(d => {
// listItem.Add(new SelectListItem { Text = d.Name_C, Value = d.DptId });
//});
//ViewData["DelivDpt"] = new SelectList(listItem, "Value", "Text", "");
//List<SelectListItem> listItem2 = new List<SelectListItem>();
//listItem2.Add(new SelectListItem { Text = "", Value = "" });
//ViewData["DelivUid"] = new SelectList(listItem2, "Value", "Text", "");
//ViewData["AccDpt"] = new SelectList(listItem, "Value", "Text", "");
//List<SelectListItem> listItem3 = new List<SelectListItem>();
//listItem3.Add(new SelectListItem { Text = "正常", Value = "正常" });
//listItem3.Add(new SelectListItem { Text = "報廢", Value = "報廢" });
//ViewData["DisposeKind"] = new SelectList(listItem3, "Value", "Text", "");
//return View(asset);
}
public IActionResult NewEdit(string id)
{
AssetModel asset = _context.BMEDAssets.Find(id);
AssetKeepModel ak = _context.BMEDAssetKeeps.Find(id);
if (ak != null)
{
asset.KeepYm = ak.KeepYm;
asset.Cycle = ak.Cycle;
}
List <SelectListItem> listItem = new List <SelectListItem>();
listItem.Add(new SelectListItem {
Text = "正常", Value = "正常"
});
listItem.Add(new SelectListItem {
Text = "報廢", Value = "報廢"
});
ViewData["DKIND"] = new SelectList(listItem, "Value", "Text");
//
List <SelectListItem> listItem2 = new List <SelectListItem>();
List <SelectListItem> delivdpt = new List <SelectListItem>();
List <SelectListItem> accdpt = new List <SelectListItem>();
if (asset.DelivUid == null)
{
asset.DelivUid = null;
asset.DelivEmp = "";
asset.DelivDpt = "";
}
else
{
listItem2.Add(new SelectListItem {
Text = asset.DelivEmp, Value = asset.DelivUid.Value.ToString()
});
}
List <AppUserModel> ul;
string gid = "CCH";
_context.Departments.ToList()
.ForEach(d => {
delivdpt.Add(new SelectListItem
{
Text = d.Name_C + "(" + d.DptId + ")",
Value = d.DptId
});
accdpt.Add(new SelectListItem
{
Text = d.Name_C + "(" + d.DptId + ")",
Value = d.DptId
});
});
ViewData["DelivUids"] = new SelectList(listItem2, "Value", "Text", asset.DelivUid);
ViewData["DelivDpts"] = new SelectList(delivdpt, "Value", "Text", asset.DelivDpt);
ViewData["AccDpts"] = new SelectList(accdpt, "Value", "Text", asset.AccDpt);
return(View(asset));
}
public JavaScriptResult DeleteById(string id)
{
AssetModel asset = _context.BMEDAssets.Find(id);
_context.BMEDAssets.Remove(asset);
AssetKeepModel keep = _context.BMEDAssetKeeps.Find(id);
_context.BMEDAssetKeeps.Remove(keep);
_context.SaveChanges();
return(new JavaScriptResult("alert('刪除成功!');window.opener.location.reload();close();"));
}
// GET: BMED/AssetKeep/Details/5
public IActionResult Details(string id)
{
if (id == null)
{
return BadRequest();
}
AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id);
if (assetKeep == null)
{
return StatusCode(404);
}
assetKeep.KeepEngName = assetKeep.KeepEngId == null ? "" : _context.AppUsers.Find(assetKeep.KeepEngId).FullName;
return PartialView(assetKeep);
}
// GET: BMED/Asset/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(BadRequest());
}
AssetModel asset = _context.BMEDAssets.Find(id);
AssetKeepModel ak = _context.BMEDAssetKeeps.Find(id);
_context.BMEDAssets.Remove(asset);
_context.BMEDAssetKeeps.Remove(ak);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: BMED/AssetKeep/Edit/5
public IActionResult Edit(string id)
{
List<SelectListItem> listItem = new List<SelectListItem>();
AppUserModel u;
//db.AppUsers.ToList().ForEach(d =>
//{
// listItem.Add(new SelectListItem { Text = d.FullName, Value = d.Id.ToString() });
//});
// Get MedEngineers to set dropdownlist.
var s = roleManager.GetUsersInRole("MedEngineer").ToList();
foreach (string l in s)
{
u = _context.AppUsers.Where(ur => ur.UserName == l).FirstOrDefault();
if (u != null)
{
listItem.Add(new SelectListItem { Text = u.FullName + "(" + u.UserName + ")", Value = u.Id.ToString() });
}
}
ViewData["KeepEngId"] = new SelectList(listItem, "Value", "Text", "");
List<SelectListItem> listItem2 = new List<SelectListItem>();
listItem2.Add(new SelectListItem { Text = "自行", Value = "自行" });
listItem2.Add(new SelectListItem { Text = "委外", Value = "委外" });
listItem2.Add(new SelectListItem { Text = "保固", Value = "保固" });
listItem2.Add(new SelectListItem { Text = "租賃", Value = "租賃" });
ViewData["InOut"] = new SelectList(listItem2, "Value", "Text", "");
//
List<SelectListItem> listItem3 = new List<SelectListItem>();
_context.BMEDKeepFormats.ToList()
.ForEach(x =>
{
listItem3.Add(new SelectListItem { Text = x.FormatId, Value = x.FormatId });
});
ViewData["FormatId"] = new SelectList(listItem3, "Value", "Text", "");
//
if (id == null)
{
return PartialView();
}
AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id);
if (assetKeep == null)
{
assetKeep = new AssetKeepModel();
assetKeep.AssetNo = id;
}
return PartialView(assetKeep);
}
public async Task <IViewComponentResult> InvokeAsync(string id = null)
{
KeepModel kp = _context.BMEDKeeps.Find(id);
List <KeepFormatListVModel> kf = new List <KeepFormatListVModel>();
KeepFormatModel f;
KeepRecordModel r;
if (kp != null)
{
AssetKeepModel ak = _context.BMEDAssetKeeps.Find(kp.AssetNo);
if (ak != null)
{
if (!string.IsNullOrEmpty(ak.FormatId))
{
_context.BMEDKeepFormatDtls.Where(d => d.FormatId == ak.FormatId)
.ToList()
.ForEach(d =>
{
kf.Add(new KeepFormatListVModel
{
Docid = id,
FormatId = d.FormatId,
Plants = (f = _context.BMEDKeepFormats.Find(d.FormatId)) == null ? "" :
f.Plants,
Sno = d.Sno,
Descript = d.Descript,
KeepDes = (r = _context.BMEDKeepRecords.Find(id, d.FormatId, d.Sno)) == null ? "" :
r.KeepDes
});
});
}
}
KeepFlowModel kf2 = _context.BMEDKeepFlows.Where(f2 => f2.DocId == id)
.Where(f2 => f2.Status == "?").FirstOrDefault();
if (kf2.Cls.Contains("工程師"))
{
return(View(kf));
}
else
{
return(View("Details", kf));
}
}
return(Content("Page not found!")); //ViewComponent can't return HTTP response (like as StatusCode() or BasRequest())
}
public JsonResult EditData(AssetKeepModel assetkeep)
{
if (ModelState.IsValid)
{
_context.Entry(assetkeep).State = EntityState.Modified;
try
{
_context.SaveChanges();
return(Json(new { success = true, msg = "儲存成功!" }));
}
catch (Exception ex)
{
string s = ex.Message;
return(Json(new { success = false, msg = s }));
}
}
return(Json(new { success = false, msg = "儲存失敗!" }));
}
public IActionResult Edit(AssetKeepModel assetKeep)
{
if (ModelState.IsValid)
{
assetKeep.KeepEngName = _context.AppUsers.Find(assetKeep.KeepEngId).FullName;
_context.Entry(assetKeep).State = EntityState.Modified;
_context.SaveChanges();
return(new JsonResult(assetKeep)
{
Value = new { success = true, error = "" }
});
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
}
public IActionResult Create(KeepModel keep)
{
AppUserModel ur = _context.AppUsers.Where(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
//if (string.IsNullOrEmpty(keep.AssetNo))
//{
// throw new Exception("財產編號不可空白!!");
//}
string msg = "";
try
{
if (ModelState.IsValid)
{
//更新申請人的Email
if (string.IsNullOrEmpty(keep.Email))
{
throw new Exception("電子信箱不可空白!!");
}
AppUserModel a = _context.AppUsers.Find(keep.UserId);
a.Email = keep.Email;
_context.Entry(a).State = EntityState.Modified;
_context.SaveChanges();
//
AssetKeepModel kp = _context.AssetKeeps.Find(keep.DeviceNo);
AssetModel at = _context.Assets.Find(keep.DeviceNo);
//
keep.AssetNo = _context.Assets.Find(keep.DeviceNo).AssetNo;
keep.AssetName = _context.Assets.Find(keep.DeviceNo).Cname;
keep.EngId = kp.KeepEngId;
//keep.AccDpt = at.AccDpt;
keep.SentDate = DateTime.Now;
keep.Cycle = "手動出單";
keep.Src = "M";
_context.Entry(keep).State = EntityState.Modified;
//
KeepDtlModel dl = new KeepDtlModel();
//var notInExceptDevice = _context.ExceptDevice.Find(keep.AssetNo);
/* If can find data in ExceptDevice table, the device is "not" 統包.
* It means if value is "Y", the device is 統包
*/
//if (notInExceptDevice == null)
//{
// dl.NotInExceptDevice = "Y";
//}
//else
//{
// dl.NotInExceptDevice = "N";
//}
dl.DocId = keep.DocId;
switch (kp == null ? "自行" : kp.InOut)
{
case "自行":
dl.InOut = "0";
break;
case "委外":
dl.InOut = "1";
break;
case "租賃":
dl.InOut = "2";
break;
case "保固":
dl.InOut = "3";
break;
default:
dl.InOut = "0";
break;
}
_context.KeepDtls.Add(dl);
_context.SaveChanges();
//
KeepFlowModel kf = new KeepFlowModel();
kf.DocId = keep.DocId;
kf.StepId = 1;
kf.UserId = ur.Id;
kf.Status = "1";
//rf.Role = Roles.GetRolesForUser().FirstOrDefault();
kf.Rtp = ur.Id;
kf.Rdt = null;
kf.Rtt = DateTime.Now;
kf.Cls = "申請者";
_context.KeepFlows.Add(kf);
//
kf = new KeepFlowModel();
kf.DocId = keep.DocId;
kf.StepId = 2;
kf.UserId = kp == null ? ur.Id : kp.KeepEngId;
kf.Status = "?";
AppUserModel u = _context.AppUsers.Find(kf.UserId);
if (u == null)
{
throw new Exception("無工程師資料!!");
}
//rf.Role = Roles.GetRolesForUser(u.UserName).FirstOrDefault();
kf.Rtp = null;
kf.Rdt = null;
kf.Rtt = DateTime.Now;
kf.Cls = "設備工程師";
_context.KeepFlows.Add(kf);
_context.SaveChanges();
//send mail
Tmail mail = new Tmail();
string body = "";
u = _context.AppUsers.Find(ur.Id);
mail.from = new System.Net.Mail.MailAddress(u.Email); //u.Email
//u = _context.AppUsers.Find(kp.KeepEngId);
mail.to = new System.Net.Mail.MailAddress(u.Email); //u.Email
mail.message.Subject = "醫工工務智能保修系統[醫工保養案]：設備名稱： " + keep.AssetName;
body += "<p>表單編號：" + keep.DocId + "</p>";
body += "<p>送單日期：" + keep.SentDate.Value.ToString("yyyy/MM/dd") + "</p>";
body += "<p>申請人：" + keep.UserName + "</p>";
body += "<p>財產編號：" + keep.AssetNo + "</p>";
body += "<p>設備名稱：" + keep.AssetName + "</p>";
body += "<p>放置地點：" + keep.PlaceLoc + "</p>";
body += "<p><a href='http://dms.cch.org.tw/EDIS/Account/Login'" + "?docId=" + keep.DocId + "&dealType=KeepEdit" + ">處理案件</a></p>";
body += "<br/>";
body += "<h3>此封信件為系統通知郵件，請勿回覆。</h3>";
body += "<br/>";
body += "<h3 style='color:red'>如有任何疑問請聯絡工務部，分機3033或7033。<h3>";
mail.message.Body = body;
mail.message.IsBodyHtml = true;
//mail.SendMail();
return(Ok(keep));
}
else
{
msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(BadRequest(msg));
}
public async Task <IViewComponentResult> InvokeAsync(string id, string viewType = null)
{
if (viewType == "Details")
{
if (id == null)
{
return(Content("無資料!"));
}
AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id);
if (assetKeep == null)
{
return(Content("無資料!"));
}
assetKeep.KeepEngName = assetKeep.KeepEngId == null ? "" : _context.AppUsers.Find(assetKeep.KeepEngId).FullName;
return(View("Details", assetKeep));
}
else
{
List <SelectListItem> listItem = new List <SelectListItem>();
AppUserModel u;
//db.AppUsers.ToList().ForEach(d =>
//{
// listItem.Add(new SelectListItem { Text = d.FullName, Value = d.Id.ToString() });
//});
// Get MedEngineers to set dropdownlist.
var s = roleManager.GetUsersInRole("MedEngineer").ToList();
foreach (string l in s)
{
u = _context.AppUsers.Where(ur => ur.UserName == l).FirstOrDefault();
if (u != null)
{
listItem.Add(new SelectListItem {
Text = u.FullName + "(" + u.UserName + ")", Value = u.Id.ToString()
});
}
}
ViewData["KeepEngId"] = new SelectList(listItem, "Value", "Text", "");
List <SelectListItem> listItem2 = new List <SelectListItem>();
listItem2.Add(new SelectListItem {
Text = "自行", Value = "自行"
});
listItem2.Add(new SelectListItem {
Text = "委外", Value = "委外"
});
listItem2.Add(new SelectListItem {
Text = "保固", Value = "保固"
});
listItem2.Add(new SelectListItem {
Text = "租賃", Value = "租賃"
});
ViewData["InOut"] = new SelectList(listItem2, "Value", "Text", "");
//
List <SelectListItem> listItem3 = new List <SelectListItem>();
_context.BMEDKeepFormats.ToList()
.ForEach(x =>
{
listItem3.Add(new SelectListItem {
Text = x.FormatId + "(" + x.Plants + ")", Value = x.FormatId
});
});
ViewData["FormatId"] = new SelectList(listItem3, "Value", "Text", "");
//
if (id == null)
{
return(View());
}
AssetKeepModel assetKeep = _context.BMEDAssetKeeps.Find(id);
if (assetKeep == null)
{
assetKeep = new AssetKeepModel();
assetKeep.AssetNo = id;
}
return(View(assetKeep));
}
}
public IActionResult NewEdit(AssetModel asset)
{
if (ModelState.IsValid)
{
if (string.IsNullOrEmpty(asset.LeaveSite))
{
return(Content("[放置地點]不可空白!!"));
}
if (string.IsNullOrEmpty(asset.RiskLvl))
{
return(Content("[風險等級]不可空白!!"));
}
if (asset.KeepYm == null || asset.Cycle == null)
{
return(Content("[保養起始年月]或[保養週期]不可空白!!"));
}
if (string.IsNullOrEmpty(asset.MakeNo))
{
return(Content("[製造號碼]不可空白!!"));
}
//if (asset.RelDate == null)
//{
// return Content("[製造日期]不可空白!!");
//}
// Get Login User's details.
var ur = _userRepo.Find(usr => usr.UserName == User.Identity.Name).FirstOrDefault();
asset.Rtp = ur.Id;
asset.Rtt = DateTime.Now;
if (asset.DelivUid != null)
{
var u = _context.AppUsers.Find(asset.DelivUid);
if (u != null)
{
asset.DelivEmp = u.FullName;
}
}
_context.Entry(asset).State = EntityState.Modified;
//
AssetKeepModel ak = _context.BMEDAssetKeeps.Find(asset.AssetNo);
if (ak == null)
{
ak = new AssetKeepModel();
ak.AssetNo = asset.AssetNo;
ak.KeepYm = asset.KeepYm;
ak.Cycle = asset.Cycle;
_context.BMEDAssetKeeps.Add(ak);
}
else
{
ak.KeepYm = asset.KeepYm;
ak.Cycle = asset.Cycle;
_context.Entry(ak).State = EntityState.Modified;
}
try
{
_context.SaveChanges();
return(Content("success"));
}
catch (Exception e)
{
return(Content(e.Message));
}
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
return(Content(msg));
}
}
public ActionResult New(AssetModel asset)
{
if (ModelState.IsValid)
{
if (asset.AssetNo.Contains(";") || asset.AssetNo.Contains("、") || asset.AssetNo.Contains(","))
{
return(Content("財產編號只能有一個，請重新輸入!!"));
}
if (_context.BMEDAssets.Where(a => a.AssetNo == asset.AssetNo).Count() > 0)
{
return(Content("新增失敗，此財產編號已經存在!!"));
//return View(asset);
}
if (string.IsNullOrEmpty(asset.LeaveSite))
{
return(Content("[放置地點]不可空白!!"));
}
if (string.IsNullOrEmpty(asset.RiskLvl))
{
return(Content("[風險等級]不可空白!!"));
}
if (asset.KeepYm == null || asset.Cycle == null)
{
return(Content("[保養起始年月]或[保養週期]不可空白!!"));
}
if (string.IsNullOrEmpty(asset.MakeNo))
{
return(Content("[製造號碼]不可空白!!"));
}
if (asset.RelDate == null)
{
return(Content("[製造日期]不可空白!!"));
}
if (string.IsNullOrEmpty(asset.DelivDpt))
{
return(Content("[保管部門]不可空白!!"));
}
if (string.IsNullOrEmpty(asset.AccDpt))
{
return(Content("[成本中心]不可空白!!"));
}
// Get Login User's details.
var ur = _userRepo.Find(usr => usr.UserName == User.Identity.Name).FirstOrDefault();
asset.Rtp = ur.Id;
asset.Rtt = DateTime.Now;
if (asset.DelivUid != null)
{
var delivUser = _context.AppUsers.Where(u => u.Id == asset.DelivUid).FirstOrDefault();
asset.DelivEmp = delivUser == null ? "" : delivUser.FullName;
}
_context.BMEDAssets.Add(asset);
AssetKeepModel ak = _context.BMEDAssetKeeps.Find(asset.AssetNo);
if (ak == null)
{
ak = new AssetKeepModel();
ak.AssetNo = asset.AssetNo;
ak.KeepYm = asset.KeepYm;
ak.Cycle = asset.Cycle;
_context.BMEDAssetKeeps.Add(ak);
}
else
{
ak.KeepYm = asset.KeepYm;
ak.Cycle = asset.Cycle;
_context.Entry(ak).State = EntityState.Modified;
}
try
{
_context.SaveChanges();
return(Content("success"));
}
catch (Exception e)
{
return(Content(e.Message));
}
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
return(Content(msg));
}
}
public IActionResult EditData(string ano = null, string id = null)
{
var ur = _userRepo.Find(usr => usr.UserName == this.User.Identity.Name).FirstOrDefault();
AssetModel at = _context.BMEDAssets.Find(ano);
DeliveryModel d = _context.Deliveries.Find(id);
int vid = d.VendorId != null?Convert.ToInt32(d.VendorId) : 0;
VendorModel v = _context.BMEDVendors.Where(vv => vv.VendorId == vid).ToList().FirstOrDefault();
List <string> s;
SelectListItem li;
s = roleManager.GetUsersInRole("Engineer").ToList();
List <SelectListItem> list = new List <SelectListItem>();
AppUserModel u;
foreach (string l in s)
{
u = _context.AppUsers.Where(usr => usr.UserName == l).FirstOrDefault();
if (u != null)
{
if (u.VendorId != null)
{
if (u.VendorId == v.VendorId)
{
li = new SelectListItem();
li.Text = u.FullName;
li.Value = u.Id.ToString();
list.Add(li);
}
}
}
}
DepartmentModel dpt = _context.Departments.Find(at.DelivDpt);
DepartmentModel g;
if (dpt != null)
{
s = roleManager.GetUsersInRole("MedEngineer").ToList();
foreach (string l in s)
{
u = _context.AppUsers.Where(usr => usr.UserName == l).FirstOrDefault();
if (u != null)
{
if (u.DptId != null)
{
g = _context.Departments.Find(u.DptId);
if (g.DptId == dpt.DptId)
{
li = new SelectListItem();
li.Text = u.FullName;
li.Value = u.Id.ToString();
list.Add(li);
}
}
}
}
}
ViewData["Items"] = new SelectList(list, "Value", "Text", "");
List <SelectListItem> listItem = new List <SelectListItem>();
listItem.Add(new SelectListItem {
Text = "自行", Value = "自行"
});
listItem.Add(new SelectListItem {
Text = "委外", Value = "委外"
});
listItem.Add(new SelectListItem {
Text = "保固", Value = "保固"
});
listItem.Add(new SelectListItem {
Text = "租賃", Value = "租賃"
});
ViewData["INOUTITEMS"] = new SelectList(listItem, "Value", "Text", "");
//
List <SelectListItem> list2 = new List <SelectListItem>();
List <KeepFormatModel> kf = _context.BMEDKeepFormats.ToList();
foreach (KeepFormatModel k in kf)
{
li = new SelectListItem {
Text = k.FormatId, Value = k.FormatId
};
list2.Add(li);
}
ViewData["FORMATITEMS"] = new SelectList(list2, "Value", "Text", "");
//
AssetKeepModel assetkeep = _context.BMEDAssetKeeps.Find(ano);
if (assetkeep == null)
{
return(NotFound());
}
assetkeep.Cname = _context.BMEDAssets.Find(assetkeep.AssetNo).Cname;
if (assetkeep.KeepYm == null)
{
assetkeep.KeepYm = (d.DelivDateR.Year - 1911) * 100 + d.DelivDateR.Month;
}
return(PartialView(assetkeep));
}
