public static AdVM ApprovedToAdsVm(Seller_Approved_book book) { AdVM adVM = new AdVM(); adVM.BookID = book.Book_Id; adVM.UserID = book.Seller_Id; adVM.Description = book.Book.Discription; adVM.SubCatName = book.Book.SubCategory.Name; var b = (from bk in db.Books where bk.Id == book.Book_Id select bk).FirstOrDefault(); var images = (from i in db.Images where i.Book_Id == book.Book_Id select i).FirstOrDefault(); if (book.Approved == "no" || book.Approved == "No") { adVM.Requests = -2; } else { Request request = (from r in db.Requests where r.Book_Id == book.Book_Id && r.Acctepted == "Yes" select r).FirstOrDefault(); if (request == null) { adVM.Requests = (from r in db.Requests where r.Book_Id == book.Book_Id && (r.Acctepted == "Yes" || r.Acctepted == "No") select r).Count(); } else { adVM.Requests = -1; } } adVM.Img_Url = images.Img_URL; adVM.Name = b.Name; adVM.Points = b.Points; adVM.Date_Uploaded = b.Date_Uploaded; adVM.CityName = b.City.Name; return(adVM); }
public IHttpActionResult postbook(AddbooVM addbook) { bool govexsist = false; bool cityexsist = false; int govid; int citid; string GoverStr = addbook.Governate; string cityStr = addbook.Governate; if (addbook != null) { if (addbook.Governate.Contains(" Governorate")) { addbook.Governate = addbook.Governate.Replace(" Governorate", ""); } if (addbook.City.Contains(" Governorate")) { addbook.City = addbook.City.Replace(" Governorate", ""); } if (addbook.City.Contains("Qesm")) { addbook.City = addbook.City.Split(' ').Last(); if (addbook.City == "Asyut") { addbook.City = "Assuit"; } } var govnames = (from i in db.Governates select i.Name).ToList(); foreach (var item in govnames) { if (GoverStr == addbook.Governate) { govexsist = true; } } if (govexsist) { govid = (from i in db.Governates where i.Name == addbook.Governate select i.Id).First(); } else { Governate Gov = new Governate(); Gov.Name = addbook.Governate; db.Governates.Add(Gov); db.SaveChanges(); govid = (from i in db.Governates where i.Name == addbook.Governate select i.Id).First(); } var citynames = (from i in db.Cities select i.Name).ToList(); foreach (var item in citynames) { if (item == addbook.City) { cityexsist = true; } } if (cityexsist) { citid = (from i in db.Cities where i.Name == addbook.City select i.Id).First(); } else { City cit = new City(); cit.Name = addbook.City; cit.Governate_Id = govid; db.Cities.Add(cit); db.SaveChanges(); citid = (from i in db.Cities where i.Name == addbook.City select i.Id).First(); } var subid = (from i in db.SubCategories where i.Name == addbook.SubCatogry select i.Id).First(); Book book = new Book(); book.Name = addbook.BookName; book.Points = addbook.Points; book.Discription = addbook.Discription; book.Date_Uploaded = DateTime.Now; book.City_Id = citid; book.Subcategory_Id = subid; db.Books.Add(book); db.SaveChanges(); var bookid = (from i in db.Books where i.Name == addbook.BookName && i.Points == addbook.Points && i.Discription == addbook.Discription && i.City_Id == citid select i.Id).First(); Seller_Approved_book sab = new Seller_Approved_book(); sab.Book_Id = bookid; sab.Seller_Id = addbook.UserId; sab.Approved = "no"; db.Seller_Approved_book.Add(sab); db.SaveChanges(); foreach (var item in addbook.Img) { if (item != null) { Image im = new Image(); im.Book_Id = bookid; im.Img_URL = item; db.Images.Add(im); db.SaveChanges(); } } } return(Ok(addbook)); }