/// <summary> /// Save /// </summary> /// <param name="unitId">unitId</param> /// <param name="companyId">companyId</param> public void Save(int unitId, int companyId) { UnitInformationTDS unitInformationChanges = (UnitInformationTDS)Data.GetChanges(); if (unitInformationChanges.InspectionDetails.Rows.Count > 0) { UnitInformationInspectionDetailsGateway unitInformationInspectionDetailsGateway = new UnitInformationInspectionDetailsGateway(unitInformationChanges); foreach (UnitInformationTDS.InspectionDetailsRow row in (UnitInformationTDS.InspectionDetailsDataTable)unitInformationChanges.InspectionDetails) { // Insert new inspection if ((!row.Deleted) && (!row.InDatabase)) { // Insert inspection int inspectionId = row.InspectionID; DateTime date_ = unitInformationInspectionDetailsGateway.GetDate_(inspectionId); Int64 country = unitInformationInspectionDetailsGateway.GetCountry(inspectionId); Int64 state = unitInformationInspectionDetailsGateway.GetState(inspectionId); string type = unitInformationInspectionDetailsGateway.GetType(inspectionId); string result = unitInformationInspectionDetailsGateway.GetResult(inspectionId); decimal? cost = unitInformationInspectionDetailsGateway.GetCost(inspectionId); string notes = unitInformationInspectionDetailsGateway.GetNotes(inspectionId); string inspectedBy = unitInformationInspectionDetailsGateway.GetInspectedBy(inspectionId); string attach = unitInformationInspectionDetailsGateway.GetAttach(inspectionId); InsertInspection(unitId, inspectionId, date_, country, state, type, result, cost, notes, inspectedBy, attach, false, companyId); } // Update inspection if ((!row.Deleted) && (row.InDatabase)) { int inspectionId = row.InspectionID; // original values DateTime originalDate_ = unitInformationInspectionDetailsGateway.GetDate_Original(inspectionId); Int64 originalCountry = unitInformationInspectionDetailsGateway.GetCountryOriginal(inspectionId); Int64 originalState = unitInformationInspectionDetailsGateway.GetStateOriginal(inspectionId); string originalType = unitInformationInspectionDetailsGateway.GetTypeOriginal(inspectionId); string originalResult = unitInformationInspectionDetailsGateway.GetResultOriginal(inspectionId); decimal? originalCost = unitInformationInspectionDetailsGateway.GetCostOriginal(inspectionId); string originalNotes = unitInformationInspectionDetailsGateway.GetNotesOriginal(inspectionId); string originalInspectedBy = unitInformationInspectionDetailsGateway.GetInspectedByOriginal(inspectionId); string originalAttach = unitInformationInspectionDetailsGateway.GetAttachOriginal(inspectionId); // new values DateTime newDate_ = unitInformationInspectionDetailsGateway.GetDate_(inspectionId); Int64 newCountry = unitInformationInspectionDetailsGateway.GetCountry(inspectionId); Int64 newState = unitInformationInspectionDetailsGateway.GetState(inspectionId); string newType = unitInformationInspectionDetailsGateway.GetType(inspectionId); string newResult = unitInformationInspectionDetailsGateway.GetResult(inspectionId); decimal? newCost = unitInformationInspectionDetailsGateway.GetCost(inspectionId); string newNotes = unitInformationInspectionDetailsGateway.GetNotes(inspectionId); string newInspectedBy = unitInformationInspectionDetailsGateway.GetInspectedBy(inspectionId); string newAttach = unitInformationInspectionDetailsGateway.GetAttach(inspectionId); UpdateInspection(unitId, inspectionId, originalDate_, originalCountry, originalState, originalType, originalResult, originalCost, originalNotes, originalInspectedBy, originalAttach, false, companyId, unitId, inspectionId, newDate_, newCountry, newState, newType, newResult, newCost, newNotes, newInspectedBy, newAttach, false, companyId); } // Delete inspection if ((row.Deleted) && (row.InDatabase)) { int inspectionId = row.InspectionID; DeleteInspection(unitId, inspectionId, companyId); } } } }
protected void grdInspections_RowDataBound(object sender, GridViewRowEventArgs e) { // Control of footer controls if (e.Row.RowType == DataControlRowType.Footer) { // For Country ((DropDownList)e.Row.FindControl("ddlCountryNew")).SelectedIndex = 0; } // Control of edit controls if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { int unitId = Int32.Parse(hdfUnitId.Value); int inspectionId = int.Parse(((Label)e.Row.FindControl("lblInspectionIdEdit")).Text); int companyId = Int32.Parse(hdfCompanyId.Value); DropDownList ddlCountry = ((DropDownList)e.Row.FindControl("ddlCountryEdit")); DropDownList ddlState = ((DropDownList)e.Row.FindControl("ddlStateEdit")); //UnitsInspectionGateway unitsInspectionGateway = new UnitsInspectionGateway(); //unitsInspectionGateway.LoadByUnitIdInspectionId(unitId, inspectionId, companyId); //if (unitsInspectionGateway.Table.Rows.Count > 0) //{ // ((DropDownList)e.Row.FindControl("ddlCountryEdit")).SelectedValue = unitsInspectionGateway.GetCountry(unitId, inspectionId).ToString(); // ((RadDatePicker)e.Row.FindControl("tkrdpInspectionDateEdit")).SelectedDate = unitsInspectionGateway.GetDate_(unitId, inspectionId); //} //else //{ // ddlCountry.SelectedValue = ((DropDownList)e.Row.FindControl("ddlCountryEdit")).SelectedValue; //} UnitInformationInspectionDetailsGateway unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetailsGateway(unitInformationTDS); try { ddlCountry.SelectedValue = unitInformationInspectionDetailsForEdit.GetCountry(inspectionId).ToString(); ((RadDatePicker)e.Row.FindControl("tkrdpInspectionDateEdit")).SelectedDate = unitInformationInspectionDetailsForEdit.GetDate_(inspectionId); } catch { } ProvinceList provinceList = new ProvinceList(); provinceList.LoadByCountryIdAndAddItem(-1, "(Select a state)", int.Parse(ddlCountry.SelectedValue)); ddlState.DataSource = provinceList.Table; ddlState.DataValueField = "ProvinceID"; ddlState.DataTextField = "Name"; ddlState.DataBind(); try { ddlState.SelectedValue = unitInformationInspectionDetailsForEdit.GetState(inspectionId).ToString(); } catch { } //if (unitsInspectionGateway.Table.Rows.Count > 0) //{ // ddlState.SelectedValue = unitsInspectionGateway.GetState(unitId, inspectionId).ToString(); //} //else //{ // ddlState.SelectedValue = ((DropDownList)e.Row.FindControl("ddlStateEdit")).SelectedValue; //} } }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// LoadByUnitId /// </summary> /// <param name="unitId">unitId</param> /// <param name="companyId">companyId</param> public void LoadByUnitId(int unitId, int companyId) { UnitInformationInspectionDetailsGateway unitInformationInspectionDetails = new UnitInformationInspectionDetailsGateway(Data); unitInformationInspectionDetails.LoadByUnitId(unitId, companyId); }