public int GetTotalsByCompanyId(int idCompany, CarFleet.Utils.Constants.CARFLEET_ENTITY CARFLEET_ENTITY) { FunctionsEntity entity = _FunctionsCrud.TotalsByCompany(idCompany, CARFLEET_ENTITY); if (entity != null) { object value; int total = 0; if (Utils.Utilities._IsCasteable(entity.result.ToString(), out value, Utils.Constants.DATA_TYPES.INT)) { total = int.Parse(entity.result.ToString()); } return(total); } else { return(0); } }
public FunctionsEntity TotalsByCompany(int companyId, CarFleet.Utils.Constants.CARFLEET_ENTITY CARFLEET_ENTITY) { using (var command = base.GetContextConnection.CreateCommand()) { command.AddParameter("ID_COMPANY_OUT", SqlDbType.Int, companyId); switch (CARFLEET_ENTITY) { case Utils.Constants.CARFLEET_ENTITY.DRIVER: command.CommandText = StoreProcedureConstants.stp_DriverTotalByCompanyId; break; case Utils.Constants.CARFLEET_ENTITY.FLEET: command.CommandText = StoreProcedureConstants.stp_FleetTotalByCompanyId; break; case Utils.Constants.CARFLEET_ENTITY.VEHICLE: command.CommandText = StoreProcedureConstants.stp_VehicleTotalByCompanyId; break; } command.CommandType = CommandType.StoredProcedure; return(ToList(command).FirstOrDefault()); } }