public IHttpActionResult UpdateVehicleDailyLogbook(VehicleDailyLogbookModel vehDLB)
{
try
{
object op = null;
// calls the procedure proVDLBEntry to insert the vehicle log details
dbobj.ExecProc(Servo_API.App_Start.DbOperations_LATEST.OprType.Insert, "proVDLBUpdate", ref op, "@VDLB_ID", vehDLB.VDLB_ID, "@vehicle_no", vehDLB.Vehicle_no, "@DOE", vehDLB.DOE, "@Meter_Reading_Pre", vehDLB.Meter_reading_pre, "@Meter_Reading_Cur", vehDLB.Meter_reading_cur, "@vehicle_route", vehDLB.Vehicle_route, "@Fuel_Used", vehDLB.Fuel_Used, "@Fuel_Used_Qty", vehDLB.Fuel_Used_Qty, "@Engine_Oil", vehDLB.EngineOil, "@Engine_pack", vehDLB.Engine_Oil_Pack, "@Engine_Oil_Qty", vehDLB.Engine_Oil_Qty, "@Gear_Oil", vehDLB.Gear_Oil, "@Gear_pack", vehDLB.Gear_Oil_Pack, "@Gear_Oil_Qty", vehDLB.Gear_Oil_Qty, "@Grease", vehDLB.Grease, "@Grease_pack", vehDLB.Grease_Pack, "@Grease_Qty", vehDLB.Grease_Qty,
"@Brake_Oil", vehDLB.Brake_Oil, "@Brake_pack", vehDLB.Brake_Oil_Pack, "@Brake_Oil_Qty", vehDLB.Brake_Oil_Qty, "@Coolent", vehDLB.Coolent, "@Coolent_Pack", vehDLB.Coolent_Oil_Pack, "@Coolent_Qty", vehDLB.Coolent_Oil_Qty, "@Trans_Oil", vehDLB.Trans_Oil, "@Trans_pack", vehDLB.Trans_Oil_Pack, "@Trans_Oil_Qty", vehDLB.Trans_Oil_Qty, "@Toll", vehDLB.Toll, "@Police", vehDLB.Police, "@Food", vehDLB.Food, "@Misc", vehDLB.Misc);
return(Ok(true));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.NotFound, "Vehicle Logbbok ID could not update data"));
}
}
public IHttpActionResult GetDropVehicleID_SelectedData(string VehicleID)
{
VehicleDailyLogbookModel vehDLB = new VehicleDailyLogbookModel();
try
{
SqlDataReader SqlDtr = null;
SqlDataReader SqlDtr1 = null;
dbobj.SelectQuery("select v.*,(ve.vehicle_no+' VID '+cast(ve.vehicledetail_id as varchar)) as v_no,ve.vehicle_name,ve.vehicledetail_id from vdlb v,vehicleentry ve where ve.vehicledetail_id = v.vehicle_no and vdlb_id =" + VehicleID, ref SqlDtr);
if (SqlDtr.Read())
{
string emp_name = "";
dbobj.SelectQuery("Select emp_name from employee where vehicle_id = " + SqlDtr["vehicledetail_id"].ToString().Trim() + " and designation = 'Driver'", ref SqlDtr1);
if (SqlDtr1.HasRows)
{
if (SqlDtr1.Read())
{
emp_name = SqlDtr1.GetValue(0).ToString().Trim();
}
}
SqlDtr1.Close();
vehDLB.Vehicle_no = SqlDtr["v_no"].ToString().Trim();
// DropVehicleNo.SelectedIndex = DropVehicleNo.Items.IndexOf(DropVehicleNo.Items.FindByText(vehicle_no));
vehDLB.Vehicle_Name = SqlDtr["vehicle_name"].ToString().Trim();
vehDLB.DOE = SqlDtr["DOE"].ToString().Trim();
vehDLB.DriverName = emp_name;
vehDLB.Meter_reading_pre = SqlDtr["meter_reading_pre"].ToString().Trim();
vehDLB.Meter_reading_cur = SqlDtr["meter_reading_cur"].ToString().Trim();
dbobj.SelectQuery("Select route_name From route where route_id =" + SqlDtr["vehicle_route"].ToString().Trim(), ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.Vehicle_route = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Fuel_Used = SqlDtr["Fuel_Used"].ToString().Trim();
vehDLB.Fuel_Used_Qty = SqlDtr["Fuel_Used_Qty"].ToString().Trim();
dbobj.SelectQuery("Select prod_name+':'+pack_type from products where prod_id =" + SqlDtr["Engine_Oil"].ToString().Trim() + " and Category like 'Engine Oil%'", ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.EngineOil = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Engine_Oil_Qty = SqlDtr["Engine_Oil_Qty"].ToString().Trim();
dbobj.SelectQuery("Select prod_name+':'+pack_type from products where prod_id =" + SqlDtr["Gear_Oil"].ToString().Trim() + " and Category like 'Gear Oil%'", ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.Gear_Oil = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Gear_Oil_Qty = SqlDtr["Gear_Oil_Qty"].ToString().Trim();
dbobj.SelectQuery("Select prod_name+':'+pack_type from products where prod_id =" + SqlDtr["Grease"].ToString().Trim() + " and Category like 'Grease%'", ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.Grease = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Grease_Qty = SqlDtr["Grease_Qty"].ToString().Trim();
dbobj.SelectQuery("Select prod_name+':'+pack_type from products where prod_id =" + SqlDtr["Brake_Oil"].ToString().Trim() + " and Category like 'Brake Oil%'", ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.Brake_Oil = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Brake_Oil_Qty = SqlDtr["Brake_Oil_Qty"].ToString().Trim();
dbobj.SelectQuery("Select prod_name+':'+pack_type from products where prod_id =" + SqlDtr["Coolent"].ToString().Trim() + " and Category like 'Collents%'", ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.Coolent = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Coolent_Oil_Qty = SqlDtr["Coolent_Qty"].ToString().Trim();
dbobj.SelectQuery("Select prod_name+':'+pack_type from products where prod_id =" + SqlDtr["Trans_Oil"].ToString().Trim() + " and Category like 'Transmission Oil%'", ref SqlDtr1);
if (SqlDtr1.Read())
{
vehDLB.Trans_Oil = SqlDtr1.GetValue(0).ToString().Trim();
}
SqlDtr1.Close();
vehDLB.Trans_Oil_Qty = SqlDtr["Trans_Oil_Qty"].ToString().Trim();
vehDLB.Toll = SqlDtr["Toll"].ToString().Trim();
vehDLB.Police = SqlDtr["Police"].ToString().Trim();
vehDLB.Food = SqlDtr["Food"].ToString().Trim();
vehDLB.Misc = SqlDtr["misc"].ToString().Trim();
}
SqlDtr.Close();
if (vehDLB == null)
{
return(Content(HttpStatusCode.NotFound, "Vehicle Logbbok ID Data Not found"));
}
return(Ok(vehDLB));
}
catch
{
return(Content(HttpStatusCode.NotFound, "Vehicle Logbbok ID Data Not found"));
}
}