protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminEmail"] == null)
{
Response.Redirect("HomePage.aspx");
}
bool pagepost = this.IsPostBack;
if (pagepost == false)
{
clscar obj = new clscar();
String query = "select * from tblcarcat";
try
{
DataSet ds = dbobj.getRecord(query);
//set the data source of the dropdown list box
ddlCarCat.DataSource = ds.Tables[0];
ddlCarCat.DataTextField = "CarCatName";//column name whose value we want to see
ddlCarCat.DataValueField = "CarCatID";
ddlCarCat.DataBind();
ddlCarCat.Items.Insert(0, new ListItem("Select", String.Empty));
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
}
protected void ddlCarCat_SelectedIndexChanged(object sender, EventArgs e)
{
String query = "select Seater from tblcarcat where CarCatID='" + ddlCarCat.Text + "'";
try{
DataSet ds = dbobj.getRecord(query);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
txtSeater.Text = dr["Seater"].ToString();
}
clscar obj = new clscar();
String query1 = "select CarName from tblcar where CarCat='" + ddlCarCat.Text + "'";
DataSet ds1 = dbobj.getRecord(query1);
ddlCarName.DataSource = ds1.Tables[0];
ddlCarName.DataTextField = "CarName";
ddlCarName.DataValueField = "CarName";
ddlCarName.DataBind();
ddlCarName.Items.Insert(0, new ListItem("Select", String.Empty));
txtMinHrs.Text = null;
txtHrlyRate.Text = null;
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void ddlCarCat1_SelectedIndexChanged(object sender, EventArgs e)
{
clscar obj = new clscar();
String query = "select CarNo from tblcar where CarCat='" + ddlCarCat1.Text + "'";
try
{
DataSet ds = dbobj.getRecord(query);
ddlCarNo.DataSource = ds.Tables[0];
ddlCarNo.DataTextField = "CarNo";
ddlCarNo.DataValueField = "CarNo";
ddlCarNo.DataBind();
ddlCarNo.Items.Insert(0, new ListItem("Select", String.Empty));
txtCarNo.Text = null;
txtCarName.Text = null;
ddlCarType.Text = null;
ddlFuelType.Text = null;
txtDescription.Text = null;
txtHrlyRate.Text = null;
txtMinHrs.Text = null;
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
protected void ddlCarNo_SelectedIndexChanged(object sender, EventArgs e)
{
clscar objreg = new clscar();
try
{
objreg.CarNo = ddlCarNo.SelectedItem.Value;
DataSet ds = objreg.GetDetailsbyCarNo();
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
txtCarNo.Text = dr["CarNo"].ToString();
txtCarName.Text = dr["CarName"].ToString();
ddlCarType.SelectedValue = dr["CarType"].ToString();
ddlFuelType.SelectedValue = dr["FuelType"].ToString();
txtDescription.Text = dr["Description"].ToString();
txtHrlyRate.Text = dr["HrlyRate"].ToString();
txtMinHrs.Text = dr["MinHrs"].ToString();
String Imagefilename = dr["CarImage"].ToString();
Image2.ImageUrl = "Upload/" + Imagefilename;
}
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
private void populateGridview()
{
clscar obj = new clscar();
try
{
obj.CarNo = Session["CarNo"].ToString();
DataSet ds = obj.GetDetailsbyCarNo();
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
private void populateGridview()
{
clscar objreg = new clscar();
try
{
DataSet ds = objreg.GetDetails();
// set the datasourec of the Gridview to
//dataset table
GridView1.DataSource = ds.Tables[0];
//call the databind method
GridView1.DataBind();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}
