private void TestMethod() { requisition.CreatedBy = 1; requisition.DepartmentID = 1; requisition.RequisitionForm = "dds/111/11"; requisition.StatusID = 1; requisition.UrgencyID = 1; requisition.DateRequested = DateTime.Now; SpecialRequisitionItem splItem = new SpecialRequisitionItem() { QuantityIssued = 0, QuantityRequested = 10, Name = "test", Description = "desc", RemarkByRequester = "remarks", Price = 0 }; RequisitionItem item = new RequisitionItem() { StationeryID = 1, QuantityRequested = 12, QuantityIssued = 0, Price = 0 }; requisition.RequisitionItems.Add(item); requisition.SpecialRequisitionItems.Add(splItem); try { rDAO.CreateRequisition(requisition); } catch (Exception) { throw; } }
/// <summary> /// Update the special requisitionItem /// </summary> /// <param name="requisitionItem">specialRequisitionItem object</param> public void UpdateSpecialRequisitionItem(SpecialRequisitionItem specialRequisitionItem) { try { var temp = (from ri in context.SpecialRequisitionItems where ri.SpecialRequisitionItemsID == specialRequisitionItem.SpecialRequisitionItemsID select ri).FirstOrDefault<SpecialRequisitionItem>(); temp.SpecialStationery = specialRequisitionItem.SpecialStationery; temp.QuantityRequested = specialRequisitionItem.QuantityRequested; temp.Price = specialRequisitionItem.Price; context.SaveChanges(); } catch (Exception) { throw; } }
/// <summary> /// Get special RequisitionItems by primary key /// </summary> /// <param name="requisitionItem">requisitionItem object</param> /// <returns></returns> public SpecialRequisitionItem GetSpecialRequisitionItemsByID(SpecialRequisitionItem specialRequisitionItem) { try { return (from ri in context.SpecialRequisitionItems where ri.SpecialRequisitionItemsID == specialRequisitionItem.SpecialRequisitionItemsID select ri).FirstOrDefault<SpecialRequisitionItem>(); } catch (Exception) { throw; } }
/// <summary> /// Delete the special requisitionItem /// </summary> /// <param name="requisitionItem">specialRequisitionItem object</param> public void DeleteSpecialRequisitionItem(SpecialRequisitionItem requisitionItem) { try { var temp = (from ri in context.SpecialRequisitionItems where ri.SpecialRequisitionItemsID == requisitionItem.SpecialRequisitionItemsID select ri).FirstOrDefault<SpecialRequisitionItem>(); if (temp != null) { context.SpecialRequisitionItems.DeleteObject(temp); context.SaveChanges(); } } catch (Exception) { throw; } }
/// <summary> /// Create a new specialRequisitionItem /// </summary> /// <param name="requisitionItem">specialRequisitionItem object</param> public void CreateSpecialSpecialRequisitionItem(SpecialRequisitionItem specialRequisitionItem) { try { context.AddToSpecialRequisitionItems(specialRequisitionItem); } catch (Exception) { throw; } }
/// <summary> /// Update the special requisitionItem /// </summary> /// <param name="requisitionItem">specialRequisitionItem object</param> public void UpdateSpecialRequisitionItem(SpecialRequisitionItem specialRequisitionItem) { try { SpecialRequisitionItem temp = requisitionDAO.GetSpecialRequisitionItemsByID(specialRequisitionItem); if (temp != null) { temp.SpecialStationery = specialRequisitionItem.SpecialStationery; temp.QuantityRequested = specialRequisitionItem.QuantityRequested; temp.Price = specialRequisitionItem.Price; requisitionDAO.UpdateSpecialRequisitionItem(temp); } else { ErrorMessage("Update special requisition failed"); } } catch (Exception) { throw; } }
/// <summary> /// Get special RequisitionItems by primary key /// </summary> /// <param name="requisitionItem">requisitionItem object</param> /// <returns></returns> public SpecialRequisitionItem GetSpecialRequisitionItemsByID(SpecialRequisitionItem specialRequisitionItem) { try { var temp = requisitionDAO.GetSpecialRequisitionItemsByID(specialRequisitionItem); if (temp != null) { return temp; } ErrorMessage("Result Not Found"); return null; } catch (Exception) { throw; } }
/// <summary> /// Delete the special requisitionItem /// </summary> /// <param name="requisitionItem">specialRequisitionItem object</param> public void DeleteSpecialRequisitionItem(SpecialRequisitionItem specialRequisitionItem) { try { SpecialRequisitionItem temp = requisitionDAO.GetSpecialRequisitionItemsByID(specialRequisitionItem); if (temp != null && ValidateSpecialRequisitionItem(specialRequisitionItem, RequisitionMethod.Delete)) { requisitionDAO.DeleteSpecialRequisitionItem(temp); } else { ErrorMessage("Delete special requisition failed"); } } catch (Exception) { throw; } }
/// <summary> /// Create a new specialRequisitionItem /// </summary> /// <param name="requisitionItem">specialRequisitionItem object</param> public void CreateSpecialSpecialRequisitionItem(SpecialRequisitionItem specialRequisitionItem) { try { if (specialRequisitionItem != null && ValidateSpecialRequisitionItem(specialRequisitionItem, RequisitionMethod.Create)) { requisitionDAO.CreateSpecialSpecialRequisitionItem(specialRequisitionItem); } else { ErrorMessage("Create Special Requisition Item Failed"); } } catch (Exception) { throw; } }
/// <summary> /// Validate SpecialRequisitionItem /// </summary> /// <param name="specialRequisitionItem">specialRequisitionItem object</param> /// <param name="requisitionMethod">enum requisitionMethod</param> /// <returns>boolean</returns> private bool ValidateSpecialRequisitionItem(SpecialRequisitionItem specialRequisitionItem, RequisitionMethod requisitionMethod) { try { if (specialRequisitionItem != null) { if (requisitionMethod == RequisitionMethod.Create) { if ((specialRequisitionItem.RequisitionID != 0 || specialRequisitionItem.Requisition != null) && (specialRequisitionItem.SpecialStationeryID != 0 || specialRequisitionItem.SpecialStationeryID != null) && (specialRequisitionItem.QuantityRequested > 0)) { return true; } } if (requisitionMethod == RequisitionMethod.Update) { if ((specialRequisitionItem.RequisitionID != 0 || specialRequisitionItem.Requisition != null) && (specialRequisitionItem.SpecialStationeryID != 0 || specialRequisitionItem.SpecialStationery != null) && (specialRequisitionItem.SpecialStationery.IsApproved == false) && (specialRequisitionItem.QuantityRequested > 0)) { return true; } } if (requisitionMethod == RequisitionMethod.Delete) { if (specialRequisitionItem.SpecialRequisitionItemsID != 0) { return true; } } } return false; } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { //Create instance of new requisition Requisition r = new Requisition(); UserDAO user = new UserDAO(); RequisitionManager rq = new RequisitionManager(); CatalogDAO cat = new CatalogDAO(); //set the properties of requisition object r.DepartmentID = user.GetDepartmentByID(1).DepartmentID; r.CreatedBy = user.GetUserByID(1).UserID; r.StatusID = rq.GetStatusByID(new Status() { StatusID = 1}).StatusID; r.ApprovedBy = user.GetUserByID(2).UserID; r.UrgencyID = rq.GetUrgencyByID(new Urgency() { UrgencyID = 1 }).UrgencyID; r.RequisitionForm = "test"; r.DateRequested = DateTime.Now; //r.DateApproved = DateTime.Now; //Create a new requisitionitem for the current requisition RequisitionItem rqi = new RequisitionItem() { RequisitionID = r.RequisitionID, StationeryID = cat.GetAllStationeries().FirstOrDefault<Stationery>().StationeryID, QuantityRequested = 10, QuantityIssued = 10, Price = 5 }; //Create a new specialrequisitionitem for the current requisition SpecialRequisitionItem spi = new SpecialRequisitionItem() { RequisitionID = r.RequisitionID, SpecialStationeryID = 1, QuantityRequested = 10, QuantityIssued = 10, Price = 5, Name = "arav", Description = "test" }; //Add Child objects of the requisition objects //Add requisitionitem to requisition object r.RequisitionItems.Add(rqi); //Add specialitem to requisition object r.SpecialRequisitionItems.Add(spi); //Persist requisition to database //EF is very intelligent. It will also persist to requistionitem and specialrequistionitem rq.CreateRequisition(r); r = rq.GetAllRequisition().Last<Requisition>(); r.RequisitionItems.Last<RequisitionItem>().QuantityIssued = 6; rq.UpdateRequisition(r); spi = rq.GetAllSpecialRequisitionItems(r).Last<SpecialRequisitionItem>(); rq.DeleteSpecialRequisitionItem(spi); //Testing databinding after creation of requisitions if (!IsPostBack) { GridView1.DataSource = rq.GetAllRequisitionItems(r); GridView1.DataBind(); if (r != null) { GridView2.DataSource = rq.GetAllRequisition(); GridView2.DataBind(); } } }
/// <summary> /// Deprecated Method for adding a new object to the SpecialRequisitionItems EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToSpecialRequisitionItems(SpecialRequisitionItem specialRequisitionItem) { base.AddObject("SpecialRequisitionItems", specialRequisitionItem); }
/// <summary> /// Create a new SpecialRequisitionItem object. /// </summary> /// <param name="specialRequisitionItemsID">Initial value of the SpecialRequisitionItemsID property.</param> /// <param name="requisitionID">Initial value of the RequisitionID property.</param> /// <param name="quantityRequested">Initial value of the QuantityRequested property.</param> /// <param name="name">Initial value of the Name property.</param> /// <param name="price">Initial value of the Price property.</param> public static SpecialRequisitionItem CreateSpecialRequisitionItem(global::System.Int32 specialRequisitionItemsID, global::System.Int32 requisitionID, global::System.Int32 quantityRequested, global::System.String name, global::System.Decimal price) { SpecialRequisitionItem specialRequisitionItem = new SpecialRequisitionItem(); specialRequisitionItem.SpecialRequisitionItemsID = specialRequisitionItemsID; specialRequisitionItem.RequisitionID = requisitionID; specialRequisitionItem.QuantityRequested = quantityRequested; specialRequisitionItem.Name = name; specialRequisitionItem.Price = price; return specialRequisitionItem; }
protected void DetailsView2_ItemInserting(object sender, DetailsViewInsertEventArgs e) { SpecialRequisitionItem splItem = new SpecialRequisitionItem(); //splItem.SpecialStationeryID = 1; splItem.QuantityRequested = Convert.ToInt32(((TextBox)DetailsView2.FindControl("QtyNeededTextBox")).Text); splItem.QuantityIssued = 0; splItem.Name = ((TextBox)DetailsView2.FindControl("itemNameTextBox")).Text; splItem.Description = ((TextBox)DetailsView2.FindControl("DescriptionTextBox")).Text; splItem.RemarkByRequester = ((TextBox)DetailsView2.FindControl("ReasonTextBox")).Text; splItem.Price = 0; requisition.SpecialRequisitionItems.Add(splItem); GridDataBind(); }