/// <summary>
/// FillParcelTypeCombo
/// </summary>
private void FillParcelTypeCombo()
{
this.parcelTypeDataset = this.formF2004Control.WorkItem.GetParcelTypeDetails(-1);
if (this.parcelTypeDataset.f2004ListParcelType.Rows.Count > 0)
{
this.ParcelTypeComboBox.DisplayMember = this.parcelTypeDataset.f2004ListParcelType.ParcelTypeColumn.ColumnName;
this.ParcelTypeComboBox.ValueMember = this.parcelTypeDataset.f2004ListParcelType.ParcelTypeIDColumn.ColumnName;
this.ParcelTypeComboBox.DataSource = this.parcelTypeDataset.f2004ListParcelType;
this.parcelTypeDataset.f2004ListParcelType.DefaultView.Sort = SharedFunctions.GetResourceString("ParcelType");
this.parcelTypeDataset = this.formF2004Control.WorkItem.GetParcelTypeDetails(this.keyId);
if (this.parcelTypeDataset.f2004ListParcelType.Rows.Count > 0)
{
this.parcelTypeIndex = this.ConvertStringToInteger(this.parcelTypeDataset.f2004ListParcelType.Rows[0][this.parcelTypeDataset.f2004ListParcelType.ParcelTypeIDColumn].ToString());
this.ParcelTypeComboBox.SelectedValue = this.parcelTypeIndex;
}
}
this.editScheduleassessmentdata = this.formF2004Control.WorkItem.F2200_GetAssessmentTypeDetails("Parcel");
if (this.editScheduleassessmentdata.List_AssessmentTypeDataTable.Rows.Count > 0)
{
this.AssessmentTypeComboBox.DataSource = this.editScheduleassessmentdata.List_AssessmentTypeDataTable;
this.AssessmentTypeComboBox.DisplayMember = this.editScheduleassessmentdata.List_AssessmentTypeDataTable.AssessmentTypeColumn.ColumnName;
this.AssessmentTypeComboBox.ValueMember = this.editScheduleassessmentdata.List_AssessmentTypeDataTable.AssessmentTypeIDColumn.ColumnName;
}
}
/// <summary>
/// Getschedules the details.
/// </summary>
private void GetscheduleDetails()
{
// Get Schedule Details for ScheduleID
this.scheduleHeaderData = this.formF2205Control.WorkItem.F2200_ListEditScheduleDetails(this.keyId);
// Set values on appropriate controls
this.BindValues();
}
/// <summary>
/// F2200 get schedule details.
/// </summary>
/// <param name="SheduleID">The shedule ID.</param>
/// <returns>scheduleData</returns>
public static F2200EditScheduleData F25050_GetScheduleDetails(int ScheduleID)
{
F2200EditScheduleData scheduleData = new F2200EditScheduleData();
Hashtable ht = new Hashtable();
ht.Add("@ScheduleID", ScheduleID);
Utility.LoadDataSet(scheduleData.f2200ListScheduleDataTable, "f2005_pcget_ScheduleLock", ht);
return(scheduleData);
}
/// <summary>
/// F2200_s the get assessment type details.
/// </summary>
/// <param name="assessmentType">Type of the assessment.</param>
/// <returns>The edit schedule dataset.</returns>
public static F2200EditScheduleData F2200_GetAssessmentTypeDetails(string assessmentType)
{
F2200EditScheduleData assessmentTypeDetails = new F2200EditScheduleData();
Hashtable ht = new Hashtable();
ht.Add("@AssessmentType", assessmentType);
Utility.LoadDataSet(assessmentTypeDetails.List_AssessmentTypeDataTable, "f9001_pclst_AssessmentType", ht);
return(assessmentTypeDetails);
}
/// <summary>
/// F2005_GetScheduleLockUserName
/// </summary>
/// <param name="userId">userId</param>
/// <returns>Typed dataset</returns>
public static F2200EditScheduleData F2005_GetScheduleUserName(int userId)
{
F2200EditScheduleData parcelLockingData = new F2200EditScheduleData();
Hashtable ht = new Hashtable();
ht.Add("@UserID", userId);
Utility.LoadDataSet(parcelLockingData.f25050GetScheduleParcelDetailsTable, "f2001_pcget_UserName", ht);
return(parcelLockingData);
}
/// <summary>
/// Get 259 Exemption Amount.
/// </summary>
/// <param name="scheduleId"></param>
/// <param name="isFarmExempt"></param>
/// <param name="ExemptRollYear"></param>
/// <returns></returns>
public static F2200EditScheduleData F2200_Get259ExemptionAmount(int scheduleId)
{
F2200EditScheduleData ScheduledObj = new F2200EditScheduleData();
Hashtable ht = new Hashtable();
ht.Add("@ScheduleID", scheduleId);
string[] tableName = new string[] { ScheduledObj.f2200Get259ExemptionAmount.TableName, ScheduledObj.Get259ExemptionAmount.TableName };
Utility.LoadDataSet(ScheduledObj, "f2200_pcget_PersonalProperty259ExemptionAmount", ht, tableName);
return(ScheduledObj);
}
/// <summary>
/// Lists the Special District Assessment ParcelID
/// </summary>
/// <param name="parcelNumber">The parcel number.</param>
/// <param name="parcelId">The parcel id.</param>
/// <returns>
/// returns dataset containing District Assessment ParcelID
/// </returns>
public static F2200EditScheduleData f25050GetDistrictAssessmentParcelID(string parcelNumber, int parcelId)
{
F2200EditScheduleData specialDistrictAssessmentData = new F2200EditScheduleData();
Hashtable ht = new Hashtable();
ht.Add("@ParcelNumber", parcelNumber);
ht.Add("@ParcelID", parcelId);
Utility.LoadDataSet(specialDistrictAssessmentData.f25050GetScheduleParcelDetailsTable, "f25050_pcget_ScheduleParcelDetails", ht);
return(specialDistrictAssessmentData);
}
/// <summary>
/// F2200_s the list edit schedule details.
/// </summary>
/// <param name="SheduleID">The shedule ID.</param>
/// <returns></returns>
public static F2200EditScheduleData F2200_ListEditScheduleDetails(int SheduleID)
{
F2200EditScheduleData F2200_ListEditSchedule = new F2200EditScheduleData();
Hashtable ht = new Hashtable();
ht.Add("@SheduleID", SheduleID);
// Utility.LoadDataSet(F2200_ListEditSchedule.f2200ListScheduleDataTable, "f25050_pcget_Schedule", ht);
string[] tableName = new string[] { F2200_ListEditSchedule.f25050_pcget_Configuredstate.TableName, F2200_ListEditSchedule.f2200ListScheduleDataTable.TableName };
Utility.LoadDataSet(F2200_ListEditSchedule, "f25050_pcget_Schedule", ht, tableName);
return(F2200_ListEditSchedule);
}
/// <summary>
/// F2200s the get farm exempt amount.
/// </summary>
/// <param name="scheduleId">The schedule id.</param>
/// <param name="isFarmExempt">if set to <c>true</c> [is farm exempt].</param>
/// <param name="ExemptRollYear">The exempt roll year.</param>
/// <returns></returns>
public static F2200EditScheduleData f2200GetFarmExemptAmount(int scheduleId, bool isFarmExempt, int ExemptRollYear)
{
F2200EditScheduleData ScheduledObj = new F2200EditScheduleData();
//object tempValue = null;
Hashtable ht = new Hashtable();
ht.Add("@ScheduleID", scheduleId);
ht.Add("@IsFarmExempt", isFarmExempt);
ht.Add("@FarmExemptYear", ExemptRollYear);
//tempValue = DataProxy.FetchSpObject("f2200_pcget_GetFarmExemptAmount_NE", ht);
Utility.LoadDataSet(ScheduledObj.f2200_GetFarmExemptAmountDataTable, "f2200_pcget_GetFarmExemptAmount_NE", ht);
//return tempValue;
return(ScheduledObj);
}
/// <summary>
/// GetscheduleNumber
/// </summary>
private void GetscheduleNumber()
{
this.editScheduleData = this.formF2204Control.WorkItem.F2200_ListEditScheduleDetails(this.keyId);
if (this.editScheduleData.f2200ListScheduleDataTable.Rows.Count > 0)
{
this.ScheduleHeaderLabel.Text = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.ScheduleNumberColumn.ColumnName].ToString();
this.ScheduleHeaderYearLabel.Text = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.RollYearColumn.ColumnName].ToString();
this.ScheduleNumberTextBox.Text = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.ScheduleNumberColumn.ColumnName].ToString();
this.scheduleNumber = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.ScheduleNumberColumn.ColumnName].ToString();
this.RollYearTextBox.Text = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.RollYearColumn.ColumnName].ToString();
this.scheduleYear = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.RollYearColumn.ColumnName].ToString();
this.AssessmentTypeComboBox.Text = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.AssessmentTypeColumn.ColumnName].ToString();
this.ScheduleTypeComboBox.Text = this.editScheduleData.f2200ListScheduleDataTable.Rows[0][this.editScheduleData.f2200ListScheduleDataTable.ScheduleTypeColumn.ColumnName].ToString();
}
}
/// <summary>
/// F2200_s the insert edit schedule.
/// </summary>
/// <param name="scheduleId">The schedule id.</param>
/// <param name="scheduleItems">The schedule items.</param>
/// <param name="userId">The user id.</param>
/// <returns></returns>
public static F2200EditScheduleData F2200_InsertEditSchedule(int?scheduleId, string scheduleItems, int userId)
{
F2200EditScheduleData ListInput = new F2200EditScheduleData();
ListInput.ListInputVAlue.AddListInputVAlueRow("@PrimaryKeyID", string.Empty, "int", 8);
ListInput.ListInputVAlue.AddListInputVAlueRow("@IsError", string.Empty, "bool", 2);
ListInput.ListInputVAlue.AddListInputVAlueRow("@Message", string.Empty, "string", 3000);
Hashtable ht = new Hashtable();
if (scheduleId != null || scheduleId > 0)
{
ht.Add("@ScheduleID", scheduleId);
}
ht.Add("@ScheduleItems", scheduleItems);
ht.Add("@UserID", userId);
Utility.SPParameters("f25050_pcins_Schedule", ListInput.ListInputVAlue, ht, ListInput.ListOutputValue);
return(ListInput);
}
/// <summary>
/// Get Schedule Lock Details
/// </summary>
private void GetScheduleLockDetails()
{
this.FormNoLabel.Text = this.formName;
this.sceduleLockingData = this.formF2005Control.WorkItem.F25050_GetScheduleDetails(this.keyId);
if (this.sceduleLockingData.f2200ListScheduleDataTable.Rows.Count > 0)
{
string[] parcelNo = null;
if (this.formName == SharedFunctions.GetResourceString("SchedulLockFormName"))
{
this.lockNumber = this.sceduleLockingData.f2200ListScheduleDataTable.Rows[0][this.sceduleLockingData.f2200ListScheduleDataTable.LockScheduleByColumn].ToString();
this.DescriptionLabel.Text = SharedFunctions.GetResourceString("ScheduleLockMessage");
this.parcelNumber = this.sceduleLockingData.f2200ListScheduleDataTable.Rows[0][this.sceduleLockingData.f2200ListScheduleDataTable.ScheduleNumberColumn].ToString();
parcelNo = this.parcelNumber.Split('/');
if (parcelNo.Length > 0)
{
this.lblScheduleNumber.Text = parcelNo[0].Trim();
if (parcelNo.Length > 1)
{
this.ParcelnumberLabel2.Text = parcelNo[1].Trim();
}
}
this.userID = Convert.ToInt32(this.lockNumber);
this.GetLockUser(this.userID);
this.formTitle = SharedFunctions.GetResourceString("ScheduleLock");
this.SetFormName(this.formTitle, this.lockNumber, this.userName);
}
else if (this.formName == SharedFunctions.GetResourceString("SchedulLockFormName"))
{
this.lockNumber = this.sceduleLockingData.f2200ListScheduleDataTable.Rows[0][this.sceduleLockingData.f2200ListScheduleDataTable.LockScheduleByColumn].ToString();
this.DescriptionLabel.Text = SharedFunctions.GetResourceString("ScheduleLockMessage");
this.parcelNumber = this.sceduleLockingData.f2200ListScheduleDataTable.Rows[0][this.sceduleLockingData.f2200ListScheduleDataTable.ParcelNumberColumn].ToString();
parcelNo = this.parcelNumber.Split('/');
this.lblScheduleNumber.Text = parcelNo[0].Trim();
this.ParcelnumberLabel2.Text = parcelNo[1].Trim();
this.userID = Convert.ToInt32(this.lockNumber);
this.GetLockUser(this.userID);
this.formTitle = SharedFunctions.GetResourceString("ScheduleLock");
this.SetFormName(this.formTitle, this.lockNumber, this.userName);
}
else
{
this.lockNumber = this.sceduleLockingData.f2200ListScheduleDataTable.Rows[0][this.sceduleLockingData.f2200ListScheduleDataTable.LockScheduleByColumn].ToString();
this.DescriptionLabel.Text = SharedFunctions.GetResourceString("ScheduleLockMessage");
this.parcelNumber = this.sceduleLockingData.f2200ListScheduleDataTable.Rows[0][this.sceduleLockingData.f2200ListScheduleDataTable.ParcelNumberColumn].ToString();
parcelNo = this.parcelNumber.Split('/');
if (parcelNo.Length > 0)
{
this.lblScheduleNumber.Text = parcelNo[0].Trim();
if (parcelNo.Length > 1)
{
this.ParcelnumberLabel2.Text = parcelNo[1].Trim();
}
}
this.userID = Convert.ToInt32(this.lockNumber);
this.GetLockUser(this.userID);
this.formTitle = SharedFunctions.GetResourceString("ScheduleLock");
this.SetFormName(this.formTitle, this.lockNumber, this.userName);
}
}
}
