//called to refresh all the fields and datagridview
private void populateFields(Button disableButton, Button enableButton, int index)
{
orders = OrderDB.GetOrders();
txtOrderID.Text = orders[index].OrderID.ToString();
txtCustomerID.Text = orders[index].CustomerID;
dtpOrderDate.Value = (DateTime)orders[index].OrderDate;
dtpRequiredDate.Value = (DateTime)orders[index].RequiredDate;
if (orders[index].ShippedDate != null) // if the shippeddate is not null
{
dtpShippedDate.Format = DateTimePickerFormat.Long;
dtpShippedDate.Value = (DateTime)orders[index].ShippedDate;
isNull = false;
}
else //shipped date is null
{
dtpShippedDate.CustomFormat = " ";
dtpShippedDate.Format = DateTimePickerFormat.Custom;
isNull = true;
}
List <OrderDetails> orderDetails_List = OrderDetailsDB.GetOrdersDetails(orders[index].OrderID);
dgvOrderDetails.DataSource = orderDetails_List;
txtTotalCharges.Text = CalculateCharges(orderDetails_List).ToString("c");
Disablebuttion(disableButton, enableButton, index);
}
protected void dtlProduct_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "delete")
{
var contentid = ConvertUtility.ToInt32(e.CommandArgument);
try
{
var orderProductInfo = OrderProductDB.GetInfo(_orderid, contentid);
var deletePriceSum = orderProductInfo.PriceSum;
OrderProductDB.Delete(_orderid, contentid);
var orderInfo = OrderDB.GetInfo(_orderid);
orderInfo.Order_Quantity = orderInfo.Order_Quantity - 1;
orderInfo.Order_Price = orderInfo.Order_Price - deletePriceSum;
OrderDB.Update(orderInfo);
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
}
}
if (e.CommandName == "updaterow")
{
//try
//{
var contentid = ConvertUtility.ToInt32(e.CommandArgument);
var txtQuantity = (TextBox)e.Item.FindControl("txtQuantity");
var orderProductInfo = OrderProductDB.GetInfo(_orderid, contentid);
var newQuantity = ConvertUtility.ToInt32(txtQuantity.Text);
var newPriceSum = orderProductInfo.Price * newQuantity;
var balancePrice = orderProductInfo.PriceSum - newPriceSum;
orderProductInfo.Quantity = newQuantity;
orderProductInfo.PriceSum = newPriceSum;
OrderProductDB.Update(orderProductInfo);
var orderInfo = OrderDB.GetInfo(_orderid);
orderInfo.Order_Price = orderInfo.Order_Price - balancePrice;
OrderDB.Update(orderInfo);
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
//}
//catch
//{
// lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR; //ex.ToString();
//}
}
}
private bool SaveOrder(Order order)
{
if (!ModelState.IsValid)
{
return(false);
}
var addressId = SaveAddressAsync(order.Address).Result;
var orderDb = new OrderDB();
var orderDbItem = _orderContext.Orders.FirstOrDefault();
if (orderDbItem == null)
{
orderDb.Id = 1;
}
else
{
var orderId = _orderContext.Orders.Max(x => x.Id);
orderId++;
orderDb.Id = orderId;
}
orderDb.Status = 0;
orderDb.Description = order.Description;
orderDb.AddressId = addressId;
List <OrderDbItem> productDbList = new List <OrderDbItem>();
order.Items.ForEach(x => productDbList.Add(OrderDbItem.ConvertProduct(x.Product, x.Count)));
orderDb.Items = JsonConvert.SerializeObject(productDbList);
_orderContext.Add(orderDb);
_orderContext.SaveChanges();
// SaveOrderInformation()
return(true);
}
public CreateAnOrder(Customer aCust)
{
OrdDb = new OrderDB();
prodDb = new ProductDB();
anOrd = new Order(aCust);
custDb = new CustomerDB();
}
private void button1_Click(object sender, EventArgs e)
{
form1 = (MainForm)this.Owner;
//电话(手机）号码格式
string pattern = "^1[0-9]{10}$";
Regex rx = new Regex(pattern);
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("Please enter enough information!!!");
}
else if (textBox1.Text != "" && !rx.IsMatch(textBox2.Text))
{
MessageBox.Show("Telephone number's format is wrong!!!");
}
else
{
using (var db = new OrderDB())
{
int orderNum = 0;
string pipeNum = db.Order.ToList().LastOrDefault <Order>().Id.Split('-')[3];
Int32.TryParse(pipeNum, out orderNum);
Order.num = orderNum;
}
form1.myService.Add(new Order(new Customer(textBox1.Text, textBox2.Text),
new List <OrderDetail>()));
MessageBox.Show("Add order succeed!!!");
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
OrderInfo info = OrderDB.GetInfo(_orderid);
if (info == null)
{
return;
}
lblID.Text = info.Order_ID.ToString();
lblDateTime.Text = ConvertUtility.ToDateTime(info.Order_CreateDate).ToString("dd/MM/yyyy HH:mm");
lnkFullname.Text = info.Order_Fullname;
lnkFullname.NavigateUrl = AppEnv.ADMIN_CMD + "memberupdate&memberid=" + info.Member_ID;
lblEmail.Text = info.Order_Email;
lblPhone.Text = info.Order_Tel;
lblAddress.Text = info.Order_Address.Replace("\n", "<br>");
lblDistrict.Text = info.Order_District;
lblCity.Text = info.Order_City;
lblContent.Text = info.Order_Note.Replace("\n", "<br>");
MiscUtility.SetSelected(dropStatus.Items, info.Order_Status.ToString());
lblQuantity.Text = ConvertUtility.ToInt32(info.Order_Quantity).ToString();
lblPrice.Text = String.Format("{0:0,0}", info.Order_Price) + " VNÐ";
dtlProduct.DataSource = OrderDB.GetProductByOrderID(_orderid);
dtlProduct.DataBind();
}
public void SetUp()
{
orderDB = new OrderDB(connectionString);
productDB = new ProductDB(connectionString);
customerDB = new CustomerDB(connectionString);
orderLogic = new OrderLogic(connectionString);
}
public object DeleteType(string id, string SHOP_ID)
{
using (var db = new OrderDB())
{
db.BeginTransaction();
try
{
var curType = (from p in db.FoodTypes where p.ID == id select p).FirstOrDefault();
if (curType is null)
{
throw new Exception("当前类别不存在！");
}
db.FoodTypes
.Where(c => c.SEQ > curType.SEQ && c.ShopId == SHOP_ID && c.STATE == 'A')
.Set(c => c.SEQ, c => c.SEQ - 1)
.Update();
db.Delete(curType);
db.CommitTransaction();
}
catch (Exception ex)
{
db.RollbackTransaction();
throw ex;
}
return(true);
}
}
private void LstBoxProductIDs_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
btnOrderDetails.IsEnabled = true;
OrderDB showOrderDetails = new OrderDB();
showOrderDetails.ShowOrderDetails(lstBoxProductIDs, txtProductID, txtUnitPrice, txtQuantity, txtDiscount, txtOrderTotal);
}
private void orderIDComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedID = (int)orderIDComboBox.SelectedValue;
try
{
current = OrderDB.GetOrderByID(selectedID);
DisplayCurrentCustomerData();
ordDetails = OrderDetailsDB.GetOrderDetailIDs(selectedID);
orderDetailDataGridView.DataSource = ordDetails; //ordDetails
//Calculating order total
float total = 0;
foreach (OrderDetail order in ordDetails)
{
total += order.OrderTotal;
}
string Total = total.ToString();
textOrderTotal.Text = total.ToString("c2");
}
catch (Exception ex)
{
MessageBox.Show("Error while retrieving customer with selected ID: " + ex.Message,
ex.GetType().ToString());
}
}
/// <summary>
/// The Update method will update a certain order
/// </summary>
/// <param name="id">The id<see cref="int"/></param>
/// <param name="updateOrder">The updateOrder<see cref="OrderDTO"/></param>
/// <returns>The <see cref="string"/></returns>
public string Update(int id, OrderDTO updateOrder)
{
OrderDB newOrder = Converter.Cast(updateOrder);
_orderRepo.Update(id, newOrder);
return("update succcessfully");
}
public List <Order> GetAllOrders()
{
using (var db = new OrderDB())
{
return(db.Order.Include("items").ToList <Order>());
}
}
public static IList <OrderDB> Cast(IList <ClientOrder> clientOrders)
{
var list = new List <OrderDB>();
foreach (var order in clientOrders)
{
if (order != null)
{
var newobj = new OrderDB()
{
IdOrder = order.IdOrder,
NameCompany = order.NameCompany,
OriginAddress = order.OriginAddress,
OriginCity = order.OriginCity,
OriginState = order.OriginState,
OriginCountry = order.OriginCountry,
DestinationAddress = order.DestinationAddress,
DestinationCity = order.DestinationCity,
DestinationCountry = order.DestinationCountry,
DestinationState = order.DestinationState,
Description = order.Description,
Status = order.Status,
IdLoad = order.IdLoad,
IdShipment = order.IdShipment,
WeigthOrder = order.WeigthOrder,
CostOrder = order.CostOrder
};
list.Add(newobj);
}
}
return(list);
}
public void ChangeOrderStatus(int orderId, OrderStatus newStatus)
{
OrderDB orderDB = new OrderDB();
Order order = orderDB.GetById(orderId);
order.StatusID = newStatus;
order.Update();
}
public static IList <OrderDB> Cast(IEnumerable <OrderDTO> orders)
{
var orderList = new List <OrderDB>();
foreach (var order in orders)
{
var newObject = new OrderDB()
{
IdOrder = order.IdOrder,
NameCompany = order.NameCompany,
OriginAddress = order.OriginAddress,
OriginCity = order.OriginCity,
OriginState = order.OriginState,
OriginCountry = order.OriginCountry,
DestinationAddress = order.DestinationAddress,
DestinationCity = order.DestinationCity,
DestinationCountry = order.DestinationCountry,
DestinationState = order.DestinationState,
Description = order.Description,
Status = order.Status,
IdLoad = order.IdLoad,
IdShipment = order.IdShipment,
WeigthOrder = order.WeigthOrder,
CostOrder = order.CostOrder
};
orderList.Add(newObject);
}
return(orderList);
}
private void customerIDComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
// get CustomerID from combo box
string custID = customerIDComboBox.Text;
var temp = from customer in customers where customer.CustomerID == custID select customer;
foreach (var c in temp)
{
companyNameTextBox.Text = c.CompanyName;
contactNameTextBox.Text = c.ContactName;
contactTitleTextBox.Text = c.ContactTitle;
addressTextBox.Text = c.Address;
cityTextBox.Text = c.City;
postalCodeTextBox.Text = c.PostalCode;
countryTextBox.Text = c.Country;
regionTextBox.Text = c.Region;
phoneTextBox.Text = c.Phone;
faxTextBox.Text = c.Fax;
}
// get the orders for that customer id and populate the orders table
List <Order> orders = OrderDB.GetOrdersByID(custID);
//var temp2 = from order in orders where order.CustomerID == custID select order;
dataGridView1.DataSource = orders;
}
public object GetDeskList()
{
using (var db = new OrderDB())
{
var result = from p in db.ShopDesks where p.ShopId == SHOP_ID select p;
return(result.ToList());
}
}
public List <Order> QueryByCustormer(String custormer)
{
using (var db = new OrderDB())
{
return(db.Order.Include("items")
.Where(o => o.Customer.Equals(custormer)).ToList <Order>());
}
}
public Order GetOrder(String Id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").
SingleOrDefault(o => o.Id == Id));
}
}
// Database test constructor. Only used for testing.
public OrderLogic(string connectionString)
{
orderDB = new OrderDB(connectionString);
cl = new CustomerLogic(connectionString);
productDB = new ProductDB(connectionString);
orderLineDB = new OrderLineDB(connectionString);
productLogic = new ProductLogic(connectionString);
customerDB = new CustomerDB(connectionString);
}
public OrderLogic()
{
orderDB = new OrderDB();
cl = new CustomerLogic();
productDB = new ProductDB();
orderLineDB = new OrderLineDB();
productLogic = new ProductLogic();
customerDB = new CustomerDB();
}
public ActionResult Details(int id)
{
//creation of multiple variables to check conditions and for the display
IOrderDB order = new OrderDB(Configuration);
IOrderManager om = new OrderManager(order);
ICustomerDB customer = new CustomerDB(Configuration);
ICustomerManager cm = new CustomerManager(customer);
ICityDB citydb = new CityDB(Configuration);
ICityManager cityman = new CityManager(citydb);
IDelivery_staffDB dsDB = new Delivery_staffDB(Configuration);
IDelivery_staffManager dsM = new Delivery_staffManager(dsDB);
IDishDB dish = new DishDB(Configuration);
IDishManager dishManager = new DishManager(dish);
IOrder_dishesDB order_Dishes = new Order_dishesDB(Configuration);
IOrder_dishesManager odm = new Order_dishesManager(order_Dishes);
IRestaurantDB restaurant = new RestaurantDB(Configuration);
IRestaurantManager restaurantManager = new RestaurantManager(restaurant);
//Creations of multiple ViewData for the display
var customerlist = cm.GetCustomers();
ViewData["Customers"] = customerlist;
var citylist = cityman.GetCities();
ViewData["City"] = citylist;
var allOrders = om.GetOrders();
ViewData["AllOrders"] = allOrders;
var allStaff = dsM.GetDelivery_staffs();
ViewData["AllStaffs"] = allStaff;
var allDishes = dishManager.GetAllDishes();
ViewData["AllDishes"] = allDishes;
var allOrderDishes = odm.GetAllOrders_dishes();
ViewData["AllOrderDishes"] = allOrderDishes;
var allRestaurants = restaurantManager.GetRestaurants();
ViewData["AllRestaurants"] = allRestaurants;
ViewBag.nameDL = HttpContext.Session.GetString("nameDL");
var od = om.GetOrders_ds(id); //Get all orders according to the deliverer's id
List <Order> odtrie = new List <Order>();
//Creation of a list which will only contain the non delivery order(s)
foreach (Order o in od)
{
if (o.status.Equals("non delivery"))
{
odtrie.Add(o);
}
}
return(View(odtrie)); //Display the non delivery order(s)
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
//db.Order.Attach(order);
//db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
public List <Order> QueryByGoods(String product)
{
using (var db = new OrderDB())
{
var query = db.Order.Include("items")
.Where(o => o.Items.Where(
item => item.Product.Equals(product)).Count() > 0);
return(query.ToList <Order>());
}
}
public void GetAllOrdersShouldReturnAllOrders()
{
using (var context = new Entity.p0storeContext(options)){
OrderDB _orderDB = new OrderDB(context);
var orders = _orderDB.GetAllOrder();
int count = orders.Count;
Assert.Equal(1, count);
}
}
public void Delete(String orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId);
db.OrderItem.RemoveRange(order.Items);
db.Order.Remove(order);
db.SaveChanges();
}
}
public bool UserIsExsist(string name)
{
using (var db = new OrderDB())
{
var isExsit = from p in db.Shops
where p.ACCOUNT == name
select p;
return(isExsit.Count() > 0);
}
}
public void Update(Order order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.Items.ForEach(
item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
static void Main(string[] args)
{
OrderDB orderdb = new OrderDB();
DataSet ds = orderdb.GetOrderDetails(4);
Console.WriteLine(ds.Tables[0].Rows[0][0].ToString());
OrderDB.Orders orders = new OrderDB.Orders();
orders.UpdateOrderDetailQuantity(5, "155", 99);
Console.WriteLine("Updated!");
Console.ReadLine();
}
public RedeemResponse Redeem(string orderNumber, string email)
{
OrderDB db = new OrderDB();
Order2 order = db.GetOrder(orderNumber);
if (order == null)
{
return(new RedeemResponse
{
Message = "",
Success = false
});
}
else if (String.IsNullOrWhiteSpace(email) || !Regex.IsMatch(email, "[a-zA-Z0-9]*@[a-zA-Z0-9]*\\.{1}[a-zA-Z]{1,}"))
{
return(new RedeemResponse
{
Success = false,
Message = "Email required to redeem password."
});
}
else if (order.EMail != null && !order.EMail.Equals(email))
{
return(new RedeemResponse
{
Success = false,
Message = "An email has already been set."
});
}
order.EMail = email;
if (order.PasswordClaimed == null)
{
order.PasswordClaimed = DateTime.Now;
db.SaveOrder(order);
}
RedeemResponse resp = new RedeemResponse();
resp.OrderInfoText = "Addr: " + order.Address + "\n" +
"Mail: " + order.EMail + "\n" +
"Name: " + order.Name + "\n" +
"Password: "******"\n" +
(order.PasswordClaimed != null ? "REDEEMED" : "");
resp.Success = true;
resp.Message = "";
return(resp);
}
protected void btnSave_Click(object sender, EventArgs e)
{
int orcId = Convert.ToInt32(Request.QueryString["orc_id"]);
int forId = Convert.ToInt32(Request.QueryString["for_id"]);
bool success = false;
OrderDB orderbd = new OrderDB();
Order order = new Order();
RequestItemBD requestbd = new RequestItemBD();
RequestItem item = new RequestItem();
order.RegisterDate = DateTime.Now;
order.IdSupplier = forId;
order.IdBudget = orcId;
if (orderbd.Insert(order))
{
int lastOrderId = orderbd.SelectLastOrder();
for (int i = 0; i < gdvItems.Rows.Count; i++)
{
item.Desc = gdvItems.Rows[i].Cells[0].Text;
item.TypeOfItem = gdvItems.Rows[i].Cells[1].Text;
item.Qty = Convert.ToInt32(gdvItems.Rows[i].Cells[2].Text);
item.Price = Convert.ToDouble(gdvItems.Rows[i].Cells[3].Text);
item.PedId = lastOrderId;
if (requestbd.Insert(item))
{
success = true;
}
else
{
success = false;
}
}
}
else
{
success = false;
}
if (success)
{
Response.Redirect("ListOrders.aspx?orc_id=" + orcId + "&success=true");
}
else
{
lblMessage.Text = "Erro ao salvar o pedido.";
}
}
public List<Order> GetOrders()
{
OrderDB orderDB = new OrderDB();
return orderDB.GetAll();
}
/// <summary>
/// TODO: change to boolean
/// </summary>
/// <param name="orderID"></param>
public void DeleteOrderByID(int orderID)
{
OrderDB orderDB = new OrderDB();
Order order = orderDB.GetById(orderID);
//Make a check for nulls
order.Delete();
}
