private void ShowSHIDDetail(int shid, int addressID) { try { ClearSHID(); List <ListAddressItem> addressList = BeetDataAddress.AddressGetInfo(shid, addressID, _cropYear); if (addressList.Count > 0) { ListAddressItem item = addressList[0]; txtSHID.Text = item.SHID; txtAddressID.Text = item.AddressID.ToString(); txtMemberID.Text = item.MemberID.ToString(); txtFirstName.Text = item.FirstName; txtLastName.Text = item.LastName; txtBusName.Text = item.BusName; txtAddrLine1.Text = item.AdrLine1; txtAddrLine2.Text = item.AdrLine2; txtCity.Text = item.CityName; txtState.Text = item.StateName; txtZip.Text = item.PostalCode; txtTaxID.Text = item.TaxID; txtPhone.Text = item.PhoneNo; txtEmail.Text = item.Email; } } catch (Exception ex) { Common.CException wex = new Common.CException("BankPayeeMaintenance.ShowSHIDDetail", ex); throw (wex); } }
protected void lstAddressName_SelectedIndexChanged(object sender, EventArgs e) { const string METHOD_NAME = "lstAddressName_SelectedIndexChanged"; try { Common.AppHelper.HideWarning(addrWarning); int cropYear = Convert.ToInt32(Common.UILib.GetDropDownText(ddlCropYear)); ListItem selItem = lstAddressName.SelectedItem; List <ListAddressItem> addrList = BeetDataAddress.AddressGetInfo(Convert.ToInt32(selItem.Value), 0, cropYear); if (addrList.Count > 0) { ListAddressItem item = addrList[0]; txtAddrSHID.Text = item.SHID; chkAddrSubscriber.Checked = item.IsSubscriber; txtAddrFName.Text = item.FirstName; txtAddrLName.Text = item.LastName; txtAddrBName.Text = item.BusName; txtAddrAddress.Text = item.AdrLine1; txtAddrAddressLine2.Text = item.AdrLine2; txtAddrCity.Text = item.CityName; txtAddrState.Text = item.StateName; txtAddrZip.Text = item.PostalCode; txtAddrPhoneNo.Text = item.PhoneNo; } } catch (System.Exception ex) { Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex); ((PrimaryTemplate)Page.Master).ShowWarning(ex, "Unable to load page correctly at this time.", addrWarning); } }
protected void btnAddrFind_Click(object sender, EventArgs e) { const string METHOD_NAME = "btnAddrFind_Click"; pacMessages.InnerText = ""; try { Common.AppHelper.HideWarning(addrWarning); lstAddressName.Items.Clear(); string searchTerm = txtSearchString.Text.TrimEnd(); int searchType = 0; if (radTypeSHID.Checked) { searchType = 1; } else { if (radTypeBusname.Checked) { searchType = 2; } else { searchType = 3; } } if (searchTerm.Length > 0) { if (!searchTerm.Contains("*")) { searchTerm = searchTerm + "%"; } else { searchTerm = searchTerm.Replace("*", "%"); } } int cropYear = Convert.ToInt16(ddlCropYear.Text);; List <ListAddressItem> addrList = BeetDataAddress.AddressFindByTerm(searchTerm, cropYear, searchType); lstAddressName.DataSource = addrList; lstAddressName.DataBind(); } catch (System.Exception ex) { Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex); ((PrimaryTemplate)Page.Master).ShowWarning(ex, "Unable to load page correctly at this time.", addrWarning); } }
private Individual CreateAndFetchIndividual(int crop_year, string shid) { int cropYear = Convert.ToInt16(ddlCropYear.Text); List <ListAddressItem> addrList = BeetDataAddress.AddressFindByTerm(shid, cropYear, 1); var x = addrList[0]; var ind = new Individual { FullName = x.FirstName + " " + x.LastName, SHID = Convert.ToInt32(shid), Sort = Convert.ToChar("1"), Percentage = 100, IndividualID = 0, Email = x.Email }; ind.IndividualID = PACData.SaveIndividual(ind); return(ind); }
// Private private void LoadPAC(int crop_year, string shid) { var METHOD_NAME = "LoadPAC"; Common.AppHelper.HideWarning(addrWarning); ResetPage(); txtSHID.Text = shid; lblBusName.Text = txtAddrBName.Text; this.MySHID = shid; try { var addresses = BeetDataAddress.AddressGetInfo(Convert.ToInt32(shid), 0, crop_year); var addr = addresses[0]; switch (Convert.ToString(addr.AddressType)) { case "1": lblAddressType.Text = "Individual"; break; case "2": lblAddressType.Text = "Corporation"; break; default: lblAddressType.Text = "Other"; break; } uplShid.Update(); PACAgreement pac = PACData.GetPACAgreement(shid, crop_year); if (pac != null) { btnDownloadPACAgreement.Enabled = true; pACContibution.Text = Convert.ToString(pac.Contribution); pACDate.Text = pac.PACDate; if (pac.Individuals.Count == 0) { pac.Individuals.Add(CreateAndFetchIndividual(crop_year, shid)); } indTableField.Value = pac.IndividualsString; this.IndTable = pac.Individuals; } else { btnDownloadPACAgreement.Enabled = false; IndTable.Add(CreateAndFetchIndividual(crop_year, shid)); } UpdatePACDetails.Visible = true; ReBuildTable(); UpdatePACDetails.Update(); } catch (Exception ex) { Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex); ((PrimaryTemplate)Page.Master).ShowWarning(ex, "Unable to load page correctly at this time.", indWarning); pacMessages.InnerHtml = "<font style='color: red;'>Invalid SHID / Crop Year</font>"; //pacMessages.InnerHtml = ex.Message + "<br />" + ex.StackTrace; UpdatePACDetails.Visible = false; return; } }
// PAC Form protected void btnDownloadPACAgreement_Click(object server, EventArgs e) { var METHOD_NAME = "btnDownloadPACAgreement_Click"; var qs = new NameValueCollection(); if (lblAddressType.Text == "Corporation") { pacMessages.InnerText = ""; string searchTerm = txtSHID.Text.Trim(); int searchType = 1; int cropYear = Convert.ToInt16(ddlCropYear.Text); List <ListAddressItem> addrList = BeetDataAddress.AddressFindByTerm(searchTerm, cropYear, searchType); var address = new StringBuilder(); address.AppendFormat("{0}, {1}, {2}, {3}", addrList[0].AdrLine1, addrList[0].AdrLine2, addrList[0].CityName, addrList[0].StateName); var phone = addrList[0].PhoneNo ?? ""; var pac = PACData.GetPACAgreement(txtSHID.Text, Convert.ToInt16(ddlCropYear.Text)); var inds = PACData.GetPACIndividuals(pac.Individuals[0].IndividualID, null); var i = new Individual(); var signerFirstName = inds[0].FullName.Split(" ".ToCharArray())[0]; var signerLastName = inds[0].FullName.Split(" ".ToCharArray())[1]; var date = DateTime.Now; var mfi = new DateTimeFormatInfo(); var strMonthName = mfi.GetMonthName(date.Month).ToString(); qs.Add("Filename", "PACDuesCorp"); qs.Add("CORPORATION NAME", Server.UrlEncode(lblBusName.Text)); qs.Add("CorporationName", Server.UrlEncode(lblBusName.Text)); qs.Add("LastNameFirstName", signerLastName + ", " + signerFirstName); //qs.Add("Dated", DateTime.Now.ToString("MM/dd/yyyy")); qs.Add("CentsPerTonDevlivered", pACContibution.Text); qs.Add("TwoDigitCents", (pACContibution.Text.Length == 1) ? "0" + pACContibution.Text : pACContibution.Text); qs.Add("Address", address.ToString()); qs.Add("PHONE", phone); qs.Add("Text1", DateTime.Now.Year.ToString()); qs.Add("Year2", DateTime.Now.Year.ToString()); try { qs.Add("Individual1", (PACData.GetPACIndividuals(pac.Individuals[0].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage1", pac.Individuals[0].Percentage.ToString()); qs.Add("Individual2", (PACData.GetPACIndividuals(pac.Individuals[1].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage2", pac.Individuals[1].Percentage.ToString()); qs.Add("Individual3", (PACData.GetPACIndividuals(pac.Individuals[2].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage3", pac.Individuals[2].Percentage.ToString()); qs.Add("Individual4", (PACData.GetPACIndividuals(pac.Individuals[3].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage4", pac.Individuals[3].Percentage.ToString()); } catch (Exception ex) { Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex); ((PrimaryTemplate)Page.Master).ShowWarning(ex, "Unable to load page correctly at this time.", indWarning); } } else { var pac = PACData.GetPACAgreement(txtSHID.Text, Convert.ToInt16(ddlCropYear.Text)); var inds = PACData.GetPACIndividuals(pac.Individuals[0].IndividualID, null); var i = new Individual(); var date = DateTime.Now; var mfi = new DateTimeFormatInfo(); var strMonthName = mfi.GetMonthName(date.Month).ToString(); var ds = WSCContract.GetContracts(txtSHID.Text, 2014, ConfigurationManager.ConnectionStrings["BeetConn"].ToString()); var strContractIds = ""; foreach (DataRow dr in ds.Tables[0].Rows) { strContractIds += dr[0] + ", "; } if (strContractIds.Length > 2) { strContractIds = strContractIds.Substring(0, strContractIds.Length - 2); } qs.Add("Filename", "PACDuesNonCorp"); qs.Add("CurrentTwoDigitYear", date.ToString("yy")); qs.Add("CurrentDayMonth", mfi.GetMonthName(date.Month).ToString() + " " + date.Day); qs.Add("SumOfMoneyPerTon", pACContibution.Text); qs.Add("CropYear1", DateTime.Now.Year.ToString()); qs.Add("SomeBullshit", DateTime.Now.Year.ToString()); qs.Add("PrintShareholderName", ((Individual)inds[0]).FullName); qs.Add("ContractNumber1", strContractIds); } Response.Redirect("~/Downloads/Downloader.aspx" + qs.ToQueryString()); }
protected void btnDownloadPACAgreement_Click(object server, EventArgs e) { var qs = new NameValueCollection(); if (lblAddressType.Text == "Corporation") { pacMessages.InnerText = ""; string searchTerm = txtSHID.Text.Trim(); int searchType = 1; int cropYear = Convert.ToInt16(ddlCropYear.Text); List <ListAddressItem> addrList = BeetDataAddress.AddressFindByTerm(searchTerm, cropYear, searchType); var address = new StringBuilder(); address.AppendFormat("{0}, {1}, {2}, {3}", addrList[0].AdrLine1, addrList[0].AdrLine2, addrList[0].CityName, addrList[0].StateName); var phone = addrList[0].PhoneNo ?? ""; var pac = PACData.GetPACAgreement(txtSHID.Text, Convert.ToInt16(ddlCropYear.Text)); var inds = PACData.GetPACIndividuals(pac.Individuals[0].IndividualID, null); var i = new Individual(); var signerFirstName = inds[0].FullName.Split(" ".ToCharArray())[0]; var signerLastName = inds[0].FullName.Split(" ".ToCharArray())[1]; var date = DateTime.Now; var mfi = new DateTimeFormatInfo(); var strMonthName = mfi.GetMonthName(date.Month).ToString(); qs.Add("Filename", "PACDuesCorp"); qs.Add("CORPORATION NAME", Server.UrlEncode(lblBusName.Text)); qs.Add("CorporationName", Server.UrlEncode(lblBusName.Text)); qs.Add("LastNameFirstName", signerLastName + ", " + signerFirstName); qs.Add("Dated", DateTime.Now.ToString("MM/dd/yyyy")); qs.Add("CentsPerTonDevlivered", pACContibution.Text); qs.Add("TwoDigitCents", (pACContibution.Text.Length == 1) ? "0" + pACContibution.Text : pACContibution.Text); qs.Add("Address", address.ToString()); qs.Add("PHONE", phone); qs.Add("Text1", DateTime.Now.Year.ToString()); qs.Add("Year2", DateTime.Now.Year.ToString()); try { qs.Add("Individual1", (PACData.GetPACIndividuals(pac.Individuals[0].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage1", pac.Individuals[0].Percentage.ToString()); qs.Add("Individual2", (PACData.GetPACIndividuals(pac.Individuals[1].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage2", pac.Individuals[1].Percentage.ToString()); qs.Add("Individual3", (PACData.GetPACIndividuals(pac.Individuals[2].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage3", pac.Individuals[2].Percentage.ToString()); qs.Add("Individual4", (PACData.GetPACIndividuals(pac.Individuals[3].IndividualID, null)[0].FullName)); qs.Add("IndividualPercentage4", pac.Individuals[3].Percentage.ToString()); } catch { } } else { var pac = PACData.GetPACAgreement(txtSHID.Text, Convert.ToInt16(ddlCropYear.Text)); var inds = PACData.GetPACIndividuals(pac.Individuals[0].IndividualID, null); var i = new Individual(); var date = DateTime.Now; var mfi = new DateTimeFormatInfo(); var strMonthName = mfi.GetMonthName(date.Month).ToString(); qs.Add("CurrentTwoDigitYear", date.ToString("yy")); qs.Add("CurrentDayMonth", mfi.GetMonthName(date.Month).ToString() + " " + date.Day); qs.Add("SumOfMoneyPerTon", pACContibution.Text); qs.Add("CropYear1", DateTime.Now.Year.ToString()); qs.Add("SomeBullshit", DateTime.Now.Year.ToString()); qs.Add("PrintShareholderName", ((Individual)inds[0]).FullName); qs.Add("Filename", "PACDuesNonCorp"); } Response.Redirect("~/Downloads/Downloader.aspx" + qs.ToQueryString()); }