public string Assign(AssignVehicleVM assignVehicle)
{
// string fromH = assignVehicle.StartTime;
// string fromHSub = fromH.Substring(0, 2);
// string fromM = assignVehicle.StartTime;
// string fromMSub = fromM.Substring(3, 2);
// int fromMin = Convert.ToInt32(fromHSub) * 60 + Convert.ToInt32(fromMSub);
// if (aTransportGateway.IsVehicleExist(assignVehicle))
// {
// }
// else
// {
// return "Vehicle assigned suucessfully!!";
// }
int rowAffected = aTransportGateway.Assign(assignVehicle);
if (rowAffected > 0)
{
return("Vehicle assigned suucessfully!!");
}
else
{
return("Failed To Assign Vehicle!!");
}
}
public List <AssignVehicleVM> GetSchedule2()
{
Query =
"select a.StartTime,r.StartPlace,r.EndPlace,a.UserType, v.VehicleNo from AssignVehicle a " +
"JOIN Route r ON r.Id= a.RouteId JOIN Vehicle v ON v.Id = a.VehicleId WHERE EndPlace = 'Campus'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <AssignVehicleVM> assignedVehicles = new List <AssignVehicleVM>();
while (Reader.Read())
{
AssignVehicleVM assignVehicle = new AssignVehicleVM()
{
StartTime = Reader["StartTime"].ToString(),
VehicleNo = Reader["VehicleNo"].ToString(),
StartPlace = Reader["StartPlace"].ToString(),
UserType = Reader["UserType"].ToString(),
EndPlace = Reader["EndPlace"].ToString()
};
assignedVehicles.Add(assignVehicle);
}
Reader.Close();
Connection.Close();
return(assignedVehicles);
}
public int Assign(AssignVehicleVM assignVehicle)
{
Query =
"INSERT INTO AssignVehicle(VehicleTypeId,VehicleId,RouteId,StartTime,UserType) VALUES(@vehicleTypeId, @vehicleId, @routeId,@startTime, @userType)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("vehicleTypeId", SqlDbType.Int);
Command.Parameters["vehicleTypeId"].Value = assignVehicle.VehicleTypeId;
Command.Parameters.Add("vehicleId", SqlDbType.Int);
Command.Parameters["vehicleId"].Value = assignVehicle.VehicleId;
Command.Parameters.Add("routeId", SqlDbType.Int);
Command.Parameters["routeId"].Value = assignVehicle.RouteId;
Command.Parameters.Add("startTime", SqlDbType.VarChar);
Command.Parameters["startTime"].Value = assignVehicle.StartTime;
Command.Parameters.Add("userType", SqlDbType.VarChar);
Command.Parameters["userType"].Value = assignVehicle.UserType;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult GeneratePdf(AssignVehicleVM assignVehicle)
{
ViewBag.Schedule = aTransportManager.GetSchedule();
ViewBag.Schedule2 = aTransportManager.GetSchedule2();
return(new ViewAsPdf("GeneratePdf", "Transport")
{
FileName = "Bus Schedule.pdf"
});
}
public ActionResult AssignVehicle(AssignVehicleVM assignVehicle)
{
ViewBag.Routes = GetRoutesForDropdownList();
ViewBag.Message = aTransportManager.Assign(assignVehicle);
ViewBag.Users = GetUserTypeForDropdownList();
ViewBag.VehicleTypes = GetVehicleTypeForDropDownList();
ViewBag.AssignedVehicles = aTransportManager.GetAllAssignedVehicles();
return(View());
}
public bool IsVehicleExist(AssignVehicleVM assignVehicle)
{
Query = "SELECT * From AssignVehicle WHERE VehicleId = @vehicleId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("vehicleId", SqlDbType.VarChar);
Command.Parameters["vehicleId"].Value = assignVehicle.VehicleId;
Connection.Open();
Reader = Command.ExecuteReader();
bool hasRow = false;
if (Reader.HasRows)
{
hasRow = true;
}
Reader.Close();
Connection.Close();
return(hasRow);
}
