protected void Page_Load(object sender, EventArgs e)
{
int tdxIncentiveId = Convert.ToInt32(Request.QueryString["TdxIncentiveId"]);
sp_050_text_detailsTableAdapter taRebateDetails = new sp_050_text_detailsTableAdapter();
Hashtable rebateDetailsRow = SearchBL.GetRebateDetails(tdxIncentiveId);
if (rebateDetailsRow != null)
{
lblIncentiveName.Text = rebateDetailsRow["IncentiveName"].ToString();
lblSummary.Text = rebateDetailsRow["Summary"].ToString();
lblEquipmentRequirements.Text = rebateDetailsRow["EquipmentRequirements"].ToString();
lblInstallationRequirements.Text = rebateDetailsRow["InstallationRequirements"].ToString();
lblProjectReviewCertification.Text = rebateDetailsRow["ProjectReviewCertification"].ToString();
lblTerms.Text = rebateDetailsRow["Terms"].ToString();
lblMaxLimit.Text = rebateDetailsRow["MaxLimit"].ToString();
lblExpirationDate.Text = rebateDetailsRow["ExpirationDate"].ToString();
lblIncentiveWebsite.Text = rebateDetailsRow["IncentiveWebsite"].ToString();
lblContactFName.Text = rebateDetailsRow["ContactFName"].ToString();
lblContactLName.Text = rebateDetailsRow["ContactLName"].ToString();
lblContactDept.Text = rebateDetailsRow["ContactDept"].ToString();
lblContactStreet.Text = rebateDetailsRow["ContactStreet"].ToString();
lblContactCity.Text = rebateDetailsRow["ContactCity"].ToString();
lblContactState.Text = rebateDetailsRow["ContactState"].ToString();
lblContactZip.Text = rebateDetailsRow["ContactZip"].ToString();
lblContactPhone.Text = rebateDetailsRow["ContactPhone"].ToString();
lblContactWebsite.Text = rebateDetailsRow["ContactWebsite"].ToString();
}
else
{
//this.lblResult.Text = "Invalid Username and/or Password";
}
}
public static Hashtable GetRebateDetails(int tdxIncentiveID)
{
sp_050_text_detailsTableAdapter taRebateDetails = new sp_050_text_detailsTableAdapter();
Search.sp_050_text_detailsDataTable dtRebateDetails = taRebateDetails.GetRebateDetails(tdxIncentiveID);
Hashtable htRebateDetails = new Hashtable();
if (dtRebateDetails.Rows.Count > 0)
{
htRebateDetails["IncentiveName"] = dtRebateDetails.Rows[0]["IncentiveName"];
htRebateDetails["Summary"] = dtRebateDetails.Rows[0]["Summary"];
htRebateDetails["EquipmentRequirements"] = dtRebateDetails.Rows[0]["EquipmentRequirements"];
htRebateDetails["InstallationRequirements"] = dtRebateDetails.Rows[0]["InstallationRequirements"];
htRebateDetails["ProjectReviewCertification"] = dtRebateDetails.Rows[0]["ProjectReviewCertification"];
htRebateDetails["Terms"] = dtRebateDetails.Rows[0]["Terms"];
htRebateDetails["MaxLimit"] = dtRebateDetails.Rows[0]["MaxLimit"];
htRebateDetails["ExpirationDate"] = dtRebateDetails.Rows[0]["ExpirationDate"];
htRebateDetails["IncentiveWebsite"] = dtRebateDetails.Rows[0]["IncentiveWebsite"];
htRebateDetails["ContactFName"] = dtRebateDetails.Rows[0]["ContactFName"];
htRebateDetails["ContactLName"] = dtRebateDetails.Rows[0]["ContactLName"];
htRebateDetails["ContactDept"] = dtRebateDetails.Rows[0]["ContactDept"];
htRebateDetails["ContactStreet"] = dtRebateDetails.Rows[0]["ContactStreet"];
htRebateDetails["ContactCity"] = dtRebateDetails.Rows[0]["ContactCity"];
htRebateDetails["ContactState"] = dtRebateDetails.Rows[0]["ContactState"];
htRebateDetails["ContactZip"] = dtRebateDetails.Rows[0]["ContactZip"];
htRebateDetails["ContactPhone"] = dtRebateDetails.Rows[0]["ContactPhone"];
htRebateDetails["ContactWebsite"] = dtRebateDetails.Rows[0]["ContactWebsite"];
return htRebateDetails;
}
else
return null;
}
public static Hashtable GetRebateDetails(int tdxIncentiveID)
{
sp_050_text_detailsTableAdapter taRebateDetails = new sp_050_text_detailsTableAdapter();
Search.sp_050_text_detailsDataTable dtRebateDetails = taRebateDetails.GetRebateDetails(tdxIncentiveID);
Hashtable htRebateDetails = new Hashtable();
if (dtRebateDetails.Rows.Count > 0)
{
htRebateDetails["IncentiveName"] = dtRebateDetails.Rows[0]["IncentiveName"];
htRebateDetails["Summary"] = dtRebateDetails.Rows[0]["Summary"];
htRebateDetails["EquipmentRequirements"] = dtRebateDetails.Rows[0]["EquipmentRequirements"];
htRebateDetails["InstallationRequirements"] = dtRebateDetails.Rows[0]["InstallationRequirements"];
htRebateDetails["ProjectReviewCertification"] = dtRebateDetails.Rows[0]["ProjectReviewCertification"];
htRebateDetails["Terms"] = dtRebateDetails.Rows[0]["Terms"];
htRebateDetails["MaxLimit"] = dtRebateDetails.Rows[0]["MaxLimit"];
htRebateDetails["ExpirationDate"] = dtRebateDetails.Rows[0]["ExpirationDate"];
htRebateDetails["IncentiveWebsite"] = dtRebateDetails.Rows[0]["IncentiveWebsite"];
htRebateDetails["ContactFName"] = dtRebateDetails.Rows[0]["ContactFName"];
htRebateDetails["ContactLName"] = dtRebateDetails.Rows[0]["ContactLName"];
htRebateDetails["ContactDept"] = dtRebateDetails.Rows[0]["ContactDept"];
htRebateDetails["ContactStreet"] = dtRebateDetails.Rows[0]["ContactStreet"];
htRebateDetails["ContactCity"] = dtRebateDetails.Rows[0]["ContactCity"];
htRebateDetails["ContactState"] = dtRebateDetails.Rows[0]["ContactState"];
htRebateDetails["ContactZip"] = dtRebateDetails.Rows[0]["ContactZip"];
htRebateDetails["ContactPhone"] = dtRebateDetails.Rows[0]["ContactPhone"];
htRebateDetails["ContactWebsite"] = dtRebateDetails.Rows[0]["ContactWebsite"];
return(htRebateDetails);
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
int tdxIncentiveId = Convert.ToInt32(Request.QueryString["TdxIncentiveId"]);
sp_050_text_detailsTableAdapter taRebateDetails = new sp_050_text_detailsTableAdapter();
Hashtable rebateDetailsRow = SearchBL.GetRebateDetails(tdxIncentiveId);
if (rebateDetailsRow != null)
{
lblIncentiveName.Text = rebateDetailsRow["IncentiveName"].ToString();
lblSummary.Text = rebateDetailsRow["Summary"].ToString();
lblEquipmentRequirements.Text = rebateDetailsRow["EquipmentRequirements"].ToString();
lblInstallationRequirements.Text = rebateDetailsRow["InstallationRequirements"].ToString();
lblProjectReviewCertification.Text = rebateDetailsRow["ProjectReviewCertification"].ToString();
lblTerms.Text = rebateDetailsRow["Terms"].ToString();
lblMaxLimit.Text = rebateDetailsRow["MaxLimit"].ToString();
lblExpirationDate.Text = rebateDetailsRow["ExpirationDate"].ToString();
lblIncentiveWebsite.Text = rebateDetailsRow["IncentiveWebsite"].ToString();
lblContactFName.Text = rebateDetailsRow["ContactFName"].ToString();
lblContactLName.Text = rebateDetailsRow["ContactLName"].ToString();
lblContactDept.Text = rebateDetailsRow["ContactDept"].ToString();
lblContactStreet.Text = rebateDetailsRow["ContactStreet"].ToString();
lblContactCity.Text = rebateDetailsRow["ContactCity"].ToString();
lblContactState.Text = rebateDetailsRow["ContactState"].ToString();
lblContactZip.Text = rebateDetailsRow["ContactZip"].ToString();
lblContactPhone.Text = rebateDetailsRow["ContactPhone"].ToString();
lblContactWebsite.Text = rebateDetailsRow["ContactWebsite"].ToString();
}
else
{
//this.lblResult.Text = "Invalid Username and/or Password";
}
}
