private void buttonAdd_Click(object sender, EventArgs e)
{
//Get the value from the input feilds
m.Room = comboBoxRoom.Text;
m.Day = comboBoxDay.Text;
m.Time = textBoxTime.Text;
//inserting Data into Databse using the method we creted in pervious episode
bool success = m.Insert(m);
if (success == true)
{
//successfully Inserted
MessageBox.Show("Data is added successfully");
//call the clear method here
Clear();
}
else
{
//Failed to insert data
MessageBox.Show("Failed to add data. Please try again.....");
}
//Load Data on DataGridVeiw
DataTable dt = m.Select();
dataGridView3.DataSource = dt;
}
protected void Page_Load(object sender, EventArgs e)
{
Choose_SearchByUserLocation_Click(sender, e);
if (!IsPostBack)
{
}
if (!ClientScript.IsStartupScriptRegistered("initialize"))
{
Page.ClientScript.RegisterStartupScript(this.GetType(),
"initialize", "initialize();", true);
}
if (Request.QueryString["Product_ID_Array"] != null)
{
product_id_array = Request.QueryString["Product_ID_Array"].Split(',');
SelectedProduct_div.InnerHtml = "<table border='10', width=100%, borderColor='#00FF00'><tr><td style=\"padding: 5px 10px 5px 10px; background-color: #666666; font-size:large;\">Order Information:</td></tr></table>";
int orderNumber = 0;
// Loop over strings
for (int i = 0; i < product_id_array.Length; i++)
{
orderNumber++;
products = products.Select(Convert.ToInt32(product_id_array[i]));
warehouse_product_location = warehouse_product_location.Select_By_Product_ID(Convert.ToInt32(product_id_array[i]));
Location = Location.Select(warehouse_product_location.Location_ID);
Lat = Convert.ToDecimal(Location.n_lat);
Long = Convert.ToDecimal(Location.n_long);
passProduct_ID_hf.Value = Convert.ToString(products.FEMA_Description);
SelectedProduct_div.InnerHtml += "<Table border='2' width='100%' align ='center'><tr><td width='10%'>" + "<b><font color='black' size='3'>#" + orderNumber + "</b></font></td ><td width='90%' bgcolor='#333333' ></td></tr>" +
"<tr><td colspan='2'><b><font color='black'>Name: </b>" + products.product_name + "</td></tr>" +
"<tr><td colspan='2'><b><font color='black'>Type: </b>" + products.product_type + "</font></td></tr>" +
"<tr><td colspan='2'><b><font color='black'>Discription: </b>" + products.product_desc + "</font></td></tr>" +
"<tr><td colspan='2'><b><font color='black'>Lat/Long: </b>" + Lat + "/" + Long + "</font></td></tr>" +
"</td></tr></Table>";
EName.Add(products.product_name);
EType.Add(products.product_type);
EDescription.Add(products.product_desc);
//Page.ClientScript.RegisterStartupScript(this.GetType(),
//"showMap", "showMap("+ Lat +", " + Long + ");", true);
}
}
else
{
//Response.Write("<script>alert('Your order does not exist; This instance has been loged and well be looked into.');</script>");
}
}
public location Insert_location_select(int ID)
{
location = location.Select(ID);
Insert_type_txt.Text = Convert.ToString(location.type);
Insert_city_txt.Text = Convert.ToString(location.city);
Insert_state_txt.Text = Convert.ToString(location.state);
Insert_zip_txt.Text = Convert.ToString(location.zip);
Insert_county_txt.Text = Convert.ToString(location.county);
Insert_location_desc_txt.Text = Convert.ToString(location.location_desc);
Insert_n_long_txt.Text = Convert.ToString(location.n_long);
Insert_s_long_txt.Text = Convert.ToString(location.s_long);
Insert_e_long_txt.Text = Convert.ToString(location.e_long);
Insert_w_long_txt.Text = Convert.ToString(location.w_long);
Insert_n_lat_txt.Text = Convert.ToString(location.n_lat);
Insert_s_lat_txt.Text = Convert.ToString(location.s_lat);
Insert_e_lat_txt.Text = Convert.ToString(location.e_lat);
Insert_w_lat_txt.Text = Convert.ToString(location.w_lat);
return(location);
}
