public IEnumerable <R_FoodTemplate> GetFoodTemplateListAdvancedSearch( string name , string description , string foodCategory , int?calories , System.DateTime?averageExpirationTimeFrom , System.DateTime?averageExpirationTimeTo , bool?liquid , bool?needsRefrigeration , bool?active ) { IEnumerable <R_FoodTemplate> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_FoodTemplate") .Where("IsDeleted = 0" + (name != null ? " and Name like '%" + name + "%'" : "") + (description != null ? " and Description like '%" + description + "%'" : "") + (foodCategory != null ? " and FoodCategory like '%" + foodCategory + "%'" : "") + (calories != null ? " and Calories like '%" + calories + "%'" : "") + (averageExpirationTimeFrom != null ? " and AverageExpirationTime >= '" + averageExpirationTimeFrom.Value.ToShortDateString() + "'" : "") + (averageExpirationTimeTo != null ? " and AverageExpirationTime <= '" + averageExpirationTimeTo.Value.ToShortDateString() + "'" : "") + (liquid != null ? " and Liquid = " + (liquid == true ? "1" : "0") : "") + (needsRefrigeration != null ? " and NeedsRefrigeration = " + (needsRefrigeration == true ? "1" : "0") : "") + (active != null ? " and Active = " + (active == true ? "1" : "0") : "") ) ; results = R_FoodTemplate.Query(sql); return(results); }
public void UpdateFoodTemplate(R_FoodTemplate t) { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "FoodTemplateId"); t.Update(); }
// example data public static R_FoodTemplate SampleFoodTemplate(int id = 1) { R_FoodTemplate foodTemplate = new R_FoodTemplate(); // int foodTemplate.FoodTemplateId = id; // string foodTemplate.Name = "NameTestValue"; // string foodTemplate.Description = "DescriptionTestValue"; // string foodTemplate.FoodCategory = "FoodCategoryTestValue"; // int? foodTemplate.Calories = 1; // System.DateTime? foodTemplate.AverageExpirationTime = new System.DateTime(); // bool foodTemplate.Liquid = false; // bool foodTemplate.NeedsRefrigeration = false; // bool foodTemplate.Active = false; // bool foodTemplate.IsDeleted = false; // int? foodTemplate.CreateBy = 1; // System.DateTime? foodTemplate.CreateOn = new System.DateTime(); // int? foodTemplate.UpdateBy = 1; // System.DateTime? foodTemplate.UpdateOn = new System.DateTime(); return(foodTemplate); }
public void GetFoodTemplates_Success_Test() { // Arrange R_FoodTemplate foodTemplate = SampleFoodTemplate(1); IList <R_FoodTemplate> list = new List <R_FoodTemplate>(); list.Add(foodTemplate); // create mock for repository var mock = new Mock <IFoodTemplateRepository>(); mock.Setup(s => s.GetFoodTemplates()).Returns(list); // service FoodTemplateService foodTemplateService = new FoodTemplateService(); FoodTemplateService.Repository = mock.Object; // Act var resultList = foodTemplateService.GetFoodTemplates(); FoodTemplateDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.FoodTemplateId); }
public FoodTemplateDTO GetFoodTemplate(int foodTemplateId) { try { //Requires.NotNegative("foodTemplateId", foodTemplateId); log.Debug("foodTemplateId: " + foodTemplateId + " "); // get R_FoodTemplate t = Repository.GetFoodTemplate(foodTemplateId); FoodTemplateDTO dto = new FoodTemplateDTO(t); log.Debug(FoodTemplateDTO.FormatFoodTemplateDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public int AddFoodTemplate(FoodTemplateDTO dto) { int id = 0; try { log.Debug(FoodTemplateDTO.FormatFoodTemplateDTO(dto)); R_FoodTemplate t = FoodTemplateDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddFoodTemplate(t); dto.FoodTemplateId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public R_FoodTemplate GetFoodTemplate(int foodTemplateId) { //Requires.NotNegative("foodTemplateId", foodTemplateId); R_FoodTemplate t = R_FoodTemplate.SingleOrDefault(foodTemplateId); return(t); }
public IEnumerable <R_FoodTemplate> GetFoodTemplates() { IEnumerable <R_FoodTemplate> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_FoodTemplate") .Where("IsDeleted = 0") ; results = R_FoodTemplate.Query(sql); return(results); }
public FoodTemplateDTO(R_FoodTemplate foodTemplate) { FoodTemplateId = foodTemplate.FoodTemplateId; Name = foodTemplate.Name; Description = foodTemplate.Description; FoodCategory = foodTemplate.FoodCategory; Calories = foodTemplate.Calories; AverageExpirationTime = foodTemplate.AverageExpirationTime; Liquid = foodTemplate.Liquid; NeedsRefrigeration = foodTemplate.NeedsRefrigeration; Active = foodTemplate.Active; IsDeleted = foodTemplate.IsDeleted; CreateBy = foodTemplate.CreateBy; CreateOn = foodTemplate.CreateOn; UpdateBy = foodTemplate.UpdateBy; UpdateOn = foodTemplate.UpdateOn; }
public IList <R_FoodTemplate> GetFoodTemplates(string searchTerm, int pageIndex, int pageSize) { IList <R_FoodTemplate> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_FoodTemplate") .Where("IsDeleted = 0") .Where( "Name like '%" + searchTerm + "%'" + " or " + "Description like '%" + searchTerm + "%'" + " or " + "FoodCategory like '%" + searchTerm + "%'" ) ; results = R_FoodTemplate.Fetch(pageIndex, pageSize, sql); return(results); }
public static R_FoodTemplate ConvertDTOtoEntity(FoodTemplateDTO dto) { R_FoodTemplate foodTemplate = new R_FoodTemplate(); foodTemplate.FoodTemplateId = dto.FoodTemplateId; foodTemplate.Name = dto.Name; foodTemplate.Description = dto.Description; foodTemplate.FoodCategory = dto.FoodCategory; foodTemplate.Calories = dto.Calories; foodTemplate.AverageExpirationTime = dto.AverageExpirationTime; foodTemplate.Liquid = dto.Liquid; foodTemplate.NeedsRefrigeration = dto.NeedsRefrigeration; foodTemplate.Active = dto.Active; foodTemplate.IsDeleted = dto.IsDeleted; foodTemplate.CreateBy = dto.CreateBy; foodTemplate.CreateOn = dto.CreateOn; foodTemplate.UpdateBy = dto.UpdateBy; foodTemplate.UpdateOn = dto.UpdateOn; return(foodTemplate); }
public void DeleteFoodTemplate(FoodTemplateDTO dto) { try { log.Debug(FoodTemplateDTO.FormatFoodTemplateDTO(dto)); R_FoodTemplate t = FoodTemplateDTO.ConvertDTOtoEntity(dto); // delete Repository.DeleteFoodTemplate(t); dto.IsDeleted = t.IsDeleted; log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void GetFoodTemplate_Success_Test() { // Arrange int id = 1; R_FoodTemplate foodTemplate = SampleFoodTemplate(id); // create mock for repository var mock = new Mock <IFoodTemplateRepository>(); mock.Setup(s => s.GetFoodTemplate(Moq.It.IsAny <int>())).Returns(foodTemplate); // service FoodTemplateService foodTemplateService = new FoodTemplateService(); FoodTemplateService.Repository = mock.Object; // Act FoodTemplateDTO result = foodTemplateService.GetFoodTemplate(id); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.FoodTemplateId); }
public void UpdateFoodTemplate(FoodTemplateDTO dto) { try { //Requires.NotNull(t); //Requires.PropertyNotNegative(t, "FoodTemplateId"); log.Debug(FoodTemplateDTO.FormatFoodTemplateDTO(dto)); R_FoodTemplate t = FoodTemplateDTO.ConvertDTOtoEntity(dto); // update Repository.UpdateFoodTemplate(t); log.Debug("result: 'success'"); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
public void DeleteFoodTemplate(R_FoodTemplate t) { t.IsDeleted = true; t.Update(); }
public int AddFoodTemplate(R_FoodTemplate t) { int id = (int)t.Insert(); return(id); }