public ActionResult Create(GuitarRatingViewModel viewModel)
{
try
{
//a.Open();
//string g = string.Format("select count(*) from GuitarRatings G");
//SqlCommand y = new SqlCommand(g, a);
//SqlDataAdapter da = new SqlDataAdapter(y);
//da.Fill(dt2);
//string h = string.Format("select FullName from AspNetUsers where Id='{0}'", User.Identity.GetUserId());
//SqlCommand w = new SqlCommand(h, a);
//SqlDataAdapter db = new SqlDataAdapter(w);
//db.Fill(dt1);
//string name = dt1.Rows[0][0].ToString();
//int c = int.Parse(dt2.Rows[0][0].ToString());
// string z = string.Format("insert into dbo.GuitarRatings values('{0}','{1}','{2}','{3}','{4}')", c, viewModel.guitarid, name, viewModel.stars, viewModel.GuitarMess);
// SqlCommand x = new SqlCommand(z, a);
// x.ExecuteNonQuery();
// a.Close();
string use = User.Identity.GetUserId();
var user = _DbContext.Users.Single(c => c.Id == use);
int list = _DbContext.GuitarRating.ToList().Count();
var rate = new GuitarRating
{
//FeedId = list,
CusName = user.FullName,
Stars = viewModel.stars,
GuitarId = viewModel.guitarid,
FeedMes = viewModel.GuitarMess,
};
var expdet = _DbContext.ExpBillDetail.Single(c => c.GuitarId == viewModel.guitarid);
expdet.Feeded = 1;
_DbContext.GuitarRating.Add(rate);
_DbContext.SaveChanges();
return(RedirectToAction("Clist", "Export"));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult Rating(int id)
{
try
{
string use = User.Identity.GetUserId();
var guitar = _DbContext.Guitars.Single(c => c.GuitarId == id);
var user = _DbContext.Users.Single(c => c.Id == use);
//int b = id;
//string z = string.Format("select g.ImageLink1, g.MDL, g.GuitarId from Guitars g where g.GuitarId ='{0}'",b);
//SqlCommand x = new SqlCommand(z, a);
//SqlDataAdapter da = new SqlDataAdapter(x);
//da.Fill(dt1);
var viewModel = new GuitarRatingViewModel()
{
feedId = -1,
guitarid = id,
guitarimg = guitar.ImageLink1,
username = user.FullName,
guitarmdl = guitar.MDL,
heading = "Giving Feed Back"
};
return(View(viewModel));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
//catch
//{
// return RedirectToAction("Index", "Home");
//}
}
public ActionResult Edit(GuitarRatingViewModel viewModel)
{
//try
//{
var rate = _DbContext.GuitarRating.Single(c => c.FeedId == viewModel.feedId);
rate.FeedMes = viewModel.GuitarMess;
rate.Stars = viewModel.stars;
_DbContext.SaveChanges();
//a.Open();
//string z = string.Format("update dbo.GuitarRatings set FeedMes='{0}', Stars='{1}' where FeedId='{2}'", viewModel.GuitarMess, viewModel.stars, viewModel.feedId);
// SqlCommand x = new SqlCommand(z, a);
// x.ExecuteNonQuery();
// a.Close();
return(RedirectToAction("Clist", "Export"));
//}
//catch
//{
// return RedirectToAction("Clist", "Export");
//}
}
public ActionResult Update(int id)
{
//try
//{
//a.Open();
//string g = string.Format("select g.FeedId, g.FeedMes,g.CusName,g.Stars from GuitarRatings G where g.GuitarId='{0}'", id);
//SqlCommand y = new SqlCommand(g, a);
//SqlDataAdapter da = new SqlDataAdapter(y);
//da.Fill(dt2);
//string h = string.Format("select MDL,ImageLink1 from Guitars where GuitarId='{0}'", id);
//SqlCommand w = new SqlCommand(h, a);
//SqlDataAdapter db = new SqlDataAdapter(w);
//db.Fill(dt1);
var feed = _DbContext.GuitarRating.Single(c => c.GuitarId == id);
var guitar = _DbContext.Guitars.Single(c => c.GuitarId == id);
var viewModel = new GuitarRatingViewModel
{
feedId = feed.FeedId,
guitarid = id,
GuitarMess = feed.FeedMes,
stars = feed.Stars,
username = feed.CusName,
guitarimg = guitar.ImageLink1,
guitarmdl = guitar.MDL,
heading = "Update Feedback"
};
return(View("Rating", viewModel));
//}
//catch
//{
// return RedirectToAction("Clist", "Export");
//}
}
