public Form2()
{
InitializeComponent();
SetConnectionString();
PoetResult.Hide();
PoetWait.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
orderType = PoetOrder.Text;
CountryName = PoetCountry.Text;
ProgramName = PoetProgram.Text;
CustomerTypeCode = PoetCustomerType.Text;
LicenseAgreementType = PoetLicAgreementType.Text;
string ProgramOfferings = PoetProgramOfferings.Text;
string OfferingLevels = PoetOfferingLevel.Text;
if (orderType == "")
{
MessageBox.Show("Please Select Order Type");
}
else if (CountryName == "")
{
MessageBox.Show("Please Select Country Name");
}
else if (ProgramName == "")
{
MessageBox.Show("Please Select Program Name");
}
else if (CustomerTypeCode == "")
{
MessageBox.Show("Please Select Customer Type");
}
else if (LicenseAgreementType == "")
{
MessageBox.Show("Please Select License Agreement Type");
}
else if (ProgramOfferings == "")
{
MessageBox.Show("Please Select Program Offerings");
}
else if (OfferingLevels == "")
{
MessageBox.Show("Please Select Offering Levels");
}
else if (orderType == "StepUp Order")
{
PoetWait.Show();
PoetSearch.Enabled = false;
SqlConnection conn = new SqlConnection(ConnectionString);
string countryCode = GetCountryCode(CountryName);
string programCode = GetProgramCode(ProgramName);
string customerType = GetCustomerType(CustomerTypeCode);
string LicAgreementType = GetLicenseAgreementType(LicenseAgreementType);
SqlCommand cmd = new SqlCommand(string.Format(@"Select DISTINCT Top 1500 i.partnumber,* From ChannelNetprice CNP with (nolock)
INNER JOIN Item I with (Nolock)
on CNP.itemid=I.itemid
JOIN vStepUpSKU stp (NOLOCK) ON STP.ItemID=I.ItemID
Where CNP.countrycode ='{0}'
and CNP.programcode = '{1}'
and CNP.customerTypecode = '{2}'
and CNP.LicenseAgreementTypeCode = '{3}'
and CNP.programofferingcode ='{4}'
and CNP.OfferingLevelcode ='{5}'
and CNP.EndEffectiveDate is NULL
and (i.ReplacedByPartNumber is null or i.ReplacedByPartNumber='')" , countryCode, programCode, customerType, LicAgreementType, ProgramOfferings, OfferingLevels), conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
conn.Open();
adapter.Fill(dt);
conn.Close();
PoetWait.Hide();
PoetResult.Show();
PoetSearch.Enabled = true;
PoetResult.DataSource = dt;
}
else if (orderType == "TrueUp Order")
{
PoetWait.Show();
PoetSearch.Enabled = false;
SqlConnection conn = new SqlConnection(ConnectionString);
string countryCode = GetCountryCode(CountryName);
string programCode = GetProgramCode(ProgramName);
string customerType = GetCustomerType(CustomerTypeCode);
string LicAgreementType = GetLicenseAgreementType(LicenseAgreementType);
SqlCommand cmd = new SqlCommand(string.Format(@"Select DISTINCT Top 1500 partnumber,ApprovedPriceBeforeTax,ProductFamilyNAme, * From ChannelNetprice CNP with (nolock)
INNER JOIN Item I with (Nolock)
on CNP.itemid=I.itemid
Where CNP.countrycode ='{0}'
and CNP.programcode = '{1}'
and CNP.customerTypecode = '{2}'
and CNP.LicenseAgreementTypeCode = '{3}'
and CNP.programofferingcode ='{4}'
and CNP.OfferingLevelcode ='{5}'
and CNP.EndEffectiveDate is NULL
and (i.ReplacedByPartNumber is null or i.ReplacedByPartNumber='')" , countryCode, programCode, customerType, LicAgreementType, ProgramOfferings, OfferingLevels), conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
conn.Open();
adapter.Fill(dt);
conn.Close();
PoetWait.Hide();
PoetResult.Show();
PoetResult.DataSource = dt;
PoetSearch.Enabled = true;
}
else if (orderType == "Additional Products")
{
PoetWait.Show();
PoetSearch.Enabled = false;
SqlConnection conn = new SqlConnection(ConnectionString);
string countryCode = GetCountryCode(CountryName);
string programCode = GetProgramCode(ProgramName);
string customerType = GetCustomerType(CustomerTypeCode);
string LicAgreementType = GetLicenseAgreementType(LicenseAgreementType);
string offerings = "ACP";
SqlCommand cmd = new SqlCommand(String.Format(@"Select DISTINCT Top 1500 partnumber,ApprovedPriceBeforeTax,ProductFamilyNAme, * From ChannelNetprice CNP with (nolock)
INNER JOIN Item I with (Nolock)
on CNP.itemid=I.itemid
Where CNP.countrycode ='{0}'
and CNP.programcode = '{1}'
and CNP.customerTypecode = '{2}'
and CNP.LicenseAgreementTypeCode = '{3}'
and CNP.programofferingcode ='{4}'
and CNP.OfferingLevelcode ='{5}'
and CNP.EndEffectiveDate is NULL
and (i.ReplacedByPartNumber is null or i.ReplacedByPartNumber='')" , countryCode, programCode, customerType, LicAgreementType, offerings, OfferingLevels), conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
conn.Open();
adapter.Fill(dt);
conn.Close();
PoetWait.Hide();
PoetResult.Show();
PoetResult.DataSource = dt;
PoetSearch.Enabled = true;
}
else if (orderType == "Reservation Order")
{
PoetWait.Show();
PoetSearch.Enabled = false;
SqlConnection conn = new SqlConnection(ConnectionString);
string countryCode = GetCountryCode(CountryName);
string programCode = GetProgramCode(ProgramName);
string customerType = GetCustomerType(CustomerTypeCode);
string LicAgreementType = GetLicenseAgreementType(LicenseAgreementType);
SqlCommand cmd = new SqlCommand(string.Format(@"Select DISTINCT Top 1500 OLS.partnumber,CNP.ApprovedPriceBeforeTax, * from ChannelNetprice CNP
JOIN Item I on CNP.itemid=I.itemid join OLSItem OLS on OLS.ItemID = CNP.itemid
Where CNP.countrycode ='{0}'
and CNP.programcode = '{1}'
and CNP.customerTypecode = '{2}'
and CNP.LicenseAgreementTypeCode = '{3}'
and CNP.programofferingcode ='{4}'
and CNP.OfferingLevelcode ='{5}'
and CNP.EndEffectiveDate is NULL
and (i.ReplacedByPartNumber is null or i.ReplacedByPartNumber='')" , countryCode, programCode, customerType, LicAgreementType, ProgramOfferings, OfferingLevels), conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
conn.Open();
adapter.Fill(dt);
conn.Close();
PoetWait.Hide();
PoetResult.Show();
PoetResult.DataSource = dt;
PoetSearch.Enabled = true;
}
else if (orderType == "Transition Order")
{
PoetWait.Show();
PoetSearch.Enabled = false;
SqlConnection conn = new SqlConnection(ConnectionString);
string countryCode = GetCountryCode(CountryName);
string programCode = GetProgramCode(ProgramName);
string customerType = GetCustomerType(CustomerTypeCode);
string LicAgreementType = GetLicenseAgreementType(LicenseAgreementType);
SqlCommand cmd = new SqlCommand(string.Format(@"select top 5 * from country"), conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
conn.Open();
adapter.Fill(dt);
conn.Close();
PoetWait.Hide();
PoetResult.Show();
PoetResult.DataSource = dt;
PoetSearch.Enabled = true;
}
}
