private void package_combo()
{
if (package.Items.Count == 0)
{
try
{
string querry = "Select Description,Price from Container_Package ";
SqlCommand cmd = new SqlCommand(querry);
SqlConnection con = new func().con();
cmd.Connection = con;
try
{
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
package.Items.Add(rdr[0].ToString());
}
}
catch (Exception c)
{
}
finally
{
con.Close();
}
}
catch (Exception)
{
}
}
}
private void combo_selection()
{
string pck = package.SelectedItem.ToString();
try
{
string querry = "Select Price,DeliveryDays from Container_Package where Description=@pck ";
SqlCommand cmd = new SqlCommand(querry);
cmd.Parameters.AddWithValue("@pck", pck);
SqlConnection con = new func().con();
cmd.Connection = con;
try
{
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
float initial_price = Convert.ToInt16(rdr[0]);
int package_days = Convert.ToInt16(rdr[1]);
DateTime td = DateTime.Now.AddDays(package_days);
R_expectedate.Text = "" + td.Date.ToString("MM/dd/yyyy");
}
}
catch (Exception c)
{
}
finally
{
con.Close();
}
}
catch (Exception cc)
{
}
}
