public int SaveOreder(rosh_orders order) { try { if (order.id == 0) { db.rosh_orders.Add(order); db.SaveChanges(); } else { try { db.Entry(order).State = EntityState.Modified; db.SaveChanges(); } catch (OptimisticConcurrencyException ex) { RDL.Debug.LogError(ex); } } } catch (Exception ex) { RDL.Debug.LogError(ex); } return(order.id); }
public void SaveOreder(OrdersViewModel model, aspnet_Users user, out string msg) { msg = ""; try { if (!_CanChangeOrder(user)) { msg = "Нет прав для данной операции"; } else { if (model.id == 0) //when order not exist... { var item = new rosh_orders { id = 0, orderDate = DateTime.Now.Date, orderNumber = model.orderNumber, contragentID = model.contragentID, orderStatusID = model.orderStatusID, description = model.description }; db.SaveOreder(item); msg = "Счет успешно создан!"; int savedOrderID = item.id; // getting id of created item mng.Orders.ChangeOrderStatus(savedOrderID); } else { var item = new rosh_orders { id = model.id, orderDate = model.orderDate, orderNumber = model.orderNumber, contragentID = model.contragentID, orderStatusID = model.orderStatusID, description = model.description }; db.SaveOreder(item); msg = "Счет успешно изменен!"; int savedOrderID = item.id; // getting id of changed item mng.Orders.ChangeOrderStatus(savedOrderID); } } } catch (Exception ex) { _debug(ex, new { model }, ""); msg = "Сбой операции"; } }
public rosh_orders GetOrder(int id) { var res = new rosh_orders(); try { res = db.GetOrder(id); } catch (Exception ex) { _debug(ex, new { id }, ""); } return(res); }