public ActionResult Create(Int32?Businessid)
{
BusinessReview bs = new BusinessReview();
bs.BusinessID = Businessid;
return(View(bs));
}
public ActionResult Delete(Int32?Businessreviewid)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var BusinessreviewidPara = new SqlParameter("@Businessreviewid", Businessreviewid);
BusinessReview obj_BusinessReview = context.Database.SqlQuery <BusinessReview>("sp_BusinessReview_select @Businessreviewid", BusinessreviewidPara).FirstOrDefault();
obj_BusinessReview.IsDeleted = true;
context.Entry(obj_BusinessReview).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["BusinessReviewSuccess"] = "Record has been deleted successfully.";
return(RedirectToAction("Index", new { Businessid = obj_BusinessReview.BusinessID }));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View());
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// db.delete(Businessreviewid);
// return RedirectToAction("Index");
//}
}
public ActionResult Create(BusinessReview Obj_BusinessReview, string command)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
Obj_BusinessReview.AddedOn = System.DateTime.Now;
Obj_BusinessReview.IsDeleted = false;
context.BusinessReviews.Add(Obj_BusinessReview);
context.SaveChanges();
TempData["BusinessReviewSuccess"] = "Record has been added successfully.";
return(RedirectToAction("Index", new { Businessid = Obj_BusinessReview.BusinessID }));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View(Obj_BusinessReview));
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// db.insert(Obj_BusinessReview);
// return RedirectToAction("Index", new { Businessid = Obj_BusinessReview.Businessid });
//}
}
public ActionResult Edit(Int32?Businessreviewid)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var BusinessreviewidPara = new SqlParameter("@Businessreviewid", Businessreviewid);
BusinessReview Obj_BusinessReview = context.Database.SqlQuery <BusinessReview>("sp_BusinessReview_select @Businessreviewid", BusinessreviewidPara).FirstOrDefault();
return(View(Obj_BusinessReview));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View());
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// BusinessReviewClass obj_BusinessReview = db.selectById(Businessreviewid);
// return View(obj_BusinessReview);
//}
}
public ActionResult Edit(BusinessReview Obj_BusinessReview)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
context.BusinessReviews.Attach(Obj_BusinessReview);
context.Entry(Obj_BusinessReview).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
TempData["BusinessReviewSuccess"] = "Record has been update successfully.";
return(RedirectToAction("Index", new { Businessid = Obj_BusinessReview.BusinessID }));
}
}
catch (Exception ex)
{
if (!ex.Message.Contains("See 'EntityValidationErrors' property"))
{
ViewBag.BusinessReviewError = ex.Message;
}
return(View(Obj_BusinessReview));
}
//using (BusinessReviewCtl db = new BusinessReviewCtl())
//{
// db.update(Obj_BusinessReview);
// return RedirectToAction("Index", new { Businessid = Obj_BusinessReview.Businessid });
//}
}
public ReadReviewDTO(BusinessReview businessReview)
{
this.Id = businessReview.Review.Id;
Text = businessReview.Review.Text;
Grade = businessReview.Review.Grade;
TimeStamp = businessReview.Review.TimeStamp;
UserId = businessReview.User.Id;
UserEmail = businessReview.User.Email;
CarrierId = businessReview.Carrier.Id;
}
public BusinessReviewDTO(BusinessReview businessReview)
{
Id = businessReview.Id;
Title = businessReview.Title;
Comment = businessReview.Comment;
Rating = businessReview.Rating;
CreatedTime = businessReview.CreatedTime;
Comments = businessReview.Comments.ConvertAll(c => new BusinessReviewCommentDTO(c));
Images = businessReview.Images;
}
public ActionResult Create(BusinessReview review)
{
//if this is false something went wrong with model
if (ModelState.IsValid)
{
_db.Reviews.Add(review);
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.BusinessId }));
}
return(View(review));
}
public void AddBusinessReview(WriteReviewViewModel model, string userId)
{
var review = new BusinessReview();
review.Rating = model.Rating;
review.Review = model.Review;
review.SubmittedDate = DateTime.UtcNow;
review.BusinessId = model.BusinessId;
review.UserId = userId;
_database.BusinessReviews.Add(review);
_database.SaveChanges();
}
public ActionResult Edit(BusinessReview review)
{
//if this is false something went wrong with model
if (ModelState.IsValid)
{
//This telle EF thet here is a review that I need you to track so you can make changes in DB
//for review. Its not a new review so don't insert it into
_db.Entry(review).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.BusinessId }));
}
return(View(review));
}
public JsonResult OnGet(string location)
{
if (string.IsNullOrEmpty(location))
{
location = "Cincinnati";
}
string searchBusiness = "https://api.yelp.com/v3/businesses/search?categories=breweries&sort_by=rating&location=";
Task <string> yelpSearch = Http_Get(searchBusiness + location);
var yelpRatingsString = yelpSearch.Result;
YelpRating yelpRating = YelpRating.FromJson(yelpRatingsString);
Yelp.Business[] businesses = yelpRating.Businesses;
List <Yelp.Business> yelpBusinesses = businesses.OfType <Yelp.Business>().ToList();
var businessesWithReviews = new List <Yelp.BusinessWithReview>();
foreach (Yelp.Business business in yelpBusinesses)
{
Task <string> businessSearch = Http_Get("https://api.yelp.com/v3/businesses/" + business.Id + "/reviews");
var businessReviewJsonString = businessSearch.Result;
BusinessReview businessReview = BusinessReview.FromJson(businessReviewJsonString);
businessesWithReviews.Add(new Yelp.BusinessWithReview
{
Id = business.Id,
Alias = business.Alias,
Name = business.Name,
ImageUrl = business.ImageUrl,
IsClosed = business.IsClosed,
Url = business.Url,
ReviewCount = business.ReviewCount,
Categories = business.Categories,
Rating = business.Rating,
Coordinates = business.Coordinates,
Transactions = business.Transactions,
Price = business.Price,
Location = business.Location,
Phone = business.Phone,
DisplayPhone = business.DisplayPhone,
Distance = business.Distance,
Reviews = businessReview.Reviews,
Total = businessReview.Total,
PossibleLanguages = businessReview.PossibleLanguages
});
}
return(new JsonResult(businessesWithReviews));
}
public void OnGet(string location)
{
if (string.IsNullOrEmpty(location))
{
location = Constant.DEFAULT_LOCATION;
}
string searchBusiness = "https://api.yelp.com/v3/businesses/search?categories=breweries&sort_by=rating&location=";
Task <string> t = Http_Get(searchBusiness + location);
var yelpRatingsString = t.Result;
YelpRating yelpRating = YelpRating.FromJson(yelpRatingsString);
var yelpBusinesses = yelpRating.Businesses.ToList();
var businessesWithReviews = new List <BusinessWithReview>();
foreach (Business business in yelpBusinesses)
{
Task <string> t2 = Http_Get("https://api.yelp.com/v3/businesses/" + business.Id + "/reviews");
var businessReviewJsonString = t2.Result;
BusinessReview businessReview = BusinessReview.FromJson(businessReviewJsonString);
businessesWithReviews.Add(new BusinessWithReview
{
Id = business.Id,
Alias = business.Alias,
Name = business.Name,
ImageUrl = business.ImageUrl,
IsClosed = business.IsClosed,
Url = business.Url,
ReviewCount = business.ReviewCount,
Categories = business.Categories,
Rating = business.Rating,
Coordinates = business.Coordinates,
Transactions = business.Transactions,
Price = business.Price,
Location = business.Location,
Phone = business.Phone,
DisplayPhone = business.DisplayPhone,
Distance = business.Distance,
Reviews = businessReview.Reviews,
Total = businessReview.Total,
PossibleLanguages = businessReview.PossibleLanguages
});
}
ViewData["BusinessesWithReviews"] = businessesWithReviews;
ViewData["TitleCity"] = location;
}
public ResultStatus Create(BusinessReview review)
{
ResultStatus result = new ResultStatus();
try
{
repo.Add(review);
repo.Save();
}
catch (Exception)
{
result = ResultStatus.Error;
}
return(result);
}
public ActionResult Create(ReviewVM reviewVM, int businessId)
{
BusinessReview review = new BusinessReview()
{
Review = reviewVM.Review,
BusinessId = businessId
};
try
{
reviewManager.Create(review);
return(RedirectToAction("Index", new { businessId = businessId }));
}
catch
{
return(View("Index"));
}
}
public Result <BusinessReview> AddReview(int businessId, BusinessReviewDTO dto)
{
//todo: check has enrolled/attended class
BusinessReview review = new BusinessReview()
{
Comment = dto.Comment, CreatedTime = DateTimeOffset.UtcNow, CreatedById = UserId, BusinessId = businessId
};
review.Images = new List <BusinessReviewImage>();
foreach (BusinessReviewImage image in dto.Images)
{
review.Images.Add(image);
}
// must add after adding images
_businessRepository.AddReview(review);
Result <BusinessReview> res = new Result <BusinessReview>(true, review);
return(res);
}
public void AddReview(BusinessReview review)
{
_ctx.BusinessReviews.Add(review);
_ctx.SaveChanges();
}
public void Update(BusinessReview review)
{
repo.Update(review);
repo.Save();
}
public void Remove(BusinessReview review)
{
repo.Delete(review);
repo.Save();
}
protected override void Seed(MyHobby.Models.MyHobbyContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
DataImporter importer = new DataImporter();
importer.ImportSuburbs(context);
Suburb mk = context.Suburbs.SingleOrDefault(s => s.EnglishName == "Mong Kok");
Suburb cwb = context.Suburbs.SingleOrDefault(s => s.EnglishName == "Causeway Bay");
Suburb tst = context.Suburbs.SingleOrDefault(s => s.EnglishName == "Tsim Sha Tsui");
context.HobbyCategories.AddOrUpdate(
c => c.Id,
new HobbyCategory {
Id = 100, Name = "Arts & Craft"
},
new HobbyCategory {
Id = 200, Name = "Career & Business"
},
new HobbyCategory {
Id = 300, Name = "Dance"
},
new HobbyCategory {
Id = 400, Name = "Fashion & Beauty"
},
new HobbyCategory {
Id = 500, Name = "Food & Drink"
},
new HobbyCategory {
Id = 600, Name = "Music"
},
new HobbyCategory {
Id = 700, Name = "Photography"
},
new HobbyCategory {
Id = 800, Name = "Sports"
},
new HobbyCategory {
Id = 900, Name = "Technology"
}
);
HobbyCategory sports = context.HobbyCategories.Find(800);
HobbyCategory food = context.HobbyCategories.Find(500);
Business tennisAcademy = new Business {
Name = "HK Tennis Academy", Description = "all about tennis", Suburb = mk, Address = "723 Evergreen Terrace", HobbyCategories = new List <HobbyCategory> {
sports
}
};
Business cakeFactory = new Business {
Name = "Cake Factory", Description = "chocolate banana cake", Suburb = cwb, Address = "723 Evergreen Terrace", HobbyCategories = new List <HobbyCategory> {
food
}
};
context.Businesses.AddOrUpdate(
i => i.Name,
tennisAcademy,
cakeFactory
);
User anthony = new User {
Name = "Anthony", Username = "******", Password = "******", CreatedDate = DateTime.UtcNow
};
context.Users.AddOrUpdate(
i => i.Username,
anthony,
new User {
Name = "mario", Username = "******", Password = "******", CreatedDate = DateTime.UtcNow
}
);
BusinessUser staff1 = new BusinessUser {
Business = tennisAcademy, User = anthony, Role = UserRole.Admin, Title = "專業教練"
};
context.BusinessUsers.AddOrUpdate(
bu => new { bu.BusinessId, bu.UserId },
staff1
);
BusinessReview goodCakeReview = new BusinessReview {
Title = "老師很用心", Comment = "非常推介，會再來", Rating = 5, CreatedTime = DateTime.UtcNow, Business = cakeFactory, CreatedBy = anthony
};
BusinessReview badCakeReview = new BusinessReview {
Title = "老師無料到", Comment = "不會再來", Rating = 1, CreatedTime = DateTime.UtcNow, Business = cakeFactory, CreatedBy = anthony
};
context.BusinessReviews.AddOrUpdate(
i => i.Title,
goodCakeReview,
badCakeReview
);
BusinessReviewComment cakeReviewComment = new BusinessReviewComment {
Comment = "thank you for your feedback", CreatedTime = DateTime.UtcNow, BusinessReview = badCakeReview, CreatedBy = anthony
};
context.BusinessReviewComments.AddOrUpdate(
i => i.Id,
cakeReviewComment
);
Course tennisDummy = new Course {
Name = "Tennis for Dummies", Description = "Teach you everything to prepare yourself for wimbledon"
};
if (context.Courses.SingleOrDefault(c => c.Name == tennisDummy.Name) == null)
{
tennisDummy.Business = tennisAcademy;
}
context.Courses.AddOrUpdate(
i => i.Name,
tennisDummy
);
LessonTag tennisTag = new LessonTag()
{
Id = 1, Tag = "Tennis"
};
LessonTag cupcakeTag = new LessonTag()
{
Id = 2, Tag = "cupcake"
};
LessonTag cakeTag = new LessonTag()
{
Id = 3, Tag = "cake"
};
context.LessonTags.AddOrUpdate(
i => i.Tag,
tennisTag,
cupcakeTag,
cakeTag
);
context.Lessons.AddOrUpdate(
i => i.Name,
new Lesson {
Id = 1, Business = tennisAcademy, Suburb = mk, Name = "Cupcakes", Description = "first class in the series", CostNotes = "4 classes, 1hr/class", Instructors = new List <User> {
anthony
}, Course = tennisDummy, Tags = new List <LessonTag> {
cakeTag, cupcakeTag
}
},
new Lesson {
Id = 2, Business = tennisAcademy, Suburb = cwb, Name = "Baking 101", Description = "first class in the series", CostNotes = "4 classes, 1hr/class", Instructors = new List <User> {
anthony
}, Course = tennisDummy, Tags = new List <LessonTag> {
cakeTag
}
}
);
int ii = 1;
for (int i = 0; i < 20; i++)
{
Lesson lesson1 = new Lesson {
Business = tennisAcademy, Suburb = tst, Name = "Tennis " + ii, Address = "Victoria park, Causewaybay", Description = "first class in the series", Instructors = new List <User> {
anthony
}, Course = null, Tags = new List <LessonTag> {
tennisTag
}
};
context.Lessons.Add(lesson1);
Session s1 = new Session {
Lesson = lesson1, Cost = 200, CostNotes = "4 classes, 1hr/class", MaxStudents = 15, StartDate = DateTime.Today, EndDate = DateTime.Today.AddHours(2), Deadline = DateTime.Today
};
context.Sessions.Add(s1);
Session s2 = new Session {
Lesson = lesson1, Cost = 200, CostNotes = "4 classes, 1hr/class", MaxStudents = 15, StartDate = DateTime.Today.AddMonths(1), EndDate = DateTime.Today.AddMonths(1).AddHours(2), Deadline = DateTime.Today, Registrations = new List <Registration> {
new Registration()
{
Student = anthony, RegistrationDate = DateTime.UtcNow
}
}
};
context.Sessions.Add(s2);
ii++;
}
}
