public FuelUsageVO GetByID(int id)
{
FuelUsageVO vo = new FuelUsageVO();
DataTable dt = Select("ID=" + id + "");
if (dt.Rows.Count > 0)
{
vo = b.ConvertObj(dt.Rows[0], new FuelUsageVO()) as FuelUsageVO;
}
return(vo);
}
//to select last issued fuel gallons
public FuelUsageVO SelectByVehicleID(string query)
{
FuelUsageVO vo = new FuelUsageVO();
DataTable dt = SelectByQuery(query);
if (dt.Rows.Count > 0)
{
vo = b.ConvertObj(dt.Rows[0], new FuelUsageVO()) as FuelUsageVO;
return(vo);
}
return(vo);
}
public int Insert(FuelUsageVO vo)
{
int lastInsertId = 0;
try
{
lastInsertId = b.Insert("Fuel_Usage_Entry", b.ConvertColName(vo), b.ConvertValueList(vo));
}
catch (SqlException ex)
{
throw ex;
}
return(lastInsertId);
}
public int UpdateInfo_Detail(int infoId, FuelUsageVO vo, List <object> detalVoList, List <String> queryList, List <String> deleteList)
{
int id = 0;
try
{
id = dao.UpdateInfo_Detail(infoId, vo, detalVoList, queryList, deleteList);
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public int Create(FuelUsageVO vo)
{
int id = 0;
if (!dao.isExist(vo.Id.ToString()))
{
id = dao.Insert(vo);
}
else
{
id = dao.Update(vo);
}
return(id);
}
public int Update(FuelUsageVO vo)
{
int ID = 0;
try
{
b.Update("Fuel_Usage_Entry", vo.Id.ToString(), b.ConvertColName(vo), b.ConvertValueList(vo));
ID = vo.Id;
}
catch (SqlException ex)
{
throw ex;
}
return(ID);
}
