private void BindProperty(int i)
{
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = from b in wDataContext.properties.Where(w => w.pk_property == i) select b;
fvProperty.DataKeyNames = new string[] { "pk_property" };
fvProperty.DataSource = a;
fvProperty.DataBind();
if (fvProperty.CurrentMode == FormViewMode.ReadOnly)
{
if (i > 0)
{
WACUT_Associations assoc = fvProperty.FindControl("WACUT_Associations") as WACUT_Associations;
List <WACParameter> parms = new List <WACParameter>();
parms.Add(new WACParameter("pk_property", i, WACParameter.ParameterType.SelectedKey));
parms.Add(new WACParameter("pk_property", i, WACParameter.ParameterType.PrimaryKey));
assoc.InitControl(parms);
parms = null;
}
}
if (fvProperty.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_StatesUS_DDL(fvProperty, "ddlState", "NY");
WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", null, "NY");
}
if (fvProperty.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_StatesUS_DDL(fvProperty, "ddlState", a.Single().state);
WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", a.Single().fk_zipcode, a.Single().state);
WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(fvProperty.FindControl("ddlCounty") as DropDownList, false, a.Single().fk_list_countyNY);
if (a.Single().fk_list_countyNY != null)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_TownshipNY_DDL(fvProperty.FindControl("ddlTownshipNY") as DropDownList, a.Single().fk_list_countyNY, a.Single().fk_list_townshipNY);
WACGlobal_Methods.PopulateControl_DatabaseLists_Basin_DDL(fvProperty.FindControl("ddlBasin") as DropDownList, null, null, null, a.Single().fk_list_countyNY, a.Single().fk_basin_code, true);
if (!string.IsNullOrEmpty(a.Single().fk_basin_code))
{
WACGlobal_Methods.PopulateControl_DatabaseLists_Subbasin_DDL(fvProperty.FindControl("ddlSubbasin") as DropDownList, a.Single().fk_basin_code, a.Single().fk_subbasin_code);
}
}
}
}
upProperty.Update();
}
private void BindOrganization(int i)
{
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = wDataContext.organizations.Where(w => w.pk_organization == i).Select(s => s);
fvOrganization.DataKeyNames = new string[] { "pk_organization" };
fvOrganization.DataSource = a;
fvOrganization.DataBind();
if (fvOrganization.CurrentMode == FormViewMode.ReadOnly)
{
// this needs to be replaced when page is converted
WACUT_Associations assoc = fvOrganization.FindControl("WACUT_Associations") as WACUT_Associations;
List <WACParameter> parms = new List <WACParameter>();
parms.Add(new WACParameter("pk_participant", i, WACParameter.ParameterType.SelectedKey));
parms.Add(new WACParameter("pk_participant", i, WACParameter.ParameterType.PrimaryKey));
assoc.InitControl(parms);
}
if (fvOrganization.CurrentMode == FormViewMode.Edit)
{
DropDownList ddl = fvOrganization.FindControl("UC_DropDownListByAlphabet").FindControl("ddl") as DropDownList;
Label lbl = fvOrganization.FindControl("UC_DropDownListByAlphabet").FindControl("lblLetter") as Label;
string contact = string.Empty;
string sLetter = string.Empty;
if (a.Any())
{
WACGlobal_Methods.PopulateControl_Property_EditInsert_UserControl(fvOrganization.FindControl("UC_Property_EditInsert1") as UserControl, a.Single().property);
if (a.Single().fk_participant_contact != null)
{
contact = a.Single().participant.fullname_LF_dnd;
}
sLetter = string.IsNullOrEmpty(contact) ? null : contact[0].ToString();
WACGlobal_Methods.EventControl_Custom_DropDownListByAlphabet(ddl, lbl, sLetter, "PARTICIPANT", "ALL", a.Single().fk_participant_contact);
}
;
}
}
upOrganization.Update();
}
