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;
}
}
