private void UpdateIndTable() { string summaryData = indTableField.Value; this.IndTable = new List<Individual>(); if (summaryData != null && summaryData.Length > 1) { string[] lines = summaryData.Split('~'); for (int l = 0; l < lines.Length; l++) { if (lines[l] != null && lines[l].Length > 1) { string[] items = lines[l].Split('|'); Individual tempHolder = new Individual(); tempHolder.IndividualID = Convert.ToInt32(items[1]); if (items[0] != null && items[0].Length > 0) tempHolder.Sort = Convert.ToChar(items[0]); else tempHolder.Sort = ' '; tempHolder.Percentage = Convert.ToDouble(items[2]); tempHolder.Signed = ("true" == items[3]); if (items.Length > 4 && items[4].Length > 1) tempHolder.SignedDate = Convert.ToDateTime(items[4]); if (items.Length > 5 && items[5].Length > 1) tempHolder.SHID = Convert.ToInt32(items[5]); this.IndTable.Add(tempHolder); } } } }
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; }
protected void btnIndAdd_Click(object sender, EventArgs e) { pacMessages.InnerText = ""; int userId = 0; if (newIndividualName != null && newIndividualName.Text.Length > 1) { var i = new Individual { IndividualID = 0, FullName = newIndividualName.Text, Email = newIndividualEmail.Text, SHID = Convert.ToInt32(txtSHID.Text) }; userId = PACData.SaveIndividual(i); if (userId > 0) { Individual user = PACData.GetPACIndividuals(userId, null)[0]; if (user != null) { this.IndTable.Add(user); ReBuildTable(); UpdatePACDetails.Update(); CloseAndResolve("PACIndividuals"); } } } }
// 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()); }
// Address Search protected void btnAddrOk_Click(object sender, EventArgs e) { // If we have a selected address, use the shid for our main page. if (lstAddressName.SelectedItem != null) { int crop_year = Convert.ToInt16(ddlCropYear.Text); string shid = txtAddrSHID.Text; if (hdnFinderType.Value == "AddressFinder") { LoadPAC(crop_year, shid); } else { var ind = new Individual { FullName = txtAddrFName.Text + " " + txtAddrLName.Text, SHID = Convert.ToInt32(shid), Sort = Convert.ToChar("1"), Percentage = 100, IndividualID = 0, Email = txtEmail.Text }; ind.IndividualID = PACData.SaveIndividual(ind); IndTable.Add(ind); ReBuildTable(); UpdatePACDetails.Update(); } CloseAndResolve("AddressFinder"); } }
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()); }