/// <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);
}
}
