public IActionResult RepairCreate(CReairViewModel cReair)
{
db.TRepairs.Add(cReair.repair);
db.SaveChanges();
return(RedirectToAction("RepairList"));
}
public IActionResult RepairEdit(CReairViewModel vrepair)
{
if (vrepair != null)
{
TRepair c = db.TRepairs.FirstOrDefault(p => p.CRepairNumber == vrepair.CRepairNumber);
if (c != null)
{
c.CContentofRepair = vrepair.CContentofRepair;
c.CAppleDate = (DateTime)vrepair.CAppleDate;
c.CLocation = vrepair.CLocation;
c.CPhone = vrepair.CPhone;
c.CRepairCategory = vrepair.CRepairCategory;
c.CRepairStatus = (byte)vrepair.CRepairStatus;
db.SaveChanges();
}
}
return(RedirectToAction("RepairList"));
}
public IActionResult search(int?number, DateTime?start, DateTime?end, string?content, string?status)
{
ViewBag.Session_USERID_USERDEPARTMENTID = int.Parse(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERDEPARTMENTID));
ViewBag.Session_USERIDSERID = int.Parse(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID));
ViewBag.Session_USERJOBTITLE = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERJOBTITLE);
ViewBag.Session_USERJOBTITLEID = int.Parse(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERJOBTITLEID));
int userid = int.Parse(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID));
string USERDEPARTMENTID = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERDEPARTMENTID);
ViewBag.UserId = int.Parse(HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID));
ViewBag.UserName = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERNAME);
List <CReairViewModel> T = new List <CReairViewModel>();
if (ViewBag.Session_USERJOBTITLE == "經理" && (ViewBag.Session_USERID_USERDEPARTMENTID == 4 || ViewBag.Session_USERID_USERDEPARTMENTID == 5))
{
var table = db.TRepairs.Where(r => (r.CRepairCategory.Contains("資訊") && int.Parse(USERDEPARTMENTID) == 4) || (r.CRepairCategory.Contains("總務") && int.Parse(USERDEPARTMENTID) == 5))
.Join(db.TUsers, t => t.CEmployeeId, u => u.CEmployeeId, (t, u) => new {
CApplyDate = t.CAppleDate,
CEmployeeId = t.CEmployeeId,
CRepairStatus = t.CRepairStatus,
CAppleDate = t.CAppleDate,
CRepairCategory = t.CRepairCategory,
CRepairNumber = t.CRepairNumber,
CEmployeeName = u.CEmployeeName,
CContentofRepair = t.CContentofRepair,
CLocation = t.CLocation,
CPhone = t.CPhone,
}).OrderBy(re => re.CAppleDate).AsEnumerable().Where(re =>
(number != null ? re.CRepairNumber == number : true) &&
(content != null ? re.CContentofRepair.Contains(content) : true) &&
(status != null ? re.CRepairStatus.ToString() == status : true) &&
(start != null ? re.CApplyDate >= start : true) &&
(end != null ? re.CApplyDate <= end : true)).ToList();
foreach (var item in table)
{
CReairViewModel obj = new CReairViewModel()
{
CEmployeeId = item.CEmployeeId,
CAppleDate = item.CAppleDate,
CContentofRepair = item.CContentofRepair,
CLocation = item.CLocation,
CPhone = item.CPhone,
CRepairCategory = item.CRepairCategory,
CRepairNumber = item.CRepairNumber,
CRepairStatus = item.CRepairStatus
};
T.Add(obj);
}
}
else
{
var table1 = db.TRepairs.Where(r => r.CEmployeeId == userid)
.Join(db.TUsers, t => t.CEmployeeId, u => u.CEmployeeId, (t, u) => new {
CApplyDate = t.CAppleDate,
CEmployeeId = t.CEmployeeId,
CRepairStatus = t.CRepairStatus,
CAppleDate = t.CAppleDate,
CRepairCategory = t.CRepairCategory,
CRepairNumber = t.CRepairNumber,
CEmployeeName = u.CEmployeeName,
CContentofRepair = t.CContentofRepair,
CLocation = t.CLocation,
CPhone = t.CPhone,
}).OrderBy(re => re.CAppleDate).AsEnumerable().Where(re =>
(number != null ? re.CRepairNumber == number : true) &&
(content != null ? re.CContentofRepair.Contains(content) : true) &&
(status != null ? re.CRepairStatus.ToString() == status : true) &&
(start != null ? re.CApplyDate >= start : true) &&
(end != null ? re.CApplyDate <= end : true)).ToList();
foreach (var item in table1)
{
CReairViewModel obj = new CReairViewModel()
{
CEmployeeId = item.CEmployeeId,
CAppleDate = item.CAppleDate,
CContentofRepair = item.CContentofRepair,
CLocation = item.CLocation,
CPhone = item.CPhone,
CRepairCategory = item.CRepairCategory,
CRepairNumber = item.CRepairNumber,
CRepairStatus = item.CRepairStatus
};
T.Add(obj);
}
}
return(PartialView("search", T));
}
