public List <OrderUser> GetPersonIdOrderId(int offer_id)
{
UserQuery userQuery = new UserQuery(language);
System.Data.DataTable dataTable = conn_db.ReadTable(userQuery.GetPersonIdOrderId(offer_id));
List <OrderUser> users = new List <OrderUser>();
if (dataTable.Rows.Count == 0)
{
throw new EmptyViewException(language);
}
foreach (System.Data.DataRow row in dataTable.Rows)
{
OrderUser user = new OrderUser();
user.userId = row["user_id"] is DBNull ? 0 : Convert.ToInt32(row["user_id"]);
user.OrderIdentity = row["ORDER_IDENTITY"].ToString();
users.Add(user);
}
return(users);
}
//Thay đổi trạng thái của đơn hàng
public ActionResult Change(int ID)
{
using (var pro = new MobileShopEntities())
{
//cột order.trangthai mặc định bằng 0
//lấy đơn hàng muốn thay đổi và thay đổi thuộc tính trangthai bằng 1
List <Order> list = null;
var order = pro.Orders
.Where(p => p.OrderID == ID)
.FirstOrDefault();
order.trangthai = 1;
pro.Entry(order).State = EntityState.Modified;
pro.SaveChanges();
//lấy dánh sách orderUser và load ra view getAllOrder
List <Order> OrderList = pro.Orders.ToList();
OrderUser OrderUser = new OrderUser();
List <OrderUser> OrderUserList = OrderList.Select(x => new OrderUser {
OrderDate = x.OrderDate, Total = x.Total, Fullname = x.User.FullName, Username = x.User.Username, OrderId = x.OrderID, TrangThai = x.trangthai
}).ToList();
return(PartialView("getAllOrder", OrderUserList));
}
}
public async Task <int> CreateUserAsync(EditUserViewModel user)
{
var newAddress = new Address
{
Street = user.Street,
ZipCode = user.ZipCode,
City = user.City,
Country = user.Country
};
var newUser = new OrderUser()
{
Name = user.Name,
LastName = user.LastName,
PhoneNumber = user.PhoneNumber,
Address = newAddress,
Email = user.Email,
OrderId = user.OrderId,
UserId = user.Id != 0 ? user.Id : 0
};
_context.OrderUsers.Add(newUser);
await _context.SaveChangesAsync();
return(newUser.Id);
}
public List <OrderUser> GetUsers(string name)
{
return(DBHelper.ExecuteDataReader <List <OrderUser> >("select order_operator_id, order_operator_name, order_operator_password from order_operator where order_operator_name = @name", new Parameter[] {
new Parameter()
{
Key = "@name",
Value = name
}
}, (reader) =>
{
var users = new List <OrderUser>();
while (reader.Read())
{
var user = new OrderUser()
{
ID = reader.GetInt64("order_operator_id"),
Name = reader.GetString("order_operator_name"),
Password = reader.GetString("order_operator_password")
};
users.Add(user);
}
return users;
}));
}
public CkUserPop(OrderUser selectproduct)
{
InitializeComponent();
NavigationPage.SetHasNavigationBar(this, false);
BindingContext = selectproduct;
send = selectproduct;
LanguageSwif();
}
public OrderPageTabVM(OrderUser o, string currency)
{
Id = o.OrderId;
if (o.UserProfile != null)
{
User = new UserTabVM(o.UserProfile, o.UserProfile.Sex, o.UserProfile.File);
}
OrderItems = o.Order.OrderItems.Where(m => m.UserId == User.UserProfileId).Select(m => new OrderItemVM(m, currency)).ToList();
}
public PartialViewResult Realize(Order order)
{
if (ModelState.IsValid)
{
var userId = User.Identity.GetUserId();
DateTime now = DateTime.Now;
ICollection <OrderProduct> orderProducts = db.OrderProducts.Where(y => y.ProductOrderStateID == 1).Where(x => x.userID == userId).ToList();
if (orderProducts.Any())
{
Order orderX = db.Orders.Where(y => y.OrderStateID == 1).FirstOrDefault(x => x.UserID == userId);
orderX.Suma = 0;
int orderId = orderX.OrderID;
foreach (var x in orderProducts)
{
x.ProductOrderStateID = 2;
db.Entry(x).State = EntityState.Modified;
orderX.Suma += x.Suma;
OrderProductHistory orderProductHistory = new OrderProductHistory {
Price = x.Product.Price, OrderProductID = x.OrderProductID
};
db.OrderProductHistory.Add(orderProductHistory);
db.SaveChanges();
}
OrderUser orderUser = new OrderUser
{
OrderUserID = order.OrderID,
Email = order.OrderUser.Email ?? orderX.User.Email,
Name = order.OrderUser.Name ?? orderX.User.Name,
Surname = order.OrderUser.Email ?? orderX.User.Surname,
Address = order.OrderUser.Surname ?? orderX.User.Address,
Telephone = order.OrderUser.Telephone ?? orderX.User.Telephone
};
db.OrderUser.Add(orderUser);
db.SaveChanges();
//user.Telephone = order.User.Telephone;
//user.Name = order.User.Name;
//user.Surname = order.User.Surname;
//user.Address = order.User.Address;
//user.Agreement = true;
//db.Entry(user).State = EntityState.Modified;
orderX.OrderUserID = orderX.OrderID;
orderX.OrderStateID = 2;
orderX.IncomingDate = now;
orderX.OrderPaymentID = order.OrderPaymentID;
orderX.OrderSupplyID = order.OrderSupplyID;
db.Entry(orderX).State = EntityState.Modified;
db.SaveChanges();
}
}
ViewBag.OrderPaymentID = new SelectList(db.OrderPayments, "OrderPaymentID", "Name");
ViewBag.OrderSupplyID = new SelectList(db.OrderSupplies, "OrderSupplyID", "Name");
return(PartialView("Modal", db.OrderProducts));
}
public void DeleteUserOrderById(string idUserOrder)
{
//if(Database.orderUsers.Find(idUserOrder) != null &&
// Database.orderUsers.Find(idUserOrder).ApplicationUserId == idUserIdentyti)
//{
OrderUser r = Database.orderUsers.Find(idUserOrder);
Database.orderUsers.Remove(r);
Database.SaveChanges();
//else result = "Что то пошло не так";
}
public async Task <bool> SendEmailMessage(OrderUser userOrder)
{
try
{
//get user info
var userInfo = await IdentityService.UserInfo(userOrder.UserId);
if (userInfo.Success)
{
var nickName = userInfo.Result.NickName;
var email = userInfo.Result.Email;
string subject = string.Empty;
string content = string.Empty;
switch (userOrder.OrderStatus)
{
case OrderStatus.Failed:
subject = "order failed.";
content = "has been failed.";
break;
case OrderStatus.Cancel:
subject = "order cancelled.";
content = "has been cancelled.";
break;
case OrderStatus.Submmit:
subject = "order submmited.";
content = "has been submmited.";
break;
}
//send email
await Email.To(email).Subject(subject)
.Body($"Dear {nickName},order {userOrder.OrderCode} {content}").SendAsync();
return(true);
}
Logger.LogWarning(
$"get user failed when sending email.order info is:{JsonConvert.SerializeObject(userOrder)}");
return(false);
}
catch (Exception e)
{
Logger.LogError(e, "send email failed.");
return(false);
}
}
public async Task Consume(ConsumeContext <UserCreatedEvent> context)
{
_logger.LogInformation($"Processing msg: '{context.MessageId}' with topic: '{context.ConversationId}'.");
var user = new OrderUser
{
Name = context.Message.Name,
Id = context.Message.Id
};
_context.OrderUsers.Add(user);
await _context.SaveChangesAsync();
_logger.LogInformation($"Created user with ID {user.Id} with name: {user.Name}");
}
//lấy danh sách đơn hàng
public ActionResult getAllOrder()
{
using (var pro = new MobileShopEntities())
{
//tiến hành kết bảng order và user
//lấy danh sách order
List <Order> OrderList = pro.Orders.ToList();
//tạo một bảng orderUser gồm các thông tin cần thiết của order và user
OrderUser OrderUser = new OrderUser();
List <OrderUser> OrderUserList = OrderList.Select(x => new OrderUser {
OrderDate = x.OrderDate, Total = x.Total, Fullname = x.User.FullName, Username = x.User.Username, OrderId = x.OrderID, TrangThai = x.trangthai
}).ToList();
return(View(OrderUserList));
}
}
public void UpdateOrderUser(OrderUser item)
{
var r = Database.orderUsers.Find(item.Id);
r.ProductName = item.ProductName;
r.EndAddressCity = item.EndAddressCity;
r.EndAddressRoad = item.EndAddressRoad;
r.EndAddressHouse = item.EndAddressHouse;
r.EndAddressCity = item.EndAddressCity;
r.EndAddressRoad = item.EndAddressRoad;
r.EndAddressHouse = item.EndAddressHouse;
r.StartDate = item.StartDate;
r.DueDate = item.DueDate;
r.Weight = item.Weight;
//Database.Entry(item).State = EntityState.Modified;
Database.SaveChanges();
}
public bool AddOrderUser(OrderUser orderUser)
{
bool isAdd = false;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string commandString = @"INSERT INTO OrderUser(FirstName,LastName,BillType,PurchaseDate)
VALUES('" + orderUser.FirstName + "','" + orderUser.LastName + "','" + orderUser.BillType + "','" + orderUser.PurchaseDate + "')";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
int isExecute = sqlCommand.ExecuteNonQuery();
if (isExecute > 0)
{
isAdd = true;
}
sqlConnection.Close();
return(isAdd);
}
public ActionResult UpdateUserOrder(string id)
{
OrderUser orderUser = UserService.FindOrderUser(id);
CreateUserOrder createUserOrder = new CreateUserOrder();
createUserOrder.StartAddressCity = orderUser.StartAddressCity;
createUserOrder.StartAddressRoad = orderUser.StartAddressRoad;
createUserOrder.StartAddressHouse = orderUser.StartAddressHouse;
createUserOrder.EndAddressCity = orderUser.EndAddressCity;
createUserOrder.EndAddressRoad = orderUser.EndAddressHouse;
createUserOrder.EndAddressHouse = orderUser.EndAddressRoad;
createUserOrder.StartDate = orderUser.StartDate;
createUserOrder.DueDate = orderUser.DueDate;
createUserOrder.ProductName = orderUser.ProductName;
createUserOrder.Weight = orderUser.Weight;
createUserOrder.Id = orderUser.Id;
return(View(createUserOrder));
}
//Insert new Order
public bool InsertOrder(MovieDTO md, UserDTO ud, DateTime?dt)
{
var queryMovie = (from m in _DB.Movies
where m.title == md.Title
select m);
Movie movie = queryMovie.FirstOrDefault();
var queryUser = (from m in _DB.Users
where m.name == ud.Name
select m);
User user = queryUser.First();
Order order = new Order();
order.Movie = movie;
order.endDate = dt;
OrderUser ou = new OrderUser();
ou.User = user;
ou.Order = order;
_DB.Orders.InsertOnSubmit(order);
_DB.OrderUsers.InsertOnSubmit(ou);
try
{
this._DB.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine("Exeption caught " + e.Message);
return(false);
}
}
public bool appointment(long uid, long oid)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
OrderUser ou = new OrderUser();
ou.Uid = uid;
ou.Oid = oid;
ctx.OrderUser.Add(ou);
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public ActionResult UpdateUserOrder(CreateUserOrder createUserOrder)
{
OrderUser orderUser = new OrderUser
{
EndAddressCity = createUserOrder.EndAddressCity,
EndAddressRoad = createUserOrder.EndAddressRoad,
EndAddressHouse = createUserOrder.EndAddressHouse,
ProductName = createUserOrder.ProductName,
StartAddressCity = createUserOrder.StartAddressCity,
StartAddressRoad = createUserOrder.StartAddressRoad,
StartAddressHouse = createUserOrder.StartAddressHouse,
Weight = createUserOrder.Weight,
ApplicationUserId = User.Identity.GetUserId().ToString(),
StartDate = createUserOrder.StartDate,
DueDate = createUserOrder.DueDate,
Status = true,
Id = createUserOrder.Id
};
UserService.UpdateOrderUser(orderUser);
return(RedirectToAction("index", "Home"));
}
public ActionResult CreateUserOrder(CreateUserOrder createUserOrder)
{
if (ModelState.IsValid)
{
string idDriver;
if (TempData["ID"] != null)
{
idDriver = TempData["ID"].ToString();
TempData["ID"] = null;
}
else
{
idDriver = null;
}
OrderUser orderUser = new OrderUser
{
EndAddressCity = createUserOrder.EndAddressCity,
EndAddressRoad = createUserOrder.EndAddressRoad,
EndAddressHouse = createUserOrder.EndAddressHouse,
ProductName = createUserOrder.ProductName,
StartAddressCity = createUserOrder.StartAddressCity,
StartAddressRoad = createUserOrder.StartAddressRoad,
StartAddressHouse = createUserOrder.StartAddressHouse,
Weight = createUserOrder.Weight,
ApplicationUserId = User.Identity.GetUserId().ToString(),
StartDate = createUserOrder.StartDate,
DueDate = createUserOrder.DueDate,
Status = true
};
UserService.CreateUserOrder(orderUser, idDriver);
string messege = "user Id:" + User.Identity.GetUserId() + "User Name: " + User.Identity.Name +
"controller: AccountController, Action CreateUserOrder Succses";
logger.Info(messege);
return(RedirectToAction("index", "Home"));
}
return(RedirectToAction("CreateUserOrder"));
}
public void CreateUserOrder(OrderUser item, string st)
{
item.Id = Database.orderUsers.Count() + 2.ToString();
if (st != null)
{
var itemOther = Database.orderDrivers.Find(st);
if (item.Weight <= itemOther.MaxWeight)
{
Database.order.Add(new Order {
OrderDriverId = st, OrderUserId = itemOther.Id, Status = "Ready"
});
item.Status = false;
Database.orderDrivers.Find(st).Status = false;
}
}
Database.orderUsers.Add(item);
try
{
Database.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, "; The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
public async Task <OrderPageTabVM> AssignMeToOrder(string welcomeCode, string userId)
{
var order = _db.Orders.GetAll().FirstOrDefault(m => m.WelcomeCode.ToString() == welcomeCode);
if (order != null && (!order.IsActive || order.WelcomeCode.ToString() != welcomeCode))
{
throw new Exception("Order session is already cancel (or invalid WelcomeCode)");
}
var myId = _db.UserProfiles.GetAll().FirstOrDefault(m => m.UserId == userId).Id;
if (_db.OrderUsers.GetAll().Any(m => m.OrderId == order.Id && m.UserProfileId == myId))
{
throw new Exception("You are already assigned this order");
}
var dbOrderUser = new OrderUser
{
OrderId = order.Id,
UserProfileId = _db.UserProfiles.GetAll().FirstOrDefault(m => m.UserId == userId).Id
};
return(new OrderPageTabVM(await _db.OrderUsers.CreateAsync(dbOrderUser), order.Location.Currency));
}
public async Task <OrderPageVM> CreateNewOrder(CreateOrderVM vm, string userId)
{
var dbOrder = new Order
{
IsActive = vm.IsActive,
Status = "In progress",
StartDate = vm.StartDate,
TableId = vm.TableId,
LocationId = vm.LocationId
};
var orderNew = await _db.Orders.CreateAsync(dbOrder);
var dbOrderUser = new OrderUser
{
OrderId = orderNew.Id,
UserProfileId = _db.UserProfiles.GetAll().FirstOrDefault(m => m.UserId == userId).Id
};
var orderUserNew = await _db.OrderUsers.CreateAsync(dbOrderUser);
var ret = new OrderPageVM(orderNew);
return(ret);
}
public void CreateUserOrder(OrderUser orderUser, string st)
{
orderUser.ApplicationUser = Database.UserManager.FindById(orderUser.ApplicationUserId);
Database.OrderManager.CreateUserOrder(orderUser, st);
}
public async Task <OrderUser> Add(OrderUser entity)
{
await _context.OrderUsers.AddAsync(entity);
return(entity);
}
public void UpdateOrderUser(OrderUser orderUser)
{
Database.OrderManager.UpdateOrderUser(orderUser);
}
public abstract void Post(OrderUser user);
public bool AddOrderUser(OrderUser orderUser)
{
return(_purchaseRepository.AddOrderUser(orderUser));
}
public Order GetOrder()
{
Order o = new Order();
if (!IsNullOrEmpty(OrderUser))
{
try
{
if (DB.CurrentDB != DataBases.OrientDB)//This if only for OrientDB
{
o.UID = Convert.ToInt32(OrderUser);
}
else
{
if (!new Regex(@"-?\d+:-?\d+").IsMatch(OrderUser))
{
throw new Exception();
}
var arr = OrderUser.Split(new[] { ':' });
o.UID = Convert.ToInt32(arr[0]);
o.UID_pos = Convert.ToInt32(arr[1]);
}
}
catch (Exception)
{
ShowErrorMessage("User ID is not valid!");
return(null);
}
}
else
{
o.UID = null;
}
if (!IsNullOrEmpty(OrderServer))
{
try
{
if (DB.CurrentDB != DataBases.OrientDB)//This if only for OrientDB
{
o.SID = Convert.ToInt32(OrderServer);
}
else
{
if (!new Regex(@"-?\d+:-?\d+").IsMatch(OrderServer))
{
throw new Exception();
}
var arr = OrderServer.Split(new[] { ':' });
o.SID = Convert.ToInt32(arr[0]);
o.SID_pos = Convert.ToInt32(arr[1]);
}
}
catch (Exception)
{
ShowErrorMessage("Server ID is not valid!");
return(null);
}
}
else
{
o.SID = null;
}
if (IsOrderFromSelected)
{
o.DateFrom = OrderFrom;
}
else
{
o.DateFrom = null;
}
if (IsOrderToSelected)
{
o.DateTo = OrderTo;
}
else
{
o.DateTo = null;
}
return(o);
}
public override void Post(OrderUser user)
{
}
public OrderUser FindOrderUser(string id)
{
OrderUser orderUser = Database.orderUsers.Find(id);
return(orderUser);
}
/// <summary>
/// 订单详情(个人订单的详细信息)
/// </summary>
public ActionResult OrderDetailInfo(string getname)
{
//第一步（绑定下拉框）
List <string> Ulsit = new List <string>();
//ef查询
var User = GetAllOrderUser();
var v = User.GroupBy(a => a.GetName).Select(a => new {
GetName = a.Key
});
Ulsit = v.Select(a => a.GetName).ToList();
ViewBag.Ulist = Ulsit; //绑定下拉框去除重复的收件人名字
//绑定快递信息Div
List <Express> Elist = shop.Express.ToList();
ViewBag.Elist = Elist;
List <OrderUser> UserList = User.ToList();
if (string.IsNullOrEmpty(getname))
{
getname = null;
}
OrderUser OUser = UserList.Where(a => a.GetName == getname || getname == null).First();
ViewBag.OneUser = OUser; //显示下拉框选择的收件人的详细信息
//获取该买家全部商品信息
List <OrderGoods> Glist = new List <OrderGoods>();
//获取买家买的商品信息
var goods = shop.OrderFormInfo.Join(shop.CommodityInfo, a => a.OFI_CI_ID, b => b.CI_ID, (x, y) => new OrderGoods()
{
BuyID = x.OFI_BI_ID,
GoodsImage = y.CI_Url,
GoodsName = y.CI_Name,
TypeID = y.CI_CTI_ID,
BuyNumber = x.OFI_Number,
Price = y.CI_NowPrice,
AddressID = x.OFI_SAI_ID,
IsState = x.OFI_States,
OrderID = x.OFI_ID
}).ToList();
//获取商品类型
Glist = goods.Join(shop.CommodityTypeInfo, a => a.TypeID, b => b.CTI_ID, (x, y) => new OrderGoods()
{
BuyID = x.BuyID,
GoodsImage = x.GoodsImage,
GoodsName = x.GoodsName,
TypeID = x.TypeID,
TypeName = y.CTI_Name,
BuyNumber = x.BuyNumber,
Price = x.Price,
GoodsType = y.CTI_Name,
AddressID = x.AddressID,
IsState = x.IsState,
OrderID = x.OrderID
}).ToList();
//这儿获取收件人姓名
var GNameList = Glist.Join(shop.MyAddressInfo, a => a.AddressID, b => b.MAI_ID, (x, y) => new OrderGoods()
{
BuyID = x.BuyID,
GoodsName = x.GoodsName,
GoodsImage = x.GoodsImage,
TypeID = x.TypeID,
TypeName = x.TypeName,
BuyNumber = x.BuyNumber,
Price = x.Price,
GoodsType = x.GoodsType,
Getname = y.MAI_Name,
IsState = x.IsState,
OrderID = x.OrderID
}).ToList();
if (string.IsNullOrEmpty(getname))
{
getname = OUser.GetName;
}
List <OrderGoods> GLIST = GNameList.Where(a => a.Getname == getname).ToList();
return(View(GLIST));
}
