public string ChangePassword(ApplicationUser user, string currentPassword, string newPassword)
{
string s = "";
if (string.IsNullOrEmpty(user.Id))
{
s = "錯誤!無此帳號!";
return(s);
}
int id = Convert.ToInt32(user.Id);
var ur = _context.AppUsers.Find(id);
if (ur != null)
{
// user's password encrypt by DES.
string DESKey = "84203025";
var checkPW = CryptoExtensions.DESEncrypt(currentPassword, DESKey);
if (ur.Password == checkPW)
{
var encryptPW = CryptoExtensions.DESEncrypt(newPassword, DESKey); // Encrypt and check password.
ur.Password = encryptPW;
_context.Entry(ur).State = EntityState.Modified;
_context.SaveChanges();
s = "成功";
return(s);
}
}
s = "錯誤!原密碼輸入不正確!";
return(s);
}
public string GetTicketSeq()
{
string result = "";
int seq = 0;
string yyymm = Convert.ToString((DateTime.Now.Year - 1911) * 100 + DateTime.Now.Month);
int cnt = _context.BMEDTicket_seq_tmps.Where(t => t.YYYMM == yyymm).Count();
Ticket_seq_tmpModel tmp;
if (cnt > 0)
{
tmp = _context.BMEDTicket_seq_tmps.Find(yyymm);
seq = Convert.ToInt32(tmp.TICKET_SEQ) + 1;
result = Convert.ToString(seq);
tmp.TICKET_SEQ = Convert.ToString(seq);
_context.Entry(tmp).State = EntityState.Modified;
}
else
{
tmp = new Ticket_seq_tmpModel();
seq = Convert.ToInt32(yyymm) * 1000 + 1;
tmp.YYYMM = Convert.ToString(yyymm);
tmp.TICKET_SEQ = Convert.ToString(seq);
result = Convert.ToString(seq);
_context.BMEDTicket_seq_tmps.Add(tmp);
}
_context.SaveChanges();
return(result);
}
public void Update(DepartmentModel entity)
{
var oriDpt = _context.Departments.Single(x => x.DptId == entity.DptId);
_context.Entry(oriDpt).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public void Update(AppUserModel entity)
{
var oriUser = _context.AppUsers.Single(x => x.Id == entity.Id);
_context.Entry(oriUser).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public void Update(AppRoleModel entity)
{
var oriRole = _context.AppRoles.Single(x => x.RoleId == entity.RoleId);
_context.Entry(oriRole).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public void Update(RepairDtlModel entity)
{
var oriRepDtl = _context.BMEDRepairDtls.Single(x => x.DocId == entity.DocId);
_context.Entry(oriRepDtl).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public ActionResult Edit(KeepEmpModel keepEmp)
{
if (ModelState.IsValid)
{
var ExistKeepEmp = _context.BMEDKeepEmps.Find(keepEmp.DocId, keepEmp.UserId);
if (ExistKeepEmp != null)
{
return(new JsonResult(keepEmp)
{
Value = new { isExist = true, error = "資料已存在!" }
});
}
else
{
_context.BMEDKeepEmps.Add(keepEmp);
_context.SaveChanges();
}
// Recount the all keep time, and set value to KeepDtl.
KeepDtlModel dtl = _context.BMEDKeepDtls.Where(d => d.DocId == keepEmp.DocId)
.FirstOrDefault();
if (dtl != null)
{
int hr = _context.BMEDKeepEmps.Where(p => p.DocId == keepEmp.DocId)
.Select(p => p.Hour)
.DefaultIfEmpty(0).Sum();
decimal min = _context.BMEDKeepEmps.Where(p => p.DocId == keepEmp.DocId)
.Select(p => p.Minute)
.DefaultIfEmpty(0).Sum();
dtl.Hours = hr + Decimal.Round(min / 60m, 2);
_context.Entry(dtl).State = EntityState.Modified;
_context.SaveChanges();
}
// Return ViewComponent for ajax request.
return(ViewComponent("BMEDKeepEmpList", new { id = keepEmp.DocId, viewType = "Edit" }));
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
}
public void Update(RepairEmpModel entity)
{
var oriRepEmp = _context.BMEDRepairEmps.Single(x => x.DocId == entity.DocId &&
x.UserId == entity.UserId);
_context.Entry(oriRepEmp).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public void Update(RepairFlowModel entity)
{
var oriRepFlow = _context.BMEDRepairFlows.Single(x => x.DocId == entity.DocId &&
x.StepId == entity.StepId);
_context.Entry(oriRepFlow).CurrentValues.SetValues(entity);
_context.SaveChanges();
}
public ActionResult Edit(BuyFlowModel buyflow)
{
if (ModelState.IsValid)
{
_context.Entry(buyflow).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(buyflow));
}
public IActionResult Edit(KeepFormatDtlModel keepformat_dtl)
{
if (ModelState.IsValid)
{
_context.Entry(keepformat_dtl).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Edit", "KeepFormat", new { Area = "BMED", id = keepformat_dtl.FormatId }));
}
return(View(keepformat_dtl));
}
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 Edit(KeepFormatModel keepformat)
{
AppUserModel ur = _context.AppUsers.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (ModelState.IsValid)
{
keepformat.Rtp = ur.Id;
keepformat.Rtt = DateTime.Now;
_context.Entry(keepformat).State = EntityState.Modified;
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(keepformat));
}
public IActionResult UpdStatus(string id = null, string vno = null)
{
// Get Login User's details.
var loginUser = _userRepo.Find(ur => ur.UserName == User.Identity.Name).FirstOrDefault();
BuyVendorModel buyvendor = _context.BuyVendors.Find(id, vno);
buyvendor.Status = "?";
buyvendor.Rtp = loginUser.Id.ToString();
buyvendor.Rtt = DateTime.Now;
_context.Entry(buyvendor).State = EntityState.Modified;
try
{
_context.SaveChanges();
}
catch (Exception e)
{
ModelState.AddModelError("", e.Message);
}
return(new JsonResult(buyvendor)
{
Value = new { success = true, error = "" },
});
}
public async Task <IActionResult> Edit(IFormCollection vmodel)
{
if (ModelState.IsValid)
{
KeepRecordModel r;
KeepRecordModel r2;
int i = vmodel["item.Sno"].Count();
for (int j = 0; j < i; j++)
{
r = new KeepRecordModel();
r.DocId = vmodel["item.DocId"][j];
r.FormatId = vmodel["item.FormatId"][j];
r.Sno = Convert.ToInt32(vmodel["item.Sno"][j]);
r.Descript = vmodel["item.Descript"][j];
r.KeepDes = vmodel["item.KeepDes"][j];
r2 = _context.BMEDKeepRecords.Find(r.DocId, r.FormatId, r.Sno);
if (r2 != null)
{
r2.KeepDes = r.KeepDes;
_context.Entry(r2).State = EntityState.Modified;
}
else
{
_context.BMEDKeepRecords.Add(r);
}
}
try
{
_context.SaveChanges();
return(new JsonResult(vmodel)
{
Value = new { success = true, error = "" }
});
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
}
public JsonResult EditData(DelivDataVModel dv)
{
if (ModelState.IsValid)
{
DeliveryModel d = _context.Deliveries.Find(dv.DocId);
if (d != null)
{
_context.Entry(d).State = EntityState.Modified;
d.WartyNt = dv.WartyNt;
d.AcceptDate = dv.AcceptDate;
d.WartySt = dv.WartySt;
d.WartyEd = dv.WartyEd;
d.FileTestDate = dv.FileTestDate;
d.TestUid = dv.TestUid;
d.Code = dv.Code;
d.Stype2 = dv.Stype2;
d.OpenDate = dv.OpenDate;
d.OrderDate = dv.OrderDate;
_context.SaveChanges();
}
return(Json(new { success = true, msg = "儲存成功!" }));
}
return(Json(new { success = false, msg = "儲存失敗!" }));
}
public async Task <IActionResult> Edit(KeepDtlModel keepDtlModel)
{
if (ModelState.IsValid)
{
try
{
if (keepDtlModel.IsCharged == "N")
{
//_context.BMEDKeepCosts.RemoveRange(_context.BMEDKeepCosts.Where(c => c.DocId == keepDtlModel.DocId));
keepDtlModel.Cost = 0;
}
else
{
keepDtlModel.Cost = _context.BMEDKeepCosts.Where(k => k.DocId == keepDtlModel.DocId)
.Select(k => k.TotalCost)
.DefaultIfEmpty(0).Sum();
int hr = _context.BMEDKeepEmps.Where(p => p.DocId == keepDtlModel.DocId)
.Select(p => p.Hour)
.DefaultIfEmpty(0).Sum();
decimal min = _context.BMEDKeepEmps.Where(p => p.DocId == keepDtlModel.DocId)
.Select(p => p.Minute)
.DefaultIfEmpty(0).Sum();
keepDtlModel.Hours = hr + Decimal.Round(min / 60m, 2);
}
_context.Entry(keepDtlModel).State = EntityState.Modified;
_context.SaveChanges();
return(new JsonResult(keepDtlModel)
{
Value = new { success = true, error = "" }
});
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
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 Edit(RepairCostModel repairCost)
{
var ur = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
/* Change to UpperCase.*/
if (repairCost.TicketDtl.TicketDtlNo != null)
{
repairCost.TicketDtl.TicketDtlNo = repairCost.TicketDtl.TicketDtlNo.ToUpper();
}
if (repairCost.SignNo != null)
{
repairCost.SignNo = repairCost.SignNo.ToUpper();
}
if (ModelState.IsValid)
{
try
{
if (repairCost.StockType == "2")
{
var dupData = _context.BMEDRepairCosts.Include(c => c.TicketDtl)
.Where(c => c.DocId == repairCost.DocId &&
c.PartName == repairCost.PartName &&
c.Standard == repairCost.Standard &&
c.TicketDtl.TicketDtlNo == repairCost.TicketDtl.TicketDtlNo).FirstOrDefault();
if (dupData != null)
{
string msg = "資料重複儲存!!";
return(BadRequest(msg));
}
}
else
{
var dupData = _context.BMEDRepairCosts.Include(c => c.TicketDtl)
.Where(c => c.DocId == repairCost.DocId &&
c.PartName == repairCost.PartName &&
c.Standard == repairCost.Standard &&
c.SignNo == repairCost.SignNo).FirstOrDefault();
if (dupData != null)
{
string msg = "資料重複儲存!!";
return(BadRequest(msg));
}
}
int seqno = _context.BMEDRepairCosts.Where(c => c.DocId == repairCost.DocId)
.Select(c => c.SeqNo).DefaultIfEmpty().Max();
repairCost.SeqNo = seqno + 1;
if (repairCost.StockType == "2")
{
if (string.IsNullOrEmpty(repairCost.TicketDtl.TicketDtlNo))
{
//throw new Exception("發票號碼不可空白!!");
string msg = "發票號碼不可空白!!";
return(BadRequest(msg));
}
if (repairCost.AccountDate == null)
{
//throw new Exception("發票日期不可空白!!");
string msg = "發票日期不可空白!!";
return(BadRequest(msg));
}
int i = _context.BMEDTicketDtls.Where(d => d.TicketDtlNo == repairCost.TicketDtl.TicketDtlNo)
.Select(d => d.SeqNo).DefaultIfEmpty().Max();
repairCost.TicketDtl.SeqNo = i + 1;
repairCost.TicketDtl.ObjName = repairCost.PartName;
repairCost.TicketDtl.Qty = repairCost.Qty;
repairCost.TicketDtl.Unite = repairCost.Unite;
repairCost.TicketDtl.Price = repairCost.Price;
repairCost.TicketDtl.Cost = repairCost.TotalCost;
TicketModel t = _context.BMEDTickets.Find(repairCost.TicketDtl.TicketDtlNo);
if (t == null)
{
t = new TicketModel();
t.TicketNo = repairCost.TicketDtl.TicketDtlNo;
t.TicDate = repairCost.AccountDate;
t.ApplyDate = null;
t.CancelDate = null;
t.VendorId = repairCost.VendorId;
t.VendorName = repairCost.VendorName;
repairCost.TicketDtl.Ticket = t;
_context.BMEDTickets.Add(t);
}
_context.BMEDTicketDtls.Add(repairCost.TicketDtl);
}
else
{
repairCost.AccountDate = repairCost.AccountDate == null ? DateTime.Now.Date : repairCost.AccountDate;
repairCost.TicketDtl = null;
}
repairCost.Rtp = ur.Id;
repairCost.Rtt = DateTime.Now;
if (repairCost.StockType != "0")
{
repairCost.PartNo = "";
}
_context.BMEDRepairCosts.Add(repairCost);
_context.SaveChanges();
//
RepairDtlModel dtl = _context.BMEDRepairDtls.Where(d => d.DocId == repairCost.DocId)
.FirstOrDefault();
if (dtl != null)
{
dtl.Cost = _context.BMEDRepairCosts.Where(k => k.DocId == repairCost.DocId)
.Select(k => k.TotalCost)
.DefaultIfEmpty(0).Sum();
_context.Entry(dtl).State = EntityState.Modified;
_context.SaveChanges();
}
return(ViewComponent("BMEDRepCostList", new { id = repairCost.DocId, viewType = "Edit" }));
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
}
public async Task <IActionResult> Edit(RepairDtlModel repairDtl)
{
if (ModelState.IsValid)
{
//if (string.IsNullOrEmpty(repairDtl.DealDes))
//{
// throw new Exception("請輸入[處理描述]!!");
//}
try
{
if (repairDtl.IsCharged == "N")
{
//_context.BMEDRepairCosts.RemoveRange(_context.BMEDRepairCosts.Where(c => c.DocId == repairDtl.DocId));
repairDtl.Cost = 0;
}
else
{
repairDtl.Cost = _context.BMEDRepairCosts.Where(k => k.DocId == repairDtl.DocId)
.Select(k => k.TotalCost)
.DefaultIfEmpty(0).Sum();
int hr = _context.BMEDRepairEmps.Where(p => p.DocId == repairDtl.DocId)
.Select(p => p.Hour)
.DefaultIfEmpty(0).Sum();
decimal min = _context.BMEDRepairEmps.Where(p => p.DocId == repairDtl.DocId)
.Select(p => p.Minute)
.DefaultIfEmpty(0).Sum();
repairDtl.Hour = hr + Decimal.Round(min / 60m, 2);
}
_context.Entry(repairDtl).State = EntityState.Modified;
/* Edit AssetNo if No exist. */
var repairModel = _context.BMEDRepairs.Find(repairDtl.DocId);
repairModel.AssetNo = repairDtl.AssetNo;
var tempAsset = _context.BMEDAssets.Where(a => a.AssetNo == repairDtl.AssetNo).FirstOrDefault();
if (tempAsset != null)
{
repairModel.AssetName = tempAsset.Cname;
}
_context.Entry(repairModel).State = EntityState.Modified;
_context.SaveChanges();
return(new JsonResult(repairDtl)
{
Value = new { success = true, error = "" }
});
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
else
{
string msg = "";
foreach (var error in ViewData.ModelState.Values.SelectMany(modelState => modelState.Errors))
{
msg += error.ErrorMessage + Environment.NewLine;
}
throw new Exception(msg);
}
}
public async Task <IActionResult> NextFlow(AssignModel assign)
{
var ur = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
/* 工程師的流程控管 */
if (assign.Cls == "設備工程師")
{
/* 如點選有費用、卻無輸入費用明細 */
var isCharged = _context.BMEDKeepDtls.Where(d => d.DocId == assign.DocId).FirstOrDefault().IsCharged;
if (isCharged == "Y")
{
var CheckRepairCost = _context.BMEDKeepCosts.Where(c => c.DocId == assign.DocId).FirstOrDefault();
if (CheckRepairCost == null)
{
throw new Exception("尚未輸入費用明細!!");
}
}
}
if (assign.FlowCls == "結案" || assign.FlowCls == "廢除")
{
assign.FlowUid = ur.Id;
}
if (ModelState.IsValid)
{
KeepFlowModel kf = _context.BMEDKeepFlows.Where(f => f.DocId == assign.DocId && f.Status == "?").FirstOrDefault();
if (assign.FlowCls == "驗收人")
{
if (_context.BMEDKeepEmps.Where(emp => emp.DocId == assign.DocId).Count() <= 0)
{
throw new Exception("沒有維修工程師紀錄!!");
}
else if (_context.BMEDKeepDtls.Find(assign.DocId).EndDate == null)
{
throw new Exception("沒有完工日!!");
}
if (_context.BMEDKeepDtls.Find(assign.DocId).Result == null)
{
throw new Exception("保養結果不可空白!!");
}
if (string.IsNullOrEmpty(_context.BMEDKeepDtls.Find(assign.DocId).InOut))
{
throw new Exception("保養方式不可空白!!");
}
}
if (assign.FlowCls == "結案")
{
KeepDtlModel kd = _context.BMEDKeepDtls.Find(assign.DocId);
kd.CloseDate = DateTime.Now;
kf.Opinions = "[" + assign.AssignCls + "]" + Environment.NewLine + assign.AssignOpn;
kf.Status = "2";
kf.UserId = ur.Id;
kf.UserName = _context.AppUsers.Find(ur.Id).FullName;
kf.Rtt = DateTime.Now;
kf.Rtp = ur.Id;
_context.Entry(kf).State = EntityState.Modified;
_context.Entry(kd).State = EntityState.Modified;
_context.SaveChanges();
// Save stock to ERP system.
//var ERPreponse = await SaveToERPAsync(assign.DocId);
//Send Mail
//To all users in this keep's flow.
Tmail mail = new Tmail();
string body = "";
string sto = "";
AppUserModel u;
KeepModel keep = _context.BMEDKeeps.Find(assign.DocId);
mail.from = new System.Net.Mail.MailAddress(ur.Email); //u.Email
_context.BMEDKeepFlows.Where(f => f.DocId == assign.DocId)
.ToList()
.ForEach(f =>
{
u = _context.AppUsers.Find(f.UserId);
sto += u.Email + ",";
});
mail.sto = sto.TrimEnd(new char[] { ',' });
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>保養結果：" + kd.Result + "</p>";
body += "<p>保養描述：" + kd.Memo + "</p>";
body += "<p><a href='http://dms.cch.org.tw/EDIS/Account/Login'" + "?DocId=" + keep.DocId + "&dealType=BMEDKeepViews" + ">檢視案件</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();
}
else if (assign.FlowCls == "廢除")
{
kf.Opinions = "[廢除]" + Environment.NewLine + assign.AssignOpn;
kf.Status = "3";
kf.Rtt = DateTime.Now;
kf.Rtp = ur.Id;
_context.Entry(kf).State = EntityState.Modified;
_context.SaveChanges();
}
else
{
//轉送下一關卡
kf.Opinions = "[" + assign.AssignCls + "]" + Environment.NewLine + assign.AssignOpn;
kf.Status = "1";
kf.Rtt = DateTime.Now;
kf.Rtp = ur.Id;
_context.Entry(kf).State = EntityState.Modified;
_context.SaveChanges();
//
KeepFlowModel flow = new KeepFlowModel();
flow.DocId = assign.DocId;
flow.StepId = kf.StepId + 1;
flow.UserId = assign.FlowUid.Value;
flow.UserName = _context.AppUsers.Find(assign.FlowUid.Value).FullName;
flow.Status = "?";
flow.Cls = assign.FlowCls;
flow.Rtt = DateTime.Now;
_context.BMEDKeepFlows.Add(flow);
_context.SaveChanges();
//Send Mail
//To user and the next flow user.
Tmail mail = new Tmail();
string body = "";
AppUserModel u;
KeepModel keep = _context.BMEDKeeps.Find(assign.DocId);
mail.from = new System.Net.Mail.MailAddress(ur.Email); //ur.Email
u = _context.AppUsers.Find(flow.UserId);
mail.to = new System.Net.Mail.MailAddress(u.Email); //u.Email
//mail.cc = new System.Net.Mail.MailAddress("*****@*****.**");
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=BMEDKeepEdit" + ">處理案件</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(new JsonResult(assign)
{
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 async Task <IActionResult> NextFlow(AssignModel assign)
{
var ur = _userRepo.Find(u => u.UserName == this.User.Identity.Name).FirstOrDefault();
var repairDtl = _context.BMEDRepairDtls.Find(assign.DocId);
/* 工程師的流程控管 */
if (assign.Cls == "設備工程師")
{
/* 如點選有費用、卻無輸入費用明細 */
var isCharged = _context.BMEDRepairDtls.Where(d => d.DocId == assign.DocId).FirstOrDefault().IsCharged;
if (isCharged == "Y")
{
var CheckRepairCost = _context.BMEDRepairCosts.Where(c => c.DocId == assign.DocId).FirstOrDefault();
if (CheckRepairCost == null)
{
throw new Exception("尚未輸入費用明細!!");
}
}
}
// var repairDtl = _context.BMEDRepairDtls.Where(d => d.DocId == assign.DocId).FirstOrDefault();
// /* 3 = 已完成，4 = 報廢 */
// if (repairDtl.DealState == 3 || repairDtl.DealState == 4)
// {
// if(repairDtl.EndDate == null)
// {
// throw new Exception("報廢及已完成，需輸入完工日!!");
// }
// }
if (assign.FlowCls == "結案" || assign.FlowCls == "廢除")
{
assign.FlowUid = ur.Id;
}
if (ModelState.IsValid)
{
RepairFlowModel rf = _context.BMEDRepairFlows.Where(f => f.DocId == assign.DocId && f.Status == "?").FirstOrDefault();
if (assign.FlowCls == "驗收人")
{
if (_context.BMEDRepairEmps.Where(emp => emp.DocId == assign.DocId).Count() <= 0)
{
throw new Exception("沒有維修工程師紀錄!!");
}
else if (_context.BMEDRepairDtls.Find(assign.DocId).EndDate == null)
{
throw new Exception("沒有完工日!!");
}
else if (_context.BMEDRepairDtls.Find(assign.DocId).DealState == 0)
{
throw new Exception("處理狀態不可空值!!");
}
if (_context.BMEDRepairDtls.Find(assign.DocId).FailFactor == 0)
{
throw new Exception("故障原因不可空白!!");
}
if (string.IsNullOrEmpty(_context.BMEDRepairDtls.Find(assign.DocId).InOut))
{
throw new Exception("維修方式不可空白!!");
}
if (_context.BMEDRepairDtls.Find(assign.DocId).DealState == 3 ||
_context.BMEDRepairDtls.Find(assign.DocId).DealState == 4 ||
_context.BMEDRepairDtls.Find(assign.DocId).DealState == 8)
{
//Do nothing.
//狀態為【已完成】、【報廢】、【退件】才可送至驗收人
}
else
{
throw new Exception("送至驗收人處理狀態只可為【已完成】、【報廢】、【退件】!!");
}
}
if (assign.FlowCls == "結案")
{
if (assign.Cls == "驗收人" && repairDtl != null)
{
if (repairDtl.IsCharged == "Y")
{
throw new Exception("有費用之案件不可由驗收人直接結案!");
}
}
RepairDtlModel rd = _context.BMEDRepairDtls.Find(assign.DocId);
rd.CloseDate = DateTime.Now;
rf.Opinions = "[" + assign.AssignCls + "]" + Environment.NewLine + assign.AssignOpn;
rf.Status = "2";
rf.UserId = ur.Id;
rf.UserName = _context.AppUsers.Find(ur.Id).FullName;
rf.Rtt = DateTime.Now;
rf.Rtp = ur.Id;
_context.Entry(rf).State = EntityState.Modified;
_context.Entry(rd).State = EntityState.Modified;
_context.SaveChanges();
// Save stock to ERP system.
var ERPreponse = await SaveToERPAsync(assign.DocId);
//Send Mail
//To all users in this repair's flow.
Tmail mail = new Tmail();
string body = "";
string sto = "";
AppUserModel u;
RepairModel repair = _context.BMEDRepairs.Find(assign.DocId);
mail.from = new System.Net.Mail.MailAddress(ur.Email); //u.Email
_context.BMEDRepairFlows.Where(f => f.DocId == assign.DocId)
.ToList()
.ForEach(f =>
{
u = _context.AppUsers.Find(f.UserId);
sto += u.Email + ",";
});
mail.sto = sto.TrimEnd(new char[] { ',' });
mail.message.Subject = "醫工工務智能保修系統[醫工請修案-結案通知]：設備名稱： " + repair.AssetName;
body += "<p>表單編號：" + repair.DocId + "</p>";
body += "<p>申請日期：" + repair.ApplyDate.ToString("yyyy/MM/dd") + "</p>";
body += "<p>申請人：" + repair.UserName + "</p>";
body += "<p>財產編號：" + repair.AssetNo + "</p>";
body += "<p>設備名稱：" + repair.AssetName + "</p>";
//body += "<p>請修地點：" + repair.PlaceLoc + " " + repair.BuildingName + " " + repair.FloorName + " " + repair.AreaName + "</p>";
body += "<p>放置地點：" + repair.PlaceLoc + "</p>";
body += "<p>故障描述：" + repair.TroubleDes + "</p>";
body += "<p>處理描述：" + rd.DealDes + "</p>";
body += "<p><a href='http://dms.cch.org.tw/EDIS/Account/Login'" + "?DocId=" + repair.DocId + "&dealType=BMEDRepViews" + ">檢視案件</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();
}
else if (assign.FlowCls == "廢除")
{
rf.Opinions = "[廢除]" + Environment.NewLine + assign.AssignOpn;
rf.Status = "3";
rf.Rtt = DateTime.Now;
rf.Rtp = ur.Id;
_context.Entry(rf).State = EntityState.Modified;
_context.SaveChanges();
}
else
{
//轉送下一關卡
rf.Opinions = "[" + assign.AssignCls + "]" + Environment.NewLine + assign.AssignOpn;
rf.Status = "1";
rf.Rtt = DateTime.Now;
rf.Rtp = ur.Id;
_context.Entry(rf).State = EntityState.Modified;
_context.SaveChanges();
//
RepairFlowModel flow = new RepairFlowModel();
flow.DocId = assign.DocId;
flow.StepId = rf.StepId + 1;
flow.UserId = assign.FlowUid.Value;
flow.UserName = _context.AppUsers.Find(assign.FlowUid.Value).FullName;
flow.Status = "?";
flow.Cls = assign.FlowCls;
flow.Rtt = DateTime.Now;
_context.BMEDRepairFlows.Add(flow);
_context.SaveChanges();
//Send Mail
//To user and the next flow user.
Tmail mail = new Tmail();
string body = "";
AppUserModel u;
RepairModel repair = _context.BMEDRepairs.Find(assign.DocId);
mail.from = new System.Net.Mail.MailAddress(ur.Email); //ur.Email
u = _context.AppUsers.Find(flow.UserId);
mail.to = new System.Net.Mail.MailAddress(u.Email); //u.Email
//mail.cc = new System.Net.Mail.MailAddress("*****@*****.**");
mail.message.Subject = "醫工工務智能保修系統[醫工請修案]：設備名稱： " + repair.AssetName;
body += "<p>表單編號：" + repair.DocId + "</p>";
body += "<p>申請日期：" + repair.ApplyDate.ToString("yyyy/MM/dd") + "</p>";
body += "<p>申請人：" + repair.UserName + "</p>";
body += "<p>財產編號：" + repair.AssetNo + "</p>";
body += "<p>設備名稱：" + repair.AssetName + "</p>";
body += "<p>故障描述：" + repair.TroubleDes + "</p>";
//body += "<p>請修地點：" + repair.PlaceLoc + " " + repair.BuildingName + " " + repair.FloorName + " " + repair.AreaName + "</p>";
body += "<p>放置地點：" + repair.PlaceLoc + "</p>";
body += "<p><a href='http://dms.cch.org.tw/EDIS/Account/Login'" + "?docId=" + repair.DocId + "&dealType=BMEDRepEdit" + ">處理案件</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(new JsonResult(assign)
{
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(BuyEvaluateModel buyevaluate)
{
if (ModelState.IsValid)
{
// Get Login User's details.
var user = _userRepo.Find(ur => ur.UserName == User.Identity.Name).FirstOrDefault();
DepartmentModel dpt = _context.Departments.Where(d => d.Name_C == buyevaluate.AccDptNam).FirstOrDefault();
if (dpt != null)
{
buyevaluate.AccDpt = dpt.DptId;
}
else
{
ModelState.AddModelError("", "成本中心無此資料!!");
return(View(buyevaluate));
}
buyevaluate.Rtp = user.Id;
buyevaluate.Rtt = DateTime.Now;
_context.Entry(buyevaluate).State = EntityState.Modified;
//
BuyFlowModel rf = new BuyFlowModel();
rf.DocId = buyevaluate.DocId;
rf.StepId = 1;
rf.UserId = user.Id;
rf.Status = "1";
rf.Role = roleManager.GetRolesForUser(user.Id).GetValue(0).ToString();
rf.Rtp = user.Id;
rf.Rdt = null;
rf.Rtt = DateTime.Now;
rf.Cls = "申請者";
_context.BuyFlows.Add(rf);
//
rf = new BuyFlowModel();
rf.DocId = buyevaluate.DocId;
rf.StepId = 2;
rf.UserId = buyevaluate.EngId;
rf.Status = "?";
AppUserModel u = _context.AppUsers.Find(buyevaluate.EngId);
rf.Role = roleManager.GetRolesForUser(u.Id).FirstOrDefault();
rf.Rtp = null;
rf.Rdt = null;
rf.Rtt = DateTime.Now;
rf.Cls = "設備工程師";
_context.BuyFlows.Add(rf);
//
_context.SaveChanges();
//
Tmail mail = new Tmail();
string body = "";
u = _context.AppUsers.Find(user.Id);
mail.from = new System.Net.Mail.MailAddress(u.Email); //u.Email
u = _context.AppUsers.Find(buyevaluate.PurchaserId);
mail.to = new System.Net.Mail.MailAddress(u.Email); //u.Email
//mail.cc = new System.Net.Mail.MailAddress("*****@*****.**");
mail.message.Subject = "醫療儀器管理資訊系統[採購評估案]：儀器名稱： " + buyevaluate.PlantCnam;
body += "<p>申請人：" + buyevaluate.UserName + "</p>";
body += "<p>儀器名稱：" + buyevaluate.PlantCnam + "</p>";
body += "<p><a href='http://dms.cch.org.tw/MvcMedEngMgr'>處理案件</a></p>";
body += "<br/>";
body += "<h3>this is a inform letter from system manager. Do not reply for it.</h3>";
mail.message.Body = body;
mail.message.IsBodyHtml = true;
//mail.SendMail();
return(RedirectToAction("Index", "Home", new { Area = "" }));
}
return(View(buyevaluate));
}
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.BMEDAssetKeeps.Find(keep.AssetNo);
AssetModel at = _context.BMEDAssets.Find(keep.AssetNo);
//
keep.AssetName = _context.BMEDAssets.Find(keep.AssetNo).Cname;
keep.EngId = kp.KeepEngId;
//keep.AccDpt = at.AccDpt;
keep.SentDate = DateTime.Now;
keep.Cycle = kp == null ? 0 : (kp.Cycle == null ? 0 : kp.Cycle.Value);
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.BMEDKeepDtls.Add(dl);
_context.SaveChanges();
//
KeepFlowModel rf = new KeepFlowModel();
rf.DocId = keep.DocId;
rf.StepId = 1;
rf.UserId = ur.Id;
rf.Status = "1";
//rf.Role = Roles.GetRolesForUser().FirstOrDefault();
rf.Rtp = ur.Id;
rf.Rdt = null;
rf.Rtt = DateTime.Now;
rf.Cls = "申請者";
_context.BMEDKeepFlows.Add(rf);
//
rf = new KeepFlowModel();
rf.DocId = keep.DocId;
rf.StepId = 2;
rf.UserId = kp == null ? ur.Id : kp.KeepEngId;
rf.Status = "?";
AppUserModel u = _context.AppUsers.Find(rf.UserId);
if (u == null)
{
throw new Exception("無工程師資料!!");
}
//rf.Role = Roles.GetRolesForUser(u.UserName).FirstOrDefault();
rf.Rtp = null;
rf.Rdt = null;
rf.Rtt = DateTime.Now;
rf.Cls = "設備工程師";
_context.BMEDKeepFlows.Add(rf);
_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=BMEDKeepEdit" + ">處理案件</a></p>";
body += "<br/>";
body += "<h3>此封信件為系統通知郵件，請勿回覆。</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 IActionResult NextFlow(DelivFlowModel DelivFlow)
{
if (ModelState.IsValid)
{
// Get Login User's details.
var ur = _userRepo.Find(usr => usr.UserName == User.Identity.Name).FirstOrDefault();
if (DelivFlow.SelOpin == "其他" && string.IsNullOrEmpty(DelivFlow.Opinions))
{
throw new Exception("請填寫意見欄!!");
}
DelivFlowModel rf = _context.DelivFlows.Where(df => df.DocId == DelivFlow.DocId)
.Where(df => df.Status == "?").ToList().FirstOrDefault();
if (rf == null)
{
throw new Exception("查無流程!");
}
if (rf.Cls == "得標廠商")
{
if (_context.BMEDAssets.Where(a => a.Docid == DelivFlow.DocId).Count() <= 0)
{
throw new Exception("沒有設備紀錄! 請新增設備!");
}
}
List<DelivFlowModel> rflist = _context.DelivFlows.Where(df => df.DocId == DelivFlow.DocId).ToList();
DeliveryModel r = _context.Deliveries.Find(DelivFlow.DocId);
AppUserModel u;
Tmail mail;
string body = "";
if (DelivFlow.Cls == "結案")
{
string sto = "";
//KeepDtl rd = db.KeepDtls.Find(KeepFlow.Docid);
rf.Opinions = DelivFlow.SelOpin + Environment.NewLine + DelivFlow.Opinions;
rf.Status = "2";
rf.Rtt = DateTime.Now;
rf.Rtp = ur.Id;
_context.Entry(rf).State = EntityState.Modified;
_context.SaveChanges();
//
mail = new Tmail();
u = _context.AppUsers.Find(ur.Id);
mail.from = new System.Net.Mail.MailAddress(u.Email); //u.Email
foreach (DelivFlowModel rr in rflist)
{
u = _context.AppUsers.Find(rr.UserId);
sto += u.Email + ",";
}
mail.sto = sto.TrimEnd(new char[] { ',' });
//mail.cc = new System.Net.Mail.MailAddress("*****@*****.**");
mail.message.Subject = "醫療儀器管理資訊系統[驗收案-結案通知]：採購案號： " + r.PurchaseNo;
body += "<p>申請人：" + r.UserName + "</p>";
body += "<p>合約號碼：" + r.ContractNo + "</p>";
body += "<p>採購案號：" + r.PurchaseNo + "</p>";
body += "<p><a href='http://dms.cch.org.tw/MvcMedEngMgr'>前往網站檢視</a></p>";
body += "<br/>";
body += "<h3>this is a inform letter from system manager.Do not reply for it.</h3>";
mail.message.Body = body;
mail.message.IsBodyHtml = true;
//mail.SendMail();
return new JsonResult(DelivFlow)
{
Value = new { success = true, error = "" },
};
}
DelivFlow.StepId = rf.StepId + 1;
DelivFlow.Rtt = DateTime.Now;
switch (DelivFlow.Cls)
{
case "申請者":
DelivFlow.UserId = r.UserId;
break;
}
DelivFlow.Status = "?";
u = _context.AppUsers.Find(DelivFlow.UserId);
DelivFlow.Role = roleManager.GetRolesForUser(u.Id).FirstOrDefault();
rf.Opinions = DelivFlow.SelOpin + Environment.NewLine + DelivFlow.Opinions;
rf.Status = "1";
rf.Rtp = ur.Id;
DelivFlow.Opinions = null;
_context.Entry(rf).State = EntityState.Modified;
_context.DelivFlows.Add(DelivFlow);
_context.SaveChanges();
//
mail = new Tmail();
body = "";
u = _context.AppUsers.Find(ur.Id);
mail.from = new System.Net.Mail.MailAddress(u.Email); //u.Email
u = _context.AppUsers.Find(DelivFlow.UserId);
mail.to = new System.Net.Mail.MailAddress(u.Email); //u.Email
//mail.cc = new System.Net.Mail.MailAddress("*****@*****.**");
mail.message.Subject = "醫療儀器管理資訊系統[驗收案]：採購案號： " + r.PurchaseNo;
body += "<p>申請人：" + r.UserName + "</p>";
body += "<p>合約號碼：" + r.ContractNo + "</p>";
body += "<p>採購案號：" + r.PurchaseNo + "</p>";
body += "<p><a href='http://dms.cch.org.tw/MvcMedEngMgr'>處理案件</a></p>";
body += "<br/>";
body += "<p>若有任何問題，請與驗收工程師(" + _context.AppUsers.Find(r.EngId).FullName + ")聯絡</p>";
body += "<h3>this is a inform letter from system manager.Do not reply for it.</h3>";
mail.message.Body = body;
mail.message.IsBodyHtml = true;
//mail.SendMail();
return new JsonResult(DelivFlow)
{
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);
}
}