public Request(List <ClassResource.Company> companies, ClassResource.Request selectRequest, String name, String phone)
{
InitializeComponent();
COMPANIES = companies;
this.Title = "Просмотр заявки - Forwarder Tools 1.0";
mainTitle.Content = "Просмотр заявки №" + selectRequest.Number;
lText.Content = "Изменение каких-либо данных не поддерживается.";
tbEngineerName.Text = name;
tbEngineerPhone.Text = phone;
cbCompany.Items.Clear();
if (COMPANIES != null)
{
foreach (ClassResource.Company item in COMPANIES)
{
cbCompany.Items.Add(item.Name);
}
}
tbNumber.Text = selectRequest.Number;
tbProductName.Text = selectRequest.ProductName;
tbWeight.Text = selectRequest.ProductWeight;
tbDimensions.Text = selectRequest.ProductDimensions;
tbQuantity.Text = selectRequest.Quantity;
tbNote.Text = selectRequest.Note;
cbCompany.SelectedItem = companies.Find(x => x.ID == selectRequest.IDCompany).Name;
dpDate.Text = selectRequest.Date;
bAdd.Visibility = Visibility.Hidden;
bCancel.Visibility = Visibility.Hidden;
}
public void UpdateRequest(String stringRequest, User user)
{
if (user.AuthSuccess == true && (user.UserRole == "Инженер" || user.UserRole == "Администратор"))
{
ClassResource.Request request = JsonConvert.DeserializeObject <ClassResource.Request>(stringRequest);
DatabaseWork.ExecuteUpdate("UPDATE Requests SET " +
"[Product weight] = N'" + request.ProductWeight + "'," +
"[Product dimensions] = N'" + request.ProductDimensions + "'," +
"[Quantity] = '" + request.Quantity + "' " +
"WHERE [ID request] = '" + request.ID + "'");
Server.UpdateRequests();
}
else
{
Functions.AddJournalEntry($": __ATTENTION__ {user.UserID} {user.UserName} Попытка доступа без соответствующих прав.");
}
}
private void BAdd_Click(object sender, RoutedEventArgs e)
{
if (tbNumber.Text == "" || tbProductName.Text == "" || tbWeight.Text == "" || tbDimensions.Text == "" || tbQuantity.Text == "" || cbCompany.SelectedIndex < 0)
{
lErrorMessage.Content = "Заполните все поля, помеченные *";
return;
}
if (!Int32.TryParse(tbQuantity.Text, out int temp))
{
lErrorMessage.Content = "Неправильно заполнено поле \"Количество\"";
return;
}
ClassResource.Request request = new ClassResource.Request(null, tbNumber.Text, tbProductName.Text, tbWeight.Text, tbDimensions.Text, tbQuantity.Text, COMPANIES[cbCompany.SelectedIndex].ID, null, tbNote.Text, null);
Sources.Client.SendMessage("AddRequest", new String[] { JsonConvert.SerializeObject(request) });
this.Close();
}
public void AddRequest(String stringRequest, User user)
{
if (user.AuthSuccess == true && user.UserRole == "Инженер")
{
ClassResource.Request request = JsonConvert.DeserializeObject <ClassResource.Request>(stringRequest);
DatabaseWork.ExecuteUpdate("INSERT INTO Requests ([Number], [Product name], [Product weight], [Product dimensions], [Quantity], [ID company], [ID engineer], [Note]) VALUES (" +
"N'" + request.Number + "'," +
"N'" + request.ProductName + "'," +
"N'" + request.ProductWeight + "'," +
"N'" + request.ProductDimensions + "'," +
"'" + request.Quantity + "'," +
"'" + request.IDCompany + "'," +
"'" + user.UserSnapping + "'," +
"N'" + request.Note + "')");
Server.UpdateRequests();
}
else
{
Functions.AddJournalEntry($": __ATTENTION__ {user.UserID} {user.UserName} Попытка доступа без соответствующих прав.");
}
}
