public void UpdateSertificatesGrid()
{
_sertificates.RemoveRange(0, _sertificates.Count);
_sertificates.
AddRange(Sertificate.GetAllEntities());
sertificatesGrid.ItemsSource = null;
sertificatesGrid.ItemsSource = _sertificates;
}
private void GetSertificatesFromDB()
{
try
{
_sertificates.
AddRange(
Sertificate.
GetAllEntities()
);
}
catch (NoSuchDataException) { }
}
protected override void OnApplyButton(object sender, RoutedEventArgs info)
{
RestoreFieldsBordersColor(inputsLayout);
HidePopupMessage(mainLayout);
if (IsThereEmptyFields(inputsLayout))
{
MakeEmptyFieldsRed(inputsLayout);
ShowPopupMessage("Не все поля заполнены", mainLayout);
return;
}
var newSertificate = new Sertificate()
{
SubjectName = subjectNameBox.Text,
SerialNumber = int.Parse(serialNumberBox.Text),
ValidFromDateTime = DateTime.Parse(validFromBox.Text),
ValidUntilDateTime = DateTime.Parse(validUntilBox.Text)
};
try
{
Sertificate.Edit(
SelectedSertificate(),
newSertificate
);
parentWindow.UpdateSertificatesGrid();
CloseThisWindow();
}
catch (DataAlreadyExistException e)
{
MakeRedBorders(serialNumberBox);
ShowPopupMessage(e.Message, mainLayout);
}
catch (ConnectionLostException e) { ShowPopupMessage(e.Message, mainLayout); }
catch (FormatException e)
{
if (e.TargetSite.Name == "ThrowOverflowOrFormatException")
{
MakeRedBorders(serialNumberBox);
ShowPopupMessage("Неверное значение серийного номера", mainLayout);
}
else
{
MakeRedBorders(validFromBox);
MakeRedBorders(validUntilBox);
ShowPopupMessage("Некорректная дата", mainLayout);
}
}
}
public void MakeOrder(OrderDTO data)
{
Sertificate dalDataSert = Database.Sertificates.Get(data.SertificateId);
if (dalDataSert == null)
{
throw new ValidationException("Data - status ids` is not found", "");
}
Order DATA = new Order
{
UserName = data.UserName,
SertificateId = data.SertificateId,
NumberOfUsers = data.NumberOfUsers,
};
Database.Orders.Create(DATA);
Database.Save();
}
private void OnDeleteSertificate(object sender, RoutedEventArgs rea)
{
try
{
HidePopupMessage(mainLayout);
if (sertificatesGrid.SelectedItem == null)
{
throw new NullReferenceException("Выберите сертификат из списка");
}
Sertificate.Delete(
sertificatesGrid.SelectedItem as Sertificate
);
UpdateSertificatesGrid();
}
catch (NullReferenceException e)
{
ShowPopupMessage(e.Message, mainLayout);
}
}
public void MakeSertificate(SertificateDTO sertificateDTO)
{
Sertificate sertificate = Database.Sertificates.Get(sertificateDTO.MySertificateId);
if (sertificate == null)
{
Sertificate newSertificate = new Sertificate
{
MySertificateId = sertificateDTO.MySertificateId,
EstimatedTime = sertificateDTO.EstimatedTime,
Name = sertificateDTO.Name,
SertificateTag = sertificateDTO.SertificateTag,
Creator = sertificateDTO.Creator,
Owner = sertificateDTO.Owner,
Validator = sertificateDTO.Validator,
QualityDocument = sertificateDTO.QualityDocument,
Items = sertificateDTO.Items,
ValidateTime = sertificateDTO.ValidateTime
};
Database.Sertificates.Create(newSertificate);
}
else
{
sertificate.EstimatedTime = sertificateDTO.EstimatedTime;
sertificate.Name = sertificateDTO.Name;
sertificate.SertificateTag = sertificateDTO.SertificateTag;
sertificate.Creator = sertificateDTO.Creator;
sertificate.Owner = sertificateDTO.Owner;
sertificate.Validator = sertificateDTO.Validator;
sertificate.QualityDocument = sertificateDTO.QualityDocument;
sertificate.Items = sertificateDTO.Items;
sertificate.ValidateTime = sertificateDTO.ValidateTime;
Database.Sertificates.Update(sertificate);
}
Database.Save();
}
protected override void OnApplyButton(object sender, RoutedEventArgs info)
{
RestoreFieldsBordersColor(inputsLayout);
HidePopupMessage(mainLayout);
if (IsThereEmptyFields(inputsLayout))
{
MakeEmptyFieldsRed(inputsLayout);
ShowPopupMessage("Не все поля заполнены", mainLayout);
return;
}
try
{
var newSertificate = new Sertificate()
{
SubjectName = subjectNameBox.Text,
SerialNumber = int.Parse(serialNumberBox.Text),
ValidFromDateTime = DateTime.ParseExact(
validFromBox.Text,
dateFormats,
CultureInfo.InvariantCulture
),
ValidUntilDateTime = DateTime.ParseExact(validUntilBox.Text,
dateFormats,
CultureInfo.InvariantCulture
),
};
Sertificate.Write(newSertificate);
HidePopupMessage(mainLayout);
ShowPopupMessage("Сертификат добавлен", mainLayout);
RestoreFieldsBordersColor(inputsLayout);
ClearInputFields(inputsLayout);
parentWindow.UpdateSertificatesGrid();
parentWindow.Show();
}
catch (DataAlreadyExistException e)
{
MakeRedBorders(serialNumberBox);
ShowPopupMessage(e.Message, mainLayout);
}
catch (ConnectionLostException e) { ShowPopupMessage(e.Message, mainLayout); }
catch (FormatException e)
{
if (e.TargetSite.Name == "ThrowOverflowOrFormatException")
{
MakeRedBorders(serialNumberBox);
ShowPopupMessage("Неверное значение серийного номера", mainLayout);
}
else
{
MakeRedBorders(validFromBox);
MakeRedBorders(validUntilBox);
ShowPopupMessage("Некорректная дата", mainLayout);
}
}
catch (OverflowException)
{
MakeRedBorders(serialNumberBox);
ShowPopupMessage("Серийный номер слишком больой", mainLayout);
}
}
public void SetUp()
{
times = new List <TimeCategory>
{
new TimeCategory()
{
Id = 1,
},
new TimeCategory()
{
Id = 2,
},
new TimeCategory()
{
Id = 3,
},
new TimeCategory()
{
Id = 4,
},
};
statuses = new List <Status>
{
new Status()
{
Id = 1, OrderId = 1, KvestRoomId = 1, TimeCategoryId = 1
},
new Status()
{
Id = 2, OrderId = 2, KvestRoomId = 1, TimeCategoryId = 4
},
new Status()
{
Id = 3, OrderId = 3, KvestRoomId = 2, TimeCategoryId = 3
},
new Status()
{
Id = 4, OrderId = 4, KvestRoomId = 3, TimeCategoryId = 2
},
};
orders = new List <Order>
{
new Order()
{
Id = 1, SertificateId = 1, UserName = "******", NumberOfUsers = 5,
},
new Order()
{
Id = 2, SertificateId = 5, UserName = "******", NumberOfUsers = 3,
},
new Order()
{
Id = 3, SertificateId = 6, UserName = "******", NumberOfUsers = 10,
},
};
serts = new List <Sertificate>
{
new Sertificate()
{
Id = 1, SertificateNumber = 3,
},
new Sertificate()
{
Id = 2, SertificateNumber = 25,
},
new Sertificate()
{
Id = 3, SertificateNumber = 44,
},
};
kvestroom = new KvestRoom()
{
Id = 1, AgeCategoryId = 1, UsersValueId = 1, Name = "GP", PriceForOneUser = 200
};
time = new TimeCategory()
{
Id = 1,
};
sert = new Sertificate()
{
Id = 1, SertificateNumber = 33,
};
}
