private void Button_Click(object sender, RoutedEventArgs e)
{
using (Model1 conx = new Model1())
{
AdminOrder order = new AdminOrder()
{
assetid = asst1,
qty = qty,
price = price,
assetid2 = Convert.ToInt64(asset2.SelectedValue),
qty2 = qty2,
memberid = memid,
modified = DateTime.Now,
connect = Convert.ToInt64(membee.SelectedValue),
interests = inter,
dealType = 4,
day = day,
totSum = totSum,
toPay = topay,
};
conx.AdminOrders.Add(order);
conx.SaveChanges();
ClearFields(null, null);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (Model1 context = new Model1())
{
AdminOrder order = new AdminOrder()
{
accountid = Convert.ToInt64(linkacs),
assetid = Convert.ToInt64(asset.SelectedValue),
price = Convert.ToDecimal(exPrice.Text),
qty = Convert.ToInt32(qtyss.Text),
day = Convert.ToInt32(dayy.Text),
totSum = totSum,
connect = toId,
modified = DateTime.Now,
memberid = memId,
state = 0,
toPay = toPay,
interests = inter,
dealType = 3,
side = 0,
};
context.AdminOrders.Add(order);
context.SaveChanges();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
short mod = Convert.ToInt16(Types.SelectedIndex);
int qtyy = Convert.ToInt32(qtyss.Text);
if (mod == 1)
{
qtyy *= (-1);
}
using (Model1 contx = new Model1())
{
AdminOrder order = new AdminOrder()
{
accountid = Convert.ToInt64(accId.SelectedValue),
assetid = Convert.ToInt32(asset.SelectedValue),
side = mod,
qty = qtyy,
modified = DateTime.Now,
memberid = memId,
state = 1,
dealType = 4,
};
contx.AdminOrders.Add(order);
contx.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
AdminOrder adminorder = db.AdminOrders.Find(id);
db.AdminOrders.Remove(adminorder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// items
// orderdetail table created
public ActionResult PlaceOrder(int id)
{
AdminOrder od = new AdminOrder();
db.AdminOrders.Add(od);
db.SaveChanges();
TempData["id"] = orderid;
return(View(db.SupplierCategories.ToList()));
}
public ActionResult Edit([Bind(Include = "OrderId")] AdminOrder adminOrder)
{
if (ModelState.IsValid)
{
db.Entry(adminOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderId = new SelectList(db.AdminOrderDetails, "OrderId", "OrderId", adminOrder.OrderId);
return(View(adminOrder));
}
public ActionResult EditOrder(int id)
{
Category category = new Category();
ViewBag.Category = category.GetCategories();
AdminOrder adminOrder = new AdminOrder();
var data = adminOrder.GetOrder(id);
return(View(data));
}
public ActionResult Create([Bind(Include = "OrderId")] AdminOrder adminOrder)
{
if (ModelState.IsValid)
{
db.AdminOrders.Add(adminOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderId = new SelectList(db.AdminOrderDetails, "OrderId", "OrderId", adminOrder.OrderId);
return(View(adminOrder));
}
public ActionResult EditOrder(AdminOrder order)
{
Category category = new Category();
ViewBag.Category = category.GetCategories();
AdminOrder adminOrder = new AdminOrder();
adminOrder.EditOrder(order);
return(RedirectToAction("Index"));
}
public ActionResult AdminCheckout()
{
int ff;
ff = Convert.ToInt32(TempData["tot"]);
AdminOrder pss = db.AdminOrders.Find(ff);
if (pss == null)
{
return(HttpNotFound());
}
return(View(pss));
}
public ActionResult DeleteOrder(int id)
{
Category category = new Category();
ViewBag.Category = category.GetCategories();
AdminOrder adminOrder = new AdminOrder();
adminOrder.DeleteOrder(id);
var data = adminOrder.GetOrders();
return(PartialView(data));
}
// GET: /AdminOrder/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminOrder adminorder = db.AdminOrders.Find(id);
if (adminorder == null)
{
return(HttpNotFound());
}
return(View(adminorder));
}
// GET: AdminOrders
public ActionResult Index(int?page)
{
Category category = new Category();
ViewBag.Category = category.GetCategories();
AdminOrder adminOrder = new AdminOrder();
var data = adminOrder.GetOrders();
int pageSize = 10;
int pageNumber = (page ?? 1);
return(View(data.ToPagedList(pageNumber, pageSize)));
}
// GET: AdminOrders/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminOrder adminOrder = db.AdminOrders.Find(id);
if (adminOrder == null)
{
return(HttpNotFound());
}
ViewBag.OrderId = new SelectList(db.AdminOrderDetails, "OrderId", "OrderId", adminOrder.OrderId);
return(View(adminOrder));
}
public ActionResult Edit([Bind(Include = "Id,FromHouseId,ProductId,Amount,ToHouseId,AdminOrderStatusId,ReceivedById,Description,ActiveStatus,CreatedBy,CreatedAt,UpdatedAt")] AdminOrder adminorder)
{
if (ModelState.IsValid)
{
db.Entry(adminorder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdminOrderStatusId = new SelectList(db.AdminOrderStatuses, "Id", "StatusValue", adminorder.AdminOrderStatusId);
// ViewBag.CreatedBy = new SelectList(db.IdentityUsers, "Id", "UserName", adminorder.CreatedBy);
ViewBag.FromHouseId = new SelectList(db.Houses, "Id", "Name", adminorder.FromHouseId);
ViewBag.ProductId = new SelectList(db.Products, "Id", "ProductName", adminorder.ProductId);
// ViewBag.ReceivedById = new SelectList(db.IdentityUsers, "Id", "UserName", adminorder.ReceivedById);
ViewBag.ToHouseId = new SelectList(db.Houses, "Id", "Name", adminorder.ToHouseId);
return(View(adminorder));
}
public ActionResult GetOrder(int id)
{
Order order = repository.Orders.FirstOrDefault(o => o.Id == id);
AdminOrder model = new AdminOrder();
if (order != null)
{
model.Number = order.Id;
model.Cost = order.TotalCost;
model.CustomerInformation = InformationConverter.StringToUserProfile(order.CustomerInfrom);
model.Description = InformationConverter.StringToDescription(order.Description);
}
return(View(model));
}
public IActionResult AdminOrders()
{
var info = HttpContext.Session.GetString("SessionUser");
if (info != null)
{
var result = JsonConvert.DeserializeObject <UserInfo>(info);
AdminOrdersModel obj = new AdminOrdersModel();
var tempU = _users.GetUsers.FirstOrDefault(t => t.Id == result.UserId);
obj.AdminName = _userProfiles.GetUserProfiles.FirstOrDefault(t => t.User == tempU).FirstName;
List <AdminOrder> listOrders = new List <AdminOrder>();
foreach (var item in _orders.GetOrders)
{
var productsOrders = _productOrders.GetProductOrders.Where(t => t.OrderId == item.Id);
if (productsOrders != null)
{
foreach (var prOr in productsOrders)
{
AdminOrder admOrder = new AdminOrder();
Product tempProd = _products.GetProducts.FirstOrDefault(t => t.Id == prOr.ProductId);
User tempUser = _users.GetUser(item.UserId);
UserProfile tempProfile = _userProfiles.GetUserProfiles.FirstOrDefault(t => t.User == tempUser);
admOrder.Description = tempProd.Name;
admOrder.Price = Convert.ToInt32(tempProd.Price - (tempProd.Price / 100 * tempProd.SalePercent));
if (item.Status)
{
admOrder.Status = "Processed";
}
else
{
admOrder.Status = "Denied";
}
admOrder.Email = tempUser.Email;
admOrder.Name = tempProfile.FirstName + " " + tempProfile.LastName;
admOrder.Date = item.DateOfOrder.ToShortDateString();
listOrders.Add(admOrder);
}
}
}
obj.Orders = listOrders;//todo order by date
return(View(obj));
}
return(RedirectToAction("AccountAction", "Account"));
}
public ActionResult ViewItems(int id)
{
SupplierCategory cat = db.SupplierCategories.Find(id);
if (cat == null)
{
return(HttpNotFound());
}
AdminOrder a = new AdminOrder
{
OrderId = id
};
db.SaveChanges();
ViewBag.Message = a;
return(View(cat));
}
protected void Button2_Click(object sender, EventArgs e)
{
MyBookStoreDataContext db = new MyBookStoreDataContext();
//在AdminOrder表中添加一条订单
AdminOrder order = new AdminOrder();
//收货人、联系方式、收货地址从页面的TextBox控件中获得
order.UserNmae = txtName.Text;
order.Address = txtAddress.Text;
order.Phone = txtPhone.Text;
order.OrderDate = DateTime.Now;
order.Status = "未审核";
//插入实体order，提交更改后在AdminOrder表添加一条记录
db.AdminOrder.InsertOnSubmit(order);
db.SubmitChanges();
//在OrderItem表中添加订单详细信息
int id = order.OrderId;
for (int i = 0; i < Profile.Cart.BookName.Count; i++)
{
OrderItem orderItem = new OrderItem();
orderItem.OrderId = id;
orderItem.BookName = (string)Profile.Cart.BookName[i];
orderItem.Price = (decimal)Profile.Cart.Price[i];
orderItem.Qty = (int)Profile.Cart.Qty[i];
orderItem.TotalPrice = (int)Profile.Cart.Qty[i] * (decimal)Profile.Cart.Price[i];
db.OrderItem.InsertOnSubmit(orderItem);
db.SubmitChanges();
var book = (from c in db.Book
where c.BookId == (int)Profile.Cart.BookId[i]
select c).First();
book.Qty -= orderItem.Qty;
db.SubmitChanges();
}
//清空Profile.Cart中的对象
Profile.Cart.BookId.Clear();
Profile.Cart.BookName.Clear();
Profile.Cart.Price.Clear();
Profile.Cart.Qty.Clear();
Profile.Cart.TotalPrice = "";
lblMsg.Text = "已经结算成功，谢谢光临";
}
// GET: /AdminOrder/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminOrder adminorder = db.AdminOrders.Find(id);
if (adminorder == null)
{
return(HttpNotFound());
}
ViewBag.AdminOrderStatusId = new SelectList(db.AdminOrderStatuses, "Id", "StatusValue", adminorder.AdminOrderStatusId);
// ViewBag.CreatedBy = new SelectList(db.IdentityUsers, "Id", "UserName", adminorder.CreatedBy);
ViewBag.FromHouseId = new SelectList(db.Houses, "Id", "Name", adminorder.FromHouseId);
ViewBag.ProductId = new SelectList(db.Products, "Id", "ProductName", adminorder.ProductId);
// ViewBag.ReceivedById = new SelectList(db.IdentityUsers, "Id", "UserName", adminorder.ReceivedById);
ViewBag.ToHouseId = new SelectList(db.Houses, "Id", "Name", adminorder.ToHouseId);
return(View(adminorder));
}
public List <AdminOrder> GetOrderDetails()
{
List <AdminOrder> adminOrders = new List <AdminOrder>();
//try{
SqlConnection objCon = new SqlConnection(Database.ConnectionString);
SqlCommand objCom = new SqlCommand(Database.ADMINORDERMANAGER, objCon);
objCom.CommandType = CommandType.StoredProcedure;
objCon.Open();
SqlDataReader objDR = objCom.ExecuteReader();
while (objDR.Read())
{
AdminOrder getlist = new AdminOrder();
getlist.OrderIngredientId = objDR.GetInt32(0);
getlist.CustomerId = objDR.GetInt32(1);
//getlist.IngredientId = objDR.GetInt32(2);
//getlist.CartId = objDR.GetInt32(2);
getlist.DateOfOrder = objDR.GetDateTime(2);
getlist.MobileNumber = objDR.GetString(3);
getlist.DeliveryAddress = objDR.GetString(4);
getlist.TotalBillAmount = objDR.GetDecimal(5);
getlist.NumberOfIngredients = objDR.GetInt32(6);
getlist.GrandTotal = objDR.GetDecimal(7);
adminOrders.Add(getlist);
}
DataTable objDT = new DataTable();
objDT.Load(objDR);
objCon.Close();
//}
//catch (DbException ex)
//{
// throw new IngredientsRecipeShoppingExceptions(ex.Message);
//}
return(adminOrders);
}
partial void UpdateAdminOrder(AdminOrder instance);
partial void DeleteAdminOrder(AdminOrder instance);
private void Button_Click_1(object sender, RoutedEventArgs e)
{
AdminOrder value = (AdminOrder)Нийтзахиалга.SelectedItem;
if (null == value)
{
return;
}
if (linkAc_Copy.SelectedItem == null)
{
MessageBox.Show("Авах дансаа сонго нуу");
return;
}
int useracc = Convert.ToInt32(linkAc_Copy.SelectedValue);
using (Model1 contx = new Model1())
{
AdminDeal pageDeal1 = new AdminDeal()
{
accountid = useracc,
assetid = value.assetid,
day = value.day,
interests = value.interests,
modified = DateTime.Now,
price = value.price,
qty = value.qty,
side = 1,
toPay = value.toPay,
totalPrice = value.totSum,
memberid = memId,
dealType = value.dealType,
connect = value.connect,
};
AdminDeal pageDeal2 = new AdminDeal()
{
accountid = value.accountid,
assetid = value.assetid,
day = value.day,
interests = value.interests,
modified = DateTime.Now,
price = value.price,
qty = -value.qty,
side = -1,
toPay = -value.toPay,
totalPrice = -value.totSum,
memberid = value.memberid,
dealType = value.dealType,
connect = value.connect,
};
contx.AdminDeals.Add(pageDeal1);
contx.AdminDeals.Add(pageDeal2);
contx.SaveChanges();
}
int id = Convert.ToInt32(value.id);
using (var contx = new Model1())
{
AdminOrder statss = contx.AdminOrders.FirstOrDefault(s => s.id == id);
statss.state = 1;
contx.SaveChanges();
}
}
partial void InsertAdminOrder(AdminOrder instance);
