public RequisitionDetail(int id, Requisition requisitionId, Item itemId, int qty, int deliveredQty) { this.Id = id; this.Requisition = requisitionId; this.Item = itemId; this.Qty = qty; this.DeliveredQty = deliveredQty; }
public RequestStationeryControl() { currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.EMPLOYEE); InventoryEntities inventory = new InventoryEntities(); requisitionBroker = new RequisitionBroker(inventory); itemBroker = new ItemBroker(inventory); employeeBroker = new EmployeeBroker(inventory); requisition = new Requisition(); requisition.CreatedBy = Util.GetEmployee(employeeBroker); requisition.Department = requisition.CreatedBy.Department; requisition.Status = Converter.objToInt(Constants.REQUISITION_STATUS.PENDING); requisition.Id = requisitionBroker.GetRequisitionId(requisition); itemAdded = 0; dataColumn = new DataColumn[] { new DataColumn(columnName[0]), new DataColumn(columnName[1]), new DataColumn(columnName[2]) }; }
//,Boolean isSaved) /// <summary> /// Logically delete the Requisition by setting the status to 2 in the Requisition table /// Return Constants.DB_STATUS /// </summary> /// <param name="requisiton"></param> /// <returns></returns> public Constants.DB_STATUS Delete(Requisition requisiton) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { //requisitionObj = inventory.Requisitions.Where(reqObj => reqObj.Id == requisiton.Id).First(); //requisitionObj.Id = requisiton.Id; //requisitionObj.ApprovedBy = requisiton.ApprovedBy; //requisitionObj.Id = requisiton.Id; // requisitionObj.Status = requisiton.Status; //requisitionObj.Status = 6; //if(isSaved) inventory.SaveChanges(); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
//, Boolean isSaved) /// <summary> /// Insert Requisition data to the Requisition Table according to the Requisition Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="requisition"></param> /// <returns></returns> public Constants.DB_STATUS Insert(Requisition requisition) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { inventory.AddToRequisitions(requisition); //foreach (RequisitionDetail requisitionDetail in requisition.RequisitionDetails) //{ // this.Insert(requisitionDetail); //} // if (isSaved) inventory.SaveChanges();//to add in all insert method inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// Retrieve the Requisition and RequisitionDetail information according to the Requisition Parameter /// /// </summary> /// <param name="requisition"></param> /// <returns></returns> public Requisition GetRequisition(Requisition requisition) { try { if (requisition.Status != 0) { int status = Converter.objToInt(requisition.Status); requisitionObj = inventory.Requisitions.Where(reqObj => reqObj.Id.Contains(requisition.Id) && reqObj.Status == status).First(); } else { requisitionObj = inventory.Requisitions.Where(reqObj => reqObj.Id.Contains(requisition.Id)).First(); } } catch (Exception e) { requisitionObj = null; } //if (!req.Equals(null)) //{ // var requisitionDetailsResult = from rd in inventory.RequisitionDetails // where rd.Requisition.Id == req.Id // select rd; // foreach (RequisitionDetail rd in requisitionDetailsResult) // { // req.RequisitionDetails.Add(rd); // } // return req; //} return requisitionObj; }
/// <summary> /// Get the last requisition Id from requistion table /// </summary> /// <param name="requisition"></param> /// <returns> /// Return RequisitionId /// </returns> public string GetRequisitionId(Requisition requisition) { try { int idInt; string newYr; if (inventory.Requisitions.Where(r => r.Id.IndexOf(requisition.Department.Id) > -1).Count() > 0) { Requisition lastRequisition = inventory.Requisitions.Where(r => r.Id.IndexOf(requisition.Department.Id) > -1).OrderByDescending(x => x.CreatedDate).First(); if (lastRequisition != null) { string requisitionId = lastRequisition.Id; string[] stringList = requisitionId.Split('/'); string idString = stringList[1]; idInt = Converter.objToInt(idString); int yearInt = DateTime.Now.Year; string yrString = yearInt.ToString(); char[] charYr = yrString.ToCharArray(); newYr = charYr[2].ToString() + charYr[3].ToString(); if (newYr.Equals(stringList[2])) { idInt++; } else { idInt = 1; } } else { idInt = 1; newYr = DateTime.Now.Year.ToString().Substring(2); } } else { idInt = 1; newYr = DateTime.Now.Year.ToString().Substring(2); } return requisition.Department.Id + "/" + idInt + "/" + newYr; } catch (Exception e) { return "Unknown"; } }
/// <summary> /// Create a new Requisition object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="createdDate">Initial value of the CreatedDate property.</param> /// <param name="status">Initial value of the Status property.</param> public static Requisition CreateRequisition(global::System.String id, global::System.DateTime createdDate, global::System.Int32 status) { Requisition requisition = new Requisition(); requisition.Id = id; requisition.CreatedDate = createdDate; requisition.Status = status; return requisition; }
/// <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); }
//public RequisitionDetail SelectRequisitionID(string requisitionId) //{ // //requisition = new Requisition(); // RequisitionDetail requisitionDetail = new RequisitionDetail(); // requisitionDetail.Id = requisitionId; // RequisitionDetail resultRequisitionDetail=requisitionBroker.GetRequisitionDetail(requisitionDetail); //} /// <summary> /// Refresh requisition list after withdraw one requisition /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="requisitionId"></param> /// <returns>The return type of this method is datatable.</returns> public Constants.ACTION_STATUS SelectWithdraw(string requisitionId, string remarks) { Constants.REQUISITION_STATUS requisitionStatus = Constants.REQUISITION_STATUS.WITHDRAW; Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; //Employee employee = new Employee(); //employee.Id = currentEmployee.Id; //employee = employeeBroker.GetEmployee(employee); requisition = new Requisition(); requisition.Id = requisitionId; requisition = requisitionBroker.GetRequisition(requisition); requisition.Remarks = (remarks == null ? String.Empty : remarks); //requisition.ApprovedBy = employee; //requisition.ApprovedDate = DateTime.Now; requisition.Status = Converter.objToInt(requisitionStatus); if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.FAILED) { status = Constants.ACTION_STATUS.FAIL; } else { status = Constants.ACTION_STATUS.SUCCESS; } return status; //Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; //Constants.DB_STATUS dbStatus = requisitionBroker.Delete(requisition); //dbStatus = Constants.DB_STATUS.SUCCESSFULL; //if (requisitionList.Count == 1) // return null; //else // return GetRequisitionList(); }
public RequisitionCollectionDetail(int id, Requisition requisitionId, RequisitionCollection requisitionCollectionId) { this.Id = id; this.Requisition = requisitionId; this.RequisitionCollection = requisitionCollectionId; }
public Constants.ACTION_STATUS SetDeliveryDate(int retrievalNo, DateTime deliveryDate) { Constants.ACTION_STATUS setStatus = Constants.ACTION_STATUS.UNKNOWN; Retrieval retrieval = retrievalList.Find(delegate(Retrieval r) { return r.Id == retrievalNo; }); foreach (RetrievalDetail retrievalDetail in retrieval.RetrievalDetails) { Requisition requisition = new Requisition(); requisition.Id = retrievalDetail.Requisition.Id; requisition = requisitionBroker.GetRequisition(requisition); RequisitionCollectionDetail requisitionCollectionDetail = requisitionCollectionBroker.GetRequisitionCollectionDetail(requisition); RequisitionCollection requisitionCollection = new RequisitionCollection(); requisitionCollection.Id = requisitionCollectionDetail.RequisitionCollection.Id; requisitionCollection = requisitionCollectionBroker.GetRequisitionCollection(requisitionCollection); requisitionCollection.DeliveryDate = DateTime.Now; requisitionCollection.DeliveryBy = Util.GetEmployee(employeeBroker); requisitionCollectionBroker.Update(requisitionCollection); } return setStatus; }
public void SelectRequisition(Requisition requisition) { RequisitionDetail requisitionDetail = new RequisitionDetail(); requisitionDetail.Requisition = requisition; RequisitionDetail resultRequisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); // show on UI }
/// <summary> /// Show requisition detail according to the selected requisition /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By:Thazin Win /// Modified Date:02-02-2012 /// Modification Reason:To retrieve detail data /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="requisitionId"></param> /// <returns>The return type of this method is datatable.</returns> public Constants.ACTION_STATUS SelectRequisitionID(string requisitionId) { Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN; requisition = RequisitionList.Find(delegate(Requisition req) { return req.Id.Contains(requisitionId); }); if (requisition != null) { selectStatus = Constants.ACTION_STATUS.SUCCESS; } else { selectStatus = Constants.ACTION_STATUS.FAIL; } return selectStatus; }
public Constants.ACTION_STATUS SelectRejectRequisition(Requisition requisition) { Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; requisition.Status = (int)Constants.REQUISITION_STATUS.REJECTED; requisitionBroker.Update(requisition); status = Constants.ACTION_STATUS.SUCCESS; return status; }
//public Requisition EnterRequisitionID(string requisitionId) //{ // requisition = new Requisition(); // requisition.Id = requisitionId; // requisitionBroker.GetRequisition(requisition); // return requisition; //} /// <summary> /// Show one requisition according to requisitionId parameter /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="requisitionId"></param> /// <returns>The return type of this method is datatable.</returns> public DataTable EnterRequisitionID(string requisitionId) { requisition = new Requisition(); requisition.Id = requisitionId; requisition = requisitionBroker.GetRequisition(requisition); requisitionDetail = new RequisitionDetail(); requisitionDetail.Requisition.Id = requisitionId; requisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); dt = new DataTable(); dr = dt.NewRow(); dr["requisitionId"] = requisition.Id; dr["requisitionDate/Time"] = requisition.CreatedDate; dr["status"] = requisition.Status; dr["remainingQty"] = requisitionDetail.Qty - requisitionDetail.DeliveredQty; dr["remarks"] = requisition.Remarks; dt.Rows.Add(dr); return dt; }
private Constants.ACTION_STATUS SelectActionRequisition(Dictionary<string, string> remarks, Constants.REQUISITION_STATUS requisitionStatus) { Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; // employeeBroker = new EmployeeBroker(inventory); if (remarks.Count > 0) { status = Constants.ACTION_STATUS.SUCCESS; Requisition requisition; Employee employee = new Employee(); employee.Id = currentEmployee.Id; employee = employeeBroker.GetEmployee(employee); foreach (string key in remarks.Keys) { requisition = pendingRequisitionList.ElementAt(Converter.objToInt(key)); requisition.Status = Converter.objToInt(requisitionStatus); requisition.Remarks = remarks[key]; requisition.ApprovedBy = employee; requisition.ApprovedDate = DateTime.Now; pendingRequisitionList[Converter.objToInt(key)] = requisition; //pendingRequisitionList.Remove(requisition); if (requisitionBroker.Update(requisition) == Constants.DB_STATUS.FAILED) { status = Constants.ACTION_STATUS.FAIL; break; } } } else { status = Constants.ACTION_STATUS.FAIL; } return status; }
/// <summary> /// Update Requisition data to Requisition Table according to the Requisition Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="requisition"></param> /// <returns></returns> public Constants.DB_STATUS Update(Requisition requisition) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { //requisitionObj = inventory.Requisitions.Where(reqObj => reqObj.Id == requisition.Id).First(); //Employee empId=inventory.Employees.Where(e=>e.Id==requisition.CreatedBy.Id).First(); //Employee approvedBy=inventory.Employees.Where(e=>e.Id==requisition.ApprovedBy.Id).First(); //Department department = inventory.Departments.Where(d => d.Id == requisition.Department.Id).First(); ////requisitionObj.Id = requisition.Id; //requisitionObj.Department = department; //requisitionObj.CreatedBy = empId; //requisitionObj.ApprovedBy = approvedBy; //requisitionObj.ApprovedDate = requisition.ApprovedDate; //requisitionObj.CreatedDate = requisition.CreatedDate; //foreach (RequisitionDetail requisitionDetail in requisition.RequisitionDetails) //{ // this.Update(requisitionDetail); //} //if (isSaved) inventory.SaveChanges(); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
static void Main() { // Write the Main Program for RequistionBrokerTest here... RequisitionBroker reqBroker = new RequisitionBroker(); Requisition req = new Requisition(); RequisitionDetail reqDetail=new RequisitionDetail(); Department dept = new Department(); Item item = new Item(); Employee emp = new Employee(); dept.Id = "COMM"; emp.Id = 1; emp.Department = dept; emp.Role = new Role(); emp.Role.Id = 1; emp.User = new User(); emp.User.Employee = emp; emp.User1 = new User(); emp.User1.Employee = emp; req.Department = dept; // req.Employee = emp; //req.Employee.Id=1; req.Remarks="Insert Test"; //req.ApprovedDate=new DateTime(23-01-2012); //req.CreatedDate=new DateTime(23-01-2012); req.Status=1; req.Employee = emp; req.Employee1 = emp; // reqDetail.Requisition.Id // reqDetail.Item.Id="1"; item.Id = "1"; reqDetail.Item=item; reqDetail.Qty=10; reqDetail.DeliveredQty=20; req.RequisitionDetails.Add(reqDetail); reqDetail.Item.Employee = reqDetail.Requisition.Employee; if (reqBroker.Insert(req).Equals("FAILED")) { Console.WriteLine("Successful"); } else { Console.WriteLine("Error"); } /* req.Id = "1"; if (reqBroker.GetRequisition(req) != null) { Console.WriteLine(reqBroker.GetRequisition(req).Remarks); foreach(RequisitionDetail reqDetial in reqBroker.GetRequisition(req).RequisitionDetails) Console.WriteLine(reqDetial.DeliveredQty); } if (reqBroker.GetAllRequisition().Count > 0) { Console.WriteLine("Retrieve all requisitions"); foreach (Requisition r in reqBroker.GetAllRequisition()) { Console.WriteLine(r.Id + " " + r.Remarks); foreach (RequisitionDetail rd in r.RequisitionDetails) { Console.WriteLine(rd.Id + " " + rd.Item.Description); } } } else { Console.WriteLine("Cannot read all requisitions"); } Console.WriteLine(SystemStoreInventorySystemUtil.Converter.objToInt(SystemStoreInventorySystemUtil.Constants.VISIBILITY_STATUS.SHOW)); Console.WriteLine(SystemStoreInventorySystemUtil.Constants.VISIBILITY_STATUS.SHOW); */ #region /* Do not remove this or write codes after this */ ISSConsole.Pause(); #endregion }
/// <summary> /// Refresh requisition list after withdraw one requisition /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By: /// Modified Date: /// Modification Reason: /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="requisitionId"></param> /// <returns>The return type of this method is datatable.</returns> public Constants.ACTION_STATUS Setstatus(string requisitionId, Constants.REQUISITION_STATUS Reqstatus, string remarks, DataTable dt) { Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; requisition = RequisitionList.Find(delegate(Requisition req) { return req.Id.Contains(requisitionId); }); if (Reqstatus != Constants.REQUISITION_STATUS.REJECTED) { foreach (RequisitionDetail temp in requisition.RequisitionDetails) { DataRow[] dr = dt.Select(" ItemCode = '" + temp.Item.Id + "'"); if (dr != null && dr.Length > 0) { temp.Qty = Convert.ToInt16(dr[0][1].ToString()); temp.DeliveredQty = Convert.ToInt16(dr[0][2].ToString()); } } } requisition.Remarks = remarks; requisition.Status = (int)(Reqstatus); requisitionBroker.Update(requisition); if(Reqstatus == Constants.REQUISITION_STATUS.COMPLETE) { RequisitionCollection RC = null; //Get all submitted requisitions RequisitionCollectionDetail rcDetails = requisitionCollectionBroker.GetAllRequisitionCollectionDetail(requisitionId); if(rcDetails != null) { RC = requisitionCollectionBroker.GetAllRequisitionCollectionByRequisitionCollectionID(rcDetails.RequisitionCollection.Id.ToString()); } foreach(RequisitionCollectionDetail rcd in RC.RequisitionCollectionDetails) { if(rcd.Requisition.Status == (int)Constants.REQUISITION_STATUS.COMPLETE) RC.Status = (int)Constants.COLLECTION_STATUS.COLLECTED; else RC.Status = (int)Constants.COLLECTION_STATUS.NEED_TO_COLLECT; } requisitionCollectionBroker.Update(RC); } return status; }
/// <summary> /// Show requisition detail according to the selected requisition /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By:Thazin Win /// Modified Date:02-02-2012 /// Modification Reason:To retrieve detail data /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name="requisitionId"></param> /// <returns>The return type of this method is datatable.</returns> public Constants.ACTION_STATUS SelectRequisitionID(string requisitionId) { Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN; requisition = pendingRequisitionList.Find(delegate(Requisition req) { return req.Id.Contains(requisitionId); }); if (requisition != null) { selectStatus = Constants.ACTION_STATUS.SUCCESS; } else { selectStatus = Constants.ACTION_STATUS.FAIL; } return selectStatus; // dt = new DataTable(); // dt.Columns.Add("itemNo"); // dt.Columns.Add("itemDescription"); // dt.Columns.Add("requiredQty"); // dt.Columns.Add("receivedQty"); // dt.Columns.Add("remainingQty"); // List<RequisitionDetail> requistionDetailList; // requisition = new Requisition(); // itemBroker = new ItemBroker(inventory); // requisition.Id = requisitionId; // requisitionDetail=new RequisitionDetail(); // requisitionDetail.Requisition=requisition; // requistionDetailList = requisitionBroker.GetAllRequisitionDetailByObj(requisitionDetail); //foreach (RequisitionDetail temp in requistionDetailList) // { // dr = dt.NewRow(); // Item item = new Item(); // item =temp.Item ; // item = itemBroker.GetItem(item); // dr["itemNo"] = item.Id; // dr["itemDescription"] = item.Description; // dr["requiredQty"] = temp.Qty; // dr["receivedQty"] = temp.DeliveredQty.HasValue ? temp.DeliveredQty.Value : 0; // if (temp.DeliveredQty.Equals(null)) // dr["remainingQty"] = 0; // else // dr["remainingQty"] = temp.Qty - temp.DeliveredQty; // dt.Rows.Add(dr); // } // return dt; }