public IHttpActionResult update([FromBody] Advert advert, int id) { int user_id = Users.GetUserId(User); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } // Advert Images Validation var imagesList = advert.images.ToList(); if (imagesList.FindAll(img => !img.deleted).Count > 20) { ExceptionThrow.Throw("Maksimum fotoğraf limitini aştınız.", System.Net.HttpStatusCode.BadRequest); } if (imagesList.FindAll(img => img.is_default && !img.deleted).Count == 0) { ExceptionThrow.Throw("Varsayılan fotoğraf seçin.", System.Net.HttpStatusCode.BadRequest); } if (imagesList.FindAll(img => !img.deleted).Count < 3) { ExceptionThrow.Throw("En az 3 fotoğraf yüklemelisiniz.", System.Net.HttpStatusCode.BadRequest); } if (imagesList.FindAll(img => img.is_default).Count > 1) { ExceptionThrow.Throw("En fazla 1 fotoğraf varsayılan olarak seçilebilir.", System.Net.HttpStatusCode.BadRequest); } if (db.advert.Where(a => a.id == id && a.user_id == user_id).FirstOrDefault() == null) { return(NotFound()); } db.Entry(advert).State = System.Data.Entity.EntityState.Detached; AdvertPossibilities apos = db.advert_possibilities.Where(aposs => aposs.advert_id == id).First(); db.Entry(advert.possibility).State = System.Data.Entity.EntityState.Detached; AdvertProperties ap = db.advert_properties.Where(app => app.advert_id == id).First(); db.Entry(advert.properties).State = System.Data.Entity.EntityState.Detached; db.advert_avaiable_dates.RemoveRange(db.advert_avaiable_dates.Where(ad => ad.advert_id == id)); db.advert_unavaiable_dates.RemoveRange(db.advert_unavaiable_dates.Where(ud => ud.advert_id == id)); //Images imagesList.ForEach(i => { if (i.is_new && !db.advert_images.Any(ai => ai.advert_id == id && ai.image_id == i.id)) { AdvertImages ai = new AdvertImages() { advert_id = id, image_id = i.id, is_default = i.is_default }; db.advert_images.Add(ai); } if (i.is_default) { AdvertImages defaultImage = db.advert_images.Where(img => img.image_id == i.id && img.advert_id == id).FirstOrDefault(); if (defaultImage != null) { db.advert_images.Where(ai => ai.advert_id == id).ToList().ForEach(ai => ai.is_default = false); defaultImage.is_default = true; } } if (i.deleted) { AdvertImages deletedImage = db.advert_images.Where(img => img.image_id == i.id && img.advert_id == id).FirstOrDefault(); if (deletedImage != null) { db.advert_images.Remove(deletedImage); } } }); db.SaveChanges(); using (var dbContext = new DatabaseContext()) { //Advert advert.id = id; advert.user_id = user_id; advert.updated_date = DateTime.Now; advert.state = false; dbContext.Entry(advert).State = System.Data.Entity.EntityState.Modified; dbContext.Entry(advert).Property("score").IsModified = false; dbContext.Entry(advert).Property("views").IsModified = false; dbContext.Entry(advert).Property("user_id").IsModified = false; //Possibilities advert.possibility.advert_id = advert.id; advert.possibility.id = apos.id; advert.possibility.updated_date = DateTime.Now; dbContext.Entry(advert.possibility).State = System.Data.Entity.EntityState.Modified; //Properties advert.properties.advert_id = advert.id; advert.properties.id = ap.id; advert.properties.updated_date = DateTime.Now; dbContext.Entry(advert.properties).State = System.Data.Entity.EntityState.Modified; //Unavaiable Dates if (advert.unavaiable_date != null) { advert.unavaiable_date.ToList().ForEach(i => { i.advert_id = advert.id; dbContext.advert_unavaiable_dates.Add(i); }); } //Avaiable Dates if (advert.available_date != null) { advert.available_date.ToList().ForEach(ad => { for (DateTime date = ad.from_fulldate; date.Date <= ad.to_fulldate.Date; date = date.AddDays(1)) { AdvertAvailableDate avaiableDate = new AdvertAvailableDate() { day = date.Day, month = date.Month, year = date.Year, fulldate = date, uniq = String.Format("{0:MMddyyyy}", ad.from) + String.Format("{0:MMddyyyy}", ad.to), advert_id = advert.id }; dbContext.advert_avaiable_dates.Add(avaiableDate); } }); } dbContext.SaveChanges(); } return(Ok(advert)); }
public IHttpActionResult add([FromBody] Advert advert) { int user_id = Users.GetUserId(User); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } // Advert Images Validation var imagesList = advert.images.ToList(); if (imagesList.FindAll(img => !img.deleted).Count > 20) { ExceptionThrow.Throw("Maksimum fotoğraf limitini aştınız.", System.Net.HttpStatusCode.BadRequest); } if (imagesList.FindAll(img => img.is_default && !img.deleted).Count == 0) { ExceptionThrow.Throw("Varsayılan fotoğraf seçin.", System.Net.HttpStatusCode.BadRequest); } if (imagesList.FindAll(img => !img.deleted).Count < 3) { ExceptionThrow.Throw("En az 3 fotoğraf yüklemelisiniz.", System.Net.HttpStatusCode.BadRequest); } if (imagesList.FindAll(img => img.is_default).Count > 1) { ExceptionThrow.Throw("En fazla 1 fotoğraf varsayılan olarak seçilebilir.", System.Net.HttpStatusCode.BadRequest); } advert.user_id = user_id; advert.score = 0; advert.state = false; advert.views = 0; advert.created_date = DateTime.Now; advert.updated_date = null; db.advert.Add(advert); db.SaveChanges(); List <_AdvertImages> selectedImages = advert.images.ToList().FindAll(i => i.is_default == true); if (selectedImages.Count == 0) { advert.images.ToList()[0].is_default = true; } if (selectedImages.Count > 1) { advert.images.ToList().ForEach(i => i.is_default = false); advert.images.ToList()[0].is_default = true; } // Images advert.images.ToList().ForEach(i => { if (i.is_new) { AdvertImages ai = new AdvertImages() { advert_id = advert.id, image_id = i.id, is_default = i.is_default }; db.advert_images.Add(ai); } }); //Possibility advert.possibility.advert_id = advert.id; db.advert_possibilities.Add(advert.possibility); //Properties advert.properties.advert_id = advert.id; db.advert_properties.Add(advert.properties); //Unavaiable Dates if (advert.unavaiable_date != null) { advert.unavaiable_date.ToList().ForEach(i => { i.advert_id = advert.id; db.advert_unavaiable_dates.Add(i); }); } //Avaiable Dates if (advert.available_date != null) { advert.available_date.ToList().ForEach(ad => { for (DateTime date = ad.from_fulldate; date.Date <= ad.to_fulldate.Date; date = date.AddDays(1)) { AdvertAvailableDate avaiableDate = new AdvertAvailableDate() { day = date.Day, month = date.Month, year = date.Year, fulldate = date, uniq = String.Format("{0:MMddyyyy}", ad.from_fulldate) + String.Format("{0:MMddyyyy}", ad.to_fulldate), advert_id = advert.id }; db.advert_avaiable_dates.Add(avaiableDate); } }); } try { db.SaveChanges(); } catch (System.Exception ex) { ExceptionThrow.Throw(ex); } return(Ok(advert)); }