private OfferedService ConvertOfferedService(IOfferedServiceDTO offeredServiceDTO) { return(new OfferedService() { Id = offeredServiceDTO.Id, Name = offeredServiceDTO.Name, Category = _categoryLogic.GetCategoryById(offeredServiceDTO.CategoryId).Name, Price = offeredServiceDTO.Price, ProviderId = offeredServiceDTO.ProviderId, Description = offeredServiceDTO.Description, DeliveryTimeDays = offeredServiceDTO.DeliveryTimeDays, DeliveryTimeHours = offeredServiceDTO.DeliveryTimeHours, DateOfPost = offeredServiceDTO.DateOfPost, AverageRating = CalcAverageRating(offeredServiceDTO.Id), Status = offeredServiceDTO.StatusId, IsDeleted = offeredServiceDTO.IsDeleted }); }
public void Update(IOfferedServiceDTO offeredServiceDTO) { using var connection = MySqlFactory.CreateConnection(); connection.Open(); var cmd = MySqlFactory.CreateCommand("UpdateOfferedService", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@_id", offeredServiceDTO.Id); cmd.Parameters.AddWithValue("@_name", offeredServiceDTO.Name); cmd.Parameters.AddWithValue("@_categoryId", offeredServiceDTO.CategoryId); cmd.Parameters.AddWithValue("@_price", offeredServiceDTO.Price); cmd.Parameters.AddWithValue("@_description", offeredServiceDTO.Description); cmd.Parameters.AddWithValue("@_deliveryTimeDays", offeredServiceDTO.DeliveryTimeDays); cmd.Parameters.AddWithValue("@_deliveryTimeHours", offeredServiceDTO.DeliveryTimeHours); cmd.ExecuteNonQuery(); connection.Close(); }
public void Add(IOfferedServiceDTO offeredServiceDTO) { using var connection = MySqlFactory.CreateConnection(); connection.Open(); var cmd = MySqlFactory.CreateCommand("AddOfferedService", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", offeredServiceDTO.Name); cmd.Parameters.AddWithValue("@categoryId", offeredServiceDTO.CategoryId); cmd.Parameters.AddWithValue("@price", offeredServiceDTO.Price); cmd.Parameters.AddWithValue("@providerId", offeredServiceDTO.ProviderId); cmd.Parameters.AddWithValue("@description", offeredServiceDTO.Description); cmd.Parameters.AddWithValue("@status", offeredServiceDTO.StatusId); cmd.Parameters.AddWithValue("@deliveryTimeDays", offeredServiceDTO.DeliveryTimeDays); cmd.Parameters.AddWithValue("@deliveryTimeHours", offeredServiceDTO.DeliveryTimeHours); cmd.Parameters.AddWithValue("@dateOfPost", offeredServiceDTO.DateOfPost); cmd.Parameters.AddWithValue("@isDeleted", Convert.ToInt16(offeredServiceDTO.IsDeleted)); cmd.ExecuteNonQuery(); connection.Close(); }