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)); }