public string loadAllPendingRequisitions(String accessToken) { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); RequisitionController requisitionController = new RequisitionController(); List <Requisition> requisition_entities = requisitionController.actionGetPendingRequisitionsByUserID(user.id); List <RequisitionModel> model = new List <RequisitionModel>(); StationeryController stationeryController = new StationeryController(); List <StationaryRequests> stationeryRequests = new List <StationaryRequests>(); int counter = 1; foreach (Requisition r in requisition_entities) { StationaryRequests stationaryRequests = new StationaryRequests(); stationaryRequests.Quantity = r.quantity; stationaryRequests.SNo = counter; stationaryRequests.StationaryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name; stationaryRequests.RequestedDate = r.datetime_requested.ToString(); stationeryRequests.Add(stationaryRequests); counter++; } return(JsonConvert.SerializeObject(stationeryRequests)); }
public static string loadPendingRequests() { User user = (User)HttpContext.Current.Session["user"]; if (user == null) { return(null); } int empId = user.id; //-------------------------------------------------------------- JavaScriptSerializer js = new JavaScriptSerializer(); RequisitionController requisitionController = new RequisitionController(); List <Requisition> requisition_entities = requisitionController.actionGetPendingRequisitionsByUserID(empId); List <RequisitionModel> model = new List <RequisitionModel>(); StationeryController stationeryController = new StationeryController(); List <StationaryRequests> stationeryRequests = new List <StationaryRequests>(); int counter = 1; foreach (Requisition r in requisition_entities) { StationaryRequests stationaryRequests = new StationaryRequests(); stationaryRequests.Quantity = r.quantity; stationaryRequests.SNo = counter; stationaryRequests.StrationeryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name; stationaryRequests.RequestedDate = r.datetime_requested.ToString("MMMM dd, yyyy"); stationeryRequests.Add(stationaryRequests); counter++; } return(js.Serialize(stationeryRequests)); }//loadPendingRequests
public RequisitionControllerTests() { context = new ApplicationDbContext(); requisitionController = new RequisitionController(); disbursementService = new DisbursementService(context); retrievalService = new RetrievalService(context); }
public static string loadRejectedRequests() { User user = (User)HttpContext.Current.Session["user"]; if (user == null) { return(null); } int empId = user.id; //-------------------------------------------------------------- JavaScriptSerializer js = new JavaScriptSerializer(); RequisitionController requisitionController = new RequisitionController(); // hard coded user id = 6 // List<Requisition> requisition_entities =requisitionController.actionGetPendingRequisitionsByUserID(6); List <Requisition> requisition_entities = requisitionController.actionGetRejectedRequisitionsByUserID(empId); List <RequisitionModel> model = new List <RequisitionModel>(); StationeryController stationeryController = new StationeryController(); List <StationaryRequests> stationeryRequests = new List <StationaryRequests>(); foreach (Requisition r in requisition_entities) { StationaryRequests stationaryRequests = new StationaryRequests(); stationaryRequests.Quantity = r.quantity; stationaryRequests.StrationeryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name; stationaryRequests.RequestedDate = r.datetime_requested.ToString("MMMM dd, yyyy"); stationaryRequests.RejectReason = r.reject_remark; stationeryRequests.Add(stationaryRequests); } // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ Rejected:" + js.Serialize(stationeryRequests)); return(js.Serialize(stationeryRequests)); } //loadDistributedRequests
public void setdgvDetailData(string reqID) { lblRequisition.Visible = true; lblReq.Visible = true; lblReq.Text = reqID; detailPanel.Visible = true; Requisition req = RequisitionController.getReqByID(reqID); txtReason.Text = req.Remark; if (req.Status == "Rejected") { dgvDetail.Visible = true; List <RequisitionViewModel> reqVMList = RequisitionController.getRequisitionVM(reqID); lblReq.Text = reqID; dgvDetail.DataSource = reqVMList; dgvDetail.DataBind(); for (int i = 0; i < dgvDetail.Rows.Count; i++) { TextBox txtQty = (TextBox)dgvDetail.Rows[i].Cells[3].FindControl("txtQty"); //dgvDetail.Rows[i].Cells[0].Text = reqVMList[i].categoryID; //dgvDetail.Rows[i].Cells[1].Text = reqVMList[i].ItemName; //dgvDetail.Rows[i].Cells[2].Text = reqVMList[i].RequiredQty.ToString(); txtQty.Text = reqVMList[i].RequiredQty.ToString(); } btnResubmit.Visible = true; } else { dgvfix.Visible = true; List <RequisitionViewModel> reqVMList = RequisitionController.getRequisitionVM(reqID); dgvfix.DataSource = reqVMList; dgvfix.DataBind(); } }
}//getStationaryId() public string makeRequisition(int userId, string stationeryName, int quantity) { StationeryController stController = new StationeryController(); Requisition requisition = new Requisition(); // System.Diagnostics.Debug.WriteLine("inside actionGetStationeryIdByName::" + name); string newstationeryName = stationeryName.Replace('_', ' '); // System.Diagnostics.Debug.WriteLine("inside actionGetStationeryIdByName::" + newstationeryName); int stationeryId = Convert.ToInt32(stController.actionGetStationeryIdByName(newstationeryName)); requisition.stationery = stationeryId; requisition.quantity = quantity; requisition.user_obj = userId; //hardcoded department id requisition.department = 8; requisition.user_approved_by = null; RequisitionController requisitionController = new RequisitionController(); Message msg = requisitionController.actionCreateRequisition(requisition); if (msg.condition) { System.Diagnostics.Debug.WriteLine("success"); return("success"); } else { System.Diagnostics.Debug.WriteLine("fail"); return("fail"); } }//makeRequisition
public static void approveRequisitions(List <RequisitionID> jsonParam) { User sUser = (User)HttpContext.Current.Session["user"]; if (sUser == null) { return; } UserController userController = new UserController(); User dUser = userController.actionGetUserByID(sUser.id); JavaScriptSerializer js = new JavaScriptSerializer(); // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + js.Serialize(jsonParam)); System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + jsonParam.Count()); //actionRequisitionStatusChangeToApproved(int requisition_id) RequisitionController requisitionController = new RequisitionController(); foreach (RequisitionID requisitionId in jsonParam) { System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ param:" + requisitionId.Id); requisitionController.actionRequisitionStatusChangeToApproved(Convert.ToInt32(requisitionId.Id), dUser.id); } }//approveRequisitions
public void DetailsTest() { RequisitionController requisitionController = new RequisitionController(departmentService, itemService, requisitionService, itemRequisitionService, disbursementService, itemDisbursementService, inventoryService); ActionResult result = requisitionController.Details("r-1"); //ASSERT Assert.IsInstanceOfType(result, typeof(ViewResult)); ViewResult viewResult = (ViewResult)result; }
public void RejectTest() { RequisitionController requisitionController = new RequisitionController(departmentService, itemService, requisitionService, itemRequisitionService, disbursementService, itemDisbursementService, inventoryService); Requisition requisition = new Requisition() { Id = "1", Status = 0 }; requisitionController.Approve(requisition.Id); Assert.AreEqual(CustomStatus.Rejected, requisition.Status); }
public void SaveTest() { Requisition requisition = new Requisition() { Id = "1", DepartmentId = "2" }; RequisitionController requisitionController = new RequisitionController(departmentService, itemService, requisitionService, itemRequisitionService, disbursementService, itemDisbursementService, inventoryService); ActionResult result = requisitionController.Save(requisition); Assert.IsNotNull(result); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "viewdetail") { Panel1.Visible = true; int index = Convert.ToInt32(e.CommandArgument); string ReqId = GridView1.Rows[index].Cells[0].Text; lblRequisitionID.Text = ReqId; List <SubmitItemDetailsModel> sids = ARC.GetReqItemByReqID(ReqId); txtRejectReason.Text = RequisitionController.getReqByID(ReqId).Remark; Session["SubmittedItemDetails"] = sids; GridView2.DataSource = ARC.GetReqItemByReqID(ReqId); GridView2.DataBind(); } }
public string approveRequisition(string accessToken, int reqId) { try { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); //get userId RequisitionController requisitionController = new RequisitionController(); requisitionController.actionRequisitionStatusChangeToApproved(reqId, user.id); return("success"); } catch (Exception e) { return("fail"); } }//approveRequisition
protected void BtnCreate_Click(object sender, EventArgs e) { List <RequisitionItem> reqItemList = new List <RequisitionItem>(); string type = ddlRequisitiontype.SelectedValue; for (int i = 0; i < GridViewCreateRequisition.Rows.Count; i++) { RequisitionItem reqItem = new RequisitionItem(); ddlCategory = (DropDownList)GridViewCreateRequisition.Rows[i].Cells[1].FindControl("DropDownListDesc"); TextBox tbQty = (TextBox)GridViewCreateRequisition.Rows[i].Cells[3].FindControl("TextboxQty"); reqItem.Item_ID = ddlCategory.SelectedValue; reqItem.Required_Qty = Convert.ToInt32(tbQty.Text); if (reqItem.Required_Qty > 0) { reqItemList.Add(reqItem); } reqItemList = reqItemList.GroupBy(x => x.Item_ID) .Select(y => new RequisitionItem { Item_ID = y.Key, Required_Qty = y.Sum(t => t.Required_Qty) }) .ToList(); } if (reqItemList.Count > 0) { try { Staff loginstaff = (Staff)Session["LoginStaff"]; RequisitionController.createRequisition(reqItemList, loginstaff.Staff_ID, type, "Submitted"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Requisition Submit Successfully')", true); initData(); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('OOPS! Requisition Submit Failed')", true); } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('You have Item which Item Quantiy is 0, Pls check!!')", true); } }
protected void btnSearch_Click(object sender, EventArgs e) { Staff loginStaff = (Staff)Session["loginStaff"]; lblReqResult.Text = ""; string reqID = txtID.Text; if (reqID != "") { if (RequisitionController.checkReqByStaffID(reqID, loginStaff.Staff_ID)) { setdgvDetailData(reqID); } else { lblReqResult.Text = "Requisition invalid, Please check!"; } } else { string fromDate = txtFromDate.Text; string toDate = txtToDate.Text; if (fromDate == "" || toDate == "") { LBStatus.Text = "Please select both From date and To date."; } else if (DateTime.Compare(TC.DateConvert(fromDate), TC.DateConvert(toDate)) > 0) { LBStatus.Text = "From date should be later than To date"; } else { Staff stf = (Staff)Session["LoginStaff"]; LBStatus.Text = ""; string status = dplStatus.SelectedValue; List <Requisition> reqList = RequisitionController.getReqByDate_Status(stf.Staff_ID, fromDate, toDate, status); Session["reqList"] = reqList; initPage(); dgvList.Visible = true; dgvList.DataSource = reqList; dgvList.DataBind(); } } }
protected void Button1_Click(object sender, EventArgs e) { User sUser = (User)Session["user"]; if (sUser == null || sUser.user_type != 1) { Response.Redirect("~/m/Login.aspx"); } User dUser = new UserController().actionGetUserByID(sUser.id); RequisitionController requisitionController = new RequisitionController(); ApplicationLayer.Requisition requisition = new ApplicationLayer.Requisition(); requisition.user_obj = dUser.id; requisition.stationery = Convert.ToInt32(ui_id_hidden.Value); requisition.quantity = Convert.ToInt32(ui_quantity.Text); requisition.department = Convert.ToInt32(dUser.department); Message message = requisitionController.actionCreateRequisition(requisition); if (message.condition) { Response.Cookies.Add(new HttpCookie("flash_message", "Successfully Requested.") { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-success") { Path = "/" }); Response.Redirect("~/m/DepartmentEmployee/Stationeries.aspx"); } else { Response.Cookies.Add(new HttpCookie("flash_message", "Requisition Fail. <br />" + message.message) { Path = "/" }); Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error") { Path = "/" }); return; } }
}//approveRequisition public string rejectRequisition(string accessToken, int reqId, string reason) { System.Diagnostics.Debug.WriteLine("inside rejectRequisition: accessToken" + accessToken + " ,reqId:" + reqId + " ,reason:" + reason); try { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); //get userId RequisitionController requisitionController = new RequisitionController(); // requisitionController.actionRequisitionStatusChangeToRejected(reqId); requisitionController.actionRequisitionStatusChangeToRejectedWithRemarkAndRejectedBy(reqId, reason, user.id); return("success"); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Exception occured in rejectRequisition.." + e.Message); return("fail"); } }//rejectRequisition
public static string MakeRequisition(object jsonParam) { User user = (User)HttpContext.Current.Session["user"]; if (user == null) { return(null); } int empId = user.id; String valueString = jsonParam.ToString(); string[] values = valueString.Split('.'); int stId = Convert.ToInt16(values[0]); int qty = Convert.ToInt16(values[1]); int depId = Convert.ToInt32(user.department); Requisition requisition = new Requisition(); requisition.stationery = stId; requisition.quantity = qty; requisition.user_obj = empId; requisition.department = depId; requisition.user_approved_by = null; RequisitionController requisitionController = new RequisitionController(); Message msg = requisitionController.actionCreateRequisition(requisition); if (msg.condition) { //return msg.message; return("success"); } else { //return msg.message; return("fail"); } // System.Diagnostics.Debug.WriteLine(" inside MakeRequisition " + msg); // return "Hi this is response from MakeRequisition"; }//
public string approveAllRequisitions(string accessToken, List <RequisitionId> requisitionsIds) { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); RequisitionController requisitionController = new RequisitionController(); try { for (int i = 0; i < requisitionsIds.Count(); i++) { RequisitionId requisitionId = requisitionsIds[i]; requisitionController.actionRequisitionStatusChangeToApproved(requisitionId.reqId, user.id); } return("success"); } catch (Exception e) { return("fail"); } }
public string showAllApprovedRequisitions(string accessToken) { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); RequisitionController requisitionController = new RequisitionController(); List <RequisitionView> requisitionDepartmentWise = requisitionController.actionGetApprovedRequisitionViewsByDepartmentID(Convert.ToInt32(user.department)); List <Requisition> requisitions = new List <Requisition>(); foreach (RequisitionView rView in requisitionDepartmentWise) { Requisition requisition = new Requisition(); requisition.EmployeeName = rView.firstname + " " + rView.lastname; requisition.Quantity = rView.quantity; requisition.RequisitionDate = rView.datetime_requested; requisition.ReqDate = rView.datetime_requested.ToString("MMMM dd, yyyy"); requisition.StationaryName = rView.stationery_name; requisitions.Add(requisition); } return(JsonConvert.SerializeObject(requisitions)); }//showAllApprovedRequisitions
protected void btnResubmit_Click(object sender, EventArgs e) { List <RequisitionItem> reqList = new List <RequisitionItem>(); string reqid = lblReq.Text; string status = "Submitted"; for (int i = 0; i < dgvDetail.Rows.Count; i++) { TextBox txtQty = (TextBox)dgvDetail.Rows[i].Cells[3].FindControl("txtQty"); string category = dgvDetail.Rows[i].Cells[0].Text; string ItemID = dgvDetail.Rows[i].Cells[1].Text; string ItemName = dgvDetail.Rows[i].Cells[2].Text; string UOM = dgvDetail.Rows[i].Cells[3].Text; int Qty = Convert.ToInt32(txtQty.Text); RequisitionItem reqitem = new RequisitionItem(); reqitem.Item_ID = ItemID; reqitem.Required_Qty = Qty; reqitem.Requisition_ID = reqid; reqList.Add(reqitem); } try { RequisitionController.updateRequisition(reqList, reqid, status); clearPage(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Requisition Submit Successfully')", true); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Requisition Submit Failed')", true); } }
protected void btnCreate_Click(object sender, EventArgs e) { List <ReceivedItemModel> restItemList = (List <ReceivedItemModel>)Session["restItemList"]; List <RequisitionItem> reqItemList = new List <RequisitionItem>(); if (restItemList.Count > 0) { foreach (ReceivedItemModel restItem in restItemList) { RequisitionItem reqItem = new RequisitionItem(); reqItem.Item_ID = restItem.itemCode; reqItem.Required_Qty = restItem.restQty; reqItemList.Add(reqItem); } Staff stf = (Staff)Session["LoginStaff"]; string type = "Special"; string status = "Approved"; RequisitionController.createRequisition(reqItemList, stf.Staff_ID, type, status); Session["restItemList"] = ""; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Create success!')", true); initPage(); }
public static void rejectRequisitions(List <RequisitionID> jsonParam, string reason) { System.Diagnostics.Debug.WriteLine("REASON FOR REJECTION:" + reason); User sUser = (User)HttpContext.Current.Session["user"]; if (sUser == null) { return; } JavaScriptSerializer js = new JavaScriptSerializer(); // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + js.Serialize(jsonParam)); // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + jsonParam.Count()); //actionRequisitionStatusChangeToApproved(int requisition_id) RequisitionController requisitionController = new RequisitionController(); foreach (RequisitionID requisitionId in jsonParam) { // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ param:" + requisitionId.Id); // requisitionController.actionRequisitionStatusChangeToRejected(Convert.ToInt32(requisitionId.Id)); requisitionController.actionRequisitionStatusChangeToRejectedWithRemarkAndRejectedBy(Convert.ToInt32(requisitionId.Id), reason, sUser.id); } }//rejectRequisitions
public string showAllPendingRequisition(string accessToken) { RequisitionController requisitionController = new RequisitionController(); JavaScriptSerializer js = new JavaScriptSerializer(); OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); // int userId = user.id; List <RequisitionView> requisitionDepartmentWise = requisitionController.actionGetPendingRequisitionViewsByDepartmentID(Convert.ToInt32(user.department)); List <UserRequisition> userRequisitionsList = new List <UserRequisition>(); foreach (RequisitionView r in requisitionDepartmentWise) { if (userRequisitionsList.Count == 0) { UserRequisition userRequisition = new UserRequisition(); userRequisition.EmployeeName = r.firstname + " " + r.lastname; userRequisition.UserId = r.user_obj; Requisition requisition = new Requisition(); requisition.ReqId = r.requisition_id; requisition.Quantity = r.quantity; requisition.StationaryName = r.stationery_name; userRequisition.UserRequisitions.Add(requisition); userRequisitionsList.Add(userRequisition); } else { bool found = false; //check if requisition from the same user is pending, if yes group the requisition based on that user id foreach (UserRequisition uR in userRequisitionsList) { if (r.user_obj == uR.UserId) { found = true; Requisition requisition = new Requisition(); requisition.ReqId = r.requisition_id; requisition.Quantity = r.quantity; requisition.StationaryName = r.stationery_name; requisition.RequisitionDate = r.datetime_requested; uR.UserRequisitions.Add(requisition); break; } }//foreach //else simply add the userrequisition to the list, grouping not required if (!found) { UserRequisition userRequisition = new UserRequisition(); userRequisition.EmployeeName = r.firstname + " " + r.lastname; userRequisition.UserId = r.user_obj; Requisition requisition = new Requisition(); requisition.ReqId = r.requisition_id; requisition.Quantity = r.quantity; requisition.StationaryName = r.stationery_name; userRequisition.UserRequisitions.Add(requisition); userRequisitionsList.Add(userRequisition); } //if } //else } //forEach System.Diagnostics.Debug.WriteLine("json serialized:" + JsonConvert.SerializeObject(userRequisitionsList)); return(JsonConvert.SerializeObject(userRequisitionsList)); /// return js.Serialize(userRequisitionsList); }//showAllPendingRequisition
public static string LoadAllPendingRequests() { User sUser = (User)HttpContext.Current.Session["user"]; if (sUser == null) { return(null); } UserController userController = new UserController(); User dUser = userController.actionGetUserByID(sUser.id); RequisitionController requisitionController = new RequisitionController(); JavaScriptSerializer js = new JavaScriptSerializer(); List <RequisitionView> requisitionDepartmentWise = requisitionController.actionGetPendingRequisitionViewsByDepartmentID(Convert.ToInt32(dUser.department)); System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ requisitions by department wise:" + requisitionDepartmentWise.Count()); List <UserRequisition> userRequisitionsList = new List <UserRequisition>(); foreach (RequisitionView r in requisitionDepartmentWise) { //System.Diagnostics.Debug.WriteLine(" Dept:" + r.department + "User id:" + r.user_id + " Name" + r.firstname + " Req Id:" + r.requisition_id + " Stationary Name" + r.stationery_name + " Quantity " + r.quantity); if (userRequisitionsList.Count == 0) { UserRequisition userRequisition = new UserRequisition(); //Since there are no requisitions made so no question of grouping based on user id userRequisition.EmployeeName = r.firstname + " " + r.lastname; userRequisition.UserId = r.user_obj; Requisition requisition = new Requisition(); requisition.ReqId = r.requisition_id; requisition.Quantity = r.quantity; requisition.StationaryName = r.stationery_name; // requisition.RequisitionDate = r.r userRequisition.UserRequisitions.Add(requisition); userRequisitionsList.Add(userRequisition); } else { bool found = false; //check if requisition from the same user is pending, if yes group the requisition based on that user id foreach (UserRequisition uR in userRequisitionsList) { if (r.user_obj == uR.UserId) { found = true; Requisition requisition = new Requisition(); requisition.ReqId = r.requisition_id; requisition.Quantity = r.quantity; requisition.StationaryName = r.stationery_name; // requisition.RequisitionDate = r.r uR.UserRequisitions.Add(requisition); break; } }//foreach //else simply add the userrequisition to the list, grouping not required if (!found) { UserRequisition userRequisition = new UserRequisition(); userRequisition.EmployeeName = r.firstname + " " + r.lastname; userRequisition.UserId = r.user_obj; Requisition requisition = new Requisition(); requisition.ReqId = r.requisition_id; requisition.Quantity = r.quantity; requisition.StationaryName = r.stationery_name; userRequisition.UserRequisitions.Add(requisition); userRequisitionsList.Add(userRequisition); } } } System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ loadAllPendingRequests:" + js.Serialize(userRequisitionsList)); return(js.Serialize(userRequisitionsList)); }//loadAllPendingRequests