public CliqueClaimRequestModel AddClaimRequest(CliqueClaimRequestModel model) { CliqueClaimRequest request = null; using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { if (model.Id == 0) { request = new CliqueClaimRequest(); entity.CliqueClaimRequests.Add(request); request.AddedAt = DateTime.Now; } else { request = entity.CliqueClaimRequests.FirstOrDefault(res => res.Id == model.Id); } request.Accomodates = model.Accomodates; request.Address1 = model.Address1; request.Address2 = model.Address2; request.Bedrooms = model.Bedrooms; request.Beds = model.Beds; request.City = model.City; request.Country = model.Country; request.Description = model.Description; request.Locality = model.City; request.Name = model.Name; request.NightPrice = model.NightPrice; request.State = model.State; request.Type = model.Type; request.WeekPrice = model.WeekPrice; request.Zip = model.Zip; request.SSN = model.SSN; request.IsACAvailable = model.IsACAvailable; request.IsBuzzerAvailable = model.IsBuzzerAvailable; request.IsLiftAvailable = model.IsLiftAvailable; request.IsPetsAllowed = model.IsPetsAllowed; request.IsPrivatePoolAvailable = model.IsPrivatePoolAvailable; request.IsWifiAvailable = model.IsWifiAvailable; request.FromDate = model.FromDate; request.ToDate = model.ToDate; request.Price = model.Price; request.Score = model.Score; request.Status = model.Status; request.Latitude = model.Latitude; request.Longitude = model.Longitude; entity.SaveChanges(); model.Id = request.Id; } return model; }
public void UpdateTweetScore(List<TweetModel> modelList) { using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { foreach (var item in modelList) { var existingItem = entity.CliqueTweets.SingleOrDefault(res => res.TweetIdStr == item.TweetIdStr); if(existingItem!= null) { existingItem.Score = item.Score; entity.SaveChanges(); } } } }
public bool UpdateRequestStatus(int status, int requestId) { using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { var response = entity.CliqueClaimRequests.SingleOrDefault(res => res.Id == requestId); response.Status = status; entity.SaveChanges(); } return true; }
public bool IsUserTweetExist(CliqueClaimRequestModel model) { using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { var response = entity.CliqueUserTweets.Where(res => res.RequestId == model.Id); entity.CliqueUserTweets.RemoveRange(response); entity.SaveChanges(); } return false; }
public bool AddEvent(List<EventModel> modelList) { using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { foreach (var item in modelList) { var request = new CliqueEvent { EventId = item.EventId, Name = item.Name, Description = item.Description, StartDate = item.StartDate, EndDate = item.EndDate, Venue = item.Venue, CreatedAt = DateTime.Now, ModifiedAt = DateTime.Now }; var existingItem = entity.CliqueEvents.FirstOrDefault(res => res.EventId == request.EventId); if (existingItem == null) { entity.CliqueEvents.Add(request); entity.SaveChanges(); item.Id = request.Id; } else { item.Id = existingItem.Id; } var mappingRequest = new CliqueLocationEvent { EventId = item.Id, RequestId = item.RequestId, CreatedAt = DateTime.Now, ModifiedAt = DateTime.Now }; entity.CliqueLocationEvents.Add(mappingRequest); entity.SaveChanges(); } } return true; }
public void AddUserFeedback(UserFeedbackModel model) { SemantriaHelper.AddUserFeedbackScore(model); using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { var homeAwayProperty = entity.HomeAwayProperties.First(res => res.Id == model.PropertyId); var request = new HomeAwayFeedback { PropertyId = model.PropertyId, UserEmail = model.UserEmail, UserName = model.UserName, Text = model.Text, AddedAt = DateTime.Now }; entity.HomeAwayFeedbacks.Add(request); //Map feedbackto to claim property var requestId = entity.CliqueClaimRequests.First(res => res.Name == homeAwayProperty.Name && res.Zip == homeAwayProperty.Zip).Id; var claimFeedback = new CliqueClaimRequestFeedback { RequestId = requestId, UserEmail = model.UserEmail, UserName = model.UserName, Text = model.Text, Score = model.Score, AddedAt = DateTime.Now }; entity.CliqueClaimRequestFeedbacks.Add(claimFeedback); entity.SaveChanges(); } }
public UserModel AddUser(UserModel model) { var request = new CliqueUser { MobileNo = model.MobileNo, EmailId = model.EmailId, TwitterUserName = model.TwitterUserName, Name = model.Name, CreatedAt = DateTime.Now, ModifiedAt = DateTime.Now }; using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { entity.CliqueUsers.Add(request); entity.SaveChanges(); } model.Id = request.Id; return model; }
public void AddTweetAndUser(List<TweetModel> modelList) { using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { foreach (var item in modelList) { var request = new CliqueTweet { PostedAt = item.PostedAt, PostedBy = item.PostedBy, Text = item.Text, ProfileImageURL = item.ProfileImageURL, TweetIdStr = item.TweetIdStr, Score = item.Score, AddedAt = DateTime.Now, ModifiedAt = DateTime.Now }; var existingItem = entity.CliqueTweets.SingleOrDefault(res => res.TweetIdStr == request.TweetIdStr); if (existingItem == null) { entity.CliqueTweets.Add(request); entity.SaveChanges(); item.Id = request.Id; } else item.Id = existingItem.Id; var mappingRequest = new CliqueUserTweet { TweetId = item.Id, RequestId = item.RequestId, CreatedAt = DateTime.Now, ModifiedAt = DateTime.Now }; entity.CliqueUserTweets.Add(mappingRequest); entity.SaveChanges(); } } }
public RequestModel AddRequest(RequestModel model) { if (model.LocationId == 0) { var locationModel = AddLocation(new LocationModel { Pincode = model.Pincode, City = model.City }); model.LocationId = locationModel.Id; } if (model.UserId == 0) { var userModel = AddUser(new UserModel { MobileNo = model.MobileNo, EmailId = model.EmailId, Name = model.UserName, TwitterUserName = model.TwitterUserName }); model.UserId = userModel.Id; } var request = new CliqueRequest { Address = model.Address, BuildingName = model.BuildingName, CreatedAt = DateTime.Now, ModifiedAt = DateTime.Now, FromDate = model.FromDate, ToDate = model.ToDate, LocationId = model.LocationId, UserId = model.UserId }; using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { var response = entity.CliqueRequests.Add(request); entity.SaveChanges(); model.Id = response.Id; } return model; }
public bool AddProperty(HomeAwayPropertyModel model) { HomeAwayProperty request = null; using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { if (model.Id == 0) { request = new HomeAwayProperty(); entity.HomeAwayProperties.Add(request); request.AddedAt = DateTime.Now; } else { request = entity.HomeAwayProperties.FirstOrDefault(res => res.Id == model.Id); } request.Accomodates = model.Accomodates; request.Address1 = model.Address1; request.Address2 = model.Address2; request.Bedrooms = model.Bedrooms; request.Beds = model.Beds; request.City = model.City; request.Country = model.Country; request.Description = model.Description; request.Locality = model.City; request.Name = model.Name; request.NightPrice = model.NightPrice; request.State = model.State; request.Type = model.Type; request.WeekPrice = model.WeekPrice; request.Zip = model.Zip; entity.SaveChanges(); } return true; }
public void AddLocationWeather(IList<WeatherModel> result, int requestId) { using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { foreach (var item in result) { var request = new CliqueWeather { CreatedAt = DateTime.Now, Humidity = item.Humidity, MaxTemp = item.MaxTemp, MinTemp = item.MinTemp, ModifiedAt = DateTime.Now, RequestId = requestId, Temp = item.Temp, Weather = item.Weather, WeatherDay = item.WeatherDay, WindDirection = item.WindDirection, WindSpeed = item.WindSpeed }; entity.CliqueWeathers.Add(request); } entity.SaveChanges(); } }
public LocationModel AddLocation(LocationModel model) { var request = new CliqueLocation { Pincode = model.Pincode, City = model.City }; using (ipl_userprofilerEntities entity = new ipl_userprofilerEntities()) { entity.CliqueLocations.Add(request); entity.SaveChanges(); } model.Id = request.Id; return model; }