public IEnumerable <ParkingSlotsBO> GetAll()
{
using (IDbConnection connection = DBConfig.GetConnection())
{
connection.Open();
List <ParkingSlotsBO> parkingSlots = null;
String sql = "GetAllParkingSlots";
try
{
using (IDbCommand command = DBConfig.Command(connection, sql, CommandType.StoredProcedure))
{
using (IDataReader reader = command.ExecuteReader())
{
parkingSlots = new List <ParkingSlotsBO>();
while (reader.Read())
{
parkingSlots.Add(ToObject(reader));
}
}
return(parkingSlots);
}
}
catch (Exception ex)
{
throw;
}
}
}
public bool Add(FloorBO model)
{
try
{
using (IDbConnection connection = DBConfig.GetConnection())
{
connection.Open();
String sql = "Add_Floor";
using (IDbCommand command = DBConfig.Command(connection, sql, CommandType.StoredProcedure))
{
DAO.AddParameter(command, "block_code", model.Block_Code);
DAO.AddParameter(command, "floor_code", model.Floor_Code);
DAO.AddParameter(command, "is_Floor_Full", model.is_Floor_Full);
DAO.AddParameter(command, "is_Reserved", model.is_Reserved);
DAO.AddParameter(command, "number_of_slots", model.Number_of_slots);
var result = command.ExecuteNonQuery();
return(result >= 0);
}
}
}
catch (Exception e)
{
return(false);
}
}
public IEnumerable <BlockBO> GetAll()
{
using (IDbConnection connection = DBConfig.GetConnection())
{
connection.Open();
List <BlockBO> blocks = null;
String sql = "GetAllBlocks";
using (IDbCommand command = DBConfig.Command(connection, sql, CommandType.StoredProcedure))
{
using (IDataReader reader = command.ExecuteReader())
{
blocks = new List <BlockBO>();
while (reader.Read())
{
blocks.Add(ToObject(reader));
}
}
return(blocks);
}
}
}
public bool Add(ReservationBO model)
{
try
{
using (IDbConnection connection = DBConfig.GetConnection())
{
String sql = "dbo.usp_Employee_Insert";
using (IDbCommand command = DBConfig.Command(connection, sql, CommandType.StoredProcedure))
{
DAO.AddParameter(command, "vehicle_number", model.vehicle_number);
DAO.AddParameter(command, "reservation_date", model.reservation_date);
DAO.AddParameter(command, "parking_slot_code", model.SlotCode);
var result = command.ExecuteNonQuery();
return(result >= 0);
}
}
}
catch (Exception e)
{
return(false);
}
}
public bool Add(ParkingSlotsBO model)
{
try
{
using (IDbConnection connection = DBConfig.GetConnection())
{
connection.Open();
String sql = "Add_ParkingSlot";
using (IDbCommand command = DBConfig.Command(connection, sql, CommandType.StoredProcedure))
{
DAO.AddParameter(command, "slot_code", model.SlotCode);
DAO.AddParameter(command, "floor_code", model.FloorCode);
DAO.AddParameter(command, "is_reserved", model.is_reserved);
var result = command.ExecuteNonQuery();
return(result >= 0);
}
}
}
catch (Exception e)
{
return(false);
}
}
public bool Add(BlockBO model)
{
try
{
using (IDbConnection connection = DBConfig.GetConnection())
{
String sql = "dbo.usp_Employee_Insert";
using (IDbCommand command = DBConfig.Command(connection, sql, CommandType.StoredProcedure))
{
// DAO = Data Access Object
DAO.AddParameter(command, "number_of_floors", model.Number_of_floors);
DAO.AddParameter(command, "block_code", model.BlockCode);
DAO.AddParameter(command, "is_block_full", model.is_Block_full);
var result = command.ExecuteNonQuery();
return(result >= 0);
}
}
}
catch (Exception e)
{
return(false);
}
}
