public ActionResult CancelRequest(string id) { RequestDAO request = new RequestDAO(); switch (request.CancelRequest(id, Convert.ToInt32(Session["userid"].ToString()))) //PUT LOGIN EMP_ID HERE { case ("success"): { SetFlash(Enums.FlashMessageType.Success, "Successfully Cancelled!"); return(RedirectToAction("RequisitionList")); } case ("failed"): { SetFlash(Enums.FlashMessageType.Error, "Something went wrong! Please try again later or contact your webmaster."); return(RedirectToAction("RequisitionList")); } case ("unauthorized"): { SetFlash(Enums.FlashMessageType.Warning, "You cannot cancel requests which are not yours!"); return(RedirectToAction("RequisitionList")); } case ("reviewed"): { SetFlash(Enums.FlashMessageType.Warning, "You cannot cancel requests which are already reviewed!"); return(RedirectToAction("RequisitionList")); } } return(RedirectToAction("RequisitionList")); }
public ActionResult RequisitionList() { RequestDAO request = new RequestDAO(); ViewData["Requisitions"] = request.GetRequistionListByEmpId(Convert.ToInt32(Session["userid"].ToString())); //PUT LOGIN EMP_ID HERE return(View()); }
private void btnSave_Click(object sender, EventArgs e) { int id = int.Parse(dataGridView1.SelectedRows[0].Cells["requestID"].Value.ToString()); Request re = RequestDAO.getRequestByRequestID(id); re.MaID = m.MaID; re.DateReply = DateTime.Now.ToString(); re.Reply = txtReplyContent.Text; RequestDAO.Update(re); MessageBox.Show("Reply Success"); DataTable dt = RequestDAO.GetDataTable(); DataView dv = new DataView(dt); string filter = ""; if (comboBox1.SelectedIndex == 1) { filter = "maID is not null"; } if (comboBox1.SelectedIndex == 0) { filter = "maID is null"; } dv.RowFilter = filter; dataGridView1.DataSource = dv; btnSave.Enabled = false; txtReplyContent.Enabled = false; txtReplyContent.Text = ""; btnCancel.Enabled = false; btnReply.Enabled = true; }
public void DeleteRequestDetail([FromBody] RequestViewModel reqDetail) { if (reqDetail != null) { RequestDAO.DeleteRequestDetail(reqDetail); } }
private void btnSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtRequestContent.Text)) { string content = txtRequestContent.Text; Request hp = new Request(s.StuID, DateTime.Now.ToString(), content, "", "", "", 1); RequestDAO.Insert(hp); MessageBox.Show("Request Success"); DataTable dt = RequestDAO.GetDataTableByStuID(s.StuID); DataView dv = new DataView(dt); string filter = ""; if (comboBox1.SelectedIndex == 0) { filter = "maID is not null"; } if (comboBox1.SelectedIndex == 1) { filter = "maID is null"; } dv.RowFilter = filter; dataGridView1.DataSource = dv; btnSave.Enabled = false; txtRequestContent.Enabled = false; txtRequestContent.Text = ""; btnCancel.Enabled = false; btnRequest.Enabled = true; } else { MessageBox.Show("TextFiled is not empty"); } }
public MResponse UpdateReqStatus(RequisitionVM status) { bool success = new RequestDAO().UpdateStatus(status.Status, status.Id); MResponse response = new MResponse(success); return(response); }
public void ProcessMailForExpenses(string subjectName) { List <MailMessage> claims = mailHelper.getStringMessages(subjectName); foreach (MailMessage claim in claims) { //store the request.... RequestDAO request = new RequestDAO(); if (request.shouldProcess(claim.id)) { Request req = request.createRequestOrGetRequest(claim.from, claim.body, DateTime.Now, claim.id); //call the rest service. XmlDocument xdoc = RestHelper.callRestService(restEndPoint, claim.body); ExpenseDTO expenseDTO = Deserialiser.deserialiseContent <ExpenseDTO>(xdoc); ExpenseDAO expenseDAO = new ExpenseDAO(); Expense expenseToValidate = expenseDAO.CreateExpense(expenseDTO, req); ExpenseValidator validator = new ExpenseValidator(expenseToValidate); mailHelper.sendMessage(claim.from, validator.getMessage(), claim.id, string.Format("response to claim dated {0}", claim.date)); //deserialise the content //validate the request //store - valid request or failure and respond to user } } }
public void UpdateRequestDetails([FromBody] List <RequestViewModel> reqDetails) { if (reqDetails != null) { RequestDAO.UpdateRequestDetails(reqDetails); } }
public void InsertRequestDetail([FromBody] RequestViewModel reqDetail) { if (reqDetail != null) { RequestDAO.InsertRequestDetail(reqDetail); } }
public ActionResult ApprovedRequestDetails(int id) { RequestDAO request = new RequestDAO(); ViewData["RequestDetails"] = request.GetRequestDetail(id); return(View()); }
public ActionResult ApprovedRequests() { RequestDAO request = new RequestDAO(); ViewData["Requests"] = request.GetApprovedRequests(); return(View()); }
public ActionResult ViewPendingRequestDetails(int id) { RequestDAO requestDAO = new RequestDAO(); ViewData["PendingRequests"] = requestDAO.ViewPendingRequestDetails(id); return(View()); }
public ActionResult RequestDetail(int id) { RequestDAO requestDAO = new RequestDAO(); ViewData["RequestDetail"] = requestDAO.GetRequestDetail(id); return(View()); }
/// <summary> /// This controller's constructor instantiates a UserDAO, a RequestDAO, and a logger. Each has parameters found in WebConfig. /// </summary> public RequestController() { string connectionString = ConfigurationManager.ConnectionStrings["GameGroove"].ConnectionString; string logPath = ConfigurationManager.AppSettings["LogPath"]; _Logger = new Logger(logPath); _RequestDataAccess = new RequestDAO(logPath, connectionString); _UserDataAccess = new UserDAO(logPath, connectionString); }
public MResponse GetRequestDetail(int reqId) { RequestDAO dao = new RequestDAO(); return(new MResponseList <MRequestItem>() { ResList = dao.GetRequestItems(reqId) }); }
public ActionResult List() { string userId = User.Identity.GetUserId(); var s1 = StaffDepartmentDAO.GetStaffByUserId(userId); var reqList = RequestDAO.GetRequests(s1).ToList(); ModelState.Clear(); return(View(reqList)); }
public MResponse GetRequestHistory(string deptId) { RequestDAO dao = new RequestDAO(); return(new MResponseList <RequisitionVM>() { ResList = dao.GetReqListByDepartment(deptId) }); }
public MResponse ApproveAllRequst(string deptId) { RequestDAO dao = new RequestDAO(); return(new MResponse() { Success = dao.ApproveAllRequest(deptId) }); }
public void parseRequestID() { int requestID = 1284; RequestDAO dao = new RequestDAO(); Request req = dao.getById(requestID); string toParse = Encoding.UTF8.GetString(req.MailContent); XmlDocument parsedSample = StringHelper.ParseString(toParse); Assert.IsTrue(!BusinessLayer.Deserialiser.deserialiseContent <ExpenseDTO>(parsedSample).isEmpty()); }
//******************************************// public ActionResult ReviewStationeryRequest() { string username = Session["username"].ToString(); EmployeeDAO employeeDAO = new EmployeeDAO(); Employee employee = employeeDAO.GetEmployeeByUsername(username); RequestDAO reqlist = new RequestDAO(); ViewData["reqlist"] = reqlist.GetRequestList(employee.DepartmentId); return(View()); }
public ActionResult Detail(int?requestId) { if (TempData.ContainsKey("ShowHistory")) { ViewBag.ShowHistory = TempData["ShowHistory"]; } ViewBag.requestId = requestId; // Read from database var reqDetails = RequestDAO.GetRequestViewModelListByReqId((int)requestId); return(View(reqDetails)); }
public ActionResult Store(string itemNo, int?requestId, string category) { ViewBag.requestId = requestId; ViewBag.category = category; ViewBag.categoryList = new SelectList(InventoryDAO.getAllCategoryId(), category); // Click add to cart if (itemNo != null) { switch (requestId) { // New request (store in session) case null: { var li = Session["cartItems"] as List <string>; IncreaseStringList(ref li, itemNo); Session["cartItems"] = li; } break; // Existed request (store in database default: { // insert the request detail RequestViewModel rd = new RequestViewModel() { itemNo = itemNo, requestId = Convert.ToInt32(requestId), quantityNeed = 1, status_requestDetail = "unfulfilled" }; int count = RequestDAO.InsertRequestDetail(rd); ViewBag.RequestItemCount = count; } break; } } List <InventoryViewModel> items = null; if (!string.IsNullOrEmpty(category) && category != "0") { items = InventoryDAO.GetInventories(category); } else { items = InventoryDAO.GetInventories(); } return(View(items)); }
public ActionResult ViewPendingRequestDetails(int id) { if (Session["delegation"].ToString() != "Yes") { return(RedirectToAction("ShowError", "Base")); } RequestDAO requestDAO = new RequestDAO(); ViewData["PendingRequests"] = requestDAO.ViewPendingRequestDetails(id); return(View()); }
public List <RequestViewModel> ReadRequest() { var userId = User.Identity.GetUserId(); Staff s1 = StaffDepartmentDAO.GetStaffByUserId(userId); var reqList = new List <RequestViewModel>(); if (s1 != null) { reqList = RequestDAO.GetRequests(s1); } return(reqList); }
public ActionResult ApproveRejectRequest(string status, int reqId) { RequestDAO chngStatus = new RequestDAO(); chngStatus.UpdateStatus(status, reqId); EmailDAO emailDAO = new EmailDAO(); Employee employee = emailDAO.EmailRequestStatus(reqId); string sender = Session["username"].ToString(); Email email = new Email(); email.SendEmail(employee.Email, "Requesation Status", "Dear" + employee.Name + ", \n Please check for Requestsation status. Regards,\n" + sender); return(RedirectToAction("ReviewStationeryRequest", "DepartmentHead")); }
public ActionResult Delete(int requestId) { string userId = User.Identity.GetUserId(); var s1 = StaffDepartmentDAO.GetStaffByUserId(userId); if (s1 != null) { // Delete the request RequestDAO.DeleteRequest(s1.staffId, requestId); } return(RedirectToAction("List")); }
public void updateApproveRejectStatus([FromBody] RequestViewModel request) { if (request != null && request.requestId != null && request.status_request != null) { if (request.status_request.ToUpper() == "APPROVED") { RequestDAO.ApproveRequest(request.requestId, request.remark); } else if (request.status_request.ToUpper() == "REJECTED") { RequestDAO.RejectRequest(request.requestId, request.remark); } } }
public ActionResult ApproveAllRequests(string id) { RequestDAO requestDAO = new RequestDAO(); if (!requestDAO.ApproveAllRequests(id)) { SetFlash(Enums.FlashMessageType.Error, "Something went wrong!"); return(RedirectToAction("ReviewStationeryRequest", "DepartmentHead")); } SetFlash(Enums.FlashMessageType.Success, "Great! You've successfully approved all requests"); return(RedirectToAction("ReviewStationeryRequest", "DepartmentHead")); }
public List <RequestViewModel> ListRequestsByDepartmentId() { string userId = User.Identity.GetUserId(); Staff s1 = StaffDepartmentDAO.GetStaffByUserId(userId); if (s1 == null) { return(null); } List <RequestViewModel> reqList = RequestDAO.GetPendingRequestsInDepartment(s1); return(reqList); }
public List <int> ExtractSalesReports( ) { int year = DateTime.Now.Year; EmployeeDAO employeeDAO = new EmployeeDAO(); RequestDAO requestDAO = new RequestDAO(); DepartmentDAO departmentDAO = new DepartmentDAO(); List <Department> departments = departmentDAO.GetDepartments(); List <int> monthlySales = new List <int>(); //{paper,pen,stapler} foreach (Department d in departments) { List <RequestReport> requestReports = requestDAO.GetRequestsByDepartment(d.Id); if (requestReports != null) { int[] sales = new int[3]; foreach (RequestReport request in requestReports) { if (request.ReqYear == year) //DateTime.Today.year) { if (request.CategoryID == 1) //paper { sales[0] += request.Qty; } else if (request.CategoryID == 2) //pen { sales[1] += request.Qty; } else //stapler { sales[2] += request.Qty; } } } //monthlySales.Add(DateTime.Today.Month); monthlySales.Add(sales[0]); monthlySales.Add(sales[1]); monthlySales.Add(sales[2]); } } System.Diagnostics.Debug.WriteLine(monthlySales); return(monthlySales); }