public static EquipmentEntity DetailEquipment(string Id) { EquipmentEntity equipmentEntity = new Entity.EquipmentEntity(); using (fitnessEntities dbe = new fitnessEntities()) { equipment equipment = dbe.equipments.Where(o => o.equipment_id.Equals(Id)).SingleOrDefault(); equipmentEntity.equipment_id = equipment.equipment_id; equipmentEntity.equipment_name = equipment.equipment_name; equipmentEntity.equipment_quantity = equipment.equipment_quantity; equipmentEntity.equipment_cost = equipment.equipment_cost; equipmentEntity.equipment_photo = equipment.equipment_photo; } return(equipmentEntity); }
public static List <EquipmentEntity> GetEquipments() { List <EquipmentEntity> equipments = new List <Entity.EquipmentEntity>(); using (fitnessEntities dbe = new fitnessEntities()) { EquipmentEntity equipmentEntity; var equipmentList = dbe.equipments.ToList(); foreach (var equipment in equipmentList) { equipmentEntity = new Entity.EquipmentEntity(); equipmentEntity.equipment_id = equipment.equipment_id; equipmentEntity.equipment_name = equipment.equipment_name; equipmentEntity.equipment_quantity = equipment.equipment_quantity; equipmentEntity.equipment_cost = equipment.equipment_cost; equipmentEntity.equipment_photo = equipment.equipment_photo; equipments.Add(equipmentEntity); } } return(equipments); }