void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select Tpid,RatePerSeat from TravelPackage_M", ddltpid, "RatePerSeat", "Tpid", "select");
}
catch
{
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select City_Id,City_Name from City_M", ddlcity, "City_Name", "City_Id", "select");
}
catch
{
}
}
public void fillcombo(string query, DropDownList drpList, string drpTextField, string drpValueField, string selectText)
{
db_conn obj = new db_conn();
DataSet ds = new DataSet();
ds = obj.select(query);
if (ds.Tables[0].Rows.Count > 0)
{
drpList.DataSource = ds.Tables[0];
drpList.DataTextField = drpTextField;
drpList.DataValueField = drpValueField;
drpList.DataBind();
}
}
public void fill_grid(DataSet ds, GridView dg)
{
db_conn obj = new db_conn();
if (ds.Tables[0].Rows.Count > 0)
{
dg.DataSource = ds.Tables[0];
dg.DataBind();
}
else
{
dg.DataSource = null;
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select Package_Id,Package_Name from Package_M", ddlpackageid, "Package_Name", "Package_Id", "select");
gf.fillcombo("select Bus_Id,Bus_Name from Bus_M", ddlbusid, "Bus_Name", "Bus_Id", "select");
gf.fillcombo("select Train_Id,Train_No from Train_M", ddltrainid, "Train_No", "Train_Id", "select");
gf.fillcombo("select Plane_Id,Plane_Name from Plane_M", ddlplaneid, "Plane_Name", "Plane_Id", "select");
gf.fillcombo("select Car_Id,Car_Name from Car_M", ddlcarid, "Car_Name", "Car_Id", "select");
}
catch
{
}
}
// Use this for initialization
void Start()
{
db_conn database = new db_conn();
switch (ut)
{
case usagetype.NewLargestHit:
StartCoroutine(database.setNewLargestHit(playerid, displayname, value));
break;
case usagetype.UpdateLargestHit:
StartCoroutine(database.UpdateLargestHit(playerid, value));
break;
case usagetype.GetTop10LargestHits:
StartCoroutine(database.getTopTenLargestHit());
break;
case usagetype.GetPlayerLargestHit:
StartCoroutine(database.getPlayerLargestHit(playerid));
break;
case usagetype.NewOttomanTime:
StartCoroutine(database.setNewOttomanTime(playerid, displayname, value));
break;
case usagetype.UpdateOttomanTime:
StartCoroutine(database.UpdateOttomanTime(playerid, value));
break;
case usagetype.GetTop10OttomanTime:
StartCoroutine(database.getTopTenOttomanTime());
break;
case usagetype.GetPlayerOttomanTime:
StartCoroutine(database.getPlayerOttomanTme(playerid));
break;
}
}
void binddropdown()
{
try
{
General_Function gf = new General_Function();
db_conn cn = new db_conn();
gf.fillcombo("select Customer_Id,First_Name from Customer_M where email = '" + Session["Email"].ToString() + "'", ddlcustomerid, "First_Name", "Customer_Id", "select");
gf.fillcombo("select Package_Id,Package_Name from Package_M", ddlpackageid, "Package_Name", "Package_Id", "select");
DataSet ds = new DataSet();
ds = cn.select("select * from Package_M where Package_Id='" + ddlpackageid.SelectedValue + "'");
Double amt = Convert.ToDouble(ds.Tables[0].Rows[0]["Price"].ToString());
lblamt.Text = amt.ToString();
// gf.fillcombo("select Tpid,RatePerSeat from TravelPackage_M", ddltpid, "RatePerSeat", "Tpid", "select");
}
catch
{
}
}
