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