public List <VehicleTypeMaster> VehicleType_Update(VehicleTypeMaster input)
{
List <VehicleTypeMaster> listArea = new List <VehicleTypeMaster>();
using (MySqlDataReader reader = ExecuteDataReader("VehicleType_InsertUpdateDelete",
CreateParameter("VehicleTypeId_", MySqlDbType.Int32, input.VehicleTypeId),
CreateParameter("VehicleTypeName_", MySqlDbType.VarChar, input.VehicleTypeName),
CreateParameter("ServiceType_", MySqlDbType.VarChar, input.ServiceType),
CreateParameter("Remarks_", MySqlDbType.VarChar, input.Remarks),
CreateParameter("ExtraCapacity_", MySqlDbType.VarChar, input.ExtraCapacity),
CreateParameter("LuggageCapacity_", MySqlDbType.VarChar, input.LuggageCapacity),
CreateParameter("Type_", MySqlDbType.Int32, 2)))
{
while (reader.Read())
{
VehicleTypeMaster obj = new VehicleTypeMaster();
obj.VehicleTypeId = Convert.ToInt32(reader["VehicleTypeId"]);
obj.VehicleTypeName = reader["VehicleTypeName"].ToString();
obj.ServiceType = reader["ServiceType"].ToString();
obj.Remarks = reader["Remarks"].ToString();
obj.ExtraCapacity = reader["ExtraCapacity"].ToString();
obj.LuggageCapacity = reader["LuggageCapacity"].ToString();
listArea.Add(obj);
}
}
return(listArea);
}
public VehicleTypeMaster VehicleType_Retrieve(int id)
{
VehicleTypeMaster obj = new VehicleTypeMaster();
using (MySqlDataReader reader = ExecuteDataReader("VehicleType_Retrieve",
CreateParameter("VehicleTypeId_", MySqlDbType.Int32, id)
))
{
while (reader.Read())
{
obj.VehicleTypeId = Convert.ToInt32(reader["VehicleTypeId"]);
obj.VehicleTypeName = reader["VehicleTypeName"].ToString();
obj.ServiceType = reader["ServiceType"].ToString();
obj.Remarks = reader["Remarks"].ToString();
obj.ExtraCapacity = reader["ExtraCapacity"].ToString();
obj.Capacity = reader["Capacity"].ToString();
obj.LuggageCapacity = reader["LuggageCapacity"].ToString();
}
}
return(obj);
}
public List <VehicleTypeMaster> VehicleType_RetrieveAll()
{
List <VehicleTypeMaster> listArea = new List <VehicleTypeMaster>();
using (MySqlDataReader reader = ExecuteDataReader("VehicleType_Retrieve",
CreateParameter("VehicleTypeId_", MySqlDbType.Int32, -1)
))
{
while (reader.Read())
{
VehicleTypeMaster obj = new VehicleTypeMaster();
obj.VehicleTypeId = Convert.ToInt32(reader["VehicleTypeId"]);
obj.VehicleTypeName = reader["VehicleTypeName"].ToString();
obj.ServiceType = reader["ServiceType"].ToString();
obj.Remarks = reader["Remarks"].ToString();
obj.ExtraCapacity = reader["ExtraCapacity"].ToString();
obj.Capacity = reader["Capacity"].ToString();
obj.LuggageCapacity = reader["LuggageCapacity"].ToString();
listArea.Add(obj);
}
}
return(listArea);
}
public bool SaveVehicleType(VehicleTypeModel model)
{
try
{
if (model != null)
{
VehicleTypeMaster vehicleType = new VehicleTypeMaster();
vehicleType.name = model.name;
vehicleType.IsActive = true;
tRSEntities4.VehicleTypeMasters.Add(vehicleType);
tRSEntities4.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
