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(); } } }
//Add data to session datatable protected void btnAdd_Click(object sender, EventArgs e) { if (ddlType.Text.Trim() == "") { this.ltStock.Text = "Required"; return; } if (txtQuantity.Text.Trim() == "") { this.ltStock.Text = ""; this.ltQuantity.Text = "Required"; return; } if (txtQuantity.Text.Trim() != "") { try { int i = Convert.ToInt32(txtQuantity.Text.ToString().Trim()); } catch { this.ltQuantity.Text = "Numeric!"; return; } } if (txtReason.Text.Trim() == "") { this.ltQuantity.Text = ""; this.ltReason.Text = "Required"; return; } else { int stationeryID = Convert.ToInt32(this.ddlStationeryID.Text.ToString()); int type = Convert.ToInt32(this.ddlType.Text.ToString()); int quantity = Convert.ToInt32(this.txtQuantity.Text.ToString().Trim()); String reason = this.txtReason.Text.Trim(); try { //Start Query the stationery description CatalogDAO cat = new CatalogDAO(); String description = cat.GetStationeryByID(stationeryID).Description; //End Query DataRow foundRow = ((DataTable)Session["myDatatable"]).Rows.Find(stationeryID); int rowNum = Convert.ToInt32(foundRow); AddDataToTable(stationeryID, description, type, quantity, reason, (DataTable)Session["myDatatable"]); this.GridView1.DataSource = ((DataTable)Session["myDatatable"]).DefaultView; this.GridView1.DataBind(); this.ltStock.Text = ""; this.ltQuantity.Text = ""; this.ltDescription.Text = ""; this.ltReason.Text = ""; this.txtQuantity.Text = ""; this.txtReason.Text = ""; } catch { this.ltStock.Text = ""; this.ltQuantity.Text = ""; this.ltReason.Text = ""; this.ltDescription.Text = "Duplicate"; } } }
public CatalogManager() { catalogDAO = new CatalogDAO(); }