public ActionResult getRecentActivity(int cid)
{
using (MainContext db = new MainContext())
{
var recentOrders =
(
from ro in db.Orders
where (ro.CustomerId == cid)
select ro
).ToList();
var cpObject = new CustomerProfileVM();
foreach (var item in recentOrders)
{
var order = new ViewModels.CustomerOrder();
order.OrderId = item.OrderId;
order.CustomerId = item.CustomerId;
cpObject.recentActivity.Add(order);
cpObject.CustomerProfileVMId = cid;
db.SaveChanges();
}
return(Redirect("/CustomerProfile/" + cid));
//var data = db.Orders.Where(e => e.CustomerId == cid);
//return Json(data, JsonRequestBehavior.AllowGet);
}
}
public void postProfile(string id, CustomerProfileVM vm)
{
CustomerInfo CustInfo = _db.Users.Where(u => u.Id == id).FirstOrDefault().CustomerInfo;
if (CustInfo != null)
{
if (vm.FirstName != null)
{
CustInfo.FirstName = vm.FirstName;
}
if (vm.LastName != null)
{
CustInfo.LastName = vm.LastName;
}
if (vm.ImageUrl != null)
{
CustInfo.ImageUrl = vm.ImageUrl;
}
if (vm.Gender != null)
{
CustInfo.Gender = vm.Gender;
}
}
_db.SaveChanges();
}
public IHttpActionResult PostProfile(CustomerProfileVM vm)
{
var userId = User.Identity.GetUserId();
if (_unit.User.IsSeat(userId) || _unit.User.IsCustomer(userId))
{
_unit.Customer.postProfile(userId, vm);
return(Ok());
}
return(Unauthorized());
}
public CustomerProfileVM ReadCustomerProfile(int customerId)
{
CustomerProfileVM _customerProfile = new CustomerProfileVM();
using (var conn = GetOpenConnection())
{
_customerProfile = conn.Query <CustomerProfileVM>(" SELECT * FROM Customer WHERE Id = @Id ",
new
{
Id = customerId
}).SingleOrDefault();
}
return(_customerProfile);
}
public CustomerProfileVM getCustomerProfile(string id)
{
CustomerProfileVM vm = _db.Users
.Where(c => c.Id == id)
.Select(c => new CustomerProfileVM
{
FirstName = c.CustomerInfo.FirstName,
LastName = c.CustomerInfo.LastName,
ImageUrl = c.CustomerInfo.ImageUrl,
Gender = c.CustomerInfo.Gender,
Email = c.Email,
Birthday = c.CustomerInfo.Birthday
}).FirstOrDefault();
return(vm);
}
// GET: Customer/Details/5
public ActionResult CustomerProfile(int id)
{
using (MainContext db = new MainContext())
{
CustomerProfileVM selectedCustomer = new CustomerProfileVM();
//search for the customer where customerId equals id
var customer = db.Customers.Find(id);
//instantiate a new viewmodel for Customer profile page
//Bind the csutomer attribute values to the ViewModel
selectedCustomer.CustomerVM = customer;
var recentOrders =
(
from ro in db.Orders
where (ro.CustomerId == id)
select ro
).ToList();
var orderCount = 0;
selectedCustomer.CustomerProfileVMId = id;
foreach (var item in recentOrders)
{
selectedCustomer.CustomerVM.CustomerId = item.CustomerId;
var order = new ViewModels.CustomerOrder();
order.OrderId = item.OrderId;
order.CustomerId = item.CustomerId;
order.OrderTotal = item.TotalAmount;
//add to orderCount
orderCount += 1;
//Populate recent activity model.
selectedCustomer.recentActivity.Add(order);
}
//Determine Customer Rating
int ocSwitch = 0;
if (orderCount == 0)
{
ocSwitch = 0;
}
else if (orderCount > 0 && orderCount < 2)
{
ocSwitch = 1;
}
else if (orderCount > 2 && orderCount < 3)
{
ocSwitch = 2;
}
else if (orderCount > 3 && orderCount < 4)
{
ocSwitch = 3;
}
else if (orderCount > 4 && orderCount < 5)
{
ocSwitch = 4;
}
else if (orderCount > 5)
{
ocSwitch = 5;
}
switch (ocSwitch)
{
case 1: selectedCustomer.rating = 1;
break;
case 2:
selectedCustomer.rating = 2;
break;
case 3:
selectedCustomer.rating = 3;
break;
case 4:
selectedCustomer.rating = 4;
break;
case 5:
selectedCustomer.rating = 5;
break;
default:
break;
}
return(View(selectedCustomer));
}
}
