public void Reset(ISettings settings, ILogicSettings logicSettings) { Client = new Client(Settings); LogicClient = new LogicClient(LogicSettings); Inventory = new Inventory(Client, LogicClient); Navigation = new Navigation(Client); }
private void Button_Click(object sender, RoutedEventArgs e) { try { Model1 db = new Model1(); int a = Convert.ToInt32(idtxt.Text); var orderr = db.Orders .Where(c => c.id_order == a) .FirstOrDefault(); orderr.order_status = Convert.ToInt32(LogicStatus.GetIdStatus(status.Text)); orderr.client = Convert.ToInt32(LogicClient.GetIdClient(client.Text)); orderr.master = Convert.ToInt32(LogicMaster.GetIdMaster(master.Text)); orderr.date_of_acceptance = accept.DisplayDate; orderr.date_of_return = @return.DisplayDate; orderr.cost = Convert.ToInt32(price.Text); orderr.description = description.Text; db.SaveChanges(); MessageBox.Show("Заказ изменён!"); ViewOrder vo = new ViewOrder(); vo.Show(); Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public string SearForDel(DataGridView dataGrid, string name) { LogicClient logCl = new LogicClient(); int columns = dataGrid.ColumnCount; for (int i = 0; i < columns; i++) { if (dataGrid.Columns[i].HeaderText == name) { return(Convert.ToString(i)); } } return("error"); }
private async void LoadData() { LogicClient logicCliente = new LogicClient(); LogicPhone logicPhone = new LogicPhone(); try { cbClientes.DataSource = (await logicCliente.GetAll()).ToList(); cbPhones.DataSource = (await logicPhone.GetAll()).ToList(); } catch (Exception ex) { base.ShowError(ex.Message, "Cargar Información."); } }
public void UpdateTable() { switch (table) { case Tables.Client: dataAll.DataSource = My.Clients.ToList <Client>(); LogicClient logicCl = new LogicClient(); logicCl.getDataClient(dataAll); break; case Tables.Disk: dataAll.DataSource = My.Disks.ToList <Disk>(); break; case Tables.Movie: dataAll.DataSource = My.Movies.ToList <Movie>(); break; case Tables.Order: dataAll.DataSource = My.Orders.ToList <Order>(); break; case Tables.Employee: dataAll.DataSource = My.Employees.ToList <Employee>(); LogicEmployees logicEmp = new LogicEmployees(); logicEmp.getDataEmployee(dataAll); break; default: DialogResult result = MessageBox.Show( "В процессе разработки!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification); break; } }
public async override void LoadData() { _logicClient = new LogicClient(); gridClientes.Rows.Clear(); try { IEnumerable <Cliente> listClientes = await _logicClient.GetAll(); foreach (Cliente c in listClientes) { // IdCliente | Apellido | Nombre // gridClientes.Rows.Add(c.Id, c.Apellido, c.Nombre); } } catch (LoggedException logex) { base.ShowError(logex.Message, "Cargar Modelos"); } catch (Exception ex) { base.ShowError(ex.Message, "Cargar Modelos"); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { if (@return.Text == "") { var dt = DateTime.Now; @return.SelectedDate = dt.AddDays(7); } if (price.Text == "") { price.Text = "0"; } if (description.Text == "") { description.Text = "Не указано"; } Model1 db = new Model1(); Orders order = new Orders { order_status = statusnew, //order_status = Convert.ToInt32(LogicStatus.GetIdStatus(status.Text)), client = Convert.ToInt32(LogicClient.GetIdClient(client.Text)), master = Convert.ToInt32(LogicMaster.GetIdMaster(master.Text)), date_of_acceptance = accept.SelectedDate, date_of_return = @return.SelectedDate, cost = Convert.ToInt32(price.Text), description = description.Text }; db.Orders.Add(order); //string connectionString = @"data source=MAX-PC\SQLEXPRESS;initial catalog=ComputerService;integrated security=True;"; //string sqlExpression = "SELECT IDENT_CURRENT('dbo.Orders')+1"; //using (SqlConnection connection = new SqlConnection(connectionString)) //{ // connection.Open(); // SqlCommand command = new SqlCommand(sqlExpression, connection); // var ident_current = command.ExecuteScalar(); // globalid = ident_current; // LogicOrders.globalidorder = Convert.ToInt32(globalid); //} //Details details = new Details //{ // Order = Convert.ToInt32(globalid), // Parts = Convert.ToInt32(LogicComputers.GetIdMark(pc.Text)), //}; //db.Details.Add(details); db.SaveChanges(); MessageBox.Show("Заказ добавлен!"); ViewOrder vo = new ViewOrder(); vo.Show(); Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button2_Click(object sender, EventArgs e) { if (dataAll.SelectedRows.Count == 0) { return; } Form1 from1 = new Form1(); DialogResult result = MessageBox.Show( "Вы уверены в этом?", "Сообщение", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.ServiceNotification ); from1.MaximizeBox = true; switch (table) { case Tables.Movie: if (result == DialogResult.Yes) { foreach (DataGridViewRow row in dataAll.SelectedRows) { Movie movie = row.DataBoundItem as Movie; if (movie == null) { continue; } Movie dbMovie = My.Movies.Find(movie.Id); My.Movies.Remove(dbMovie); } My.SaveChanges(); UpdateTable(); } break; case Tables.Client: if (result == DialogResult.Yes) { LogicClient LogCl = new LogicClient(); int idClient = Convert.ToInt32(dataAll[0, dataAll.CurrentCell.RowIndex].Value); int idPassCL = Convert.ToInt32(dataAll[9, dataAll.CurrentCell.RowIndex].Value); LogCl.RemoveClient(idClient, idPassCL); UpdateTable(); //ObjectContext objectContext = (new Contex() as IObjectContextAdapter).ObjectContext; //SqlConnection connection = new SqlConnection(@"Data source=.\SQLEXPRESS;InitialCatalog=Kinosoft4"); //ObjectQuery<DbDataRecord> disk = objectContext.CreateQuery<DbDataRecord>("SELECT * FROM Client, Passport"); //dataAll.DataSource = disk.ToList(); } break; case Tables.Disk: if (result == DialogResult.Yes) { foreach (DataGridViewRow row in dataAll.SelectedRows) { Disk disk = row.DataBoundItem as Disk; if (disk == null) { continue; } Disk dbDisk = My.Disks.Find(disk.Id); My.Disks.Remove(dbDisk); } My.SaveChanges(); UpdateTable(); } break; case Tables.Employee: LogicEmployees logEmp = new LogicEmployees(); int idEmployee = Convert.ToInt16(dataAll[0, dataAll.CurrentCell.RowIndex].Value); int idPassEmp = Convert.ToInt16(dataAll[8, dataAll.CurrentCell.RowIndex].Value); logEmp.RemoveEmployee(idEmployee, idPassEmp); UpdateTable(); //if (result == DialogResult.Yes) //{ // foreach (DataGridViewRow row in dataAll.SelectedRows) // { // Employee employee = new Employee(); // if (employee == null) // continue; // Employee dbEmployee = My.Employees.Find(employee.Id); // My.Employees.Remove(dbEmployee); // } // My.SaveChanges(); // UpdateTable(); //} break; case Tables.Order: if (result == DialogResult.Yes) { foreach (DataGridViewRow row in dataAll.SelectedRows) { Order order = row.DataBoundItem as Order; if (order == null) { continue; } Order dborder = My.Orders.Find(order.Id); My.Orders.Remove(dborder); } My.SaveChanges(); UpdateTable(); } break; default: break; } }