public ActionResult CartProduct()
{
string date = Request["OrderDate"];
int id = Convert.ToInt32(Request["CustomerID"]);
string status = Request["status"];
int ProductID = Convert.ToInt32(Request["ProductID"]);
orders order = new orders();
order.OrderDate = date;
order.CustomerID = id;
order.status = status;
order.ProductID = ProductID;
dbo.AddProductMember(order);
return(RedirectToAction("CartMember", new { id = Session["CustomerID"] }));
}
orders createorder(orderinfo param)
{
orders order = new orders();
order.ordersInfo = Newtonsoft.Json.JsonConvert.SerializeObject(param);
order.startlocation = param.startingPoint;
order.endlocation = param.endingPoint;
order.state = 0;
order.userprice = (float)param.price;
order.driverprice = (float)param.driverprice;
order.orderType = param.riderType;
order.routeid = int.Parse(param.routeid);
order.StartTime = param.startDate;
return(order);
}
public HttpResponseMessage Delete(string id)
{
orders orders = new orders();
string outMessage = string.Empty;
if (orders.Delete(id, out outMessage))
{
var message = Request.CreateResponse(HttpStatusCode.OK);
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, outMessage));
}
}
private void MakeOrder_Click(object sender, RoutedEventArgs e)
{
DateTime myTime = DateTime.Now.ToLocalTime();
orders item = new orders()
{
time = myTime,
status_id = status,
table_id = tabl_id,
waiter_id = wait_id
};
_db.orders.Add(item);
_db.SaveChanges();
MessageBox.Show("Столик успішно заброньованo.");
}
// GET: orders/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
orders orders = db.Orders.Find(id);
if (orders == null)
{
return(HttpNotFound());
}
ViewBag.customerId = new SelectList(db.Customers, "customerId", "customerLastName", orders.customerId);
return(View(orders));
}
private bool guardarPedido(string[] pedidos, string id, string side)
{
try{
string pedido = "";
orderDta orders = new orderDta();
// Abro el objeto json e inserto el nuevo pedido
var service = HttpContext.RequestServices.GetService(typeof(Microsoft.AspNetCore.Hosting.IHostingEnvironment)) as Microsoft.AspNetCore.Hosting.IHostingEnvironment;
string folderName = "json/";
string webRootPath = service.WebRootPath;
string Path = System.IO.Path.Combine(webRootPath, folderName);
// Cargo el json en la entidad
orderDta od = JsonConvert.DeserializeObject <orderDta>(System.IO.File.ReadAllText(Path + @"/orders.json"));
orders = od;
orders order = new orders();
order.mesa = id;
order.fecha_hora = DateTime.Now.ToString();
order.entregado = false;
order.side = side;
foreach (string m in pedidos)
{
if (!m.Trim().Equals(""))
{
pedido += m.Trim() + "<br>";
}
}
order.orden = pedido;
od.order.Add(order);
// vuelvo a guardar el objeto en el documento json.
string objeto = JsonConvert.SerializeObject(od);
System.IO.File.WriteAllText(Path + @"/orders.json", objeto);
// Uso el inmemory para guardar el pedido de esa mesa y que no vuelvan a hacerlo hasta 3000 seg despues.
var cacheEntryOptions = new MemoryCacheEntryOptions().SetSlidingExpiration(TimeSpan.FromSeconds(300));
memoryCache.Set("mesa_" + id + side, pedido, cacheEntryOptions);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult OrderDetails(string idOrdersAsString)
{
try
{
using (var dc = new MySQLEntities())
{
SelectList districts = new SelectList(dc.districts.ToList(), "iddistricts", "name");
ViewBag.Districts = districts;
SelectList statuses = new SelectList(dc.status.ToList(), "idstatus", "name");
ViewBag.Statuses = statuses;
SelectList customers = new SelectList(dc.customers.ToList(), "idcustomers", "name");
ViewBag.Customers = customers;
SelectList worktypes = new SelectList(dc.worktypes.ToList(), "idWorkTypes", "name");
ViewBag.Worktypes = worktypes;
SelectList masters = new SelectList(dc.masters.ToList(), "idMasters", "name");
ViewBag.Masters = masters;
SelectList works = new SelectList(dc.works.ToList(), "idWorks", "name");
ViewBag.Works = works;
var order = new orders();
if (idOrdersAsString == "")
{
order.idOrders = Guid.NewGuid();
}
else
{
Guid idOrders = new Guid(idOrdersAsString);
order = dc.orders.Find(idOrders);
}
var model = new OrderAndTable(order)
{
order = order,
};
return(PartialView(model));
};
}
catch (Exception ex)
{
return(HttpNotFound());
}
}
int IOrdersRepository.AddOrder(orders order)
{
_efDbContext.Orders.Add(order);
_efDbContext.SaveChanges();
var notyfications = new client_notyfications
{
Id_Client = order.Id_Client,
AsRead = false,
Message = "Złożono zamówienie o numerze " + order.Id + " w dniu " + order.InsertTime.ToShortDateString()
};
_efDbContext.ClientNotyfications.Add(notyfications);
_efDbContext.SaveChanges();
return(order.Id);
}
public HttpResponseMessage Post([FromBody] orders obj)
{
orders orders = new orders();
string outMessage = string.Empty;
if (orders.Create(obj, out outMessage))
{
obj.id = outMessage;
var message = Request.CreateResponse(HttpStatusCode.Created, obj);
message.Headers.Location = new Uri(Request.RequestUri + obj.id);
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, outMessage));
}
}
public async Task <string> ChangeCashPaymentStatus(string paymentstatus, int oid)
{
orders obj = _ordersServices.GetById(oid);// await _usermanager.GetUserAsync(User);
if (obj == null)
{
return("NotFound");
}
else
{
obj.deliveryboyCheckStaus = "completed";
obj.paymentstatus = paymentstatus;
await _ordersServices.UpdateAsync(obj);
return("success");
}
return("");
}
/// <summary>
/// 贡献报表分析
/// </summary>
/// <returns></returns>
public ActionResult Contribute()
{
orders searchEntity = new orders();
var db = new LinqHelper().Db;
var sql = from line in db.orders_line
join order in db.orders
on line.odd_order_id equals order.odr_id
select new { line.odd_price, line.odd_count, order.odr_cust_name } into tab
group tab by tab.odr_cust_name into newGroup
select new ContributeReportModel {
Name = newGroup.Key, TotalMoney = newGroup.Sum(n => n.odd_count * n.odd_price)
};
ViewData["pagerHelper"] = new PageHelper <ContributeReportModel>(sql.ToList(), 1, 10);
ViewData["reportData"] = new JavaScriptSerializer().Serialize(ViewData["pagerHelper"] as PageHelper <ContributeReportModel>);
SetYeasList();
return(View(searchEntity));
}
public ActionResult View_Collect_Order(String name)
{
using (var db = new DataBaseContext())
{
staff current_staff_obj = db.staff_repository.Where(x => x.name == name).Select(x => x).FirstOrDefault();
List <orders> order_lis = db.orders_repository.Where(i => i.staff_obj.department_obj.department_name == current_staff_obj.department_obj.department_name && i.order_status == "Approved_by_Clerk").ToList();
for (int i = 0; i < order_lis.Count; i++)
{
orders temp_order = order_lis[i];
order_lis[i].item_obj = temp_order.item_obj;
}
return(Json(new { status = "ok", order_lis }));
}
}
//lay schedule_id va room id
public List <orders> getRoom_namefordrp()
{
List <orders> li = new List <orders>();
con.Open();
SqlCommand cmd = new SqlCommand("select * from schedules,rooms where schedules.room_id=rooms.room_id and schedules.schedule_status=0", con);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
orders orr = new orders();
orr.schedule_id = (int)rd["schedule_id"];
orr.room_name = (string)rd["room_name"];
li.Add(orr);
}
con.Close();
return(li);
}
protected void Button1_Click(object sender, EventArgs e)
{
Ord = new orders();
Ord.setP_id(p_id.Text);
Ord.setPr_number(pr_number.Text);
Ord.setS_amount(Convert.ToInt32(amount.SelectedValue));
Ord.setS_date(s_date.Text);
Ord.setS_e_id(s_e_id.Text);
Ord.setS_get(Convert.ToDouble(s_get.Text));
Ord.setS_id(s_id.Text);
Ord.setS_price(Convert.ToInt32(s_price.Text));
Ord.setS_return(Convert.ToDouble(s_return.Text));
Ord.setS_summary(Convert.ToDouble(s_summary.Text));
Ord.setS_way(s_way.Text);
bool flag = SS.salePhone(Ord);
if (flag)
{
Response.Write("<script>alert('购买成功！');</script>");
// 建立实例
IncomeExpenseAction IEA = new IncomeExpenseAction();
// 新建收支明细对象
IEA.addIncomeExpense();
// 设置交易内容
IEA.setIEDeal(Ord.getS_summary(), "", "", "", "");
// 设置交易人内容
IEA.setIEDealMan(Ord.getS_date(), "收入", "现金交易", Ord.getS_e_id());
// 设置交易备注
IEA.setIENote("");
// 提交并操作
IEA.submit();
}
else
{
Response.Write("<script>alert('购买失败！');</script>");
}
}
public ActionResult Contribute(FormCollection forms)
{
var db = new LinqHelper().Db;
List <ContributeReportModel> list = new List <ContributeReportModel>();
var sql = from line in db.orders_line
join order in db.orders
on line.odd_order_id equals order.odr_id
select new { line.odd_price, line.odd_count, order.odr_cust_name, order.odr_date } into tab
group tab by tab.odr_cust_name into newGroup
select new ContributeReportModel {
Name = newGroup.Key, TotalMoney = newGroup.Sum(n => n.odd_count * n.odd_price), Year = newGroup.Select(n => n.odr_date).FirstOrDefault()
};
if (!string.IsNullOrEmpty(forms["odr_cust_name"]))
{
var s = forms["odr_cust_name"];
sql = sql.Where(c => c.Name.Contains(s));
}
if (int.Parse(forms["year"]) > 0)
{
foreach (var item in sql.ToList())
{
if (item.Year.Year.ToString() == forms["year"])
{
list.Add(item);
}
}
}
else
{
list = sql.ToList();
}
int curPage = int.Parse(forms["curPage"]);
orders searchEntity = new orders();
SetYeasList();
UpdateModel <orders>(searchEntity);
ViewData["pagerHelper"] = new PageHelper <ContributeReportModel>(list, curPage, 3);
ViewData["reportData"] = new JavaScriptSerializer().Serialize(ViewData["pagerHelper"] as PageHelper <ContributeReportModel>);
return(View(searchEntity));
}
public IActionResult PurchasePorduct(int productid, int amount)
{
int? id = HttpContext.Session.GetInt32("Id");
products PurchasedProduct = _context.products.FirstOrDefault(x => x.id == productid);
orders neworder = new orders()
{
usersid = (int)id,
productsid = productid,
amount = amount,
price = Math.Round(PurchasedProduct.price * amount, 2),
created_at = DateTime.Now,
updated_at = DateTime.Now
};
_context.Add(neworder);
PurchasedProduct.inventory -= neworder.amount;
_context.SaveChanges();
return(RedirectToAction("UserOrder"));
}
public ActionResult sendmail(ApplicationUser user, orders o)
{
var mail = new MailMessage();
var login = new NetworkCredential("*****@*****.**", "mohamed447");
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(new MailAddress(user.Email));
mail.Subject = "Order";
var cust = db.Users.Find(o.custId);
mail.Body = ("you have order from :" + cust.UserName + "<br>" + "Delivery address is :" + cust.Delivery_address + "<br/>" + "Customer number is :" + cust.phone);
var smtpclient = new SmtpClient("smtp.gmail.com", 587);
smtpclient.EnableSsl = true;
smtpclient.Credentials = login;
smtpclient.UseDefaultCredentials = true;
smtpclient.Send(mail);
return(RedirectToAction("Index"));
}
private void getdata(int id)
{
accountinfo.Visible = false;
createBtn.Text = "Save";
bankdiv.Visible = false;
trans_date_time.Visible = false;
totalprice.Visible = false;
// get data from the given id
OrderModel db = new OrderModel();
orders user = db.Get_order_userinfo(id);
// fill text boxes with the new data
FullName.Text = user.full_name;
email.Text = user.email;
ContactNum.Text = Convert.ToString(user.contact_num);
address.Text = user.current_address;
}
public OrderMasterData(orders sd)
{
Command = sd.command;
RequestId = NewGuid(sd.requestId);
ManId = sd.ManifestId;
ORD_NO = sd.ORD_NO;
DLR_NO = (int)sd.DLR_NO;
DLR_PO = sd.DLR_PO;
ORD_DTE = sd.ORD_DTE;
SHP_DTE = sd.SHP_DTE;
SHIP_DTE = sd.SHIP_DTE;
CMNT1 = sd.CMNT1;
CMNT2 = sd.CMNT2;
DLR_NME = sd.DLR_NME;
DLR_ADDR = sd.DLR_ADDR;
DLR_ADDR2 = sd.DLR_ADDR2;
SHP_NME = sd.SHP_NME;
SHP_ADDR = sd.SHP_ADDR;
SHP_ADDR2 = sd.SHP_ADDR2;
SHP_CSZ = sd.SHP_CSZ;
SHP_TEL = sd.SHP_TEL;
SHP_CT = sd.SHP_CT;
SHP_ZIP = sd.SHP_ZIP;
CUS_NME = sd.CUS_NME;
CUS_ADDR = sd.CUS_ADDR;
CUS_CSZ = sd.CUS_CSZ;
CUS_TEL = sd.CUS_TEL;
RTE_CDE = sd.RTE_CDE;
ORD_TYPE = sd.ORD_TYPE;
ENT_BY = sd.ENT_BY;
ORD_AMT = sd.ORD_AMT;
ENT_BY = sd.ENT_BY;
WIN_QTY = sd.WIN_QTY;
STK_QTY = sd.STK_QTY;
CMP_QTY = sd.CMP_QTY;
SHP_QTY = sd.SHP_QTY;
SHP_AMT = sd.SHP_AMT;
MISC_TEXT = sd.MISC_TEXT;
IsSelected = false;
}
public Int64 Update(orders objorders)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "orders_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@oid";
param.Value = objorders.oid;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@uid", objorders.uid);
cmd.Parameters.AddWithValue("@productquantites", objorders.productquantites);
cmd.Parameters.AddWithValue("@billpaidornot", objorders.billpaidornot);
cmd.Parameters.AddWithValue("@amount", objorders.amount);
cmd.Parameters.AddWithValue("@discount", objorders.discount);
cmd.Parameters.AddWithValue("@tax", objorders.tax);
cmd.Parameters.AddWithValue("@totalamount", objorders.totalamount);
cmd.Parameters.AddWithValue("@orderdate", objorders.orderdate);
cmd.Parameters.AddWithValue("@isdelete", objorders.isdelete);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
public IActionResult Update(orders order)
{
if (HttpContext.Session.GetString("accRole").Equals("Admin") || HttpContext.Session.GetString("accRole").Equals("Technician"))
{
try
{
var result = db.orders.FirstOrDefault(item => item.Order_id.Equals(order.Order_id));
if (db.bills.FirstOrDefault(item => item.Bill_order_id.Equals(order.Order_id)) == null)
{
result.Order_feasibility = order.Order_feasibility;
result.Order_status = order.Order_status;
if (result.Order_status.Equals("Complete"))
{
var plans = db.plans_orders.Where(item => item.Plans_orders_order_id.Equals(order.Order_id)).ToList();
foreach (var item in plans)
{
item.Plans_orders_status = "Connected";
}
}
db.SaveChanges();
return(RedirectToAction("Index", "Orders"));
}
else
{
ViewBag.Msg = "This order can not be edited anymore because it has been billed!";
}
return(View(@"~/Views/Admin/orders/Update.cshtml", result));
}
catch (Exception ex)
{
ModelState.AddModelError("Error: ", ex.Message);
}
}
return(View(@"~/Views/Admin/ErrorPemission.cshtml"));
}
//check update
private void updateCheckBtn_Click(object sender, RoutedEventArgs e)
{
CheckTable item = (checksGrid.SelectedItem as CheckTable);
checks item1 = _db.checks.First(c => c.id == item.id);
item1.count = item.count;
menu item4 = _db.menu.First(c => c.id == item1.menu_id);
item4.price = item.price;
item4.size = item.size;
item4.unit_of_measurement_id = _db.units_of_measurement.First(c => c.name == item.unit_measurement).id;
item4.dish_name = item.dishname;
orders item2 = _db.orders.First(c => c.id == item1.order_id);
item2.waiter_id = _db.waiters.First(c => c.name == item.waiter_name).id;
item2.table_id = _db.platens.First(c => c.number == item.id_table).id;
_db.SaveChanges();
checksGrid.ItemsSource = GetCheck();
MessageBox.Show("Зміни успішно збережено");
}
public static orders Map(this ordersDTO dto)
{
var order = new orders()
{
id = dto.id,
customer_name = dto.customer_name,
customer_email = dto.customer_email,
customer_mobile = dto.customer_mobile,
created_at = dto.created_at,
updated_at = dto.updated_at,
status = dto.status,
price = dto.price,
transaction_id = dto.transaction_id,
user_email = dto.user_email,
url_payment = dto.url_payment,
paymentStatus = dto.paymentStatus,
};
return(order);
}
// -----------------------------------------------------------------------------------//
// ------------------------------------ History_Request_Items-------------------------------------//
public ActionResult View_History_Request_Items()
{
using (var db = new DataBaseContext())
{
string user_name = Session["UserName"].ToString();
staff current_staff_obj = db.staff_repository.Where(x => x.name == user_name).Select(x => x).FirstOrDefault();
List <orders> orders_lis = db.orders_repository.Where(or => or.order_status == "Approved_by_Head" && or.staff_obj.staffId == current_staff_obj.staffId).ToList();
for (int i = 0; i < orders_lis.Count; i++)
{
orders temp_order = orders_lis[i];
orders_lis[i].item_obj = temp_order.item_obj;
}
ViewBag.order_lis = (List <orders>)orders_lis;
}
return(View());
}
public HttpResponseMessage DeleteUsers(int id)
{
if (Thread.CurrentPrincipal.Identity.AuthenticationType == "Admin")
{
orders orders = db.orders.FirstOrDefault(order => order.id == id);
if (orders == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.orders.Remove(orders);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public ActionResult View_Collect_Order()
{
string user_name = Session["UserName"].ToString();
using (var db = new DataBaseContext())
{
staff current_staff_obj = db.staff_repository.Where(x => x.name == user_name).Select(x => x).FirstOrDefault();
List <orders> order_lis = db.orders_repository.Where(i => i.staff_obj.department_obj.department_name == current_staff_obj.department_obj.department_name && i.order_status == "Approved_by_Clerk").ToList();
for (int i = 0; i < order_lis.Count; i++)
{
orders temp_order = order_lis[i];
order_lis[i].item_obj = temp_order.item_obj;
}
ViewBag.Order_List_Approved_by_Clerk = order_lis;
}
return(View());
}
public IActionResult AddOders(orders model)
{
IARresponse = BadRequest();
//string res = null;
try
{
if (db.AddOrders(model) == "")
{
IARresponse = Ok(new { res = "Items Odered Successfully" });
}
else
{
IARresponse = BadRequest(new { res = "Something Went Wrong... Try Again" });
}
}
catch (Exception ex)
{
IARresponse = BadRequest(new { res = ex.Message });
}
return(IARresponse);
}
protected void btnOderUser_Click(object sender, EventArgs e)
{
try
{
orders o = new orders();
o.schedule_id = int.Parse(drppickroom.SelectedValue.ToString());
o.service_id = int.Parse(drppickservice.SelectedValue.ToString());
o.quantity = int.Parse(txtpickquantity.Text.ToString());
o.bill_id = ord.getBill_id(int.Parse(drppickroom.SelectedValue.ToString()));
ord.addOrder(o);
ord.updateService_price(int.Parse(drppickroom.SelectedValue.ToString()));
ord.updateTotal_price(int.Parse(drppickroom.SelectedValue.ToString()));
err_msg.ForeColor = System.Drawing.Color.White;
err_msg.Text = "Đặt dịch vụ thành công";
}
catch
{
err_msg.ForeColor = System.Drawing.Color.White;
err_msg.Text = "Đã xảy ra lỗi, không đặt được";
}
}
public static isaCommand MyQueryReader_Orders(SqlDataReader reader, Func <byte[], Task> cb)
{
orders ord = new orders();
try
{
ord.requestId = Guid.Empty.ToByteArray();
ord.ManifestId = reader.GetInt64(reader.GetOrdinal("ManifestId"));
ord.DSP_SEQ = reader.GetInt32(reader.GetOrdinal("DSP_SEQ"));
ord.CustomerId = reader.GetInt32(reader.GetOrdinal("CustomerId"));
ord.DLR_NO = reader.GetInt64(reader.GetOrdinal("DLR_NO"));
ord.ORD_NO = reader.GetInt64(reader.GetOrdinal("ORD_NO"));
ord.CLR = reader.GetString(reader.GetOrdinal("CLR"));
ord.MDL_CNT = reader.GetInt32(reader.GetOrdinal("MDL_CNT"));
ord.MDL_NO = reader.GetInt32(reader.GetOrdinal("MDL_NO"));
ord.WIN_CNT = reader.GetInt32(reader.GetOrdinal("WIN_CNT"));
ord.command = eCommand.OrdersLoad;
}
catch (Exception ex) { }
return(ord);
}
public static ordersDTO Map(this orders entity)
{
var dto = new ordersDTO()
{
id = entity.id,
customer_name = entity.customer_name,
customer_email = entity.customer_email,
customer_mobile = entity.customer_mobile,
created_at = entity.created_at,
updated_at = entity.updated_at,
status = entity.status,
price = entity.price,
transaction_id = entity.transaction_id,
user_email = entity.user_email,
url_payment = entity.url_payment,
paymentStatus = entity.paymentStatus,
};
return(dto);
}
