/// <summary> /// Inserts a pickup point /// </summary> /// <param name="MediaModel">Pickup point</param> public virtual void InsertMedia(Domain.Media MediaModel) { if (MediaModel == null) { throw new ArgumentNullException(nameof(MediaModel)); } _MediaModelRepository.Insert(MediaModel); _cacheManager.RemoveByPattern(MediaModel_POINT_PATTERN_KEY); }
// list dealer records public List <EVA_Record> ListVehicleRecordByDealerID(int DealerID, PaginateListRequestModel model)//for other one only id as param { List <EVA_Record> myList = null; DataProvider.ExecuteCmd(GetConnection, "dbo.EVA_Records_Select_By_DealerID" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@DealerID", DealerID); paramCollection.AddWithValue("@CurrentPage", model.CurrentPage); paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage); }, map : delegate(IDataReader reader, short set) { if (set == 0) { EVA_Record p = new EVA_Record(); int startingIndex = 0; //startingOrdinal p.ID = reader.GetSafeInt32(startingIndex++); p.EntityID = reader.GetSafeInt32(startingIndex++); p.WebsiteId = reader.GetSafeInt32(startingIndex++); p.Value = new List <Value>(); p.Pictures = new List <Domain.Media>(); //this line only give a empty []; if (myList == null) { myList = new List <EVA_Record>(); } myList.Add(p); } else if (set == 1) { Value x = new Value(); int startingIndex = 0; //startingOrdinal x.RecordID = reader.GetSafeInt32(startingIndex++); x.AttributeID = reader.GetSafeInt32(startingIndex++); x.ValueString = reader.GetSafeString(startingIndex++); x.ValueInt = reader.GetSafeInt32(startingIndex++); x.ValueDecimal = reader.GetSafeDecimal(startingIndex++); x.ValueText = reader.GetSafeString(startingIndex++); x.ValueGeo = reader.GetSafeDecimal(startingIndex++); x.AttributeSlug = reader.GetSafeString(startingIndex++); x.AttributeName = reader.GetSafeString(startingIndex++); //insert loop here for (int i = 0; i < myList.Count; i++) { if (myList[i].ID == x.RecordID) { myList[i].Value.Add(x); break; } } // within the loop p.Value.Add(x); } else if (set == 2) { Domain.Media w = new Domain.Media(); int startingIndex = 0; //startingOrdinal w.ID = reader.GetSafeInt32(startingIndex++); w.MediaType = reader.GetSafeString(startingIndex++); w.Path = reader.GetSafeString(startingIndex++); w.FileName = reader.GetSafeString(startingIndex++); w.FileType = reader.GetSafeString(startingIndex++); w.Title = reader.GetSafeString(startingIndex++); w.Description = reader.GetSafeString(startingIndex++); w.UserID = reader.GetSafeString(startingIndex++); w.ThumbnailPath = reader.GetSafeString(startingIndex++); w.CreatedDate = reader.GetSafeDateTime(startingIndex++); w.ModifiedDate = reader.GetSafeDateTime(startingIndex++); w.MediaId = reader.GetSafeInt32(startingIndex++); w.RecordId = reader.GetSafeInt32(startingIndex++); w.DealerId = reader.GetSafeInt32(startingIndex++); w.IsCoverPhoto = reader.GetSafeBool(startingIndex++); //insert loop here for (int y = 0; y < myList.Count; y++) { if (myList[y].ID == w.RecordId) { myList[y].Pictures.Add(w); break; } } } } ); return(myList); }