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; } }
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"; } }
protected void Page_Load(object sender, EventArgs e) { DataContext db = new DataContext(); List<Requisition> rl = db.Requisitions.Where(o => (o.id >= 141 && o.id <= 225)).ToList(); List<PurchaseOrder> po = db.PurchaseOrders.Where( o => (o.id >= 1 && o.id <=300)).ToList(); foreach (PurchaseOrder p in po) { if(p.po_reordered_quantity > 60){ p.po_reordered_quantity -= 20; } } db.SaveChanges(); return; foreach (Requisition r2 in rl) { Requisition r1 = new Requisition(); //copier Department department = db.Departments.Where(o => o.id == r2.department).SingleOrDefault(); r1.stationery = r2.stationery; r1.quantity = GetRandomNumber(1, 3); r1.user_obj = r2.user_obj; r1.status = 1; r1.department = department.id; r1.datetime_requested = DateTime.Now; db.Requisitions.AddObject(r1); } db.SaveChanges(); return; //Requisition r1 = new Requisition(); //Requisition r2 = new Requisition(); ////copier //Department department = db.Departments.Where(o => o.id == r2.department).SingleOrDefault(); //r1.stationery = r2.stationery; //r1.quantity = r2.quantity; //r1.user_obj = r2.user_obj; ////r1.status = r2.status; //r1.department = department.id; ////r1.user_approved_by = department.department_head; }
public string showAllRejectedRequisitions(string accessToken) { OAuthController oAuth = new OAuthController(); User user = oAuth.actionGetUserByToken(accessToken); RequisitionController requisitionController = new RequisitionController(); List<RequisitionView> requisitionDepartmentWise = requisitionController.actionGetRejectedRequisitionViewsByDepartmentID(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); }
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); }
/// <summary> /// Deprecated Method for adding a new object to the Requisitions EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToRequisitions(Requisition requisition) { base.AddObject("Requisitions", requisition); }
/// <summary> /// Create a new Requisition object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="stationery">Initial value of the stationery property.</param> /// <param name="quantity">Initial value of the quantity property.</param> /// <param name="user_obj">Initial value of the user_obj property.</param> /// <param name="status">Initial value of the status property.</param> /// <param name="datetime_requested">Initial value of the datetime_requested property.</param> /// <param name="department">Initial value of the department property.</param> public static Requisition CreateRequisition(global::System.Int32 id, global::System.Int32 stationery, global::System.Int32 quantity, global::System.Int32 user_obj, global::System.Int32 status, global::System.DateTime datetime_requested, global::System.Int32 department) { Requisition requisition = new Requisition(); requisition.id = id; requisition.stationery = stationery; requisition.quantity = quantity; requisition.user_obj = user_obj; requisition.status = status; requisition.datetime_requested = datetime_requested; requisition.department = department; return requisition; }
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 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"; }