public JsonResult CardCreat(CardData DataCreat)
{
db.CardData.Add(DataCreat);
DataCreat.Disable = "N";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult ReserveConfirm(EmpData EData, CardData CData, RecordData RData, string mistake = "")
{
CardData C = db.CardData.Where(x => x.CardID == CData.CardID).FirstOrDefault();
EmpData E = db.EmpData.Where(x => x.EmpID == EData.EmpID).FirstOrDefault();
//判斷卡片是否跟借用員工同部門
if (E.EmpDept != C.CardDept)
{
mistake = "Case01";
return(Json(mistake));
}
//判斷卡片狀態
if (C.CardState == "已借用")
{
mistake = "Case02";
return(Json(mistake));
}
E.EmpState = "已借用";
C.CardState = "已借用";
RecordData R = db.RecordData.Where(x => x.RecordNumber == RData.RecordNumber).FirstOrDefault();
R.CardID = C.CardID;
R.TimeLend = RData.TimeLend;
R.UseDay = RData.UseDay;
R.RecordState = "已借用";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult EmpCreat(EmpData DataCreat)
{
db.EmpData.Add(DataCreat);
DataCreat.Disable = "N";
DataCreat.EmpState = "未借用";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
public JsonResult UserReserve(EmpData E, RecordData R)
{
EmpData ED = db.EmpData.Where(x => x.EmpID == E.EmpID).FirstOrDefault();
ED.EmpState = "已預約";
db.RecordData.Add(R);
R.RecordNumber = db.RecordData.Select(x => x.RecordNumber).Max(); //找出編號最大，並加1
R.RecordNumber++;
R.Disable = "N";
R.CardID = "未選取";
R.RecordState = "已預約";
db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}