private void BindAg_WFP3_Encumbrance()
{
FormView fv = fvAg_WFP3_Encumbrance;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = from b in wDataContext.form_wfp3_encumbrances.Where(w => w.pk_form_wfp3_encumbrance == PK_Wfp3Encumbrance) select b;
fv.DataKeyNames = new string[] { "pk_form_wfp3_encumbrance" };
fv.DataSource = a;
fv.DataBind();
string sRegionWAC = WACGlobal_Methods.SpecialQuery_Agriculture_GetWACRegion_ByFarmBusinessPK(FK_FarmBusiness);
if (fv.CurrentMode == FormViewMode.Insert)
{
TextBox tbAmount = fv.FindControl("tbAmount") as TextBox;
try
{
var x = wDataContext.form_wfp3_get_encumbranceAmt_all(FK_Wfp3);
tbAmount.Text = x.Single().amt_encumbrance.ToString();
}
catch { }
WACGlobal_Methods.PopulateControl_DatabaseLists_Encumbrance_DDL(fv, "ddlEncumbrance", null);
}
if (fv.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_Encumbrance_DDL(fv, "ddlEncumbrance", a.Single().fk_encumbrance_code);
WACGlobal_Methods.PopulateControl_DatabaseLists_EncumbranceType_DDL(fv.FindControl("ddlType") as DropDownList, a.Single().fk_encumbranceType_code, true);
}
}
}
protected void lbBMPPlanning_ImplementationYears_Delete_Click(object sender, EventArgs e)
{
bool b = WACGlobal_Methods.Security_UserObjectCustom(Session["userID"], WACGlobal_Methods.Enum_Security_UserObjectCustom.A_PLAN);
if (b)
{
LinkButton lb = (LinkButton)sender;
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
iCode = wDataContext.bmp_ag_implementation_delete(Convert.ToInt32(lb.CommandArgument), Session["userName"].ToString());
if (iCode == 0)
{
BindData_BMPPlanning_FormView(Convert.ToInt32(fvBMPPlanning.DataKey.Value));
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
else
{
WACAlert.Show("You do not have permission to insert into the BMP Planning Implementation Year table.", 0);
}
}
protected void ddlInsert_SelectedIndexChanged(object sender, EventArgs e)
{
if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "I", "GlobalData", "GlobalData", "msgInsert"))
{
if (!string.IsNullOrEmpty(ddlInsert.SelectedValue))
{
int?i = null;
int iCode = 0;
try
{
using (WACDataClassesDataContext wac = new WACDataClassesDataContext())
{
iCode = wac.participantType_add(Convert.ToInt32(hfPK_Participant.Value), ddlInsert.SelectedValue, Session["userName"].ToString(), ref i);
if (iCode == 0)
{
object[] oArgs = new object[] { Convert.ToInt32(hfPK_Participant.Value) };
Page.GetType().InvokeMember("InvokedMethod_ControlGroup_RebindRecord", System.Reflection.BindingFlags.InvokeMethod, null, this.Page, oArgs);
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
}
catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); }
}
}
}
private void BindAg_WFP3_PaymentBMP()
{
FormView fv = fvAg_WFP3_PaymentBMP;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = from b in wDataContext.form_wfp3_paymentBMPs.Where(w => w.pk_form_wfp3_paymentBMP == PK_Wfp3PaymentBMP) select b;
fv.DataKeyNames = new string[] { "pk_form_wfp3_paymentBMP" };
fv.DataSource = a;
fv.DataBind();
if (fv.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_ByWFP3BMP_DDL(fv, "ddlBMP", Convert.ToInt32(FK_Wfp3), null);
WACGlobal_Methods.PopulateControl_DatabaseLists_PaymentStatus_DDL(fv.FindControl("ddlPaymentStatus") as DropDownList, null, true);
WACGlobal_Methods.PopulateControl_DatabaseLists_AgencyFunding_DDL(fv.FindControl("ddlFundingAgency") as DropDownList, null, "Y", null, true);
WACGlobal_Methods.PopulateControl_Custom_Agriculture_WFP3PaymentBMP_ByWFP3Specification_DDL(fv.FindControl("ddlBMPPractice") as DropDownList, Convert.ToInt32(FK_Wfp3), null, true, true);
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fv, "ddlReimbursementYN", "N", true);
}
if (fv.CurrentMode == FormViewMode.Edit)
{
decimal?bmp = a.Any() ? a.Single().fk_bmpPractice_code : null;
WACGlobal_Methods.PopulateControl_DatabaseLists_PaymentStatus_DDL(fv.FindControl("ddlPaymentStatus") as DropDownList, a.Single().fk_paymentStatus_code, true);
WACGlobal_Methods.PopulateControl_DatabaseLists_AgencyFunding_DDL(fv.FindControl("ddlFundingAgency") as DropDownList, null, "Y", a.Single().fk_agencyFunding_code, true);
//WACGlobal_Methods.PopulateControl_Custom_Agriculture_WFP3PaymentBMP_ByWFP3Specification_DDL(fv.FindControl("ddlBMPPractice") as DropDownList, Convert.ToInt32(FK_Wfp3), null, true, true);
//WACGlobal_Methods.PopulateControl_Custom_Agriculture_WFP3PaymentBMP_ByWFP3Specification_DDL(fv.FindControl("ddlBMPPractice") as DropDownList, Convert.ToInt32(FK_Wfp3), a.Single().fk_bmpPractice_code, true, true);
WACGlobal_Methods.PopulateControl_DatabaseLists_BMPPractice_DDL((DropDownList)fv.FindControl("ddlBMPPractice"), bmp, true, true, false);
DropDownList ddlReimbursementYN = fv.FindControl("ddlReimbursementYN") as DropDownList;
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fv.FindControl("ddlReimbursementYN") as DropDownList, a.Single().reimbursement, true);
}
}
}
private void BindAg_WFP3_BMP()
{
FormView fv = fvAg_WFP3_BMP;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = wDataContext.vw_form_wfp3_BMPs.Where(w => w.pk_form_wfp3_bmp == PK_Wfp3Bmp).Select(s => s);
fv.DataKeyNames = new string[] { "pk_form_wfp3_bmp" };
fv.DataSource = a;
fv.DataBind();
if (fv.CurrentMode == FormViewMode.Insert)
{
// JWJ 9/17/2012 changes parameter 3 from { 0,1 } to { 0 } re: BA934
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_ByFarmBusiness_DDL(fv.FindControl("ddlBMP") as DropDownList, Convert.ToInt32(FK_FarmBusiness), null, new int?[] { 0 }, true);
}
if (fv.CurrentMode == FormViewMode.Edit)
{
// JWJ 9/17/2012 changes parameter 3 from { 0,1 } to { 0 } re: BA934
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_ByFarmBusiness_DDL(fv.FindControl("ddlBMP") as DropDownList, Convert.ToInt32(FK_FarmBusiness), a.Single().pk_bmp_ag, new int?[] { 0 }, true);
//var b = wDataContext.bmp_ags.Where(w => w.pk_bmp_ag == a.Single().pk_bmp_ag).Select(s => s);
WACGlobal_Methods.PopulateControl_Custom_Agriculture_Units_By_BMPPractice(a.Single().fk_bmpPractice_code, fv.FindControl("lblAg_WFP3_BMP_Units") as Label);
}
}
}
protected void ddl_Search_State_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddl = sender as DropDownList;
object target = WACGlobal_Methods.ContainingObject(ddl.Page, "ChangeIndex2Zero4SearchDDLs");
try
{
object[] oArgs = new object[] { ddl.SelectedValue };
//target.GetType().InvokeMember("ChangeIndex2Zero4SearchDDLs", System.Reflection.BindingFlags.InvokeMethod, null, target, oArgs);
//Page.GetType().InvokeMember("ChangeIndex2Zero4SearchDDLs", System.Reflection.BindingFlags.InvokeMethod, null, this.Page, null);
ddl_Search_City.Items.Clear();
ddl_Search_AddressType.Items.Clear();
pnl_Search_Base.Visible = false;
ddl_Search_Address.Items.Clear();
ddl_Search_AddressNumber.Items.Clear();
if (!string.IsNullOrEmpty(ddl_Search_State.SelectedValue))
{
PopulateDDL4Search_City(ddl_Search_State.SelectedValue);
}
}
catch (Exception Exception)
{
//WACAlert.Show(Exception.Message, 0);
}
}
protected void fvSA_Note_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
StringBuilder sb = new StringBuilder();
FormView fv = fvSA.FindControl("fvSA_Note") as FormView;
TextBox tbNote = fv.FindControl("tbNote") as TextBox;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = wDataContext.supplementalAgreementNotes.Where(w => w.pk_supplementalAgreementNote == Convert.ToInt32(fv.DataKey.Value)).Select(s => s).Single();
try
{
a.note = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbNote.Text, 255);
a.modified = DateTime.Now;
a.modified_by = Session["userName"].ToString();
wDataContext.SubmitChanges();
fv.ChangeMode(FormViewMode.ReadOnly);
Populate_SA_Note_FormView(fv, Convert.ToInt32(fv.DataKey.Value));
if (!string.IsNullOrEmpty(sb.ToString()))
{
WACAlert.Show(sb.ToString(), 0);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
protected void lbVenue_EventVenueType_Delete_Click(object sender, EventArgs e)
{
if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "D", "GlobalData", "GlobalData", "msgDelete"))
{
LinkButton lb = (LinkButton)sender;
int i = Convert.ToInt32(lb.CommandArgument);
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
iCode = wDataContext.eventVenueType_delete(i);
if (iCode == 0)
{
BindVenue(Convert.ToInt32(fvVenue.DataKey.Value));
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
}
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddl = (DropDownList)sender;
WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(fvProperty, "ddlZip", null, ddl.SelectedValue);
if (fvProperty.CurrentMode == FormViewMode.Edit)
{
Label lblCity = fvProperty.FindControl("lblCity") as Label;
DropDownList ddlCountyNY = fvProperty.FindControl("ddlCounty") as DropDownList;
DropDownList ddlTownshipNY = fvProperty.FindControl("ddlTownshipNY") as DropDownList;
DropDownList ddlBasin = fvProperty.FindControl("ddlBasin") as DropDownList;
DropDownList ddlSubbasin = fvProperty.FindControl("ddlSubbasin") as DropDownList;
if (ddl.SelectedValue == "NY")
{
WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(ddlCountyNY, false, null);
ddlTownshipNY.Items.Clear();
ddlBasin.Items.Clear();
ddlSubbasin.Items.Clear();
}
else
{
ddlCountyNY.Items.Clear();
ddlTownshipNY.Items.Clear();
ddlBasin.Items.Clear();
ddlSubbasin.Items.Clear();
}
if (lblCity != null)
{
lblCity.Text = "";
}
}
}
private void BindHR_WACEmployee_TrainingCost(int i)
{
using (WACDataClassesDataContext wac = new WACDataClassesDataContext())
{
FormView fvHR_WACEmployee_TrainingCost = fvHR_WACEmployee_Training.FindControl("fvHR_WACEmployee_TrainingCost") as FormView;
var x = wac.participantWAC_trainingCosts.Where(w => w.pk_participantWAC_trainingCost == i).
Select(s => s).OrderByDescending(o => o.created);
fvHR_WACEmployee_TrainingCost.DataSource = x;
fvHR_WACEmployee_TrainingCost.DataKeyNames = new string[] { "pk_participantWAC_trainingCost" };
fvHR_WACEmployee_TrainingCost.DataBind();
if (fvHR_WACEmployee_TrainingCost.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_TrainingCost_DDL(fvHR_WACEmployee_TrainingCost.FindControl("ddlTrainingCostCode") as DropDownList, null, true);
}
if (fvHR_WACEmployee_TrainingCost.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_TrainingCost_DDL(fvHR_WACEmployee_TrainingCost.FindControl("ddlTrainingCostCode") as DropDownList, x.Single().fk_trainingCost_code, false);
if (x.Single().date != null)
{
TextBox tbDate = fvHR_WACEmployee_TrainingCost.FindControl("AjaxCalendar_TrCostDate").FindControl("tb") as TextBox;
tbDate.Text = Convert.ToDateTime(x.Single().date).ToShortDateString();
}
}
}
}
protected void ddlVenue_EventVenueType_Add_SelectedIndexChanged(object sender, EventArgs e)
{
if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "I", "GlobalData", "GlobalData", "msgInsert"))
{
DropDownList ddl = (DropDownList)sender;
if (!string.IsNullOrEmpty(ddl.SelectedValue))
{
int?i = null;
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
iCode = wDataContext.eventVenueType_add(Convert.ToInt32(fvVenue.DataKey.Value), ddl.SelectedValue, ref i);
if (iCode == 0)
{
BindVenue(Convert.ToInt32(fvVenue.DataKey.Value));
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
}
}
private void BindData_Ag_BMPPractice(decimal d)
{
using (WACDataClassesDataContext wac = new WACDataClassesDataContext())
{
var a = wac.list_bmpPractices.Where(w => w.pk_bmpPractice_code == d).Select(s => s);
fvList_Ag_BMPPractice.DataKeyNames = new string[] { "pk_bmpPractice_code" };
fvList_Ag_BMPPractice.DataSource = a;
fvList_Ag_BMPPractice.DataBind();
if (fvList_Ag_BMPPractice.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_Agency_DDL(fvList_Ag_BMPPractice, "ddlAgency", null);
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_Lifespan_DDL(fvList_Ag_BMPPractice.FindControl("ddlLifespan") as DropDownList, null, false);
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fvList_Ag_BMPPractice, "ddlAgronomic", null);
WACGlobal_Methods.PopulateControl_DatabaseLists_Unit_DDL(fvList_Ag_BMPPractice, "ddlUnit", null);
WACGlobal_Methods.PopulateControl_DatabaseLists_WACPracticeCategory_DDL(fvList_Ag_BMPPractice.FindControl("ddlWACPracticeCategory") as DropDownList, null);
}
if (fvList_Ag_BMPPractice.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_Agency_DDL(fvList_Ag_BMPPractice, "ddlAgency", a.Single().fk_agency_code);
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_Lifespan_DDL(fvList_Ag_BMPPractice.FindControl("ddlLifespan") as DropDownList, a.Single().life_reqd_yr, false);
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fvList_Ag_BMPPractice, "ddlAgronomic", a.Single().agronomic);
WACGlobal_Methods.PopulateControl_DatabaseLists_Unit_DDL(fvList_Ag_BMPPractice, "ddlUnit", a.Single().fk_unit_code);
WACGlobal_Methods.PopulateControl_DatabaseLists_WACPracticeCategory_DDL(fvList_Ag_BMPPractice.FindControl("ddlWACPracticeCategory") as DropDownList, a.Single().fk_list_wacPracticeCategory);
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fvList_Ag_BMPPractice, "ddlActive", a.Single().active, false);
}
}
}
protected void fvList_Ag_BMPPractice_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
bool b = WACGlobal_Methods.Security_UserObjectCustom(Session["userID"], WACGlobal_Methods.Enum_Security_UserObjectCustom.A_ABC);
if (b)
{
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
iCode = wDataContext.list_bmpPractice_delete(Convert.ToDecimal(fvList_Ag_BMPPractice.DataKey.Value), Session["userName"].ToString());
if (iCode == 0)
{
lbList_Ag_BMPPracticePopUp_Close_Click(null, null);
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); }
}
}
else
{
WACAlert.Show("You do not have permission to delete BMP Practice data.", 0);
}
//if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "D", "GlobalData", "GlobalData", "msgDelete"))
//{
//}
}
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddl = (DropDownList)sender;
TextBox tbCity = pnlGlobal_Insert_Properties.FindControl("tbCity") as TextBox;
DropDownList ddlCounty = pnlGlobal_Insert_Properties.FindControl("ddlCounty") as DropDownList;
DropDownList ddlTownshipNY = pnlGlobal_Insert_Properties.FindControl("ddlTownshipNY") as DropDownList;
DropDownList ddlBasin = pnlGlobal_Insert_Properties.FindControl("ddlBasin") as DropDownList;
DropDownList ddlSubbasin = pnlGlobal_Insert_Properties.FindControl("ddlSubbasin") as DropDownList;
DropDownList ddlZip = (DropDownList)pnlGlobal_Insert_Properties.FindControl("ddlZip");
WACGlobal_Methods.PopulateControl_DatabaseLists_Zipcode_DDL(ddlZip, null, ddl.SelectedValue, true);
if (ddl.SelectedValue == "NY")
{
WACGlobal_Methods.PopulateControl_DatabaseLists_CountyNY_DDL(ddlCounty, false, null);
ddlTownshipNY.Items.Clear();
ddlBasin.Items.Clear();
ddlSubbasin.Items.Clear();
}
else
{
ddlCounty.Items.Clear();
ddlTownshipNY.Items.Clear();
ddlBasin.Items.Clear();
ddlSubbasin.Items.Clear();
}
if (tbCity != null)
{
tbCity.Text = string.Empty;
}
}
private void BindParticipant_Property(int i)
{
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = from b in wDataContext.participantProperties.Where(w => w.pk_participantProperty == i) select b;
fvParticipant_Property.DataKeyNames = new string[] { "pk_participantProperty" };
fvParticipant_Property.DataSource = a;
fvParticipant_Property.DataBind();
if (fvParticipant_Property.CurrentMode == FormViewMode.Insert)
{
DropDownList ddlZipCode = (DropDownList)fvParticipant_Property.FindControl("ddlZipCode");
WACGlobal_Methods.ZipCodesFromExistingAddresses(ddlZipCode);
}
if (fvParticipant_Property.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_Property_EditInsert_UserControl(fvParticipant_Property.FindControl("UC_Property_EditInsert_Participant_Property") as UserControl, a.Single().property);
//WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fvParticipant_Property, "ddlMaster", a.Single().master, false);
//DropDownList ddl = fvParticipant_Property.FindControl("UC_DropDownListByAlphabet_Participant_Property").FindControl("ddl") as DropDownList;
//Label lblLetter = fvParticipant_Property.FindControl("UC_DropDownListByAlphabet_Participant_Property").FindControl("lblLetter") as Label;
//string sLetter = null;
//try { sLetter = a.Single().participant1.lname.Substring(0, 1); }
//catch { }
//WACGlobal_Methods.EventControl_Custom_DropDownListByAlphabet(ddl, lblLetter, sLetter, "PARTICIPANT", "ALL", a.Single().fk_participant_cc);
}
}
}
protected void ddlCounty_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddlCounty = (DropDownList)sender;
DropDownList ddlTownshipNY = (DropDownList)fvProperty.FindControl("ddlTownshipNY");
DropDownList ddlBasin = (DropDownList)fvProperty.FindControl("ddlbasin");
DropDownList ddlSubbasin = (DropDownList)fvProperty.FindControl("ddlSubbasin");
if (!string.IsNullOrEmpty(ddlCounty.SelectedValue))
{
WACGlobal_Methods.PopulateControl_DatabaseLists_TownshipNY_DDL(ddlTownshipNY, Convert.ToInt32(ddlCounty.SelectedValue), null);
if (_CountyControlsBasin)
{
WACGlobal_Methods.PopulateControl_DatabaseLists_Basin_DDL(ddlBasin, null, null, null, Convert.ToInt32(ddlCounty.SelectedValue), null, true);
if (_BoolShowSubbasin)
{
ddlSubbasin.Items.Clear();
}
}
}
else
{
if (_BoolShowTownship)
{
ddlTownshipNY.Items.Clear();
}
if (_CountyControlsBasin)
{
ddlBasin.Items.Clear();
if (_BoolShowSubbasin)
{
ddlSubbasin.Items.Clear();
}
}
}
}
private void BindAg_WFP3_Specification()
{
FormView fv = fvAg_WFP3_Specification;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = wDataContext.form_wfp3_specifications.Where(w => w.pk_form_wfp3_specification == PK_Wfp3Spec).Select(s => s);
fv.DataKeyNames = new string[] { "pk_form_wfp3_specification" };
fv.DataSource = a;
fv.DataBind();
if (fv.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_ByWFP3BMP_DDL(fv, "ddlBMP", FK_Wfp3, null);
WACGlobal_Methods.PopulateControl_DatabaseLists_BMPPractice_DDL(fv.FindControl("ddlPractice") as DropDownList, null, true, true, false);
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fv.FindControl("ddlBidRequired") as DropDownList, null, true);
}
if (fv.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_ByWFP3BMP_DDL(fv, "ddlBMP", FK_Wfp3, a.Single().fk_form_wfp3_bmp);
WACGlobal_Methods.PopulateControl_DatabaseLists_BMPPractice_DDL(fv.FindControl("ddlPractice") as DropDownList, a.Single().fk_bmpPractice_code, true, true, false);
WACGlobal_Methods.PopulateControl_Generic_YesNoDDL(fv.FindControl("ddlBidRequired") as DropDownList, a.Single().bid_reqd, true);
}
}
}
public 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.Insert)
{
hfOrganizationPK.Value = a.Single().pk_organization.ToString();
}
if (fvOrganization.CurrentMode == FormViewMode.Edit)
{
DropDownList ddl = fvOrganization.FindControl("UC_DropDownListByAlphabet_Organization").FindControl("ddl") as DropDownList;
Label lbl = fvOrganization.FindControl("UC_DropDownListByAlphabet_Organization").FindControl("lblLetter") as Label;
string sLetter = null;
try { sLetter = a.Single().participant.lname[0].ToString(); }
catch { }
WACGlobal_Methods.EventControl_Custom_DropDownListByAlphabet(ddl, lbl, sLetter, "PARTICIPANT", "ALL", a.Single().fk_participant_contact);
WACGlobal_Methods.PopulateControl_Property_EditInsert_UserControl(fvOrganization.FindControl("UC_Property_EditInsert_Organization") as UserControl, a.Single().property);
}
}
}
private void _connect(Control _control, ConnectorFactory _factory, WACViewModel _containerViewModel)
{
if (ViewModel == null)
{
ViewModel = GetViewModel(_control, _factory);
}
if (String.IsNullOrEmpty(ViewModel.UserName))
{
ViewModel.UserName = _control.Page.Session["userName"] as string;
ViewModel.UserID = WACGlobal_Methods.KeyAsInt(_control.Page.Session["userID"]);
}
if (_containerViewModel == null)
{
ViewModel.DataProvider = GetDataProvider(_control, _factory);
}
else
{
ViewModel.DataProvider = _containerViewModel.DataProvider;
ViewModel.ListSource = _containerViewModel.ListSource;
}
if (SessionID == null)
{
SessionID = _control.Page.Session.SessionID;
}
else if (!_control.Page.Session.SessionID.Equals(SessionID, StringComparison.OrdinalIgnoreCase))
{
throw new Exception("Connector / Control SessionID mismatch");
}
ConnectControlSpecific(_control, _factory);
}
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);
}
}
protected void fvSA_Note_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
FormView fv = fvSA.FindControl("fvSA_Note") as FormView;
if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "D", "A", "supplementalAgreementNote", "msgDelete"))
{
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
iCode = wDataContext.supplementalAgreementNote_delete(Convert.ToInt32(fv.DataKey.Value), Session["userName"].ToString());
if (iCode == 0)
{
lbSA_Note_Close_Click(null, null);
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
}
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);
}
}
private void BindAg_WFP3_Bid()
{
FormView fv = fvAg_WFP3_Bid;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
var a = from b in wDataContext.form_wfp3_bids.Where(w => w.pk_form_wfp3_bid == PK_Wfp3Bid) select b;
fv.DataKeyNames = new string[] { "pk_form_wfp3_bid" };
fv.DataSource = a;
fv.DataBind();
string sRegionWAC = WACGlobal_Methods.SpecialQuery_Agriculture_GetWACRegion_ByFarmBusinessPK(FK_FarmBusiness);
if (fv.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_Participant_DBView_DDL(fv.FindControl("ddlContractor") as DropDownList, null, new string[] { "C" },
null, null, new string[] { sRegionWAC }, null, null, null, false, false, false, false, false, false,
WACGlobal_Methods.Enum_Participant_Forms.ALL, true);
}
if (fv.CurrentMode == FormViewMode.Edit)
{
WACGlobal_Methods.PopulateControl_Participant_DBView_DDL(fv.FindControl("ddlContractor") as DropDownList, a.Single().fk_participant_contractor,
new string[] { "C" }, null, null, new string[] { sRegionWAC }, null, null, null, false, false, false, false, false, false,
WACGlobal_Methods.Enum_Participant_Forms.ALL, true);
}
}
}
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());
}
//private void HandleSupplementalAgreementsBasedOnFarm(int iPK_FarmBusiness, int? iPK_SupplementalAgreementTaxParcel)
private void HandleSupplementalAgreementsBasedOnFarm(int?iPK_SupplementalAgreementTaxParcel)
{
Panel pnlSA_Available = fvBMPPlanning.FindControl("pnlSA_Available") as Panel;
Panel pnlSA_Message = fvBMPPlanning.FindControl("pnlSA_Message") as Panel;
Label lblSA_Message = fvBMPPlanning.FindControl("lblSA_Message") as Label;
DropDownList ddlSAA = fvBMPPlanning.FindControl("ddlSAA") as DropDownList;
DropDownList ddlSA = fvBMPPlanning.FindControl("ddlSA") as DropDownList;
using (WACDataClassesDataContext wac = new WACDataClassesDataContext())
{
//var a = wac.bmp_ag_SAs.Where(w => w.bmp_ag.fk_farmBusiness == iPK_FarmBusiness).Select(s => s.pk_bmp_ag_SA);
//if (a.Count() > 0)
//{
//if (fvBMPPlanning.CurrentMode == FormViewMode.Insert) WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_SupplementalAgreementTaxParcel(ddlSA, iPK_FarmBusiness, null, true);
//else WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_SupplementalAgreementTaxParcel(ddlSA, iPK_FarmBusiness, iPK_SupplementalAgreementTaxParcel, true);
if (fvBMPPlanning.CurrentMode == FormViewMode.Insert)
{
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_SupplementalAgreementTaxParcel(ddlSA, null, true);
}
else
{
WACGlobal_Methods.PopulateControl_Custom_Agriculture_BMP_SupplementalAgreementTaxParcel(ddlSA, iPK_SupplementalAgreementTaxParcel, true);
}
pnlSA_Message.Visible = false;
pnlSA_Available.Visible = true;
//}
//else
//{
// lblSA_Message.Text = "No Supplemental Agreements have been assigned to this farm";
// pnlSA_Available.Visible = false;
// pnlSA_Message.Visible = true;
//}
}
}
protected void fvOrganization_ItemInserting(object sender, FormViewInsertEventArgs e)
{
int?i = null;
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
TextBox tbOrg = fvOrganization.FindControl("tbOrg") as TextBox;
try
{
string sOrg = WACGlobal_Methods.Format_Global_StringLengthRestriction(tbOrg.Text, 96).Trim();
iCode = wDataContext.organization_add(sOrg, Session["userName"].ToString(), ref i);
if (iCode == 0)
{
fvOrganization.ChangeMode(FormViewMode.ReadOnly);
BindOrganization(Convert.ToInt32(i));
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show("Error: " + ex.Message, 0); }
}
}
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());
}
protected void fvOrganization_Note_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
//if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "D", "GlobalData", "GlobalData", "msgDelete"))
//{
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
if (WACGlobal_Methods.Security_UserCanModifyDeleteNote(Session["userName"], "organizationNote", Convert.ToInt32(fvOrganization_Note.DataKey.Value)))
{
iCode = wDataContext.organizationNote_delete(Convert.ToInt32(fvOrganization_Note.DataKey.Value), Session["userName"].ToString());
if (iCode == 0)
{
lbOrganization_Note_Close_Click(null, null);
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
//}
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
if (WACGlobal_Methods.Security_UserCanPerformAction(Session["userID"], "D", "GlobalData", "GlobalData", "msgDelete"))
{
int iCode = 0;
using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext())
{
try
{
iCode = wDataContext.participantType_delete(Convert.ToInt32(lb.CommandArgument), Session["userName"].ToString());
if (iCode == 0)
{
object[] oArgs = new object[] { Convert.ToInt32(hfPK_Participant.Value) };
Page.GetType().InvokeMember("InvokedMethod_ControlGroup_RebindRecord", System.Reflection.BindingFlags.InvokeMethod, null, this.Page, oArgs);
}
else
{
WACAlert.Show("Error Returned from Database.", iCode);
}
}
catch (Exception ex) { WACAlert.Show(ex.Message, 0); }
}
}
}
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());
}
