public async Task <ActionResult <MessageType> > Put(int id, TypeDTO type) { MessageType typeDb = (MessageType)type; if (typeDb == null) { return(BadRequest()); } using (MailingServiceDbContext serviceDbContext = new MailingServiceDbContext()) { try { var typeDbLast = await serviceDbContext.MessageTypes.FindAsync(id); typeDbLast.MessageTemplate = type.Template; await serviceDbContext.SaveChangesAsync(); return(Ok(typeDbLast)); } catch (Exception ex) { return(BadRequest(ex.Message)); } } }
public void TypesControllerUpdateTest() { var topic = CreateContext(); var typeId = Guid.NewGuid(); var Logic = CreateLogic(); var Controller = new TypesController(Logic); TypeEntity type = new TypeEntity() { Id = typeId, Name = "First Type", Topic = topic, TopicId = topic.Id }; Logic.Create(type); type.Name = "Updated Type"; var result = Controller.Put(typeId, TypeDTO.ToModel(type)); var createdResult = result as CreatedAtRouteResult; var model = createdResult.Value as TypeDTO; Assert.AreEqual("Updated Type", model.Name); }
public void Update(TypeDTO entity) { // Data_Access.Models.Type type = _mapper.Map <Data_Access.Models.Type>(entity); _db.GetTypeRepo.Update(type); _db.Save(); }
public void GetAllTypesCaseErrorInDB() { var types = new List <Type>(); types.Add(oneType); types.Add(anotherType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.GetAll()).Throws( new DataAccessException("Error: could not get Table's elements")); var typeController = new TypeController(typeLogicMock.Object); var typeModels = new List <TypeDTO>(); foreach (Type type in types) { TypeDTO tm = new TypeDTO(type); typeModels.Add(tm); } var result = typeController.Get(); var okResult = result as ObjectResult; var value = okResult.Value; typeLogicMock.VerifyAll(); Assert.AreEqual(value, "Error: could not get Table's elements"); Assert.AreEqual(okResult.StatusCode, 500); }
public List <TypeDTO> getAllType() { using (SqlConnection conn = new SqlConnection("Data Source=DESKTOP-4V6I868\\SQLEXPRESS2008;Initial Catalog=Assignment5;User ID=sa;Password=Iluvumerijan12")) { try { List <TypeDTO> list = new List <TypeDTO>(); conn.Open(); string sql = "SELECT [TypeId] ,[TypeName] FROM[dbo].[Type]"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { TypeDTO ty = new TypeDTO(); ty.typeId = Convert.ToInt32(reader["TypeId"]); ty.typeName = Convert.ToString(reader["TypeName"]); list.Add(ty); } return(list); } catch { return(null); } } }
public void DoMeasure(MethodInfo mi, object instance, TypeDTO typeDto) { Console.Write("Start executing algorithm "); Console.ForegroundColor = ConsoleColor.Green; Console.Write(typeDto.NameAlgorithm); Console.ResetColor(); Console.Write(" from group "); Console.ForegroundColor = ConsoleColor.Green; Console.Write(typeDto.NameTypeAlgotrithms + "\n"); Console.ResetColor(); Stopwatch sw = new Stopwatch(); sw.Start(); object results = mi.Invoke(instance, BindingFlags.InvokeMethod | BindingFlags.Instance | BindingFlags.Public, null, null, CultureInfo.InvariantCulture); sw.Stop(); dynamic convertedResults = Convert.ChangeType(results, typeDto.ReturnedType); Console.Write("Results: "); foreach (var res in convertedResults) { Console.Write(res + "; "); } if (convertedResults.Count == 0) { Console.Write("No Results"); } Console.Write("\nElapsed time of executing algorithm "); Console.ForegroundColor = ConsoleColor.Green; Console.Write(" : " + sw.Elapsed + "\n\n"); Console.ResetColor(); }
public void GetAllTypesCaseNotEmpty() { var types = new List <Type>(); types.Add(oneType); types.Add(anotherType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.GetAll()).Returns(types); var typeController = new TypeController(typeLogicMock.Object); var typeModels = new List <TypeDTO>(); foreach (Type type in types) { TypeDTO tm = new TypeDTO(type); typeModels.Add(tm); } var result = typeController.Get(); var okResult = result as OkObjectResult; var value = okResult.Value as List <TypeDTO>; typeLogicMock.VerifyAll(); for (int i = 0; i < typeModels.Count; i++) { Assert.AreEqual(value[i], typeModels[i]); } }
public async Task <bool> EditAsync(TypeDTO model) { var type = _mapper.Map <Type>(model); _repository.Edit(type); return(await _repository.SaveAsync() > 0 ? true : false); }
public int Add(TypeDTO type) { using (System.Data.IDbConnection connection = Connection.GetConnection()) { string sqlExpression = "Type_Add @name"; return(connection.Query <int>(sqlExpression, type).FirstOrDefault()); } }
public void Update(TypeDTO type) { using (IDbConnection connection = Connection.GetConnection()) { string sqlExpression = "Type_Update"; connection.Execute(sqlExpression, type, commandType: CommandType.StoredProcedure); } }
public IActionResult Post([FromBody] TypeDTO model) { try { var typeResult = Logic.Create(TypeDTO.ToEntity(model)); return(CreatedAtRoute("GetTypes", new { id = typeResult.Id }, TypeDTO.ToModel(typeResult))); } catch (ArgumentException e) { return(BadRequest(e.Message)); } }
public static MethodSignatureDTO FromMethod(MethodInfo method) { return(new MethodSignatureDTO() { DeclaringType = TypeDTO.FromType(method.DeclaringType), MethodName = method.Name, ParameterTypes = method.GetParameters().Select(t => TypeDTO.FromType(t.ParameterType)).ToArray() }); }
public static type TypeToDAL(TypeDTO t) { return(new type() { type_id = t.type_id, type_name = t.type_name, //questions = e.questions.Where(q => q.type_id == tdto.type_id).ToList() }); }
public IActionResult Get(Guid id) { TypeEntity TypeGet = Logic.Get(id); if (TypeGet == null) { return(NotFound()); } return(Ok(TypeDTO.ToModel(TypeGet))); }
public void PostCaseValidType() { var typeDTO = new TypeDTO(oneType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.Create(It.IsAny <Type>())).Returns(oneType); var typeController = new TypeController(typeLogicMock.Object); var result = typeController.Post(typeDTO); var okResult = result as OkObjectResult; var value = okResult.Value; typeLogicMock.VerifyAll(); Assert.AreEqual(typeDTO, value); }
public void GetTypeByIdCaseExist() { var typeDTO = new TypeDTO(oneType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.Get(It.IsAny <Guid>())).Returns(oneType); var typeController = new TypeController(typeLogicMock.Object); var result = typeController.Get(oneType.Id); var okResult = result as OkObjectResult; var value = okResult.Value as TypeDTO; typeLogicMock.VerifyAll(); Assert.AreEqual(typeDTO, value); }
public void PostCaseErrorInDB() { var typeDTO = new TypeDTO(oneType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.Create(It.IsAny <Type>())).Throws( new DataAccessException("Error: Could not add entity to DB")); var typeController = new TypeController(typeLogicMock.Object); var result = typeController.Post(typeDTO); var okResult = result as ObjectResult; var value = okResult.Value; typeLogicMock.VerifyAll(); Assert.AreEqual(value, "Error: Could not add entity to DB"); Assert.AreEqual(okResult.StatusCode, 500); }
public void PostCaseInvalidTypeEmptyFields() { var typeDTO = new TypeDTO(oneType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.Create(It.IsAny <Type>())).Throws( new BusinessLogicException("Error: Type had empty fields")); var typeController = new TypeController(typeLogicMock.Object); var result = typeController.Post(typeDTO); var okResult = result as ObjectResult; var value = okResult.Value; typeLogicMock.VerifyAll(); Assert.AreEqual(value, "Error: Type had empty fields"); Assert.AreEqual(okResult.StatusCode, 400); }
public void PostCaseInvalidTypeAlreadyRegistered() { var typeDTO = new TypeDTO(oneType); var typeLogicMock = new Mock <ITypeLogic>(MockBehavior.Strict); typeLogicMock.Setup(m => m.Create(It.IsAny <Type>())).Throws( new BusinessLogicException("Error: Type with same name associated to this topic already registered")); var typeController = new TypeController(typeLogicMock.Object); var result = typeController.Post(typeDTO); var okResult = result as ObjectResult; var value = okResult.Value; typeLogicMock.VerifyAll(); Assert.AreEqual(value, "Error: Type with same name associated to this topic already registered"); Assert.AreEqual(okResult.StatusCode, 400); }
public void TypeControllerPostTest() { var topic = CreateContext(); var Logic = CreateLogic(); var Controller = new TypesController(Logic); var Type = new TypeEntity { Id = Guid.NewGuid(), Name = "First Type", Topic = topic, TopicId = topic.Id }; var result = Controller.Post(TypeDTO.ToModel(Type)); var createdResult = result as CreatedAtRouteResult; var model = createdResult.Value as TypeDTO; Assert.AreEqual(Type.Name, model.Name); }
public ActionResult Detail(int id) { TypeVM typeViewModel = new TypeVM(); TypeRepository repository = new TypeRepository(); DataOperations dataOperations = new DataOperations(); TypeDTO typeDTO = repository.GetTypeDTOByID(id); typeViewModel.ParentID = typeDTO.ParentID; typeViewModel.ParentName = typeDTO.ParentTypeName; typeViewModel.ID = typeDTO.ID; typeViewModel.Name = typeDTO.Name; typeViewModel.Description = typeDTO.Description; if (typeDTO != null) { typeViewModel.RTypeList = dataOperations.GetTypeByParentId(typeDTO.ID); } return(PartialView(typeViewModel)); }
public List <TypeDTO> removeType(VenueDTO v) { TypeDTO t = new TypeDTO(); t = v.types.Last(); using (var db = new GG.Models.GGModelContainer()) { Venue VenueTbl = new Venue(); var existingType = (from x in db.Types where x.Id == t.id select x).FirstOrDefault(); var existingVenue = (from x in db.Venues where x.Id == v.id select x).FirstOrDefault(); existingVenue.Types.Remove(existingType); db.SaveChanges(); var l = (from x in existingVenue.Types .Select(b => new TypeDTO { id = b.Id, typeText = b.Text }) select x).ToList(); return(l); } }
public async Task <ActionResult <MessageStatus> > Post(TypeDTO type) { MessageType typeDb = (MessageType)type; if (typeDb == null) { return(BadRequest()); } using (MailingServiceDbContext serviceDbContext = new MailingServiceDbContext()) { try { serviceDbContext.MessageTypes.Add(typeDb); await serviceDbContext.SaveChangesAsync(); return(Ok(typeDb)); } catch (Exception ex) { return(BadRequest(ex.Message)); } } }
public TypeDTO GetTypeDTOByID(int typeID) { TypeDTO typeDTO = new TypeDTO(); var query = @"select t1.Name as ParentName,t.ID,t.Name ,t.ParentID,t.Description,t.Code from dbo.[tbl_Type] t left join [tbl_Type] t1 on t.ParentID =t1.ID where t.Status=1 and t.id=@T_TypeId"; using (var connection = new SqlConnection(ConnectionStrings.ConnectionString)) { connection.Open(); using (var command = new SqlCommand(query.ToString(), connection)) { command.Parameters.AddWithValue("@T_TypeId", typeID); var reader = command.ExecuteReader(); while (reader.Read()) { typeDTO.ParentTypeName = reader.GetStringOrEmpty(0); typeDTO.ID = reader.GetInt32OrDefaultValue(1); typeDTO.Name = reader.GetStringOrEmpty(2); typeDTO.ParentID = reader.GetInt32OrDefaultValue(3); typeDTO.Description = reader.GetStringOrEmpty(4); typeDTO.Code = reader.GetStringOrEmpty(5); } } connection.Close(); } return(typeDTO); }
public IHttpActionResult Update(int id, TypeDTO typeDTO) { return(CheckForErrors(typeService.Update(id, typeDTO))); }
public void Add(TypeDTO entity) { Data_Access.Models.Type type = _mapper.Map <TypeDTO, Data_Access.Models.Type>(entity); _db.GetTypeRepo.Add(type); _db.Save(); }
public void TypeUpdate(TypeDTO typeDTO) { var updateType = type.GetAll().SingleOrDefault(c => c.Id == typeDTO.Id); type.Update((mapper.Map <TypeDTO, DAL.Models.Type>(typeDTO, updateType))); }
public int TypeCreate(TypeDTO typeDTO) { var createType = type.Create(mapper.Map <DAL.Models.Type>(typeDTO)); return((int)createType.Id); }
private void ButSave_Click(object sender, EventArgs e) { if (tBName.Text == "") { ShowError("Не все обязательные поля заполнены!"); } else { if (_Product == null) { ProductDTO product = new ProductDTO(); product.Name = tBName.Text.ToString(); product.PsevdoName = tBPsevdoName.Text.ToString(); if (tBNorm.Text != "") { product.Norm = float.Parse(tBNorm.Text); } if (tBSum.Text != "") { product.Sum = float.Parse(tBSum.Text); } if (tBBalance.Text != "") { product.Balance = float.Parse(tBBalance.Text); } if (tBCarbo.Text != "") { product.Carbohydrate = int.Parse(tBCarbo.Text); } if (tBProtein.Text != "") { product.Protein = int.Parse(tBProtein.Text); } if (tBFat.Text != "") { product.Fat = int.Parse(tBFat.Text); } if (tBVitamine.Text != "") { product.Vitamine_C = int.Parse(tBVitamine.Text); } TypeDTO type = MainForm.DB.Types.GetAll().Where(x => x.Name == cBType.SelectedValue.ToString()).First(); product.Type = type; product.TypeId = type.Id; UnitDTO unit = MainForm.DB.Units.GetAll().Where(x => x.Name == cBUnit.SelectedValue.ToString()).First(); product.Unit = unit; product.UnitId = unit.Id; MainForm.DB.Products.Create(product); actions.Add(new ActionDescription("Характеристики продукта: " + product.Name, "Псевдоним: " + product.PsevdoName, "Ед. изм.: " + product.Unit.Name, "Тип: " + product.Type.Name, "Сумма: " + product.Sum.ToString(), "Количество: " + product.Balance.ToString(), "Норма = " + product.Norm.ToString(), "Углеводы: " + product.Carbohydrate.ToString(), "Жиры: " + product.Fat.ToString(), "Белки: " + product.Protein.ToString(), "Витамин С: " + product.Vitamine_C.ToString())); logMessage.Append(product.Name); } else { ProductDTO product = MainForm.DB.Products.Get(_Product.Id); product.Name = tBName.Text.ToString(); product.PsevdoName = tBPsevdoName.Text.ToString(); if (tBNorm.Text != "") { product.Norm = float.Parse(tBNorm.Text); } if (tBCarbo.Text != "") { product.Carbohydrate = int.Parse(tBCarbo.Text); } if (tBProtein.Text != "") { product.Protein = int.Parse(tBProtein.Text); } if (tBSum.Text != "") { product.Sum = float.Parse(tBSum.Text); } if (tBBalance.Text != "") { product.Balance = float.Parse(tBBalance.Text); } if (tBFat.Text != "") { product.Fat = int.Parse(tBFat.Text); } if (tBVitamine.Text != "") { product.Vitamine_C = int.Parse(tBVitamine.Text); } TypeDTO type = MainForm.DB.Types.GetAll().Where(x => x.Name == cBType.SelectedValue.ToString()).First(); product.Type = type; product.TypeId = type.Id; UnitDTO unit = MainForm.DB.Units.GetAll().Where(x => x.Name == cBUnit.SelectedValue.ToString()).First(); product.Unit = unit; product.UnitId = unit.Id; MainForm.DB.Products.Update(product); actions.Add(new ActionDescription("Характеристики продукта: " + product.Name, "Псевдоним: " + product.PsevdoName, "Ед. изм.: " + product.Unit.Name, "Тип: " + product.Type.Name, "Cумма: " + product.Sum.ToString(), "Количество: " + product.Balance.ToString(), "Норма = " + product.Norm.ToString(), "Углеводы: " + product.Carbohydrate.ToString(), "Жиры: " + product.Fat.ToString(), "Белки: " + product.Protein.ToString(), "Витамин С: " + product.Vitamine_C.ToString())); logMessage.Append(product.Name); } MainForm.DB.Save(); MessageBox.Show("Продукт успешно сохранён"); LoggingService.AddLog(logMessage.ToString(), actions.ToArray()); this.Close(); } }
public IHttpActionResult Post(TypeDTO typeDTO) { return(CheckForErrors(typeService.Save(typeDTO))); }