// 顯示目前已預約資料 public ActionResult AdmBorrowIndex(string empid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var dept = Session["EmpDept"].ToString(); //各部門管理者只能看到自己部門資料 List <RecordDataViewModel> RecData = new List <RecordDataViewModel>(); var rdata = (from x in Data.EmpData join y in Data.RecordData on x.EmpID equals y.EmpID where x.EmpState == "已預約" && y.CardID == "0001" && y.RecordDisable == "False" //顯示目前未刪除的已預約 select new RecordDataViewModel { RecordID = y.RecordID, EmpID = x.EmpID, EmpName = x.EmpName, EmpDept = x.EmpDept, TimeLend = y.TimeLend, EmpState = x.EmpState, UseDay = y.UseDay }).ToList(); RecData = rdata; if (Session["EmpRole"].ToString() == "admin") //各部門管理者只能看到自己部門資料 { RecData = RecData.Where(x => x.EmpDept == dept).ToList(); } if (!string.IsNullOrWhiteSpace(empid)) //搜尋功能 { RecData = RecData.Where(x => x.EmpID == empid).ToList(); } return(View(RecData)); } }
public ActionResult UserBorrow(RecordDataViewModel getrecorddata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { if (getrecorddata.EmpID != Session["EmpID"].ToString() || getrecorddata.EmpName != Session["EmpName"].ToString()) { ModelState.AddModelError("UseDay", "請使用本人ID、姓名借用"); return(View(getrecorddata)); } EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault(); if (empdata.EmpState == "已借用")//防止重複借卡 { ModelState.AddModelError("UseDay", "尚有未歸還或已預約卡片,請先歸還"); return(View(getrecorddata)); } else { empdata.EmpState = "已預約"; RecordData recorddata = new RecordData() { RecordID = Data.RecordData.Count() + 1, EmpID = getrecorddata.EmpID, TimeLend = getrecorddata.TimeLend, UseDay = getrecorddata.UseDay, CardID = "0001", //預約時,預設卡號"0001"為預約卡 RecordDisable = "False", RecordState = "已預約", }; Data.RecordData.Add(recorddata); Data.SaveChanges(); return(RedirectToAction("UserRecord")); } } }
public ActionResult Login(EmpData emplogin) { using (EasyCardEntities4 data = new EasyCardEntities4()) { var obj = data.EmpData.Where(x => x.EmpID == emplogin.EmpID && x.EmpPwd == emplogin.EmpPwd).FirstOrDefault(); if (obj != null) { Session["EmpID"] = obj.EmpID; Session["EmpName"] = obj.EmpName; Session["EmpPwd"] = obj.EmpPwd; Session["EmpDept"] = obj.EmpDept; Session["EmpRole"] = obj.Role; Session["EmpState"] = obj.EmpState; if (obj.Role == "admin" || obj.Role == "Superadmin") { return(RedirectToAction("AdmBorrowIndex", "AdminBorrow")); } else { return(RedirectToAction("UserBorrow", "UserBorrow")); } } //密碼錯誤訊息 ModelState.AddModelError("EmpPwd", "登入錯誤,請輸入正確帳號、密碼。"); return(View(emplogin)); } }
// 使用者借用紀錄 public ActionResult UserRecord() { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var userid = Session["EmpID"].ToString(); List <RecordDataViewModel> userdata = new List <RecordDataViewModel>(); var rdata = (from x in Data.EmpData join y in Data.RecordData on x.EmpID equals y.EmpID join z in Data.CardData on y.CardID equals z.CardID where x.EmpID == userid && y.RecordDisable == "False" orderby y.RecordID descending //降冪 select new RecordDataViewModel { RecordID = y.RecordID, CardID = y.CardID, CardName = z.CardName, TimeLend = y.TimeLend, TimeReturn = y.TimeReturn, UseDay = y.UseDay, RecordState = y.RecordState }).ToList(); userdata = rdata; return(View(userdata)); } }
// GET: Card /// <summary> /// 顯示所有資料 /// </summary> /// <param name="cardid"></param> /// <returns></returns> public ActionResult CardIndex(string cardid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var dept = Session["EmpDept"].ToString(); //各部門管理者只能看到自己部門資料 List <CardData> carddata = (from x in Data.CardData where x.CardDisable == "False" // 顯示未刪除的所有資料 select x).ToList(); if (Session["EmpRole"].ToString() == "admin") //各部門管理者只能看到自己部門資料 { carddata = carddata.Where(x => x.CardDept == dept).ToList(); } if (!string.IsNullOrWhiteSpace(cardid))//搜尋功能 { carddata = carddata.Where(x => x.CardID == cardid).ToList(); } //if (carddata.Count() == 0) //{ // Response.Write("error"); //} return(View(carddata)); } }
// 歸還畫面 public ActionResult AdmReturnIndex(string cardname) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var dept = Session["EmpDept"].ToString(); //各部門管理者只能看到自己部門資料 List <RecordDataViewModel> RecData = new List <RecordDataViewModel>(); var rdata = (from x in Data.EmpData join y in Data.RecordData on x.EmpID equals y.EmpID join z in Data.CardData on y.CardID equals z.CardID where y.TimeReturn == null && y.CardID != "0001" //顯示一筆 select new RecordDataViewModel { RecordID = y.RecordID, EmpID = x.EmpID, EmpName = x.EmpName, EmpDept = x.EmpDept, CardName = z.CardName, TimeLend = y.TimeLend, EmpState = x.EmpState, UseDay = y.UseDay }).ToList(); RecData = rdata; if (Session["EmpRole"].ToString() == "admin") //各部門管理者只能看到自己部門資料 { RecData = RecData.Where(x => x.EmpDept == dept).ToList(); } if (!string.IsNullOrWhiteSpace(cardname)) //搜尋功能 { RecData = RecData.Where(x => x.CardName == cardname).ToList(); } return(View(RecData)); } }
public ActionResult AdmEdit(RecordDataViewModel getrecorddata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { CardData carddata = Data.CardData.Where(x => x.CardName == getrecorddata.CardName).FirstOrDefault(); //if (carddata.CardState =="已借出")//防止選到已借出的卡片 //{ //} //else { carddata.CardState = "已借出"; } EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault(); empdata.EmpState = "已借用"; //RecordData 儲存 RecordData recorddata = Data.RecordData.Where(x => x.RecordID == getrecorddata.RecordID).FirstOrDefault(); recorddata.EmpID = getrecorddata.EmpID; recorddata.CardID = carddata.CardID; recorddata.TimeLend = getrecorddata.TimeLend; recorddata.UseDay = getrecorddata.UseDay; recorddata.RecordState = "未歸還"; Data.SaveChanges(); } return(RedirectToAction("AdmReturnIndex")); }
public ActionResult EmpCreate(EmpData empdata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { empdata.EmpDisable = "False"; Data.EmpData.Add(empdata); Data.SaveChanges(); } return(RedirectToAction("EmployeeIndex")); }
// GET: Card/Edit/5 public ActionResult CardEdit(string cardid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var carddata = (from x in Data.CardData where x.CardID == cardid select x).FirstOrDefault(); return(View(carddata)); } }
public ActionResult CardCreate(CardData createdata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { createdata.CardDisable = "False"; Data.CardData.Add(createdata); Data.SaveChanges(); } return(RedirectToAction("CardIndex")); }
// GET: Employee/Edit/5 public ActionResult EmpEdit(string empid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var empdata = (from x in Data.EmpData where x.EmpID == empid select x).FirstOrDefault(); return(View(empdata)); } }
// 使用者續借 public ActionResult UserRenew(int recordid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var recdata = (from x in Data.RecordData where x.RecordID == recordid select x).FirstOrDefault(); recdata.UseDay = recdata.UseDay + 5; Data.SaveChanges(); return(RedirectToAction("UserRecord")); } }
public ActionResult UserEdit(RecordDataViewModel editdata) { using (EasyCardEntities4 data = new EasyCardEntities4()) { if (ModelState.IsValid) { RecordData recdata = data.RecordData.Where(x => x.RecordID == editdata.RecordID).FirstOrDefault(); recdata.TimeLend = editdata.TimeLend; recdata.UseDay = editdata.UseDay; data.SaveChanges(); } return(RedirectToAction("UserRecord")); } }
// GET: AllRecord public ActionResult AllRecordIndex(string empid, string cardname, string timelend) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var dept = Session["EmpDept"].ToString(); //各部門管理者只能看到自己部門資料 List <RecordDataViewModel> RecData = new List <RecordDataViewModel>(); var rdata = (from x in Data.EmpData join y in Data.RecordData on x.EmpID equals y.EmpID join z in Data.CardData on y.CardID equals z.CardID where y.RecordDisable == "False" orderby y.RecordID descending //降冪 select new RecordDataViewModel { RecordID = y.RecordID, EmpID = x.EmpID, EmpName = x.EmpName, EmpDept = x.EmpDept, EmpState = x.EmpState, CardName = z.CardName, TimeLend = y.TimeLend, TimeReturn = y.TimeReturn, CardState = z.CardState, UseDay = y.UseDay, CardAmount = z.CardAmount, TotalSpent = y.TotalSpent }).ToList(); RecData = rdata; if (Session["EmpRole"].ToString() == "admin") //各部門管理者只能看到自己部門資料 { RecData = RecData.Where(x => x.EmpDept == dept).ToList(); } if (!string.IsNullOrWhiteSpace(empid)) //搜尋功能 { RecData = RecData.Where(x => x.EmpID == empid).ToList(); } if (!string.IsNullOrWhiteSpace(cardname)) //搜尋功能 { RecData = RecData.Where(z => z.CardName == cardname).ToList(); } if (!string.IsNullOrWhiteSpace(timelend)) //搜尋功能 { RecData = RecData.Where(y => y.TimeLend == DateTime.Parse(timelend)).ToList(); } return(View(RecData)); } }
public ActionResult CardEdit(CardData getdata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { if (ModelState.IsValid) { CardData carddata = Data.CardData.Where(x => x.CardID == getdata.CardID).FirstOrDefault(); carddata.CardID = getdata.CardID; carddata.CardDept = getdata.CardDept; carddata.CardName = getdata.CardName; carddata.CardState = getdata.CardState; carddata.CardAmount = getdata.CardAmount; Data.SaveChanges(); } return(RedirectToAction("CardIndex")); } }
// 預約確認 或 修改 public ActionResult AdmEdit(int recorid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var recorddata = (from x in Data.EmpData join y in Data.RecordData on x.EmpID equals y.EmpID where y.RecordID == recorid select new RecordDataViewModel { RecordID = y.RecordID, EmpID = x.EmpID, EmpName = x.EmpName, EmpDept = x.EmpDept, TimeLend = y.TimeLend, UseDay = y.UseDay }).FirstOrDefault(); return(View(recorddata)); }; }
// GET: Employee/Delete/5 public ActionResult EmpDelete(string empid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var empddata = (from x in Data.EmpData where x.EmpID == empid select x).FirstOrDefault(); if (empddata == null) { return(HttpNotFound()); } else { empddata.EmpDisable = "True"; Data.SaveChanges(); } return(RedirectToAction("EmployeeIndex")); } }
public ActionResult EmpEdit(EmpData getempdata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { if (ModelState.IsValid) { EmpData empdata = Data.EmpData.Where(x => x.EmpID == getempdata.EmpID).FirstOrDefault(); empdata.EmpID = getempdata.EmpID; empdata.EmpCardCode = getempdata.EmpCardCode; empdata.EmpDept = getempdata.EmpDept; empdata.EmpName = getempdata.EmpName; empdata.Email = getempdata.Email; empdata.EmpState = getempdata.EmpState; empdata.Role = getempdata.Role; Data.SaveChanges(); } return(RedirectToAction("EmployeeIndex")); } }
// GET: Card/Delete/5 //[AcceptVerbs(HttpVerbs.Delete)] //有別於get post public ActionResult CardDelete(string cardid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var carddata = (from x in Data.CardData where x.CardID == cardid select x).FirstOrDefault(); if (carddata == null) { return(HttpNotFound()); } else { carddata.CardDisable = "True"; Data.SaveChanges(); } return(RedirectToAction("CardIndex")); } }
// 使用者取消預約 public ActionResult UserDelete(int recordid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var recdata = (from x in Data.RecordData where x.RecordID == recordid select x).FirstOrDefault(); if (recdata == null) { return(HttpNotFound()); } else { recdata.RecordDisable = "True"; Data.SaveChanges(); } return(RedirectToAction("UserRecord")); } }
public ActionResult AdmBorrow(RecordDataViewModel getrecorddata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { CardData carddata = Data.CardData.Where(x => x.CardName == getrecorddata.CardName).FirstOrDefault(); //if (carddata.CardState == "已借出")//防止選到已借出的卡片 //{ //} //else { carddata.CardState = "已借出"; getrecorddata.CardID = carddata.CardID; } EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault(); //if (empdata.EmpState == "已借用")//防止重複借卡 //{ //} //else { empdata.EmpState = "已借用"; } RecordData recorddata = new RecordData() { RecordID = Data.RecordData.Count() + 1, EmpID = getrecorddata.EmpID, CardID = getrecorddata.CardID, TimeLend = getrecorddata.TimeLend, UseDay = getrecorddata.UseDay, RecordDisable = "False", RecordState = "未歸還", }; Data.RecordData.Add(recorddata); Data.SaveChanges(); } return(RedirectToAction("AdmReturnIndex")); }
// GET: Employee public ActionResult EmployeeIndex(string empid) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { var dept = Session["EmpDept"].ToString(); //各部門管理者只能看到自己部門資料 List <EmpData> empdata = (from x in Data.EmpData where x.EmpDisable == "False" select x).ToList(); if (Session["EmpRole"].ToString() == "admin") //各部門管理者只能看到自己部門資料 { empdata = empdata.Where(x => x.EmpDept == dept).ToList(); } if (!string.IsNullOrWhiteSpace(empid))//搜尋功能 { empdata = empdata.Where(x => x.EmpID == empid).ToList(); } return(View(empdata)); } }
// 歸還確認 public ActionResult AdmReturnConfirm(RecordDataViewModel getrecorddata) { using (EasyCardEntities4 Data = new EasyCardEntities4()) { CardData carddata = Data.CardData.Where(x => x.CardName == getrecorddata.CardName).FirstOrDefault(); carddata.CardState = "可使用"; carddata.CardAmount = getrecorddata.CardAmount; EmpData empdata = Data.EmpData.Where(x => x.EmpID == getrecorddata.EmpID).FirstOrDefault(); empdata.EmpState = "可借用"; //RecordData 儲存 RecordData recorddata = Data.RecordData.Where(x => x.RecordID == getrecorddata.RecordID).FirstOrDefault(); recorddata.EmpID = getrecorddata.EmpID; recorddata.CardID = carddata.CardID; recorddata.TimeLend = getrecorddata.TimeLend; recorddata.UseDay = getrecorddata.UseDay; recorddata.TimeReturn = DateTime.Now; recorddata.RecordState = "已歸還"; Data.SaveChanges(); return(RedirectToAction("AdmReturnIndex")); } }