public bool setShowroom(DataSetMuseum dataSet)
{
bool result = false;
Connection connection = new Connection();
connection.Open();
try
{
Transaction transaction = connection.BeginTransaction();
try
{
showroom = new Showroom();
showroom.Save(dataSet, connection, transaction);
transaction.Commit();
result = true;
}
catch (Exception ex)
{
ShowError(ex.ToString());
transaction.Rollback();
result = false;
}
}
finally
{
connection.Close();
}
return(result);
}
public Restoration(Exhibit tempExhibitWindow, ref DataSetMuseum tempDataset, ref ControlFunction tempConrolFunction)
{
InitializeComponent();
dataset = tempDataset;
ExW = tempExhibitWindow;
CFunc = tempConrolFunction;
UpdateDataView();
photoPictureBox.SizeMode = PictureBoxSizeMode.Zoom;
photoPictureBox.Image = Image.FromFile("Pictures/DefaultImage.jpg");
restorerComboBox.DataSource = dataset.Restorer;
restorerComboBox.DisplayMember = "Name";
restorerComboBox.ValueMember = "ID";
RestorationListBox.DataSource = null;
RestorationListBox.DisplayMember = "Name";
RestorationListBox.ValueMember = "ID";
RestorationRestorerComboBox.DataSource = null;
RestorationRestorerComboBox.DisplayMember = "Name";
RestorationRestorerComboBox.ValueMember = "ID";
comboBoxExhibit.DataSource = null;
comboBoxExhibit.DisplayMember = "Name";
comboBoxExhibit.ValueMember = "ID";
canChooseComboRestorer = true;
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Rent (ExhibitID, MuseumID, Start, [End]) " +
"VALUES (@ExhibitID, @MuseumID, @Start, @End);"),
conn.getConnection(), tr.getTransaction());
dataAdapter.InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.InsertCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.InsertCommand.Parameters.Add("@MuseumID", SqlDbType.Int, 11, "MuseumID");
dataAdapter.InsertCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.InsertCommand.Parameters.Add("@End", SqlDbType.DateTime, 11, "End");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Rent SET ExhibitID = @ExhibitID, MuseumID = @MuseumID, Start = @Start, [End] = @End WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.UpdateCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.UpdateCommand.Parameters.Add("@MuseumID", SqlDbType.Int, 11, "MuseumID");
dataAdapter.UpdateCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.UpdateCommand.Parameters.Add("@End", SqlDbType.DateTime, 11, "End");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Rent WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.DeleteCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.DeleteCommand.Parameters.Add("@MuseumID", SqlDbType.Int, 11, "MuseumID");
dataAdapter.DeleteCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.DeleteCommand.Parameters.Add("@End", SqlDbType.DateTime, 11, "End");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Rent.TableName);
return((countUpdate > 0) ? true : false);
}
private void loadDataFromBase()
{
dataset = new DataSetMuseum();
dataset.Merge(logic.getExhibition());
dataset.Merge(logic.getExhibit());
dataset.Merge(logic.getExhibit_Exhibition());
}
public DataSetMuseum getCategory()
{
DataSetMuseum result = new DataSetMuseum();
Connection connection = new Connection();
connection.Open();
try
{
Transaction transaction = connection.BeginTransaction();
try
{
category = new Category();
category.Read(result, connection, transaction);
transaction.Commit();
}
catch (Exception ex)
{
ShowError(ex.ToString());
transaction.Rollback();
result = null;
}
}
finally
{
connection.Close();
}
return(result);
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Exhibition (Name, Start, [End], ShowroomID) " +
"VALUES (@Name, @Start, @[End], @ShowroomID);"),
conn.getConnection(), tr.getTransaction());
dataAdapter.InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.InsertCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 255, "Name");
dataAdapter.InsertCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.InsertCommand.Parameters.Add("@[End]", SqlDbType.DateTime, 11, "[End]");
dataAdapter.InsertCommand.Parameters.Add("@ShowroomID", SqlDbType.Int, 11, "ShowroomID");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Exhibition SET Name = @Name, Start = @Start, [End] = @[End], ShowroomID = @ShowroomID WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.UpdateCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 255, "Name");
dataAdapter.UpdateCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.UpdateCommand.Parameters.Add("@[End]", SqlDbType.DateTime, 11, "[End]");
dataAdapter.UpdateCommand.Parameters.Add("@ShowroomID", SqlDbType.Int, 11, "ShowroomID");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Exhibition WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.DeleteCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 255, "Name");
dataAdapter.DeleteCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.DeleteCommand.Parameters.Add("@[End]", SqlDbType.DateTime, 11, "[End]");
dataAdapter.DeleteCommand.Parameters.Add("@ShowroomID", SqlDbType.Int, 11, "ShowroomID");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Exhibition.TableName);
return((countUpdate > 0) ? true : false);
}
public Exhibition(Exhibit tempExhibitWindow, ref DataSetMuseum tempDataset)
{
InitializeComponent();
dataset = tempDataset;
ExW = tempExhibitWindow;
exhibitionListBox.DataSource = dataset.Exhibition;
exhibitionListBox.DisplayMember = "Name";
exhibitionListBox.ValueMember = "ID";
}
public Museum(Exhibit tempExhibitWindow, ref DataSetMuseum tempDataset, ref ControlFunction tempConrolFunction)
{
InitializeComponent();
ExW = tempExhibitWindow; ExW.Enabled = false;
dataset = tempDataset;
CFunc = tempConrolFunction;
MuseumListBox.DataSource = dataset.Museum;
MuseumListBox.DisplayMember = "Name";
MuseumListBox.ValueMember = "ID";
canChooseMuseum = true;
}
public Restorer(Exhibit tempExhibitWindow, ref DataSetMuseum tempDataset, ref ControlFunction tempConrolFunction)
{
InitializeComponent();
dataset = tempDataset;
ExW = tempExhibitWindow;
CFunc = tempConrolFunction;
RestorerListBox.DataSource = dataset.Restorer;
RestorerListBox.DisplayMember = "Name";
RestorerListBox.ValueMember = "ID";
canChooseRestorer = true;
}
public Showroom(Exhibit tempExhibitWindow, ref DataSetMuseum tempDataset, ref ControlFunction tempConrolFunction)
{
InitializeComponent();
dataset = tempDataset;
ExW = tempExhibitWindow;
CFunc = tempConrolFunction;
showroomListBox.DataSource = dataset.Showroom;
showroomListBox.DisplayMember = "Name";
showroomListBox.ValueMember = "ID";
canChooseShowroom = true;
}
private void LoadDataFromBase()
{
dataset = new DataSetMuseum();
dataset.Merge(logic.getMaecenas());
dataset.Merge(logic.getRestorer());
dataset.Merge(logic.getMuseum());
dataset.Merge(logic.getCrutch());
dataset.Merge(logic.getCategory());
dataset.Merge(logic.getShowroom());
dataset.Merge(logic.getExhibit());
dataset.Merge(logic.getExhibition());
dataset.Merge(logic.getExhibit_Exhibition());
dataset.Merge(logic.getRent());
dataset.Merge(logic.getRestoration());
}
public Rent(Exhibit tempExhibitWindow, ref DataSetMuseum tempDataset, ref ControlFunction tempConrolFunction)
{
InitializeComponent();
SetControlDefault();
dataset = tempDataset;
ExW = tempExhibitWindow;
CFunc = tempConrolFunction;
museumComboBox.DataSource = dataset.Museum;
museumComboBox.DisplayMember = "Name";
museumComboBox.ValueMember = "ID";
canChooseAnyMuseum = true;
}
public ExhibitAdd(Exhibit tempExhibitWindow, ref DataSetMuseum tempDtaset, ref ControlFunction tempControlFunction)
{
InitializeComponent();
EW = tempExhibitWindow;
dataset = tempDtaset;
CFunc = tempControlFunction;
comboBoxGetFrom.DisplayMember = "Name";
comboBoxGetFrom.ValueMember = "ID";
comboBoxExhibitCategor.DataSource = dataset.Category;
comboBoxExhibitCategor.DisplayMember = "Name";
comboBoxExhibitCategor.ValueMember = "ID";
radioMuseum.Checked = false;
radioMaecenas.Checked = false;
}
public RestorationAdd(Restoration tempRestorationWindow, ref DataSetMuseum tempDataset, ref ControlFunction tempControlFunction)
{
InitializeComponent();
RW = tempRestorationWindow;
dataset = tempDataset;
CFunc = tempControlFunction;
RestorationRestorerComboBox.DataSource = dataset.Restorer;
RestorationRestorerComboBox.DisplayMember = "Name";
RestorationRestorerComboBox.ValueMember = "ID";
comboBoxExhibit.DataSource = dataset.Exhibit;
comboBoxExhibit.DisplayMember = "Name";
comboBoxExhibit.ValueMember = "ID";
CanChooseRestorer = true;
CanChooseExhibit = true;
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Restorer (Name) VALUES (@Name);"), conn.getConnection(), tr.getTransaction());
dataAdapter.InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.InsertCommand.Parameters.Add("@Name", SqlDbType.NChar, 50, "Name");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Restorer SET Name = @Name WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.UpdateCommand.Parameters.Add("@Name", SqlDbType.NChar, 50, "Name");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Restorer WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.DeleteCommand.Parameters.Add("@Name", SqlDbType.NChar, 50, "Name");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Restorer.TableName);
return((countUpdate > 0) ? true : false);
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Exhibit_Exhibition (ExhibitID, ExhibitionID) " +
"VALUES (@ExhibitID, @ExhibitionID);"),
conn.getConnection(), tr.getTransaction());
dataAdapter.InsertCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.InsertCommand.Parameters.Add("@ExhibitionID", SqlDbType.Int, 11, "ExhibitionID");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Exhibit_Exhibition SET ExhibitID = @ExhibitID WHERE ExhibitionID = @ExhibitionID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.UpdateCommand.Parameters.Add("@ExhibitionID", SqlDbType.Int, 11, "ExhibitionID");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Exhibit_Exhibition WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.DeleteCommand.Parameters.Add("@ExhibitionID", SqlDbType.Int, 11, "ExhibitionID");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Exhibit_Exhibition.TableName);
return((countUpdate > 0) ? true : false);
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Crutch ([From], InstanceID) VALUES (@From, @InstanceID);"), conn.getConnection(), tr.getTransaction());
dataAdapter.InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.InsertCommand.Parameters.Add("@From", SqlDbType.NChar, 50, "From");
dataAdapter.InsertCommand.Parameters.Add("@InstanceID", SqlDbType.Int, 11, "InstanceID");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Crutch SET [From] = @From, InstanceID = @InstanceID WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.UpdateCommand.Parameters.Add("@From", SqlDbType.NChar, 50, "From");
dataAdapter.UpdateCommand.Parameters.Add("@InstanceID", SqlDbType.Int, 11, "InstanceID");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Crutch WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.DeleteCommand.Parameters.Add("@From", SqlDbType.NChar, 50, "From");
dataAdapter.DeleteCommand.Parameters.Add("@InstanceID", SqlDbType.Int, 11, "InstanceID");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Crutch.TableName);
return((countUpdate > 0) ? true : false);
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Exhibit (Name, CategoryID, CreatedDate, AppearanceDate, Photo, Description, CrutchID) " +
"VALUES (@Name, @CategoryID, @CreatedDate, @AppearanceDate, @Photo, @Description, @CrutchID);"),
conn.getConnection(), tr.getTransaction());
//dataAdapter.InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.InsertCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 50, "Name");
dataAdapter.InsertCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 11, "CategoryID");
dataAdapter.InsertCommand.Parameters.Add("@CreatedDate", SqlDbType.NVarChar, 50, "CreatedDate");
dataAdapter.InsertCommand.Parameters.Add("@AppearanceDate", SqlDbType.DateTime, 11, "AppearanceDate");
dataAdapter.InsertCommand.Parameters.Add("@Photo", SqlDbType.NVarChar, 255, "Photo");
dataAdapter.InsertCommand.Parameters.Add("@Description", SqlDbType.NText, 10000, "Description");
dataAdapter.InsertCommand.Parameters.Add("@CrutchID", SqlDbType.Int, 11, "CrutchID");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Exhibit SET Name = @Name, CategoryID = @CategoryID, CreatedDate = @CreatedDate, AppearanceDate = @AppearanceDate, Photo = @Photo, Description = @Description, CrutchID = @CrutchID WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.UpdateCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 50, "Name");
dataAdapter.UpdateCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 11, "CategoryID");
dataAdapter.UpdateCommand.Parameters.Add("@CreatedDate", SqlDbType.NVarChar, 50, "CreatedDate");
dataAdapter.UpdateCommand.Parameters.Add("@AppearanceDate", SqlDbType.DateTime, 11, "AppearanceDate");
dataAdapter.UpdateCommand.Parameters.Add("@Photo", SqlDbType.NVarChar, 255, "Photo");
dataAdapter.UpdateCommand.Parameters.Add("@Description", SqlDbType.NText, 10000, "Description");
dataAdapter.UpdateCommand.Parameters.Add("@CrutchID", SqlDbType.Int, 11, "CrutchID");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Exhibit WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.DeleteCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 50, "Name");
dataAdapter.DeleteCommand.Parameters.Add("@CategoryID", SqlDbType.Int, 11, "CategoryID");
dataAdapter.DeleteCommand.Parameters.Add("@CreatedDate", SqlDbType.NVarChar, 50, "CreatedDate");
dataAdapter.DeleteCommand.Parameters.Add("@AppearanceDate", SqlDbType.DateTime, 11, "AppearanceDate");
dataAdapter.DeleteCommand.Parameters.Add("@Photo", SqlDbType.NVarChar, 255, "Photo");
dataAdapter.DeleteCommand.Parameters.Add("@Description", SqlDbType.NText, 10000, "Description");
dataAdapter.DeleteCommand.Parameters.Add("@CrutchID", SqlDbType.Int, 11, "CrutchID");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Exhibit.TableName);
return((countUpdate > 0) ? true : false);
}
public bool Save(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.InsertCommand = new System.Data.SqlClient.SqlCommand(string.Format("INSERT INTO Restoration (Name, ExhibitID, RestorerID, Start, [End], Photo, Description) " +
"VALUES (@Name, @ExhibitID, @RestorerID, @Start, @[End], @Photo, @Description);"),
conn.getConnection(), tr.getTransaction());
dataAdapter.InsertCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.InsertCommand.Parameters.Add("@Name", SqlDbType.NChar, 255, "Name");
dataAdapter.InsertCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.InsertCommand.Parameters.Add("@RestorerID", SqlDbType.Int, 11, "RestorerID");
dataAdapter.InsertCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.InsertCommand.Parameters.Add("@[End]", SqlDbType.DateTime, 11, "[End]");
dataAdapter.InsertCommand.Parameters.Add("@Photo", SqlDbType.NChar, 255, "Photo");
dataAdapter.InsertCommand.Parameters.Add("@Description", SqlDbType.NText, 10000, "Description");
dataAdapter.UpdateCommand = new System.Data.SqlClient.SqlCommand(string.Format("UPDATE Restoration SET Name = @Name, ExhibitID = @ExhibitID, RestorerID = @RestorerID, Start = @Start, [End] = @[End], Photo = @Photo, Description = @Description WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.UpdateCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.UpdateCommand.Parameters.Add("@Name", SqlDbType.NChar, 255, "Name");
dataAdapter.UpdateCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.UpdateCommand.Parameters.Add("@RestorerID", SqlDbType.Int, 11, "RestorerID");
dataAdapter.UpdateCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.UpdateCommand.Parameters.Add("@[End]", SqlDbType.DateTime, 11, "[End]");
dataAdapter.UpdateCommand.Parameters.Add("@Photo", SqlDbType.NChar, 255, "Photo");
dataAdapter.UpdateCommand.Parameters.Add("@Description", SqlDbType.NText, 10000, "Description");
dataAdapter.DeleteCommand = new System.Data.SqlClient.SqlCommand(string.Format("DELETE FROM Restoration WHERE ID = @ID;"), conn.getConnection(), tr.getTransaction());
dataAdapter.DeleteCommand.Parameters.Add("@ID", SqlDbType.Int, 11, "ID");
dataAdapter.DeleteCommand.Parameters.Add("@Name", SqlDbType.NChar, 255, "Name");
dataAdapter.DeleteCommand.Parameters.Add("@ExhibitID", SqlDbType.Int, 11, "ExhibitID");
dataAdapter.DeleteCommand.Parameters.Add("@RestorerID", SqlDbType.Int, 11, "RestorerID");
dataAdapter.DeleteCommand.Parameters.Add("@Start", SqlDbType.DateTime, 11, "Start");
dataAdapter.DeleteCommand.Parameters.Add("@[End]", SqlDbType.DateTime, 11, "[End]");
dataAdapter.DeleteCommand.Parameters.Add("@Photo", SqlDbType.NChar, 255, "Photo");
dataAdapter.DeleteCommand.Parameters.Add("@Description", SqlDbType.NText, 10000, "Description");
var countUpdate = dataAdapter.Update(dataSet, dataSet.Restoration.TableName);
return((countUpdate > 0) ? true : false);
}
public Exhibit()
{
InitializeComponent();
ChangeActivityControl();
dataset = new DataSetMuseum();
LoadDataFromBase();
exhibitsCategor = new DataView(dataset.Category);
comboBoxExhibitCategor.DataSource = null;
categoryComboBox.DataSource = dataset.Category;
categoryComboBox.DisplayMember = "Name";
categoryComboBox.ValueMember = "ID";
pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;
pictureBox1.Image = Image.FromFile("Pictures/DefaultImage.jpg");
canChooseListBox = true;
canChooseCombo = true;
canChooseComboBoxGetFrom = true;
canChooseComboBoxExhibitCategor = true;
}
public void Read(DataSetMuseum dataSet, Connection conn, Transaction tr)
{
dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = new System.Data.SqlClient.SqlCommand("SELECT * FROM Restorer", conn.getConnection(), tr.getTransaction());
dataAdapter.Fill(dataSet, "Restorer");
}