protected void SubmitButton_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter("insert into Hotel_Details(H_Type,H_Stars,H_Name,H_Country,Room_Category,H_City,Amount,Description)values('" + typeDropDownList.SelectedItem.Text + "','" + StarDropDownList.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "'," + AmtTextBox.Text + ",'" + DescTextBox.Text + "')", con);
dt = new DataTable();
da.Fill(dt);
cmtLabel.Text = "Data Submit";
typeDropDownList.ClearSelection();
StarDropDownList.ClearSelection();
NameTextBox.Text = "";
DropDownCountry.ClearSelection();
DropdownCategory.ClearSelection();
DropDownCity.ClearSelection();
AmtTextBox.Text = "";
DescTextBox.Text = "";
da = new SqlDataAdapter("select * from Hotel_Details order by H_Id desc", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewHotelDetails.DataSource = dt;
GridViewHotelDetails.DataBind();
}
else
{
GridViewHotelDetails.DataSource = "";
GridViewHotelDetails.DataBind();
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter("insert into [Homestay-Resort_Details](HR_Type,HR_Stars,HR_Category,HR_Name,HR_Country,HR_City,Amount,Description)values('" + DropDownListType.SelectedItem.Text + "','" + NameDropDownList.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "'," + TextBoxAmount.Text + ",'" + DescTextBox.Text + "')", con);
dt = new DataTable();
da.Fill(dt);
CmtLabel.Text = "Data Submit";
DropDownListType.ClearSelection();
NameDropDownList.ClearSelection();
DropdownCategory.ClearSelection();
NameTextBox.Text = "";
DropDownCountry.ClearSelection();
DropDownCity.ClearSelection();
TextBoxAmount.Text = "";
DescTextBox.Text = "";
CmtLabel.Text = "Data Submit";
da = new SqlDataAdapter("select * from [Homestay-Resort_Details] order by HR_ID desc", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewHomestayDetails.DataSource = dt;
GridViewHomestayDetails.DataBind();
}
else
{
GridViewHomestayDetails.DataSource = "";
GridViewHomestayDetails.DataBind();
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter("insert into Transport_Details(T_Type,T_category,T_Name,To_Country,To_City,From_Country,From_City,Date,Time,Amount,Description)values('" + typeDropDownList.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + NameTextBox.Text + "','" + DropDownToCountry.SelectedItem.Text + "','" + DropDownToCity.SelectedItem.Text + "','" + DropDownFromCountry.SelectedItem.Text + "','" + DropDownFromCity.SelectedItem.Text + "','" + TextBox1.Text + "','" + TimeTextBox.Text + "'," + AmtTextBox.Text + ",'" + DescTextBox.Text + "')", con);
dt = new DataTable();
da.Fill(dt);
Label2.Text = "Data Sumbmit";
TextBox1.Text = "";
DropdownCategory.ClearSelection();
DropDownToCountry.ClearSelection();
DropDownToCity.ClearSelection();
DropDownFromCountry.ClearSelection();
DropDownFromCity.ClearSelection();
NameTextBox.Text = "";
typeDropDownList.ClearSelection();
TimeTextBox.Text = "";
AmtTextBox.Text = "";
DescTextBox.Text = "";
da = new SqlDataAdapter("select T_Id,T_Type,T_Category,T_Name,To_Country,To_City,From_Country,From_City,convert(varchar,Date,106)Date,Time,Amount,Description from Transport_Details order by T_Id DESC", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewTransportDetails.DataSource = dt;
GridViewTransportDetails.DataBind();
}
else
{
GridViewTransportDetails.DataSource = "";
GridViewTransportDetails.DataBind();
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter("insert into Package_Details(P_Type,P_Category,Country,City,Days,Amount,Description)values('" + DropDownListType.SelectedItem.Text + "','" + DropdownCategory.SelectedItem.Text + "','" + DropDownCountry.SelectedItem.Text + "','" + DropDownCity.SelectedItem.Text + "','" + TextBoxDays.Text + "'," + TextBoxAmount.Text + ",'" + TextBoxDesc.Text + "')", con);
dt = new DataTable();
da.Fill(dt);
Label1.Text = "Data Submit Successfully";
DropDownCountry.ClearSelection();
DropDownCity.ClearSelection();
DropdownCategory.ClearSelection();
DropDownListType.ClearSelection();
TextBoxDays.Text = "";
TextBoxAmount.Text = "";
TextBoxDesc.Text = "";
da = new SqlDataAdapter("select * from Package_Details order by P_Id desc", con);
dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
GridViewPackageDetails.DataSource = dt;
GridViewPackageDetails.DataBind();
}
else
{
GridViewPackageDetails.DataSource = "";
GridViewPackageDetails.DataBind();
}
}
