private void readButton_Click(object sender, EventArgs e)
{
try {
string itemID = readOneTextBox.Text;
int id = Convert.ToInt32(itemID);
Item newItem = new Item(id);
SofwareItem newSoft = new SofwareItem(id);
HardwareItem newhard = new HardwareItem(id);
Computer newComp = new Computer(id);
Monitor newmon = new Monitor(id);
ItemsDatabase db = new ItemsDatabase();
MessageBox.Show(db.readItem(id) + " " + db.readHardware(id) + " " + db.readSoftware(id) + " " + db.readComp(id) + " " + db.readMon(id));
}
catch
{
MessageBox.Show("Try again");
}
}
public void listaUp()
{
if (licenceTextBox.Text != "" || sizeMbTextBox.Text != "")
{
string itemID = itemIDTextBox.Text;
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
int id;
int.TryParse(itemID, out id);
string licence = licenceTextBox.Text;
int size = Convert.ToInt32(sizeMbTextBox.Text);
SofwareItem newItem = new SofwareItem(id, price, itemName, licence, size);
ItemsDatabase db = new ItemsDatabase();
db.updateSoftware(id, newItem);
MessageBox.Show("Updated");
}
if (weightTextBox.Text != "")
{
string itemID = itemIDTextBox.Text;
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
int id;
int.TryParse(itemID, out id);
double weight;
Double.TryParse(weightTextBox.Text, out weight);
HardwareItem newItem = new HardwareItem(id, price, itemName, weight);
ItemsDatabase db = new ItemsDatabase();
db.updateHardware(id, newItem);
MessageBox.Show("Updated");
}
if (noOfCoresTextBox.Text != "" || ramTextBox.Text != "" || hddTextBox.Text != "")
{
string itemID = itemIDTextBox.Text;
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
int id;
int.TryParse(itemID, out id);
int ram = Convert.ToInt32(ramTextBox.Text);
int cores = Convert.ToInt32(noOfCoresTextBox.Text);
int hdd = Convert.ToInt32(hddTextBox.Text);
Computer newItem = new Computer(id, itemName, price, cores, ram, hdd);
ItemsDatabase db = new ItemsDatabase();
db.updateComp(id, newItem);
MessageBox.Show("Updated");
}
if (resolutionTextBox.Text != "" || monTypeTextBox.Text != "")
{
string itemID = itemIDTextBox.Text;
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
int id;
int.TryParse(itemID, out id);
string resol = resolutionTextBox.Text;
string type = monTypeTextBox.Text;
Monitor newItem = new Monitor(id, itemName, price, resol, type);
ItemsDatabase db = new ItemsDatabase();
db.updateMon(id, newItem);
MessageBox.Show("Updated");
}
if (itemComboBox.SelectedItem.ToString() == "Item")
{
string itemID = itemIDTextBox.Text;
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
int id;
int.TryParse(itemID, out id);
Item newItem = new Item(id, itemName, price);
ItemsDatabase db = new ItemsDatabase();
db.updateItem(id, newItem);
MessageBox.Show("Updated");
}
}
private void saveButton_Click(object sender, EventArgs e)
{
try {
if (licenceTextBox.Text != "" || sizeMbTextBox.Text != "")
{
int itemID = Convert.ToInt32(itemIDTextBox.Text);
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
string licence = licenceTextBox.Text;
int sizeMb = Convert.ToInt32(sizeMbTextBox.Text);
SofwareItem newSoft = new SofwareItem(itemID, price, itemName, licence, sizeMb);
ItemsDatabase db = new ItemsDatabase();
db.SaveSoftware(newSoft);
MessageBox.Show("Saved");
}
if (weightTextBox.Text != "")
{
int itemID = Convert.ToInt32(itemIDTextBox.Text);
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
double weight;
Double.TryParse(weightTextBox.Text, out weight);
HardwareItem newhard = new HardwareItem(itemID, price, itemName, weight);
ItemsDatabase db = new ItemsDatabase();
db.SaveHardware(newhard);
MessageBox.Show("Saved");
}
if (noOfCoresTextBox.Text != "" || ramTextBox.Text != "" || hddTextBox.Text != "")
{
int itemID = Convert.ToInt32(itemIDTextBox.Text);
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
int ram = Convert.ToInt32(ramTextBox.Text);
int cores = Convert.ToInt32(noOfCoresTextBox.Text);
int hdd = Convert.ToInt32(hddTextBox.Text);
Computer newComp = new Computer(itemID, itemName, price, ram, cores, hdd);
ItemsDatabase db = new ItemsDatabase();
db.SaveComputer(newComp);
MessageBox.Show("Saved");
}
if (resolutionTextBox.Text != "" || monTypeTextBox.Text != "")
{
int itemID = Convert.ToInt32(itemIDTextBox.Text);
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
string resol = resolutionTextBox.Text;
string type = monTypeTextBox.Text;
Monitor newMon = new Monitor(itemID, itemName, price, resol, type);
ItemsDatabase db = new ItemsDatabase();
db.SaveMonitor(newMon);
MessageBox.Show("Saved");
}
if (itemComboBox.SelectedItem.ToString() == "Item")
{
int itemID = Convert.ToInt32(itemIDTextBox.Text);
string itemName = itemNameTextBox.Text;
double price;
Double.TryParse(priceTextBox.Text, out price);
Item newItem = new Item(itemID, itemName, price);
ItemsDatabase db = new ItemsDatabase();
db.SaveItem(newItem);
MessageBox.Show("Saved");
}
}
catch
{
MessageBox.Show("Try again");
}
}
