public void Delete(OrderGridVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
Order order = new Order();
order.dateOfOrder = p.dateOfOrder;
order.order_amount = p.order_amount;
order.order_status = p.order_status;
order.trackingId = p.trackingId;
order.order_ID = p.order_ID;
t.Orders.Attach(order);
t.Orders.Remove(order);
t.SaveChanges();
}
public void updateOrderStatus(OrderGridVM p)
{
MECProjectDBEntities t = new MECProjectDBEntities();
Order d = new Order();
var dd = t.Orders.First(x => x.order_ID == p.order_ID);
var id = Convert.ToInt32(dd.user_ID);
var user = t.Users.Where(x => x.user_ID == id).FirstOrDefault();
int commision = Convert.ToInt32(user.shopkeeper_commission);
int totalAmount = Convert.ToInt32(dd.order_amount);
int shopkeeperAmount = (totalAmount * commision) / 100;
int adminAmout = totalAmount - shopkeeperAmount;
dd.shopkeeper_amount = shopkeeperAmount;
dd.Admin_amount = adminAmout;
dd.order_status = p.order_status;
t.SaveChanges();
}
public List <OrderGridVM> GetOrders(string status, int userId)
{
MECProjectDBEntities t = new MECProjectDBEntities();
List <OrderGridVM> og = new List <OrderGridVM>();
var s = t.sp_GetOrdersGrid(status, userId);
foreach (var item in s)
{
OrderGridVM ogv = new OrderGridVM();
ogv.order_ID = item.order_ID;
ogv.dateOfOrder = Convert.ToDateTime(item.dateOfOrder);
ogv.order_amount = Convert.ToInt32(item.order_amount);
ogv.order_status = item.order_status;
ogv.trackingId = item.trackingId;
ogv.user_name = item.clint_name;
ogv.phone = item.clint_phone;
ogv.address = item.clint_address;
ogv.serviceId = Convert.ToInt32(item.service_ID);
ogv.shopkeeperName = item.user_name;
ogv.shopkeeperId = item.user_ID;
og.Add(ogv);
}
return(og);
}
