public void showForm(int orderId = -1)
{
currentOrder = homeBugaltery.ListOrders.FirstOrDefault(or => or.Id == orderId);
updateForm();
ShowDialog();
}
public OrderWindow(HomeBugaltery hb, OrdersView order = null)
{
InitializeComponent();
this.hb = hb;
ComboBoxCategories.ItemsSource = hb.ListCategories.Select(c => c.Name);
ComboBoxUsers.ItemsSource = hb.ListUsers.Select(c => c.Name);
if (order != null)
{
orderId = order.Id;
ComboBoxCategories.SelectedItem = order.CategoryName;
ComboBoxUsers.SelectedItem = order.UserName;
DatePickerDate.SelectedDate = order.DateOrder;
TextBoxDescription.Text = order.Description;
TextBoxPrice.Text = order.Price.ToString();
Title = "Редагування операції";
ButtonOk.Content = "Зберегти";
IsEdit = true;
}
else
{
DatePickerDate.SelectedDate = DateTime.Now;
Title = "Додавання операції";
ButtonOk.Content = "Додати";
IsEdit = false;
}
}
public ActionResult ShowOrders()
{
DataLayer dal = new DataLayer();
OrdersView v = new OrdersView();
int userId = int.Parse(System.Web.HttpContext.Current.User.Identity.Name);
v.Orders = (from x in dal.Orders
where x.UserId == userId
select new OrdersView
{
OrderId = x.OrderId,
OrderDate = x.OrderTime,
Amount = 0,
TotalPrice = 0
}).ToList <OrdersView>();
foreach (OrdersView o in v.Orders)
{
List <OrderItem> items = (from x in dal.OrderItems where x.OrderId == o.OrderId select x).ToList <OrderItem>();
o.Amount = items.Sum(x => x.Amount);
o.TotalPrice = items.Sum(x => x.Amount * x.Price);
}
return(View(v));
}
public static List <OrdersView> GetOrders(int idCompany) //yjs 260619
{
cadenaConexion = SelectCadena(idCompany);
List <OrdersView> listaordenes = new List <OrdersView>();
string sql = "select b.nombre,a.* from orders a inner join provedor b on a.idProveedor = b.idProveedor ";
SqlConnection con = new SqlConnection(cadenaConexion);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
DataSet dsResultado = new DataSet();
adapter.Fill(dsResultado, "VistaOrder");
DataTable tblCliente;
tblCliente = dsResultado.Tables["VistaOrder"];
foreach (DataRow drCurrent in tblCliente.Rows)
{
OrdersView orden = new OrdersView()
{
nombreProvedor = (drCurrent["nombre"].ToString()),
ordersId = Int32.Parse(drCurrent["ordersId"].ToString()),
orderNo = drCurrent["orderNo"].ToString(),
idProveedor = Int32.Parse(drCurrent["idProveedor"].ToString()),
pMethod = drCurrent["pMethod"].ToString(),
gTotal = float.Parse(drCurrent["gTotal"].ToString())
};
listaordenes.Add(orden);
}
return(listaordenes);
}
private IDockContent GetContentFromPersistString(string persistString)
{
if (persistString == typeof(RiskClinicFamilyHistoryView).ToString())
{
rcfhv = new RiskClinicFamilyHistoryView();
return(rcfhv);
}
if (persistString == typeof(AdditionalCancerRiskFactorsView).ToString())
{
acrf = new AdditionalCancerRiskFactorsView();
return(acrf);
}
else if (persistString == typeof(CancerRiskView).ToString())
{
crv = new CancerRiskView();
return(crv);
}
else if (persistString == typeof(SimpleRiskModelView).ToString())
{
srmv = new SimpleRiskModelView();
return(srmv);
}
//else if (persistString == typeof(RiskClinicNotesView).ToString())
//{
// rcnv = new RiskClinicNotesView();
// rcnv.PatientHeaderVisible = false;
// return rcnv;
//}
else if (persistString == typeof(PatientCommunicationView).ToString())
{
pcv = new PatientCommunicationView();
pcv.PatientHeaderVisible = false;
return(pcv);
}
else if (persistString == typeof(Recommendations).ToString())
{
brecs = new Recommendations();
return(brecs);
}
else if (persistString == typeof(TestsView).ToString())
{
tv = new TestsView();
//drv.PatientHeaderVisible = false;
return(tv);
}
else if (persistString == typeof(OrdersView).ToString())
{
ov = new OrdersView();
return(ov);
}
else if (persistString == typeof(PediatricRecsView).ToString())
{
prv = new PediatricRecsView();
return(prv);
}
else
{
return(null);
}
}
public ActionResult DeleteConfirmed(int id)
{
ViewBag.Exception = null;
string msg = null;
OrdersView ordersView = db.OrdersView.SingleOrDefault(m => m.id == id);
var entity = (from x in db.Orders where x.id == ordersView.id select x).First();
db.Orders.Remove(entity);
try
{
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.Exception = msg;
return(View(ordersView));
}
return(RedirectToAction("Index"));
}
protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
{
if (e.Exception != null)
{
e.ExceptionHandled = true;
e.KeepInInsertMode = true;
ValidationUtility.ShowValidationErrors(this, e.Exception);
}
else
{
GXGridView1.TotalRecords = OrdersView.SelectCountCached();
GXGridView1.DataBind();
//mvMain.SetActiveView(viewGrid);
string orderNumber = e.Values["OrderNumber"] as string;
Broker.DataAccess.Order o = Broker.DataAccess.Order.GetByOrderNumber(orderNumber);
string DataKeyValue = o.ID.ToString();
int intSelectedIndex = 0;
int intPageIndex = 0;
int intGridViewPages = GXGridView1.PageCount;
// Loop thru each page in the GridView
for (int intPage = 0; intPage < intGridViewPages; intPage++)
{
// Set the current GridView page
GXGridView1.PageIndex = intPage;
// Bind the GridView to the current page
GXGridView1.DataBind();
// Loop thru each DataKey in the GridView
for (int i = 0; i < GXGridView1.DataKeys.Count; i++)
{
if (Convert.ToString(GXGridView1.DataKeys[i].Value) == DataKeyValue)
{
// If it is a match set the variables and exit
intSelectedIndex = i;
intPageIndex = intPage;
break;
}
}
}
// Set the GridView to the values found
GXGridView1.PageIndex = intPageIndex;
GXGridView1.SelectedIndex = intSelectedIndex;
GXGridView1.DataBind();
int GXgvSelectedValue = o.ID;
GXGridView1SelectedValue = GXgvSelectedValue;
odsOrderPreview.SelectParameters.Clear();
odsOrderPreview.SelectParameters.Add("id", GXgvSelectedValue.ToString());
dvOrderPreview.DataBind();
odsGridViewOrderItems.SelectParameters.Clear();
odsGridViewOrderItems.SelectParameters.Add("orderID", GXgvSelectedValue.ToString());
GridViewOrderItems.DataBind();
mvMain.SetActiveView(viewOrderItems);
mvOrderItems.SetActiveView(viewOrderItemsGrid);
}
}
private void orderDetailsToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Visible = false;
dgMgrVisible DDMV = new dgMgrVisible(Visibility);
OrdersView odrView = new OrdersView(DDMV);
odrView.Visible = true;
}
public void AddItem()
{
if (OrdersView.Count != 0 && OrdersView.Last().Content == null)
{
return;
}
OrdersView.Add(new ItemViewModel(this));
OnPropertyChanged();
}
public OrdersViewEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
OrdersView ordersView = (OrdersView)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdOrder"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Date"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["AmountMaterial"];
label3.Content = str;
str = bufferData.NameOfAttribDictinionary["Material"];
label4.Content = str;
str = bufferData.NameOfAttribDictinionary["Destination"];
label5.Content = str;
str = bufferData.NameOfAttribDictinionary["Status"];
label6.Content = str;
var lst1 = new List <string>(bufferData.MaterialTable.Data.Select(x => x.Name));
var lst2 = new List <string>(bufferData.DestinationTable.Data.Select(x => x.Type));
var lst3 = new List <string>(bufferData.StateTable.Data.Select(x => x.Name));
comboBox4.ItemsSource = lst1;
comboBox5.ItemsSource = lst2;
comboBox6.ItemsSource = lst3;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = ordersView.IdOrder;
textBox1.Text = ordersView.IdOrder.ToString();
datePicker2.SelectedDate = DateTime.Parse(ordersView.Date);
textBox3.Text = ordersView.AmountMaterial.ToString();
int index = lst1.FindIndex(x => x == ordersView.Material);
comboBox4.SelectedIndex = index;
index = lst2.FindIndex(x => x == ordersView.Destination);
comboBox5.SelectedIndex = index;
index = lst3.FindIndex(x => x == ordersView.Status);
comboBox6.SelectedIndex = index;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
datePicker2.SelectedDate = DateTime.Now.Date;
textBox3.Text = "";
comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
comboBox6.SelectedIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GXGridView1.TotalRecords = OrdersView.SelectCountCached();
mvMain.SetActiveView(viewGrid);
reportControl.BranchName = BrokerHouseInformation.GetBrokerHouseNameByCode(BrokerHouseInformation.FIRST_ROW);
reportControl.CompanyName = "Брокерско друштво";
}
}
protected void btnDelete_Click1(object sender, EventArgs e)
{
ClientAccount ca = ClientAccount.GetByClientAndBank(int.Parse(GXGridView1.SelectedDataKey["ClientID"].ToString()), int.Parse(GXGridView1.SelectedDataKey["BankID"].ToString()));
ca.IsActive = false;
ClientAccount.Table.Context.SubmitChanges();
GXGridView1.TotalRecords = OrdersView.SelectCountCached();
GXGridView1.DataBind();
mvMain.SetActiveView(viewGrid);
}
private void EditForm_FormClosing(object sender, FormClosingEventArgs e)
{
EditOrderNestedForm form = (EditOrderNestedForm)sender;
if (form.Order != null)
{
form.Order.Customer = CurrentObject;
OrdersView.FocusedRowHandle = OrdersView.FindRow(form.Order);
}
}
private void EditOrder()
{
EditOrderNestedForm form = new EditOrderNestedForm(Session);
form.MdiParent = this.MdiParent;
form.WindowState = FormWindowState.Maximized;
form.Order = (Order)OrdersView.GetFocusedRow();
form.Show();
form.FormClosing += EditForm_FormClosing;
}
private void btnEdit_ItemClick(object sender, ItemClickEventArgs e)
{
EditOrderForm form = new EditOrderForm();
form.OrderId = (int)OrdersView.GetFocusedRowCellValue("Oid");
form.WindowState = FormWindowState.Maximized;
form.MdiParent = this.MdiParent;
form.Show();
form.FormClosing += EditForm_FormClosing;
}
public ActionResult Invoice(int id = 0)
{
List <OrdersView> MyOrders = new List <OrdersView>();
DataManager DM = new DataManager();
MyOrders = DM.GetOrdersViews();
OrdersView CurrOrder = new OrdersView();
CurrOrder = MyOrders.Where(o => o.OrderID.Equals(id)).FirstOrDefault();
return(View(CurrOrder));
}
private void EditForm_FormClosing(object sender, FormClosingEventArgs e)
{
EditOrderForm form = (EditOrderForm)sender;
Reload();
int rowHandle = OrdersView.LocateByValue("Oid", form.OrderId, new OperationCompleted(rh => SetFocusedRow((int)rh)));
if (rowHandle != GridControl.InvalidRowHandle)
{
SetFocusedRow(rowHandle);
}
}
// GET: OrdersViews/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrdersView ordersView = db.OrdersView.SingleOrDefault(m => m.id == id);
if (ordersView == null)
{
return(HttpNotFound());
}
return(View(ordersView));
}
public ActionResult Update([FromBody] CRUDModel <OrdersView> myObject)
{
var ord = myObject.Value;
OrdersView val = ordersdata.Where(or => or.OrderID == ord.OrderID).FirstOrDefault();
val.OrderID = ord.OrderID;
val.EmployeeID = ord.EmployeeID;
val.CustomerID = ord.CustomerID;
val.Freight = ord.Freight;
val.OrderDate = ord.OrderDate;
val.ShipCity = ord.ShipCity;
val.ShipName = ord.ShipName;
return(Json(myObject.Value));
}
public ActionResult Track(int id = 0)
{
if (id == 0)
{
return(HttpNotFound());
}
else
{
List <OrdersView> MyOrders = new List <OrdersView>();
DataManager DM = new DataManager();
MyOrders = DM.GetOrdersViews();
OrdersView order = MyOrders.Where(o => o.OrderID.Equals(id)).FirstOrDefault();
return(View(order));
}
}
protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
if (e.Exception != null)
{
e.ExceptionHandled = true;
e.KeepInEditMode = true;
ValidationUtility.ShowValidationErrors(this, e.Exception);
}
else
{
GXGridView1.TotalRecords = OrdersView.SelectCountCached();
GXGridView1.DataBind();
mvMain.SetActiveView(viewGrid);
}
}
// GET: OrdersViews/Edit/5
public ActionResult Send(int?id)
{
ViewBag.odView = (from x in db.OrderDetailsView where x.order_id == id select x).ToList();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrdersView ordersView = db.OrdersView.SingleOrDefault(m => m.id == id);
if (ordersView == null)
{
return(HttpNotFound());
}
return(View(ordersView));
}
public OrderTrackForm(OrdersView orderData)
{
InitializeComponent();
dataNumberLabel.Text = orderData.OrderTrackingNumber.ToString();
switch (orderData.OrderStatus)
{
case 0:
dataStatusLabel.ForeColor = Color.LightCoral;
dataStatusLabel.Text = "в ожидании";
descCarLabel.Visible = false;
dataCarLabel.Visible = false;
break;
case 1:
dataStatusLabel.ForeColor = Color.Green;
dataStatusLabel.Text = "исполняется";
descCarLabel.Visible = true;
dataCarLabel.Visible = true;
if (orderData.DriverID != 0)
{
dataCarLabel.Text = string.Format("{0} {1} {2}",
orderData.CarTypeName,
orderData.CarColor,
orderData.CarNumber);
}
break;
case 2:
dataStatusLabel.ForeColor = Color.Silver;
dataStatusLabel.Text = "закрыт";
descCarLabel.Visible = true;
dataCarLabel.Visible = true;
if (orderData.DriverID != 0)
{
dataCarLabel.Text = string.Format("{0} {1} {2}",
orderData.CarTypeName,
orderData.CarColor,
orderData.CarNumber);
}
break;
default:
dataStatusLabel.Text = "Что-то не так со статусом!";
break;
}
}
public ActionResult CreateIncoming([Bind(Include = "id,warehouse_name,pub_name,producer_name,Incoming_Outcoming,status,date")] OrdersView ordersView)
{
ViewBag.Exception = null;
string msg = "";
if (ModelState.IsValid)
{
Orders order = new Orders
{
warehouse_id = (from w in db.Warehouses where w.name == ordersView.warehouse_name select w).Single().id,
pub_id = (from p in db.Pubs where p.name == ordersView.pub_name select p).Single().id,
Incoming_Outcoming = OrderIncoming,
status = OrderInCreation,
date = System.DateTime.Now
};
db.Orders.Add(order);
try
{
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.Exception = msg;
ViewBag.warehouse_name = new SelectList(db.Warehouses, "name", "name");
ViewBag.pub_name = new SelectList(db.Pubs, "name", "name");
return(View(ordersView));
}
return(RedirectToAction("Details", new { id = order.id }));
}
ViewBag.warehouse_name = new SelectList(db.Warehouses, "id", "name");
ViewBag.pub_name = new SelectList(db.Pubs, "id", "name");
ViewBag.producer_name = new SelectList(db.Producers, "id", "name");
return(View(ordersView));
}
public List <OrdersView> GetOrdersViews()
{
List <OrdersView> OV = new List <OrdersView>();
using (CMSProjectEntities db = new CMSProjectEntities())
{
var OrderList = db.CustomerOrders.ToList();
foreach (CustomerOrder order in OrderList)
{
OrdersView ordersView = new OrdersView();
ordersView.OrderID = order.OrderID;
ordersView.CustomerID = order.CustomerID;
ordersView.OrderDate = order.OrderDate.ToString("yyyy-MM-dd");
if (order.ShippedDate.HasValue)
{
ordersView.ShippedDate = order.ShippedDate.GetValueOrDefault().ToString("yyyy-MM-dd");
}
else
{
ordersView.ShippedDate = null;
}
ordersView.PickupAddressID = order.PickupAddressID;
ordersView.ShippingAddressID = order.ShippingAddressID;
ordersView.Weight = (float)order.Weight;
ordersView.OrderValue = (float)order.OrderValue;
var cust = db.CustomerUsers.Where(o => o.CustomerID.Equals(ordersView.CustomerID)).FirstOrDefault();
var userp = db.UserProfiles.Where(o => o.UserID.Equals(cust.UserID)).FirstOrDefault();
ordersView.CustomerName = userp.FirstName + " " + userp.LastName;
var paddr = db.Addresses.Where(o => o.AddressID.Equals(ordersView.PickupAddressID)).FirstOrDefault();
ordersView.PickupAddress = paddr.StreetAddress + ", " + paddr.City + ", " + paddr.State + " - " + paddr.Pincode;
var saddr = db.Addresses.Where(o => o.AddressID.Equals(ordersView.ShippingAddressID)).FirstOrDefault();
ordersView.ShippingAddress = saddr.StreetAddress + ", " + saddr.City + ", " + saddr.State + " - " + saddr.Pincode;
ordersView.TrackingID = db.TrackingTBLs.Where(o => o.OrderID.Equals(ordersView.OrderID)).FirstOrDefault().TrackingID;
ordersView.OrderStatusID = db.TrackingTBLs.Where(o => o.TrackingID.Equals(ordersView.TrackingID)).FirstOrDefault().OrderStatusID;
ordersView.OrderStatus = db.OrderStatusLookups.Where(o => o.OrderStatusID.Equals(ordersView.OrderStatusID)).FirstOrDefault().Status;
ordersView.PaymentID = db.PaymentTBLs.Where(o => o.OrderID.Equals(ordersView.OrderID)).FirstOrDefault().PaymentID;
ordersView.PaymentStatusID = db.PaymentTBLs.Where(o => o.PaymentID.Equals(ordersView.PaymentID)).FirstOrDefault().PaymentStatusID;
ordersView.PaymentStatus = db.PaymentStatusLookups.Where(o => o.PaymentStatusID.Equals(ordersView.PaymentStatusID)).FirstOrDefault().Status;
OV.Add(ordersView);
}
return(OV);
}
}
private void ChangeOrderStatus(int orderStatus)
{
if (dataGridView1.SelectedRows.Count > 0)
{
var row = dataGridView1.SelectedRows[0];
var order = new OrdersView
{
OrderID = Convert.ToInt32(row.Cells[0].Value),
CompanyID = Convert.ToInt32(row.Cells[1].Value),
DriverID = Convert.ToInt32(row.Cells[6].Value),
OrderStatus = orderStatus
};
int driverCompanyId = Convert.ToInt32(row.Cells[7].Value);
if (DataBaseHelper.GetCurrentDataBase().UpdateOrderInformation(order, driverCompanyId))
{
UpdateGridInformation();
}
}
}
public ActionResult Send([Bind(Include = "id,warehouse_name,pub_name,producer_name,Incoming_Outcoming,status,date")] OrdersView ordersView)
{
ViewBag.odView = (from x in db.OrderDetailsView where x.order_id == ordersView.id select x).ToList();
ViewBag.Exception = null;
string msg = null;
if (ModelState.IsValid)
{
try
{
var entity = (from c in db.Orders where c.id == ordersView.id select c).First();
entity.status = OrderCompleted;
db.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException == null)
{
msg = e.Message;
}
else if (e.InnerException.InnerException == null)
{
msg = e.InnerException.Message;
}
else
{
msg = e.InnerException.InnerException.Message;
}
ViewBag.Exception = msg;
OrdersView ov = db.OrdersView.SingleOrDefault(m => m.id == ordersView.id);
return(View(ov));
}
return(RedirectToAction("Details", "OrdersViews", new { id = ordersView.id }));
}
return(View(ordersView));
}
public IActionResult CreateOrders(OrdersView OrdView)
{
System.Console.WriteLine($"Order action ******** {OrdView.CustomersId} {OrdView.Quantity}");
if (ModelState.IsValid)
{
Orders Ord = new Orders {
CustomersId = (int)OrdView.CustomersId,
ProductsId = (int)OrdView.ProductsId,
Quantity = (int)OrdView.Quantity,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
};
_context.Orders.Add(Ord);
_context.SaveChanges();
return(RedirectToAction("ShowOrders"));
}
else
{
ViewBag.Errors = ModelState.Values;
return(View("customer"));
}
return(View("order"));
}
public void RemoveItem(ItemViewModel itemViewModel)
{
OrdersView.Remove(itemViewModel);
}
public decimal?GetTotal(MaterialModel.Material type)
{
var result = OrdersView.Where(x => x.Type == type).Sum(x => x.Content.Total);
return(result);
}
