public EquipmentDTO GetEquipment(int equipmentId)
{
try
{
//Requires.NotNegative("equipmentId", equipmentId);
log.Debug("equipmentId: " + equipmentId + " ");
// get
R_Equipment t = Repository.GetEquipment(equipmentId);
EquipmentDTO dto = new EquipmentDTO(t);
log.Debug(EquipmentDTO.FormatEquipmentDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public int AddEquipment(EquipmentDTO dto)
{
int id = 0;
try
{
log.Debug(EquipmentDTO.FormatEquipmentDTO(dto));
R_Equipment t = EquipmentDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddEquipment(t);
dto.EquipmentId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public void GetEquipments_Success_Test()
{
// Arrange
R_Equipment equipment = SampleEquipment(1);
IList <R_Equipment> list = new List <R_Equipment>();
list.Add(equipment);
// create mock for repository
var mock = new Mock <IEquipmentRepository>();
mock.Setup(s => s.GetEquipments()).Returns(list);
// service
EquipmentService equipmentService = new EquipmentService();
EquipmentService.Repository = mock.Object;
// Act
var resultList = equipmentService.GetEquipments();
EquipmentDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.EquipmentId);
}
public void UpdateEquipment(R_Equipment t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "EquipmentId");
t.Update();
}
public IEnumerable <R_Equipment> GetEquipmentListAdvancedSearch(
string name
, string description
, string category
, int?photo
, double?quantityInStock
, double?minimumQuantityNeeded
, double?pricePerUnit
, string storageLocation
, bool?active
)
{
IEnumerable <R_Equipment> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Equipment")
.Where("IsDeleted = 0"
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (description != null ? " and Description like '%" + description + "%'" : "")
+ (category != null ? " and Category like '%" + category + "%'" : "")
+ (photo != null ? " and Photo like '%" + photo + "%'" : "")
+ (quantityInStock != null ? " and QuantityInStock like '%" + quantityInStock + "%'" : "")
+ (minimumQuantityNeeded != null ? " and MinimumQuantityNeeded like '%" + minimumQuantityNeeded + "%'" : "")
+ (pricePerUnit != null ? " and PricePerUnit like '%" + pricePerUnit + "%'" : "")
+ (storageLocation != null ? " and StorageLocation like '%" + storageLocation + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_Equipment.Query(sql);
return(results);
}
public R_Equipment GetEquipment(int equipmentId)
{
//Requires.NotNegative("equipmentId", equipmentId);
R_Equipment t = R_Equipment.SingleOrDefault(equipmentId);
return(t);
}
public IEnumerable <R_Equipment> GetEquipments()
{
IEnumerable <R_Equipment> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Equipment")
.Where("IsDeleted = 0")
;
results = R_Equipment.Query(sql);
return(results);
}
public EquipmentDTO(R_Equipment equipment)
{
EquipmentId = equipment.EquipmentId;
Name = equipment.Name;
Description = equipment.Description;
Category = equipment.Category;
Photo = equipment.Photo;
QuantityInStock = equipment.QuantityInStock;
MinimumQuantityNeeded = equipment.MinimumQuantityNeeded;
PricePerUnit = equipment.PricePerUnit;
StorageLocation = equipment.StorageLocation;
Active = equipment.Active;
IsDeleted = equipment.IsDeleted;
CreateBy = equipment.CreateBy;
CreateOn = equipment.CreateOn;
UpdateBy = equipment.UpdateBy;
UpdateOn = equipment.UpdateOn;
}
public IList <R_Equipment> GetEquipments(string searchTerm, int pageIndex, int pageSize)
{
IList <R_Equipment> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Equipment")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
+ " or " + "Category like '%" + searchTerm + "%'"
+ " or " + "StorageLocation like '%" + searchTerm + "%'"
)
;
results = R_Equipment.Fetch(pageIndex, pageSize, sql);
return(results);
}
public void DeleteEquipment(EquipmentDTO dto)
{
try
{
log.Debug(EquipmentDTO.FormatEquipmentDTO(dto));
R_Equipment t = EquipmentDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteEquipment(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public static R_Equipment ConvertDTOtoEntity(EquipmentDTO dto)
{
R_Equipment equipment = new R_Equipment();
equipment.EquipmentId = dto.EquipmentId;
equipment.Name = dto.Name;
equipment.Description = dto.Description;
equipment.Category = dto.Category;
equipment.Photo = dto.Photo;
equipment.QuantityInStock = dto.QuantityInStock;
equipment.MinimumQuantityNeeded = dto.MinimumQuantityNeeded;
equipment.PricePerUnit = dto.PricePerUnit;
equipment.StorageLocation = dto.StorageLocation;
equipment.Active = dto.Active;
equipment.IsDeleted = dto.IsDeleted;
equipment.CreateBy = dto.CreateBy;
equipment.CreateOn = dto.CreateOn;
equipment.UpdateBy = dto.UpdateBy;
equipment.UpdateOn = dto.UpdateOn;
return(equipment);
}
public void GetEquipment_Success_Test()
{
// Arrange
int id = 1;
R_Equipment equipment = SampleEquipment(id);
// create mock for repository
var mock = new Mock <IEquipmentRepository>();
mock.Setup(s => s.GetEquipment(Moq.It.IsAny <int>())).Returns(equipment);
// service
EquipmentService equipmentService = new EquipmentService();
EquipmentService.Repository = mock.Object;
// Act
EquipmentDTO result = equipmentService.GetEquipment(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.EquipmentId);
}
// example data
public static R_Equipment SampleEquipment(int id = 1)
{
R_Equipment equipment = new R_Equipment();
// int
equipment.EquipmentId = id;
// string
equipment.Name = "NameTestValue";
// string
equipment.Description = "DescriptionTestValue";
// string
equipment.Category = "CategoryTestValue";
// int?
equipment.Photo = 1;
// double?
equipment.QuantityInStock = 1;
// double?
equipment.MinimumQuantityNeeded = 1;
// double?
equipment.PricePerUnit = 1;
// string
equipment.StorageLocation = "StorageLocationTestValue";
// bool
equipment.Active = false;
// bool
equipment.IsDeleted = false;
// int?
equipment.CreateBy = 1;
// System.DateTime?
equipment.CreateOn = new System.DateTime();
// int?
equipment.UpdateBy = 1;
// System.DateTime?
equipment.UpdateOn = new System.DateTime();
return(equipment);
}
public void UpdateEquipment(EquipmentDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "EquipmentId");
log.Debug(EquipmentDTO.FormatEquipmentDTO(dto));
R_Equipment t = EquipmentDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateEquipment(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public void DeleteEquipment(R_Equipment t)
{
t.IsDeleted = true;
t.Update();
}
public int AddEquipment(R_Equipment t)
{
int id = (int)t.Insert();
return(id);
}
