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());
}
