protected void GridView_SelectedIndexChanged(object sender, EventArgs e)
{
RouteId.Visible = true;
RouteName.Visible = true;
VehicleDropDown.Visible = true;
UpdateVehicle.Visible = true;
RouteId.Text = GridView.SelectedRow.Cells[1].Text;
RouteName.Text = GridView.SelectedRow.Cells[3].Text;
using (SqlConnection conn = new SqlConnection(DBstring))
{
String q1 = "SELECT VehicleID,Number from Vehicle where Status = 'Active'";
SqlDataAdapter sda = new SqlDataAdapter(q1, conn);
DataTable dt1 = new DataTable();
sda.Fill(dt1);
if (dt1.Columns.Count != 0)
{
VehicleDropDown.DataSource = dt1;
VehicleDropDown.DataTextField = "Number";
VehicleDropDown.DataValueField = "VehicleID";
VehicleDropDown.DataBind();
ListItem liVehicle = new ListItem("Select Vehicle", "-1");
VehicleDropDown.Items.Insert(0, liVehicle);
}
}
}
List <VehicleDropDown> IVehicleRepository.getAllVehicleByCustomer(string custExID)
{
List <VehicleDropDown> list = new List <VehicleDropDown>();
try
{
var entities = _dbContext.Vehicles.Where(s => (custExID.Equals(s.Customer.ExternalID.ToString()))).ToList();
if (entities != null)
{
foreach (var item in entities)
{
//// TODO: automapper mapping
var config = new MapperConfiguration(cfg => cfg.CreateMap <Models.Vehicle, VehicleDropDown>());
var mapper = new Mapper(config);
VehicleDropDown vehicle = mapper.Map <VehicleDropDown>(item);
list.Add(vehicle);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection(DBstring))
{
String q1 = "SELECT VehicleID,Number from Vehicle where Status = 'Active'";
SqlDataAdapter sda = new SqlDataAdapter(q1, conn);
DataTable dt1 = new DataTable();
sda.Fill(dt1);
if (dt1.Columns.Count != 0)
{
VehicleDropDown.DataSource = dt1;
VehicleDropDown.DataTextField = "Number";
VehicleDropDown.DataValueField = "VehicleID";
VehicleDropDown.DataBind();
ListItem LiVehicle = new ListItem("Select Vehicle", "-1");
VehicleDropDown.Items.Insert(0, LiVehicle);
}
}
using (SqlConnection con = new SqlConnection(DBstring))
{
String q2 = "SELECT DriverID,Name from Driver where Status = 'Active'";
SqlDataAdapter sda = new SqlDataAdapter(q2, con);
DataTable dt2 = new DataTable();
sda.Fill(dt2);
if (dt2.Columns.Count != 0)
{
DriverDropDown.DataSource = dt2;
DriverDropDown.DataTextField = "Name";
DriverDropDown.DataValueField = "DriverID";
DriverDropDown.DataBind();
ListItem LiDriver = new ListItem("Select driver", "-1");
DriverDropDown.Items.Insert(0, LiDriver);
}
}
}
}
