/// <summary> /// Populates the control values. /// </summary> private void PopulateControlValues() { try { ////Calling DB for the parcelId review Status Details this.reviewStatusData = this.form2409Control.WorkItem.F2409_ListReviewstatus(Convert.ToInt32(this.parcelId)); ////if review status detail datatable rowcount is greater than Zero then do the following lines. if (this.reviewStatusData.F2409_ListReviewStatus.Rows.Count > 0) { this.InspectedByComboBox.SelectedValue = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.InspectedByUserIDColumn.ColumnName].ToString(); this.InspectedByDateTextBox.Text = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.DateInspectedColumn.ColumnName].ToString(); this.EnteredByComboBox.SelectedValue = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.EnteredByUserIDColumn.ColumnName].ToString(); this.InspectionTypeComboBox.SelectedValue = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.InspectionTypeIDColumn.ColumnName].ToString(); this.ReviewedByComboBox.SelectedValue = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.ReviewedByUserIDColumn.ColumnName].ToString(); this.ReviewedByDateTextBox.Text = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.ReviewDateColumn.ColumnName].ToString(); this.ReviewStatusComboBox.SelectedValue = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.ReviewStatusIDColumn.ColumnName].ToString(); this.EnteredDateTextBox.Text = this.reviewStatusData.F2409_ListReviewStatus.Rows[0][this.reviewStatusData.F2409_ListReviewStatus.EnteredByDateColumn.ColumnName].ToString(); } else { this.ClearControlValues(); } } catch (Exception ex) { ExceptionManager.ManageException(ex, ExceptionManager.ActionType.Display, this.ParentForm); } }
/// <summary> /// Datat set of Review satatus Data /// </summary> /// <returns>Datat set of Review satatus Data</returns> public static F2409ReviewStatusData F2409_Reviewstatus() { F2409ReviewStatusData reviewStatus = new F2409ReviewStatusData(); Hashtable ht = new Hashtable(); Utility.LoadDataSet(reviewStatus.F2409_ReviewStatus, "f2409_pclst_ReviewStatus", ht); return(reviewStatus); }
/// <summary> /// F2409_s the type of the reviewstatus inspection. /// </summary> /// <returns></returns> public static F2409ReviewStatusData F2409_ReviewstatusInspectionType() { F2409ReviewStatusData inspectionType = new F2409ReviewStatusData(); Hashtable ht = new Hashtable(); Utility.LoadDataSet(inspectionType.F2409_InspectedType, "f2409_pclst_InspectedType", ht); return(inspectionType); }
/// <summary> /// F2409_s the list reviewstatus. /// </summary> /// <param name="parcelId">The parcel id.</param> /// <returns></returns> public static F2409ReviewStatusData F2409_ListReviewstatus(int parcelId) { F2409ReviewStatusData reviewStatus = new F2409ReviewStatusData(); Hashtable ht = new Hashtable(); ht.Add("@ParcelID", parcelId); Utility.LoadDataSet(reviewStatus.F2409_ListReviewStatus, "f2409_pcget_ReviewStatus", ht); return(reviewStatus); }
/// <summary> /// F2409_s the reviewstatus inspection by user. /// </summary> /// <param name="applicationId">The application id.</param> /// <returns></returns> public static F2409ReviewStatusData F2409_ReviewstatusInspectionByUser(int applicationId) { F2409ReviewStatusData inspectionByUser = new F2409ReviewStatusData(); Hashtable ht = new Hashtable(); ht.Add("@ApplicationID", applicationId); Utility.LoadDataSet(inspectionByUser.F2409_ListInspectedByUser, "f2409_pclst_InspectedByUser", ht); return(inspectionByUser); }
/// <summary> /// Populates the combo value. /// </summary> private void PopulateComboValue() { ////Populate InspectionByUser Combobox. this.reviewStatusData = this.form2409Control.WorkItem.F2409_ReviewstatusInspectionByUser(TerraScanCommon.ApplicationId); this.InspectedByComboBox.DataSource = this.reviewStatusData.F2409_ListInspectedByUser; this.InspectedByComboBox.DisplayMember = this.reviewStatusData.F2409_ListInspectedByUser.Name_DIsplayColumn.ColumnName; this.InspectedByComboBox.ValueMember = this.reviewStatusData.F2409_ListInspectedByUser.UserIDColumn.ColumnName; this.InspectedByComboBox.SelectedIndex = 0; ////Populate ReviewByUser Combobox. this.reviewStatusData = this.form2409Control.WorkItem.F2409_ReviewstatusInspectionByUser(TerraScanCommon.ApplicationId); this.ReviewedByComboBox.DataSource = this.reviewStatusData.F2409_ListInspectedByUser; this.ReviewedByComboBox.DisplayMember = this.reviewStatusData.F2409_ListInspectedByUser.Name_DIsplayColumn.ColumnName; this.ReviewedByComboBox.ValueMember = this.reviewStatusData.F2409_ListInspectedByUser.UserIDColumn.ColumnName; this.ReviewedByComboBox.SelectedIndex = 0; ////To Populate ReviewInspectionType Comobobox. this.reviewStatusData = this.form2409Control.WorkItem.F2409_ReviewstatusInspectionType(); this.InspectionTypeComboBox.DataSource = this.reviewStatusData.F2409_InspectedType; this.InspectionTypeComboBox.DisplayMember = this.reviewStatusData.F2409_InspectedType.InspectionTypeColumn.ColumnName; this.InspectionTypeComboBox.ValueMember = this.reviewStatusData.F2409_InspectedType.InspectionTypeIDColumn.ColumnName; this.InspectionTypeComboBox.SelectedIndex = 0; /////To populate EnteredBy Combobox this.enteredStatusData = this.form2409Control.WorkItem.F2409_ReviewstatusInspectionByUser(TerraScanCommon.ApplicationId); this.EnteredByComboBox.DataSource = this.enteredStatusData.F2409_ListInspectedByUser; this.EnteredByComboBox.DisplayMember = this.enteredStatusData.F2409_ListInspectedByUser.Name_DIsplayColumn.ColumnName; this.EnteredByComboBox.ValueMember = this.enteredStatusData.F2409_ListInspectedByUser.UserIDColumn.ColumnName; this.EnteredByComboBox.SelectedIndex = 0; ///To Populate ReviewInspectionType Comobobox. this.reviewStatusData = this.form2409Control.WorkItem.F2409_ReviewStatus(); this.ReviewStatusComboBox.DataSource = this.reviewStatusData.F2409_ReviewStatus; this.ReviewStatusComboBox.DisplayMember = this.reviewStatusData.F2409_ReviewStatus.ReviewStatusColumn.ColumnName; this.ReviewStatusComboBox.ValueMember = this.reviewStatusData.F2409_ReviewStatus.ReviewStatusIDColumn.ColumnName; this.ReviewStatusComboBox.SelectedIndex = 0; }
/// <summary> /// Saves the review status. /// </summary> private void SaveReviewStatus() { try { bool saveFailure = false; ////assign all control values to datatable this.Cursor = Cursors.WaitCursor; F2409ReviewStatusData listReviewStatusData = new F2409ReviewStatusData(); listReviewStatusData.F2409_ListReviewStatus.Columns.Add("ParcelID"); F2409ReviewStatusData.F2409_ListReviewStatusRow reviewStatusRow = listReviewStatusData.F2409_ListReviewStatus.NewF2409_ListReviewStatusRow(); if (this.InspectedByComboBox.SelectedIndex > 0) { reviewStatusRow.InspectedByUserID = this.InspectedByComboBox.SelectedValue.ToString(); } if (!string.IsNullOrEmpty(this.InspectedByDateTextBox.Text.Trim())) { var dateString = this.InspectedByDateTextBox.Text; DateTime result; bool success = DateTime.TryParse(dateString, out result); if (success) { reviewStatusRow.DateInspected = this.InspectedByDateTextBox.Text.Trim(); } else { saveFailure = true; } } if (this.InspectionTypeComboBox.SelectedIndex > 0) { reviewStatusRow.InspectionTypeID = this.InspectionTypeComboBox.SelectedValue.ToString(); } if (this.ReviewedByComboBox.SelectedIndex > 0) { reviewStatusRow.ReviewedByUserID = this.ReviewedByComboBox.SelectedValue.ToString(); } if (!string.IsNullOrEmpty(this.ReviewedByDateTextBox.Text.Trim())) { var dateString = this.ReviewedByDateTextBox.Text; DateTime result; bool success = DateTime.TryParse(dateString, out result); if (success) { reviewStatusRow.ReviewDate = this.ReviewedByDateTextBox.Text.Trim(); } else { saveFailure = true; } } if (this.ReviewStatusComboBox.SelectedIndex > 0) { reviewStatusRow.ReviewStatusID = this.ReviewStatusComboBox.SelectedValue.ToString(); } if (this.EnteredByComboBox.SelectedIndex > 0) { reviewStatusRow.EnteredByUserID = this.EnteredByComboBox.SelectedValue.ToString(); } if (!string.IsNullOrEmpty(this.EnteredDateTextBox.Text.Trim())) { var dateString = this.EnteredDateTextBox.Text; DateTime result; bool success = DateTime.TryParse(dateString, out result); if (success) { reviewStatusRow.EnteredByDate = this.EnteredDateTextBox.Text.Trim(); } else { saveFailure = true; } } reviewStatusRow["ParcelID"] = this.parcelId; listReviewStatusData.F2409_ListReviewStatus.Rows.Add(reviewStatusRow); ////DB Call for save if (!saveFailure) { this.form2409Control.WorkItem.F2409UpdateParcelReviewDetails(TerraScanCommon.GetXmlString(listReviewStatusData.F2409_ListReviewStatus.Copy()), TerraScanCommon.UserId); ////After saving Populate values to controls. this.PopulateControlValues(); this.Close(); } else { MessageBox.Show("Invalid Date Format - Save Operation Aborted", "TerraScan T2", MessageBoxButtons.OK, MessageBoxIcon.Warning); } this.Cursor = Cursors.Default; } catch (Exception ex) { ExceptionManager.ManageException(ex, ExceptionManager.ActionType.Display, this.ParentForm); } }