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) { 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 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); }
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 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()); }
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()); } }
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 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); } }
public void ChildGridStateChanged(Control c, List <WACParameter> parms) { WACGridControl.ListState state = (WACGridControl.ListState)WACParameter.GetParameterValue(parms, WACParameter.ParameterType.ListState); ServiceRequest sr = new ServiceRequest(c); switch (state) { case WACGridControl.ListState.ListFull: //sr.ServiceRequested = ServiceFactory.ServiceTypes.OpenGridView; //ServiceFactory.Instance.ServiceRequest(sr); //sr.ServiceRequested = ServiceFactory.ServiceTypes.CloseFormView; //ServiceFactory.Instance.ServiceRequest(sr); break; case WACGridControl.ListState.ListSingle: //sr.ServiceRequested = ServiceFactory.ServiceTypes.OpenGridView; //ServiceFactory.Instance.ServiceRequest(sr); //sr.ParmList = Parms; //sr.ServiceRequested = ServiceFactory.ServiceTypes.HandleGridViewSelection; //ServiceFactory.Instance.ServiceRequest(sr); break; case WACGridControl.ListState.ListEmpty: sr.ServiceRequested = ServiceFactory.ServiceTypes.ClearFormView; ServiceFactory.Instance.ServiceRequest(sr); //ResetTabs(sr); break; case WACGridControl.ListState.OpenView: break; case WACGridControl.ListState.SelectionMade: break; case WACGridControl.ListState.Closed: sr.ServiceRequested = ServiceFactory.ServiceTypes.ClearFormView; ServiceFactory.Instance.ServiceRequest(sr); break; default: break; } sr = null; }
public override IList <DDLListItem> GetList(List <WACParameter> parms) { int fk_County = WACGlobal_Methods.KeyAsInt(WACParameter.GetParameterValue(parms, "pk_County")); using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { if (fk_County > 0) { var x = wac.list_basins.Where(w => w.list_countyNYBasins.Any(a => a.fk_list_countyNY == fk_County)).OrderBy(o => o.basin).Select(s => new DDLListItem(s.pk_basin_code, s.basin)); return(x.ToList()); } else { var x = wac.list_basins.OrderBy(o => o.basin).Select(s => new DDLListItem(s.pk_basin_code, s.basin)); return(x.ToList()); } } }
private void OpenTabControl(ServiceRequest _request) { // called from page level form WACControlConnector topCon = GetConnector(_request); int tabIndex = Convert.ToInt32(WACParameter.GetParameterValue(_request.ParmList, "activeTabindex")); //var x = topCon.Connections.Values.Where(w => IsTabControl(w)).Select(s => s); //foreach (WACTabControl tc in x) //{ // if (tabIndex == tc.MyTabIndex) // { // WACTabControlViewModel tcvm = GetViewModelForControl(tc) as WACTabControlViewModel; // if (tcvm != null && tcvm.MyTabState == WACTabControlViewModel.TabState.Initialized) // { // _request.ParmList.Add(tcvm.ListSource.MasterKey); // tc.OpenTabControl(tc, _request.ParmList); // tcvm.MyTabState = WACTabControlViewModel.TabState.Open; // } // } //} }
public override IList GetFilteredList(List <WACParameter> parms) { WACEnumerations.AssociationTypes assocType = (WACEnumerations.AssociationTypes)WACParameter.GetParameterValue(parms, WACParameter.ParameterType.AssociationType); switch (assocType) { case WACEnumerations.AssociationTypes.Participant: return(GetList(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.SelectedKey), LoadPartcipantAssociations)); case WACEnumerations.AssociationTypes.Property: return(GetList(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.SelectedKey), LoadPropertyAssociations)); case WACEnumerations.AssociationTypes.Organization: return(GetList(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.SelectedKey), LoadOrganizationAssociations)); case WACEnumerations.AssociationTypes.TaxParcel: return(GetList(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.SelectedKey), LoadTaxParcelAssociations)); default: return(null); } }
private string getCount() { string rowCount; StringBuilder sb = new StringBuilder(); sb.Append("("); sReq.ServiceFor = WACPR_TaxParcelOwnerGrid; sReq.ServiceRequested = ServiceFactory.ServiceTypes.ListRowCount; ServiceFactory.Instance.ServiceRequest(sReq); rowCount = WACParameter.GetParameterValue(WACPR_TaxParcelOwnerGrid.GetContents(), WACParameter.ParameterType.RowCount).ToString(); if (!string.IsNullOrEmpty(rowCount)) { sb.Append(rowCount); } else { sb.Append("?"); } sb.Append(")"); return(sb.ToString()); }
public bool PrimaryKeyVerify(ref List <WACParameter> parms) { Object pk = null; WACParameter wp = null; if (parms.Count() < 1) { return(false); } try { // get pk parameter based on parameter type wp = WACParameter.GetPrimaryKey(parms); if (wp == null) { return(false); } // if pk parameter exists, make sure the pk property name is set in the parameter if (string.IsNullOrEmpty(wp.ParmName)) { parms.Remove(wp); wp.ParmName = PrimaryKeyName(); parms.Add(wp); } // verify the pk parameter has a value pk = WACParameter.GetParameterValue(parms, PrimaryKeyName()); if (pk == null) { return(false); } return(true); } catch (Exception ex) { WACAlert.Show(ex.Message + " in WACDataProvider.PrimaryKeyVerify()", 0); return(false); } }
public bool IsActiveFormMode(List <WACParameter> parms) { try { WACFormControl.FormState state = (WACFormControl.FormState)WACParameter.GetParameterValue(parms, WACParameter.ParameterType.FormState); if (state == WACFormControl.FormState.OpenView && IsActiveReadOnly) { return(true); } if (state == WACFormControl.FormState.OpenInsert && IsActiveInsert) { return(true); } if (state == WACFormControl.FormState.OpenUpdate && IsActiveUpdate) { return(true); } return(false); } catch (Exception) { return(true); } }
public override IList GetItem(List <WACParameter> parms, IList list) { if (list == null) { list = GetFilteredList(parms); } List <TaxParcelOwner> ilist = list as List <TaxParcelOwner>; return(ilist.Where(w => w.pk_taxParcelOwner == WACGlobal_Methods.KeyAsInt(WACParameter.GetParameterValue(parms, TaxParcelOwner.PrimaryKeyName))).ToList()); }
public void PageGridView(GridView gv, List <WACParameter> parms) { gv.PageIndex = WACGlobal_Methods.KeyAsInt(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.ListPage)); BindGridView(gv); }
public override void CustomAction(List <WACParameter> parms) { Control parent = WACParameter.GetParameterValue(parms, "ContainingControl") as Control; base.BindControlDDLs(parent, parms); }
public override void OpenDefaultDataView(List <WACParameter> parms) { BindOrganization(WACGlobal_Methods.KeyAsInt(WACParameter.GetParameterValue(parms, WACParameter.ParameterType.PrimaryKey))); }
public FarmBusiness ValidateInsert(List <WACParameter> parms) { FarmBusiness f = new FarmBusiness(); int val; foreach (WACParameter parm in parms) { switch (parm.ParmName) { case "swis": f.swis = ValidateString(parm.ParmValue, parm.ParmName, false); break; case "printKey": f.printKey = ValidateString(parm.ParmValue, parm.ParmName, false); break; case "fk_participantOwner": val = ValidateInt(parm.ParmValue, parm.ParmName, false, true); if (val == 0) { f.fk_participantOwner = null; } else { f.fk_participantOwner = val; } break; case "fk_participantOperator": val = ValidateInt(parm.ParmValue, parm.ParmName, false, true); if (val == 0) { f.fk_participantOperator = null; } else { f.fk_participantOperator = val; } break; case "farm_name": f.farm_name = ValidateString(parm.ParmValue, parm.ParmName, false); break; case "fk_programWAC_code": f.fk_programWAC_code = ValidateString(parm.ParmValue, parm.ParmName, true); break; case "fk_farmSize_code": string programWAC_code = WACParameter.GetParameterValue(parms, "fk_programWAC_code") as string; if (programWAC_code.Contains("EOH")) { f.fk_farmSize_code = ValidateString(parm.ParmValue, parm.ParmName, false); } else { f.fk_farmSize_code = ValidateString(parm.ParmValue, parm.ParmName, true); } break; case "fk_basin_code": f.fk_basin_code = ValidateString(parm.ParmValue, parm.ParmName, true); break; case "sold_farm": val = ValidateInt(parm.ParmValue, parm.ParmName, false, true); if (val == 0) { f.sold_farm = null; } else { f.sold_farm = val; } break; case "GenerateID": f.GenerateID = ValidateString(parm.ParmValue, parm.ParmName, true); break; case "created_by": f.created_by = ValidateString(parm.ParmValue, parm.ParmName, true); break; default: break; } } return(f); }
public override IList <DDLListItem> GetList(List <WACParameter> parms) { AlphaPickerListType listType; try { listType = (AlphaPickerListType)WACParameter.GetParameterValue(parms, WACParameter.ParameterType.PickerListType); string startsWith = WACParameter.GetParameterValue(parms, "NameStartsWith") as string; if (string.IsNullOrEmpty(startsWith)) { switch (listType) { case AlphaPickerListType.Participant: return(participantOnlyList()); case AlphaPickerListType.Organization: return(organizationOnlyList()); case AlphaPickerListType.ParticipantOrganization: return(participantAndOrganizationList()); case AlphaPickerListType.TaxParcelOwner: return(taxParcelOwner()); case AlphaPickerListType.Operator: return(operatorList(startsWith)); default: return(null); } } else { switch (listType) { case AlphaPickerListType.Participant: return(participantOnlyList(startsWith)); case AlphaPickerListType.Organization: return(organizationOnlyList(startsWith)); case AlphaPickerListType.ParticipantOrganization: return(participantAndOrganizationList(startsWith)); case AlphaPickerListType.TaxParcelOwner: return(taxParcelOwner(startsWith)); case AlphaPickerListType.Operator: return(operatorList(startsWith)); default: return(null); } } } catch (Exception ex) { WACAlert.Show("Invalid or Missing AlphaPickerListType In ParticipantOrganizationDP" + ex.Message, 0); return(null); } }
protected void TaxParcelPicker_Notify(object sender, UserControlResultEventArgs e) { Label lblSBL = fvTaxParcel.FindControl("lblSBL") as Label; lblSBL.Text = WACParameter.GetParameterValue(e.Parms, "SBL") as string; }