/// <summary> /// Update Requisition detail data to Requisition detail Table according to the Requisition Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="requisitionDetail"></param> /// <returns></returns> public Constants.DB_STATUS Update(RequisitionDetail requisitionDetail) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { requisitionDetailObj = inventory.RequisitionDetails.Where(reqObj => reqObj.Id == requisitionDetail.Id).First(); Item itemId = inventory.Items.Where(i => i.Id == requisitionDetail.Item.Id).First(); Requisition requisitionId = inventory.Requisitions.Where(r => r.Id == requisitionDetail.Requisition.Id).First(); requisitionDetailObj.Id = requisitionDetail.Id; requisitionDetailObj.Requisition = requisitionId; requisitionDetailObj.Qty = requisitionDetail.Qty; requisitionDetailObj.DeliveredQty = requisitionDetail.DeliveredQty; requisitionDetailObj.Item = itemId; inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// There is no status in RetrievalTable. /// </summary> /// <param name="requisitionDetail"></param> /// <returns></returns> public Constants.DB_STATUS Delete(RequisitionDetail requisitionDetail) { throw new NotImplementedException(); }
/// <summary> /// Retrieve the RequisitionDetail information according to the Requisition detail Parameter /// </summary> /// <param name="requisitionDetail"></param> /// <returns></returns> public RequisitionDetail GetRequisitionDetail(RequisitionDetail requisitionDetail) { try { requisitionDetailObj = inventory.RequisitionDetails.Where(reqObj => reqObj.Id == requisitionDetail.Id || reqObj.Requisition.Id == requisitionDetail.Requisition.Id ).First(); } catch (Exception e) { requisitionDetailObj = null; } return requisitionDetailObj; }
/// <summary> /// Insert Requisition dtail data to the Requisition detail Table according to the Requisition Parameter /// Return Constants.DB_STATUS /// </summary> /// <param name="requisitionDetail"></param> /// <returns></returns> public Constants.DB_STATUS Insert(RequisitionDetail requisitionDetail) { Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN; try { inventory.AddToRequisitionDetails(requisitionDetail); inventory.SaveChanges(); status = Constants.DB_STATUS.SUCCESSFULL; } catch (Exception e) { status = Constants.DB_STATUS.FAILED; } return status; }
/// <summary> /// Deprecated Method for adding a new object to the RequisitionDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToRequisitionDetails(RequisitionDetail requisitionDetail) { base.AddObject("RequisitionDetails", requisitionDetail); }
/// <summary> /// Retrieve the list of RequisitionDetail information according to the Requisition detail Parameter /// </summary> /// <param name="requisitionDetail"></param> /// <returns> /// List of Requisition Detail /// </returns> public List<RequisitionDetail> GetAllRequisitionDetailByObj(RequisitionDetail requisitionDetail) { try { requisitionDetailList = inventory.RequisitionDetails.Where(reqObj => reqObj.Requisition.Id == requisitionDetail.Requisition.Id).ToList<RequisitionDetail>(); } catch (Exception e) { requisitionDetailList = null; } return requisitionDetailList; }
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> /// Create a new RequisitionDetail object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="qty">Initial value of the Qty property.</param> public static RequisitionDetail CreateRequisitionDetail(global::System.Int32 id, global::System.Int32 qty) { RequisitionDetail requisitionDetail = new RequisitionDetail(); requisitionDetail.Id = id; requisitionDetail.Qty = qty; return requisitionDetail; }
public void SelectRequisition(Requisition requisition) { RequisitionDetail requisitionDetail = new RequisitionDetail(); requisitionDetail.Requisition = requisition; RequisitionDetail resultRequisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); // show on UI }
/// <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 getRequisition(string requisitionId) { //requisition = new Requisition(); //requisition.Id = requisitionId; //requisition = RequisitionList.Find(delegate(Requisition req) { return requisitionId == req.Id; }); requisitionDetail = new RequisitionDetail(0, new Requisition(), new Item(), 0, 0); requisitionDetail.Requisition.Id = requisitionId; requisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); dt = new DataTable(); dt.Columns.Add("requisitionId"); dt.Columns.Add("requisitionDate/Time"); dt.Columns.Add("status"); dt.Columns.Add("remainingQty"); dt.Columns.Add("remarks"); dt.Columns.Add("deptCode"); dt.Columns.Add("deptName"); dt.Columns.Add("empName"); dt.Columns.Add("empNumber"); dt.Columns.Add("empEmail"); 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; dr["deptCode"] = requisition.Department.Id; dr["deptName"] = requisition.Department.Name; dr["empName"] = requisition.CreatedBy.Name; dr["empNumber"] = requisition.CreatedBy.Id; dr["empEmail"] = requisition.CreatedBy.Email; dt.Rows.Add(dr); return dt; }
//public List<Requisition> GetRequisitionList() //{ // return requisitionList; //} /// <summary> /// Show all requisition. /// Created By:JinChengCheng /// Created Date:26-01-2012 /// Modified By:Thazin Win /// Modified Date:02-02-2012 /// Modification Reason:Get requisition list by requistion /// Modified By: /// Modified Date: /// Modification Reason: /// </summary> /// <param name=""></param> /// <returns>The return type of this method is datatable.</returns> public DataTable GetRequisitionList() { dt = new DataTable(); dt.Columns.Add("requisitionID"); dt.Columns.Add("requisitionDate"); dt.Columns.Add("status"); dt.Columns.Add("remainingQty"); dt.Columns.Add("remarks"); List<Requisition> requisitionList = requisitionBroker.GetAllRequisitionByEmployee(Util.GetEmployee().Id);// GetAllRequisitionByStatus(); foreach (Requisition temp in requisitionList) { requisitionDetail = new RequisitionDetail(); // requisitionDetail.Requisition.Id = temp.Id; requisitionDetail.Requisition = temp; //Requisition resultRequisition = requisitionBroker.GetRequisition(temp); RequisitionDetail resultRequisitionDetail = requisitionBroker.GetRequisitionDetail(requisitionDetail); dr = dt.NewRow(); dr["requisitionID"] = temp.Id; dr["requisitionDate"] = temp.CreatedDate; //dr["status"] = Converter.GetRequisitionStatusText(Converter.objToRequisitionStatus(temp.Status)); dr["status"] = temp.Status; dr["status"] = Enum.GetName(typeof(Constants.REQUISITION_STATUS), temp.Status); dr["remainingQty"] = resultRequisitionDetail.Qty - requisitionDetail.DeliveredQty; dr["remarks"] = temp.Remarks; dt.Rows.Add(dr); //dr["requsitionId"] = temp.Id; //dr["requisitionDate"] = temp.CreatedDate; //dr["status"] = temp.Status; //dr["remainingQty"] = resultRequisitionDetail.Qty-requisitionDetail.DeliveredQty; //dr["remarks"] = temp.Remarks; } return dt; }
//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; }
public Constants.ACTION_STATUS AddToTable(string itemId) { Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN; RequisitionDetail requisitionDetail; Item item = new Item(); item.Id = itemId; item = itemBroker.GetItem(item); if (item != null) { if (requisition.RequisitionDetails.Where(x=> x.Item.Id == itemId).Count() == 0) { requisitionDetail = new RequisitionDetail(); requisitionDetail.Id = requisitionBroker.GetRequisitionDetailId() + (itemAdded++); requisitionDetail.Requisition = requisition; requisitionDetail.Item = item; requisitionDetail.Qty = 1; requisition.RequisitionDetails.Add(requisitionDetail); status = Constants.ACTION_STATUS.SUCCESS; } else { status = Constants.ACTION_STATUS.FAIL; } } else { status = Constants.ACTION_STATUS.FAIL; } return status; }