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); }
public static string LoadAllApprovedRequests() { 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.actionGetApprovedRequisitionViewsByDepartmentID(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) { 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); }
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
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