//新增 private void btnSubmit_Click(object sender, EventArgs e) { if (txtProcductName.Text == "" || txtProcductName.Text == "請輸入產品名稱" || txtUnitPrice.Text == "" || txtUnitPrice.Text == "請輸入產品單價" || txtQuantity.Text == "" || txtQuantity.Text == "請輸入產品數量" || txtNote.Text == "" || txtNote.Text == "請輸入購買原因") { MessageBox.Show("請輸入完整資料!!!"); } else { try { this.Cursor = Cursors.WaitCursor; try { var newRequisitionMain = new RequisitionMain { ReportID = 2, EmployeeID = LoginID }; var newOrderDetail = new OrderDetail { Note = txtNote.Text, ProductName = txtProcductName.Text, UnitPrice = decimal.Parse(txtUnitPrice.Text), Quantity = Convert.ToInt32(txtQuantity.Text), RequisitionMain = newRequisitionMain }; if (MessageBox.Show("確定新增購案?", "新增購案", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { this.dbContext.RequisitionMains.Add(newRequisitionMain); this.dbContext.OrderDetails.Add(newOrderDetail); this.dbContext.SaveChanges(); DataGridViewFormat(); txtProcductName.Text = txtProcductNameExpand; txtUnitPrice.Text = txtUnitPriceExpand; txtQuantity.Text = txtQuantityExpand; txtNote.Text = txtNoteExpand; } else { txtProcductName.Text = txtProcductNameExpand; txtUnitPrice.Text = txtUnitPriceExpand; txtQuantity.Text = txtQuantityExpand; txtNote.Text = txtNoteExpand; } } finally { this.Cursor = Cursors.Default; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public ActionResult DeleteConfirmed(int id) { RequisitionMain requisitionMain = db.RequisitionMains.Find(id); db.RequisitionMains.Remove(requisitionMain); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { OrderDetail orderDetail = db.OrderDetails.Find(id); RequisitionMain requisitionMain = db.RequisitionMains.Find(orderDetail.OrderID); Approval approval = db.Approvals.Find(orderDetail.OrderID); db.OrderDetails.Remove(orderDetail); db.RequisitionMains.Remove(requisitionMain); db.Approvals.Remove(approval); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "OrderID,ReportID,EmployeeID,RequisitionDate,ApprovalStatusID")] RequisitionMain requisitionMain) { if (ModelState.IsValid) { db.Entry(requisitionMain).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ApprovalStatusID = new SelectList(db.ApprovalStatus, "ApprovalStatusID", "StatusName", requisitionMain.ApprovalStatusID); ViewBag.EmployeeID = new SelectList(db.Employees, "employeeID", "EmployeeName", requisitionMain.EmployeeID); ViewBag.ReportID = new SelectList(db.ReportCategories, "ReportID", "ReportName", requisitionMain.ReportID); return(View(requisitionMain)); }
// GET: RequisitionMains/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RequisitionMain requisitionMain = db.RequisitionMains.Find(id); if (requisitionMain == null) { return(HttpNotFound()); } return(View(requisitionMain)); }
public ActionResult Delete(int id) { OrderDetail orderDetail = db.OrderDetails.Find(id); RequisitionMain requisitionMain = db.RequisitionMains.Find(orderDetail.OrderID); Approval approval = db.Approvals.Find(orderDetail.OrderID); db.OrderDetails.Remove(orderDetail); db.RequisitionMains.Remove(requisitionMain); db.Approvals.Remove(approval); db.SaveChanges(); return(Json(new { success = true, message = "刪除成功" }, JsonRequestBehavior.AllowGet)); }
// GET: RequisitionMains/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RequisitionMain requisitionMain = db.RequisitionMains.Find(id); if (requisitionMain == null) { return(HttpNotFound()); } ViewBag.ApprovalStatusID = new SelectList(db.ApprovalStatus, "ApprovalStatusID", "StatusName", requisitionMain.ApprovalStatusID); ViewBag.EmployeeID = new SelectList(db.Employees, "employeeID", "EmployeeName", requisitionMain.EmployeeID); ViewBag.ReportID = new SelectList(db.ReportCategories, "ReportID", "ReportName", requisitionMain.ReportID); return(View(requisitionMain)); }
public ActionResult ApprovalReject(RequisitionMain requisitionMain) { if (requisitionMain.OrderID == 0) { return(View()); } else { var approval = db.Approvals.Find(requisitionMain.OrderID); if (approval.FirstSignerID == EmployeeDetail.EmployeeID) { requisitionMain.ApprovalStatusID = 1; approval.FirstSignDate = DateTime.Now; approval.FirstSignStatus = "駁回簽核"; } if (approval.SecondSignerID == EmployeeDetail.EmployeeID && approval.FirstSignStatus == "已審核") { requisitionMain.ApprovalStatusID = 1; approval.SecondSignDate = DateTime.Now; approval.SecondSignStatus = "駁回簽核"; } if (approval.ThirdSignerID == EmployeeDetail.EmployeeID && approval.SecondSignStatus == "已審核") { requisitionMain.ApprovalStatusID = 1; approval.ThirdSignDate = DateTime.Now; approval.ThirdSignStatus = "駁回簽核"; } if (approval.FourthSignerID == EmployeeDetail.EmployeeID && approval.ThirdSignStatus == "已審核") { requisitionMain.ApprovalStatusID = 1; approval.ForthSignDate = DateTime.Now; approval.FourthSignStatus = "駁回簽核"; } db.Entry(requisitionMain).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "填寫成功" }, JsonRequestBehavior.AllowGet)); } }