private void fvItemInserting(FormView fv) { TextBox tbFarmName = fv.FindControl("tbFarmName") as TextBox; DropDownList ddlProgramWAC = fv.FindControl("ddlProgramWAC") as DropDownList; DropDownList ddlFarmSize = fv.FindControl("ddlFarmSize") as DropDownList; DropDownList ddlBasin = fv.FindControl("ddlBasin") as DropDownList; DropDownList ddlSoldFarm = fv.FindControl("ddlSoldFarm") as DropDownList; CheckBox cbGenerateFarmID = fv.FindControl("cbGenerateFarmID") as CheckBox; WACPR_TaxParcelPicker taxParcelPicker = fv.FindControl("WACPR_TaxParcelPicker") as WACPR_TaxParcelPicker; sReq.ParmList.Clear(); List <WACParameter> taxParcelProps = taxParcelPicker.GetContents(); sReq.ParmList.Add(WACParameter.GetParameter(taxParcelProps, "swis")); sReq.ParmList.Add(WACParameter.GetParameter(taxParcelProps, "printKey")); WACUserInputUtilityControl wcc = (WACUserInputUtilityControl)fv.FindControl("WACPT_ParticipantAlphaPicker"); WACParameter wp = WACParameter.GetParameter(wcc.GetContents(), "pk_participant"); wp.ParmName = "fk_participantOperator"; wcc = (WACUserInputUtilityControl)fv.FindControl("WACPT_ParticipantAlphaPicker_Owner"); wp = WACParameter.GetParameter(wcc.GetContents(), "pk_participant"); wp.ParmName = "fk_participantOwner"; sReq.ParmList.Add(wp); sReq.ParmList.Add(new WACParameter("farm_name", tbFarmName.Text, WACParameter.ParameterType.Property)); sReq.ParmList.Add(new WACParameter("fk_programWAC_code", ddlProgramWAC.SelectedValue, WACParameter.ParameterType.Property)); sReq.ParmList.Add(new WACParameter("fk_farmSize_code", ddlFarmSize.SelectedValue, WACParameter.ParameterType.Property)); sReq.ParmList.Add(new WACParameter("fk_basin_code", ddlBasin.SelectedValue, WACParameter.ParameterType.Property)); sReq.ParmList.Add(new WACParameter("sold_farm", ddlSoldFarm.SelectedValue, WACParameter.ParameterType.Property)); sReq.ParmList.Add(new WACParameter("GenerateID", cbGenerateFarmID.Checked ? "Y" : "N", WACParameter.ParameterType.Property)); sReq.ServiceRequested = ServiceFactory.ServiceTypes.InsertItem; sReq.ServiceFor = fv; ServiceFactory.Instance.ServiceRequest(sReq); taxParcelProps = null; }
public override IList GetFilteredList(List <WACParameter> parms) { try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { int pk_participant = WACGlobal_Methods.KeyAsInt(WACParameter.GetPrimaryKey(parms).ParmValue); var e = wac.participants.Where(w => w.pk_participant == pk_participant).Select(s => new Participant(s.pk_participant, s.lname, s.fname, s.email, s.fk_gender_code, s.list_gender.gender, s.fk_ethnicity_code, s.list_ethnicity.ethnicity, s.fk_race_code, s.list_race.race, s.fk_diversityData_code, s.list_diversityData.dataSetVia, s.fk_mailingStatus_code, s.list_mailingStatus.status, s.fk_property, s.fk_organization, s.organization.org, s.active, s.form_W9_signed_date, s.fk_regionWAC_code, s.list_regionWAC.regionWAC, s.fk_prefix_code, s.list_prefix.prefix, s.mname, s.nickname, s.fk_suffix_code, s.list_suffix.suffix, s.fullname_LF_dnd, s.fullname_FL_dnd, s.web, s.fk_dataReview_code, s.dataReview_note, s.fk_participant_split)); if (e.Any()) { return(e.ToList <Participant>()); } else { return(new List <Participant>()); } } } catch (Exception ex) { throw new WACEX_GeneralDatabaseException("Error loading Participant. " + ex.Message, -1); } }
public override IList GetItem(List <WACParameter> parms, IList list) { List <FarmBusiness> ilist = list as List <FarmBusiness>; int key = WACGlobal_Methods.KeyAsInt(WACParameter.GetSelectedKey(parms).ParmValue); return(ilist.Where(w => w.pk_farmBusiness == key).ToList()); }
private bool IsProperty(WACParameter parm) { return(parm.ParmType == WACParameter.ParameterType.Property ? true : parm.ParmType == WACParameter.ParameterType.PrimaryKey ? true : parm.ParmType == WACParameter.ParameterType.SelectedKey ? true : parm.ParmType == WACParameter.ParameterType.MasterKey ? true : false); }
public override IList GetFilteredList(List <WACParameter> parms) { try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { int pk_participantProperty = WACGlobal_Methods.KeyAsInt(WACParameter.GetSelectedKey(parms).ParmValue); var e = wac.participantProperties.Where(w => w.pk_participantProperty == pk_participantProperty).Select(s => new ParticipantProperty(s.pk_participantProperty, s.fk_participant, s.fk_participant_cc, s.fk_property, s.master, s.created, s.created_by, s.modified, s.modified_by)); if (e.Any()) { return(e.ToList <ParticipantProperty>()); } else { return(new List <ParticipantProperty>()); } } } catch (Exception ex) { throw new WACEX_GeneralDatabaseException("Error loading Participant Properties. " + ex.Message, -1); } }
public override IList GetItem(List <WACParameter> parms, IList list) { List <ParticipantCommunication> ilist = list as List <ParticipantCommunication>; int key = WACGlobal_Methods.KeyAsInt(WACParameter.GetSelectedKey(parms).ParmValue); return(ilist.Where(w => w.pk_participantCommunication == key).ToList()); }
public void SetPrimaryKey(List <WACParameter> parms) { if (ListSource != null) { ListSource.MasterKey.ParmValue = WACParameter.GetMasterKey(parms).ParmValue; } }
public override IList GetFilteredList(List <WACParameter> parms) { try { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { int pk_participantCommunication = WACGlobal_Methods.KeyAsInt(WACParameter.GetSelectedKey(parms).ParmValue); var e = wac.participantCommunications.Where(w => w.pk_participantCommunication == pk_participantCommunication).Select(s => new ParticipantCommunication(s.pk_participantCommunication, s.fk_participant, s.fk_communication, s.fk_communicationType_code, s.fk_communicationUsage_code, s.fk_organization, s.extension, s.note, s.source, s.created, s.created_by, s.modified, s.modified_by)); if (e.Any()) { return(e.ToList <ParticipantCommunication>()); } else { return(new List <ParticipantCommunication>()); } } } catch (Exception ex) { throw new WACEX_GeneralDatabaseException("Error loading ParticipantCommunication. " + ex.Message, -1); } }
public override IList <DDLListItem> GetList(List <WACParameter> parms) { string _swis = (string)WACParameter.GetParameterValue(parms, "swis"); bool newTPOnly = (bool)WACParameter.GetParameterValue(parms, "NewTaxParcelsOnly"); using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { //var c = wac.vw_taxParcel_DEP_alls.Where(w => w.swis == _swis).Distinct((x, y) => x.SBL == y.SBL).OrderBy(o => o.PRINT_KEY). // Select(s => new DDLListItem(s.SBL, s.PRINT_KEY)); //return c.ToList(); var c = wac.vw_taxParcel_DEP_alls.Where(w => w.SWIS == _swis).Distinct((x, y) => x.SBL == y.SBL).OrderBy(o => o.PRINT_KEY). Select(s => new DDLListItem(s.SBL, s.PRINT_KEY)); var d = wac.taxParcels.Where(w => w.fk_list_swis == _swis).Distinct((x, y) => x.SBL == y.SBL).OrderBy(o => o.taxParcelID). Select(s => new DDLListItem(s.SBL, s.taxParcelID)); if (newTPOnly) { var minus = c.ToList().Except(d.ToList(), new DDLListItemComparer()); return(minus.OrderBy(o => o.DataTextField).ToList()); } else { var union = c.ToList().Union(d.ToList(), new DDLListItemComparer()). Distinct((x, y) => x.DataValueField == y.DataValueField); return(union.OrderBy(o => o.DataTextField).ToList()); } } }
public override IList GetFilteredList(List <WACParameter> parms) { try { IList <TaxParcel> x = GetList() as IList <TaxParcel>; PrimaryKeyVerify(ref parms); string _partialPrintKey = WACParameter.GetParameterValue(parms, "partialPrintKey") as string; string _participant = WACParameter.GetParameterValue(parms, "participant") as string; if (!string.IsNullOrEmpty(_partialPrintKey)) { var a = x.Where(w => w.taxParcelID.StartsWith(_partialPrintKey)).OrderBy(o => o.taxParcelID).Select(s => s); return(a.ToList <WAC_DataObjects.TaxParcel>()); } else if (!string.IsNullOrEmpty(_participant)) { var a = x.Where(w => !string.IsNullOrEmpty(w.ownerStr_dnd) && w.ownerStr_dnd.Contains(_participant)).OrderBy(o => o.taxParcelID).Select(s => s); return(a.ToList <WAC_DataObjects.TaxParcel>()); } else { return(x.Where <TaxParcel>(FuncWhere <TaxParcel>(parms)).ToList()); } } catch (Exception e) { WACAlert.Show(e.Message, 0); } return(null); }
public void ContainedFormStateChanged(Control container, Control grid, Control form, List <WACParameter> parms) { WACParameter wp = WACParameter.RemoveParameterType(parms, WACParameter.ParameterType.FormState); WACFormControl.FormState state = (WACFormControl.FormState)wp.ParmValue; ((WACFormControl)form).CurrentState = state; ServiceRequest sr = new ServiceRequest(container); sr.ServiceFor = form; sr.ParmList = parms; switch (state) { case WACFormControl.FormState.Closed: //((WACGridControl)grid).InitControl(parms); break; //case WACFormControl.FormState.OpenView: // break; //case WACFormControl.FormState.OpenInsert: // break; case WACFormControl.FormState.OpenUpdate: break; //case WACFormControl.FormState.UpdateCanceled: // break; case WACFormControl.FormState.ItemDeleted: sr.ServiceFor = form; sr.ServiceRequested = ServiceFactory.ServiceTypes.CloseFormView; //OnServiceRequested(this, new ServiceRequestEventArgs(sr)); ServiceFactory.Instance.ServiceRequest(sr); ((WACControl)container).UpdateControl(null); break; case WACFormControl.FormState.ItemInserted: WACParameter.RemoveAllButParameterType(parms, WACParameter.ParameterType.MasterKey); ((WACGridControl)grid).CurrentState = WACDataBoundListControl.ListState.ListEmpty; ((WACGridControl)grid).InitControl(parms); sr.ServiceFor = form; sr.ServiceRequested = ServiceFactory.ServiceTypes.CloseFormView; ServiceFactory.Instance.ServiceRequest(sr); //OnServiceRequested(this, new ServiceRequestEventArgs(sr)); ((WACControl)container).UpdateControl(null); break; case WACFormControl.FormState.ItemUpdated: break; default: //grid.Visible = ((WACControl)grid).DefaultVisibility; //form.Visible = ((WACControl)form).DefaultVisibility; //container.Visible = ((WACControl)container).DefaultVisibility; //if (up != null) // up.Visible = ((WACContainer)container).DefaultVisibility; break; } // this.UpdatePanelUpdate(); sr = null; }
public override IList GetFilteredList(List <WACParameter> parms) { WACEnumerations.WACSectorCodes sectorCode = (WACEnumerations.WACSectorCodes)WACParameter.GetParameterValue(parms, WACParameter.ParameterType.SectorCode); object pk = WACParameter.GetParameterValue(parms, WACParameter.ParameterType.PrimaryKey); object mk = WACParameter.GetParameterValue(parms, WACParameter.ParameterType.MasterKey); if (mk == null && pk == null) { return(docLoader(sectorCode)); } if (mk != null && pk == null) { return(docLoader(mk, sectorCode)); } if (mk == null && pk != null) { return(docLoader(pk, sectorCode)); } if (mk != null && pk != null) { return(docLoader(mk, pk, sectorCode)); } else { return(null); } }
public void ContainedFilterStateChanged(Control container, Control filter, Control grid, Control form, List <WACParameter> parms) { WACParameter wp = WACParameter.RemoveParameterType(parms, WACParameter.ParameterType.FilterState); WACFilterControl.FilterState state = (WACFilterControl.FilterState)wp.ParmValue; ServiceRequest sr = new ServiceRequest(container); switch (state) { case WACFilterControl.FilterState.Unfiltered: sr.ServiceFor = grid; sr.ServiceRequested = ServiceFactory.ServiceTypes.GridViewList; ServiceFactory.Instance.ServiceRequest(sr); break; case WACFilterControl.FilterState.Filtered: sr.ServiceFor = grid; sr.ParmList = parms; sr.ServiceRequested = ServiceFactory.ServiceTypes.FilteredGridViewList; ServiceFactory.Instance.ServiceRequest(sr); break; case WACFilterControl.FilterState.Reset: sr.ServiceFor = grid; sr.ServiceRequested = ServiceFactory.ServiceTypes.ClearGridView; ServiceFactory.Instance.ServiceRequest(sr); break; default: break; } sr = null; }
public override IList GetItem(List <WACParameter> parms, IList list) { List <SupplementalAgreement> ilist = list as List <SupplementalAgreement>; int key = WACGlobal_Methods.KeyAsInt(WACParameter.GetSelectedKey(parms).ParmValue); return(ilist.Where(w => w.pk_supplementalAgreement == key).ToList()); }
protected void TaxParcelPicker_Notify(object sender, UserControlResultEventArgs e) { County = WACParameter.GetParameterValue(e.Parms, "county") as string; Swis = WACParameter.GetParameterValue(e.Parms, "swis") as string; TaxParcelID = WACParameter.GetParameterValue(e.Parms, "printkey") as string; sReq.ServiceFor = fvSA; sReq.ServiceRequested = ServiceFactory.ServiceTypes.BindDDL; ServiceFactory.Instance.ServiceRequest(sReq); }
public void SortGridView(GridView gv, List <WACParameter> parms) { string srt = WACParameter.GetParameterValue(parms, WACParameter.ParameterType.ListSort) as string; string sortDirection = ToggleSortDirection(srt); sortExpression = srt; IList sorted = ListSource.GetSortedList(DataProvider.SortedList, sortExpression, sortDirection); BindGridView(gv, sorted); }
public void BindSingleDDL(Control c, List <WACParameter> parms) { string ddlID = (string)WACParameter.GetParameterValue(parms, "ddlID"); DDLDataObject ddlDO = DDLBinders[ddlID]; if (ddlDO != null) { bindControlDDL(c, parms, null, ddlDO, ddlID); } }
public override IList <DDLListItem> GetList(List <WACParameter> parms) { int _pkCounty = WACGlobal_Methods.KeyAsInt(WACParameter.GetParameterValue(parms, "pk_list_countyNY")); using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { var c = wac.vw_taxParcel_jurisdictions.Where(w => w.pk_list_countyNY == _pkCounty).Distinct((x, y) => x.Jurisdiction == y.Jurisdiction). OrderBy(o => o.Jurisdiction).Select(s => new DDLListItem(s.SWIS, s.Jurisdiction)); return(c.ToList()); } }
public void OpenEdit(ServiceRequest sr, FormView fv, string keyName, object key) { CurrentState = FormState.OpenUpdate; sr.ServiceRequested = ServiceFactory.ServiceTypes.OpenFormViewUpdate; sr.ServiceFor = fv; WACParameter wp = new WACParameter(keyName, key, WACParameter.ParameterType.SelectedKey); sr.ParmList.Clear(); sr.ParmList.Add(wp); ServiceFactory.Instance.ServiceRequest(sr); }
protected void lb_gvOpenView_Click(object sender, EventArgs e) { LinkButton lb = (LinkButton)sender; WACParameter wp = new WACParameter("pk_taxParcelOwner", lb.CommandArgument, WACParameter.ParameterType.SelectedKey); WACParameter state = new WACParameter(string.Empty, ListState.SelectionMade, WACParameter.ParameterType.ListState); List <WACParameter> parms = new List <WACParameter>(); parms.Add(wp); parms.Add(state); StateChanged(parms); }
public override IList GetItem(List <WACParameter> parms, IList list) { if (list == null) { list = GetFilteredList(parms); } List <TaxParcel> ilist = list as List <TaxParcel>; return(ilist.Where(w => w.pk_taxParcel == WACGlobal_Methods.KeyAsInt(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.SelectedKey))).ToList()); }
private void SetMasterKeyForContainer(ServiceRequest _request) { //WACParameter wp = WACParameter.RemoveParameterType(_request.ParmList, WACParameter.ParameterType.MasterKey); foreach (WACControl _control in ControlList(_request.ServiceFor)) { WACViewModel vm = GetViewModelForControl(_request.ServiceFor); if (vm.ListSource != null) { vm.ListSource.SetMasterKeyValue(WACParameter.GetParameterValue(_request.ParmList, WACParameter.ParameterType.MasterKey)); } } }
public override void InitControl(List <WACParameter> parms) { WACParameter masterKey = WACParameter.GetSelectedKey(parms); masterKey.ParmType = WACParameter.ParameterType.MasterKey; parms.Add(masterKey); sReq.ServiceFor = this; sReq.ParmList = parms; sReq.ServiceRequested = ServiceFactory.ServiceTypes.SetMasterKeyForContainer; ServiceFactory.Instance.ServiceRequest(sReq); WACPR_TaxParcelOwnerGrid.InitControl(parms); lblOwnerCount.Text = getCount(); }
public void ContainedFormStateChanged(Control container, Control filter, Control grid, Control form, List <WACParameter> parms) { WACParameter wp = WACParameter.RemoveParameterType(parms, WACParameter.ParameterType.FormState); WACFormControl.FormState state = (WACFormControl.FormState)wp.ParmValue; ((WACFormControl)form).CurrentState = state; ServiceRequest sr = new ServiceRequest(container); sr.ServiceFor = form; sr.ParmList = parms; switch (state) { //case WACFormControl.FormState.Closed: // grid.Visible = ((WACGridControl)grid).DefaultVisibility; // filter.Visible = ((WACFilterControl)filter).DefaultVisibility; // break; //case WACFormControl.FormState.OpenView: // grid.Visible = ((WACGridControl)grid).IsActiveReadOnly; // filter.Visible = ((WACFilterControl)filter).IsActiveReadOnly; // break; //case WACFormControl.FormState.OpenInsert: // grid.Visible = ((WACGridControl)grid).IsActiveInsert; // filter.Visible = ((WACFilterControl)filter).IsActiveInsert; // break; //case WACFormControl.FormState.OpenUpdate: // break; case WACFormControl.FormState.UpdateCanceled: break; case WACFormControl.FormState.ItemDeleted: sr.ServiceFor = grid; sr.ServiceRequested = ServiceFactory.ServiceTypes.OpenGridView; ServiceFactory.Instance.ServiceRequest(sr); break; case WACFormControl.FormState.ItemInserted: WACParameter.RemoveAllButParameterType(parms, WACParameter.ParameterType.SelectedKey); sr.ServiceFor = grid; sr.ServiceRequested = ServiceFactory.ServiceTypes.FilteredGridViewList; ServiceFactory.Instance.ServiceRequest(sr); break; case WACFormControl.FormState.ItemUpdated: break; default: break; } this.UpdatePanelUpdate(); sr = null; }
public override void Insert(WACFormControl wfc, FormView fv, List <WACParameter> parms) { WACParameter masterKey = ListSource.MasterKey; parms.Add(new WACParameter("fk_taxParcel", masterKey.ParmValue, WACParameter.ParameterType.Property)); if (base.Insert <TaxParcelOwner>(parms, TaxParcelOwnerValidator.ValidateInsert)) { parms.Clear(); parms.Add(new WACParameter(string.Empty, WACFormControl.FormState.ItemInserted, WACParameter.ParameterType.FormState)); parms.Add(masterKey); ListSource.SetCurrentItem <TaxParcelOwner>(null, null); wfc.StateChanged(parms); } }
private void fvItemInserting(FormView fv) { TextBox tbNote = fv.FindControl("tbNote") as TextBox; WACUserInputUtilityControl wcc = (WACUserInputUtilityControl)fv.FindControl("WACUT_YesNoChooser"); sReq.ParmList = wcc.GetContents(); wcc = (WACUserInputUtilityControl)fv.FindControl("WACPT_ParticipantAlphaPicker"); WACParameter wp = WACParameter.GetParameter(wcc.GetContents(), "pk_participant"); wp.ParmName = "fk_participant"; sReq.ParmList.Add(wp); sReq.ParmList.Add(new WACParameter("note", tbNote.Text, WACParameter.ParameterType.Property)); sReq.ServiceFor = fv; sReq.ServiceRequested = ServiceFactory.ServiceTypes.InsertItem; ServiceFactory.Instance.ServiceRequest(sReq); }
public override IList GetFilteredList(List <WACParameter> parms) { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { string _county = WACParameter.GetParameterValue(parms, "county") as string; string _jurisdiction = WACParameter.GetParameterValue(parms, "jurisdiction") as string; try { var a = wac.taxParcels.Where(w => w.list_swi.county == _county && w.list_swi.jurisdiction == _jurisdiction).OrderBy(o => o.taxParcelID).Select(s => new WAC_DataObjects.TaxParcel(s.pk_taxParcel, s.fk_list_swis, s.taxParcelID, s.list_swi.county, s.list_swi.jurisdiction, s.retired)); return(a.ToList <WAC_DataObjects.TaxParcel>()); } catch (Exception e) { WACAlert.Show(e.Message, 0); } } return(null); }
public override IList GetFilteredList(List <WACParameter> parms) { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { string _partialPrintKey = WACParameter.GetParameterValue(parms, "partialPrintKey") as string; try { var a = wac.taxParcels.Where(w => w.taxParcelID.StartsWith(_partialPrintKey)).OrderBy(o => o.taxParcelID).Select(s => new WAC_DataObjects.TaxParcel(s.pk_taxParcel, s.fk_list_swis, s.taxParcelID, s.note, s.SBL, s.ownerStr_dnd, s.acreage, s.retired, s.list_swi.county, s.list_swi.jurisdiction, s.created, s.created_by, s.modified, s.modified_by)); return(a.ToList <WAC_DataObjects.TaxParcel>()); } catch (Exception e) { WACAlert.Show(e.Message, 0); } } return(null); }
protected void TaxParcelPicker_Notify(object sender, UserControlResultEventArgs e) { County = WACParameter.GetParameterValue(e.Parms, "county") as string; Swis = WACParameter.GetParameterValue(e.Parms, "swis") as string; TaxParcelID = WACParameter.GetParameterValue(e.Parms, "printkey") as string; DropDownList ddlBasin = fvFarmBusiness.FindControl("ddlBasin") as DropDownList; if (ddlBasin != null) { ddlBasin.Items.Clear(); } sReq.ParmList.Add(new WACParameter("pk_County", County, WACParameter.ParameterType.Property)); sReq.ParmList.Add(new WACParameter("ddlID", "ddlBasin", WACParameter.ParameterType.Property)); sReq.ServiceFor = fvFarmBusiness; sReq.ServiceRequested = ServiceFactory.ServiceTypes.BindDDL; ServiceFactory.Instance.ServiceRequest(sReq); }
public override void CustomAction(List <WACParameter> parms) { if (DataProvider != null) { Control filter = WACParameter.GetParameterValue(parms, "FilterControl") as Control; ServiceRequest sr = new ServiceRequest(filter); sr.ParmList = parms; sr.ParmList.Add(new WACParameter("dataprovider", DataProvider, WACParameter.ParameterType.DataProvider)); sr.ServiceRequested = ServiceFactory.ServiceTypes.FilteredGridViewList; ServiceFactory.Instance.ServiceRequest(sr); sr = null; } else { WACAlert.Show("WACPR_TaxParcelPrintKeySearchVM.CustomAction: DataProvider is null", 0); } }