private void RememberChenged()
{
int restorationID = (int)RestorationListBox.SelectedValue;
string nameText = CFunc.CheckTextBox(this, RestorerNameTextBox.Text, EnterNameRestorations);
if (nameText == "")
{
return;
}
if (indexNewRestorer == 0)
{
CFunc.ShowMessage(ChooseNewRestorer);
return;
}
if (indexNewExhibit == 0)
{
CFunc.ShowMessage(ChooseNewExhibit);
return;
}
if (photoFilePath != "NOTHING" || photoFilePath != null)
{
dataset.Exhibit.Rows.Find(restorationID)["Photo"] = photoFilePath;
photoFilePath = "";
}
dataset.Restoration.Rows.Find(restorationID)["Name"] = RestorerNameTextBox.Text;
dataset.Restoration.Rows.Find(restorationID)["ExhibitID"] = RestorationRestorerComboBox.SelectedValue;
dataset.Restoration.Rows.Find(restorationID)["RestorerID"] = comboBoxExhibit.SelectedValue;
dataset.Restoration.Rows.Find(restorationID)["Start"] = RestorationStart.Value;
dataset.Restoration.Rows.Find(restorationID)["End"] = RestorationEnd.Value;
dataset.Restoration.Rows.Find(restorationID)["Photo"] = photoFilePath;
dataset.Restoration.Rows.Find(restorationID)["Description"] = descriptionTextBox.Text;
getRestorationList() = new DataView(dataset.Restoration);
}
private void CreateNewRestorer()
{
var newExhibit = dataset.Restoration.NewRow();
if (indexRestorer == 0)
{
CFunc.ShowMessage("Выберите реставратора!");
return;
}
newExhibit["RestorerID"] = RestorationRestorerComboBox.SelectedValue;
if (indexExhibit == 0)
{
CFunc.ShowMessage("Выберите экспонат!");
return;
}
newExhibit["ExhibitID"] = comboBoxExhibit.SelectedValue;
newExhibit["Start"] = RestorationStart.Value;
newExhibit["End"] = RestorationEnd.Value;
if (photoFilePath == "NOTHING")
{
CFunc.ShowMessage("Выберите фотографию!");
return;
}
newExhibit["Photo"] = photoFilePath;
newExhibit["Description"] = descriptionTextBox.Text;
dataset.Restoration.Rows.Add(newExhibit);
}
private void SaveButton_Click(object sender, EventArgs e)
{
DataView tempView = new DataView(dataset.Rent);
tempView.RowFilter = "ExhibitID = " + ExhibitCombo.SelectedValue;
for (int i = 0; i < tempView.Count; i++)
{
DateTime temp1 = (DateTime)tempView[i]["Start"];
DateTime temp2 = (DateTime)tempView[i]["End"];
int tempInt = (int)tempView[i]["ID"];
int tempExhibitID = (int)tempView[i]["ExhibitID"];
if (temp1 <= rentStart.Value && temp2 >= rentStart.Value || temp1 <= rentEnd.Value && temp2 >= rentEnd.Value)
{
if (tempInt != rentIndex)
{
CFunc.ShowMessage("В указанный период данный экспонат находится в аренде в музее '" + dataset.Museum.Rows.Find(tempView[i]["MuseumID"])["Name"] + "'!!!");
return;
}
}
}
dataset.Rent.Rows.Find(rentIndex)["MuseumID"] = museumtenantComboBox.SelectedValue;
dataset.Rent.Rows.Find(rentIndex)["Start"] = rentStart.Value;
dataset.Rent.Rows.Find(rentIndex)["End"] = rentEnd.Value;
dataset.Rent.Rows.Find(rentIndex)["ExhibitID"] = ExhibitCombo.SelectedValue;
saveButton.Enabled = false;
setExhibitListBox();
}
private void AddMuseum_Click(object sender, EventArgs e)
{
string nameText = CFunc.CheckTextBox(this, NameMuseum.Text, EnterNameMuseum);
if (nameText == "")
{
return;
}
foreach (DataRow item in dataset.Museum)
{
if (item["Name"].ToString() == nameText)
{
CFunc.ShowMessage("Музей '" + nameText + "' уже существует!");
return;
}
}
var dr = dataset.Museum.NewRow();
dr["Name"] = nameText;
dataset.Museum.Rows.Add(dr);
ExW.SaveToDataBase();
DataView tempMuseum = new DataView(dataset.Museum);
tempMuseum.RowFilter = "Name = " + "'" + nameText + "'";
var newRow = dataset.Crutch.NewRow();
newRow["From"] = "Museum";
newRow["InstanceID"] = tempMuseum[0][0];
dataset.Crutch.Rows.Add(newRow);
ChangeMuseum.Enabled = false;
ExW.SaveToDataBase();
}
private void ChangeMaecenas_Click(object sender, EventArgs e)
{
if (idListBox != 0)
{
string nameText = CFunc.CheckTextBox(this, NameMaecenas.Text, EnterNameMaecenas);
if (nameText == "")
{
return;
}
dataset.Maecenas.Rows.Find(idListBox)["Name"] = NameMaecenas.Text;
canChooseMaecenas = true;
MaecenasListBox.DataSource = dataset.Maecenas;
}
else
{
CFunc.ShowMessage(NeedChooseMaecenas);
}
}
private void addButton_Click(object sender, EventArgs e)
{
string nameText = CFunc.CheckTextBox(this, nameTextBox.Text, EnterNameShowRoom);
if (nameText == "")
{
return;
}
foreach (DataRow item in dataset.Showroom)
{
if (item["Name"].ToString() == nameText)
{
CFunc.ShowMessage("Зал '" + nameText + "' уже существует!");
return;
}
}
var dr = dataset.Showroom.NewRow();
dr["Name"] = nameTextBox.Text;
dataset.Showroom.Rows.Add(dr);
}
private void deleteButton_Click(object sender, EventArgs e)
{
canChooseRestorer = false;
if (idListBox != 0)
{
nameTextBox.Text = "";
dataset.Restorer.Rows.Find(idListBox).Delete();
idListBox = 0;
}
else
{
CFunc.ShowMessage(ChooseRestorer);
}
canChooseRestorer = true;
}
private void CreateNewExhibit()
{
var newExhibit = dataset.Exhibit.NewRow();
DateTime temp = appearanceDate.Value;
string nameText = CFunc.CheckTextBox(this, nameTextBox.Text, EnterNameExhibit);
if (nameText == "")
{
return;
}
newExhibit["Name"] = nameText;
newExhibit["CategoryID"] = comboBoxExhibitCategor.SelectedValue;
nameText = CFunc.CheckTextBox(this, nameTextBox.Text, EnterCreationDate);
if (nameText == "")
{
return;
}
newExhibit["CreatedDate"] = dateCreationTextBox.Text;
newExhibit["AppearanceDate"] = appearanceDate.Value;
if (photoFilePath == "NOTHING")
{
CFunc.ShowMessage("Выберите фотографию!");
return;
}
newExhibit["Photo"] = photoFilePath;
newExhibit["Description"] = descriptionTextBox.Text;
int getFromID = (int)comboBoxGetFrom.SelectedValue;
string crutchFilter = "[From] = '" + tableNameDaritel + "' " + "AND InstanceID = " + getFromID;
DataView tempCrutch = new DataView(dataset.Crutch);
tempCrutch.RowFilter = crutchFilter;
newExhibit["CrutchID"] = (int)tempCrutch[0][0];
dataset.Exhibit.Rows.Add(newExhibit);
}