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); }