private void updateClick(object sender, RoutedEventArgs e)
{
try
{
StatusOrder s = (StatusOrder)Enum.Parse(typeof(StatusOrder), StatusComboBox.SelectedItem.ToString());
bl.updateOrder(HU, O, s, G);
if (s == StatusOrder.SentMail)
{
try
{
bl.mailSent(O, HU, G);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
MessageBox.Show("This order was updated successfully!", "UPDATE", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
catch (Exceptions ex)
{
MessageBox.Show(ex.message, "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public Order(int id, string username, Pizza[] pizzas)
{
_id = id;
Username = username;
Pizzas = pizzas;
status = StatusOrder.None;
}
// GET: Orders/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order order = db.Orders.Find(id);
if (order == null)
{
return(HttpNotFound());
}
Tour tour = db.Tours.FirstOrDefault(t => t.TourID == order.TourID.Value);
StatusOrder statusOrder = db.StatusOrders.FirstOrDefault(s => s.StatusOrderID == order.StatusOrderID.Value);
Hostel hostel = db.Hostels.FirstOrDefault(h => h.HostelID == tour.HostelID.Value);
var userId = User.Identity.GetUserId();
ApplicationUser user = db.Users.FirstOrDefault(u => u.Id == order.UserId);
dynamic model = new ExpandoObject();
model.Order = order;
model.Tour = tour;
model.Status = statusOrder.StatusOrderName;
model.Hostel = hostel;
model.UserName = user.FirstName + " " + user.LastName;
return(View(model));
}
public EntityStatusOrder Insert(EntityStatusOrder data)
{
try
{
StatusOrder dataNew = new StatusOrder()
{
PK_StatusOrderID = data.PK_StatusOrderID,
StatusOrder1 = data.StatusOrder1,
Status = data.Status,
CreateDate = data.CreateDate,
ModifyDate = data.ModifyDate
};
base.DataContext.StatusOrder.Add(dataNew);
base.DataContext.SaveChanges();
data.PK_StatusOrderID = dataNew.PK_StatusOrderID;
return(data);
}
catch (DbException dbex)
{
throw dbex;
}
catch (Exception ex)
{
throw ex;
}
}
// GET: Orders/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Order order = db.Orders.Find(id);
if (order == null)
{
return(HttpNotFound());
}
Tour tour = db.Tours.FirstOrDefault(t => t.TourID == order.TourID.Value);
StatusOrder statusOrder = db.StatusOrders.FirstOrDefault(s => s.StatusOrderID == order.StatusOrderID.Value);
Hostel hostel = db.Hostels.FirstOrDefault(h => h.HostelID == tour.HostelID.Value);
dynamic model = new ExpandoObject();
model.Order = order;
model.Tour = tour;
model.Status = statusOrder.StatusOrderName;
model.Hostel = hostel;
return(View(model));
}
public async Task <ActionResult <StatusOrder> > PostStatusOrder(StatusOrder statusOrder)
{
_context.StatusOrder.Add(statusOrder);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetStatusOrder", new { id = statusOrder.Id }, statusOrder));
}
public async Task <IActionResult> PutStatusOrder(int id, StatusOrder statusOrder)
{
if (id != statusOrder.Id)
{
return(BadRequest());
}
_context.Entry(statusOrder).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StatusOrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public bool orderStatus(Order or, StatusOrder s)
{
if (or.statusOrder == StatusOrder.CloseOfResponsiveness || or.statusOrder == StatusOrder.CloseOfUnresponsivness || or.statusOrder == StatusOrder.closed)
{
return(false);//אם הסטטוס לא סגור, רק אז אפשר לשנות
}
return(true);
}
public ActionResult DeleteConfirmed(int id)
{
StatusOrder statusOrder = db.StatusOrder.Find(id);
db.StatusOrder.Remove(statusOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public virtual ActionResult Search(string array, string term = "", string search = "", string order = "")
{
int[] arrayResult = Array.ConvertAll(array.Split(','), x => int.Parse(x)).ToArray();
StatusSearch serachResult = (StatusSearch)Enum.Parse(typeof(StatusSearch), search);
StatusOrder orderResult = (StatusOrder)Enum.Parse(typeof(StatusOrder), order);
return(View());
}
public Order(DateTime?begin, string name, string requestDescription, Problems?problem, LightPole lightPole)
{
InitialDate = begin;
LightPole = lightPole;
Name = name;
RequestDescription = requestDescription;
Problem = problem;
Status = StatusOrder.Open;
}
public ActionResult Create(StatusOrder statusOrder)
{
if (ModelState.IsValid)
{
db.StatusOrders.Add(statusOrder);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public void updateOrder(Order or, StatusOrder so)
{
Order myOr = DataSource.orderList.FirstOrDefault(item => item.OrderKey == or.OrderKey);
if (myOr == null)
{
throw new Exceptions("This order isn't exist, can't can't update (DAL)", or.OrderKey, or.CreateDate.ToString());
}
myOr.statusOrder = so;
}
public static ApiResultEnum UpdateStatusOrder(StatusOrder model)
{
string sql = "UPDATE unit SET status_order=@status WHERE id=@id";
if (MySQLHelper.ExecuteNonQuery(sql, DAHelper.CreateParams(sql, model)) > 0)
{
return(ApiResultEnum.Success);
}
return(ApiResultEnum.Failed);
}
public Result UpdateStatusOrder(StatusOrder model)
{
ApiResultEnum result = AccountDA.UpdateStatusOrder(model);
if (result == ApiResultEnum.Success && MonitorRA.GetStatusTrade() != 0)
{
AccountRA.UpdateStatusOrder(model.status, "A_" + model.id);
}
return(Result(result));
}
public ActionResult Edit([Bind(Include = "IdStatus,StatusName")] StatusOrder statusOrder)
{
if (ModelState.IsValid)
{
db.Entry(statusOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(statusOrder));
}
public Order(int id, int dateId, int loginId, int categoryId, int quatity, decimal price, int statusId)
{
Id = id;
DateId = dateId;
LoginId = loginId;
Category = (Category)categoryId;
Quantity = quatity;
Price = price;
Status = (StatusOrder)statusId;
}
public List <Order> getOrderNotSuccesYetByCustomer(string cus, int status)
{
List <Order> orders = new List <Order>();
try
{
string sql = "SELECT dbo.[order].*,dbo.Shipping.name,dbo.Shipping.phone,dbo.Shipping.address,status_order.status \n"
+ " FROM dbo.[order] INNER JOIN dbo.Shipping\n"
+ " ON Shipping.id = [order].shipping_id INNER JOIN status_order\n"
+ " ON status_order.code = dbo.[order].status WHERE Customer =@cus AND dbo.[order].status <> @status";
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@cus", cus);
command.Parameters.AddWithValue("@status", status);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Shipping shipping = new Shipping();
shipping.id = Convert.ToInt32(reader["shipping_id"]);
shipping.name = Convert.ToString(reader["name"]);
shipping.phone = Convert.ToString(reader["phone"]);
shipping.address = Convert.ToString(reader["address"]);
StatusOrder statusOrder = new StatusOrder();
statusOrder.code = Convert.ToInt32(reader[6]);
statusOrder.status = Convert.ToString(reader[10]);
Order o = new Order();
o.id = Convert.ToInt32(reader["id"]);
o.customer = Convert.ToString(reader["Customer"]);
o.shippingId = Convert.ToInt32(reader["shipping_id"]);
o.createDate = Convert.ToString(reader["create_date"]);
o.totalPrice = Convert.ToDouble(reader["total_price"]);
o.note = Convert.ToString(reader["note"]);
o.status = Convert.ToInt32(reader["status"]);
o.Shipping = shipping;
o.statusOrder = statusOrder;
orders.Add(o);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
if (connection.State != ConnectionState.Closed)
{
connection.Close();
}
}
return(orders);
}
public static void RunUnitCapitalMonitor()
{
string[] keys = TradeRA.KeySearch("U_*");
foreach (string key in keys)
{
Unit unit = UnitRA.Get(key);
if (unit.user_id > 0 && unit.ratio_warning > 0)
{
if (unit.capital_total < unit.ratio_warning * unit.capital_scale && unit.status_order_enum == StatusOrderEnum.Allowed)
{
StatusOrder model = new StatusOrder(unit.id, StatusOrderEnum.NoBuying);
UnitDA.UpdateStatusOrder(model);
UnitRA.UpdateStatusOrder(model.status, "U_" + model.id);
UserDA.ListParents(unit.user_id).ForEach(user_id =>
{
MessageBiz.Send(user_id.ToString(), MessageTypeEnum.Unit_Warning, "单元[" + unit.code + "]资产已低于预警线，被禁止买入");
});
NLog.Info(string.Format("单元[{0}]资产已低于预警线，被禁止买入。总资产：{1}", unit.code, unit.capital_total));
}
else if (unit.capital_total > unit.ratio_warning * unit.capital_scale && unit.status_order_enum == StatusOrderEnum.NoBuying)
{
StatusOrder model = new StatusOrder(unit.id, StatusOrderEnum.Allowed);
UnitDA.UpdateStatusOrder(model);
UnitRA.UpdateStatusOrder(model.status, "U_" + model.id);
MessageBiz.Send(unit.user_id.ToString(), MessageTypeEnum.Unit_Recovery, "单元[" + unit.code + "]资产已高于预警线，恢复交易");
}
}
if (unit.user_id > 0 && unit.ratio_close_position > 0 && unit.capital_total < unit.ratio_close_position * unit.capital_scale)
{
List <Position> list = PositionRA.List4Unit(unit.id).Where(p => p.count_sellable > 0).ToList();
if (list.Count > 0)
{
list.ForEach(p =>
{
Order order = new Order()
{
code = p.code,
count = p.count_sellable,
type_enum = OrderTypeEnum.Sell,
unit_id = unit.id,
price = DataBiz.GetPriceByPriceType(p.code, OrderPriceEnum.Buy5),
user_id = 1,
platform = 1
};
Order(order);
});
UserDA.ListParents(unit.user_id).ForEach(user_id =>
{
MessageBiz.Send(unit.id.ToString(), MessageTypeEnum.Unit_Close_Position, "单元[" + unit.code + "]资产已低于平仓线，被强制平仓");
});
NLog.Info(string.Format("单元[{0}]资产已低于平仓线，被强制平仓。总资产：{1}", unit.code, unit.capital_total));
}
}
}
}
public ActionResult Create([Bind(Include = "IdStatus,StatusName")] StatusOrder statusOrder)
{
if (ModelState.IsValid)
{
db.StatusOrder.Add(statusOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(statusOrder));
}
public Result UpdateStatusOrder(StatusOrder model)
{
string status_order = ((int)model.status).ToString();
if (UserRA.Exists(model.id.ToString()))
{
UserRA.Set(model.id.ToString(), "status_order", status_order);
}
MessageBiz.Send(model.id.ToString(), MessageTypeEnum.User_Order_Status, status_order);
return(Result(UserDA.UpdateStatusOrder(model)));
}
private void ChangeStatus(StatusOrder status)
{
if (dataGridView1.SelectedRows.Count > 0)
{
Order order = dataGridView1.SelectedRows[0].DataBoundItem as Order;
StatusManager.ChangeStatus(order, status);
Controller.SaveChanges();
UpdateData();
}
}
public StatusOrderDTO Delete(StatusOrderDTO obj)
{
try
{
StatusOrder statusOrder = _mapper.Map <StatusOrder>(obj);
statusOrderRepository.Delete(statusOrder);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
/// </summary>
/// <returns></returns>
public StatusOrderDTO AddOrUpdate(StatusOrderDTO obj)
{
try
{
StatusOrder statusOrder = _mapper.Map <StatusOrder>(obj);
statusOrderRepository.AddOrUpdate(statusOrder);
return(_mapper.Map <StatusOrderDTO>(statusOrder));
}
catch (Exception ex)
{
throw ex;
}
}
// GET: StatusOrders/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StatusOrder statusOrder = db.StatusOrder.Find(id);
if (statusOrder == null)
{
return(HttpNotFound());
}
return(View(statusOrder));
}
private ActionResult Find(int?id, int action)
{
if (id == null)
{
return(HttpNotFound());
}
StatusOrder statusOrder = db.StatusOrders.Find(id);
if (statusOrder == null)
{
return(HttpNotFound());
}
return(action == 0 ? View("Details", statusOrder) : View("Edit", statusOrder));
}
public void updateOrder(Order o, StatusOrder os)
{
XElement OrderElement = (from p in OrderRoot.Elements()
where Convert.ToInt32(p.Element("OrderKey").Value) == o.OrderKey
select p).FirstOrDefault();
if (OrderElement == null)
{
throw new Exceptions("This order isn't exist, can't can't update (DAL)", o.OrderKey, o.CreateDate.ToString());
}
o.statusOrder = os;
OrderElement.Remove();
OrderRoot.Add(ConverOrderToXElement(o));
OrderRoot.Save(OrderPath);
}
public virtual ActionResult GetDataTable(string arrayCategory, string arrayCompany, string search = "", string order = "", string term = "", int count = 20, int page = 0)
{
int[] arrayResultCategory = (!string.IsNullOrEmpty(arrayCategory)) ? Array.ConvertAll(arrayCategory.Split(','), x => int.Parse(x)).ToArray() : null;
int[] arrayResultCompany = (!string.IsNullOrEmpty(arrayCompany)) ? Array.ConvertAll(arrayCompany.Split(','), x => int.Parse(x)).ToArray() : null;
var resultCategory = _categoryService.CheckCollectionId_(arrayResultCategory);
if (resultCategory)
{
var resultCompany = _companyService.CheckCollectionId_(arrayResultCompany);
if (resultCompany)
{
StatusSearch serachResult = (StatusSearch)Enum.Parse(typeof(StatusSearch), search);
StatusOrder orderResult = (StatusOrder)Enum.Parse(typeof(StatusOrder), order);
//مقدار دهی
ViewBag.arrayCategory = arrayCategory;
ViewBag.search = search;
ViewBag.order = order;
ViewBag.term = term;
ViewBag.count = count;
ViewBag.page = page;
ViewBag.arrayCompany = arrayCompany;
var totalRecord = _productService.CountProductSerach_(term.ToSafeHtml(), arrayResultCategory, arrayResultCompany);
ViewBag.totalRecords = totalRecord;
ViewBag.currentPage = page + 1;
var list = _productService.GetdataTableProduct_(arrayResultCategory, arrayResultCompany, term.ToSafeHtml(), count, page, serachResult, orderResult);
if (list.Count() > 0)
{
return(PartialView(viewName: "_DataTableCategory", model: list));
}
else
{
return(PartialView(MVC.Shared.Views._Alert));
}
}
else
{
return(PartialView(MVC.Shared.Views._Alert));
}
}
else
{
return(PartialView(MVC.Shared.Views._Alert));
}
}
public void updateGuestRequest(int guestRequestKey, StatusOrder guestRequestStatus)
{
var match = from guest in DS.DataSource.guestRequests
where guestRequestKey == guest.GuestRequestKey
select guest;
if (match.Count() == 0)
{
throw new dalExeptionItemDoesntexist();
}
else if (match.Count() > 1)
{
throw new dalExeptionMoreThanOneAnswer();
}
match.ToList().RemoveAll(guest => guestRequestKey == guest.GuestRequestKey);
match.ToList()[0].status = guestRequestStatus;
DataSource.guestRequests.Add(match.ToList()[0]);
}
public void updateOrder(int orderKey, StatusOrder status)
{
var match = from anOrder in DataSource.orders
where orderKey == anOrder.HostingUnitKey
select anOrder;
if (match.Count() == 0)
{
throw new dalExeptionItemDoesntexist();
}
else if (match.Count() > 1)
{
throw new dalExeptionMoreThanOneAnswer();
}
match.ToList().RemoveAll(anOrder => anOrder.OrderKey == orderKey);
match.ToList()[0].status = status;
DataSource.orders.Add(match.ToList()[0]);
}
