public async Task <IActionResult> AddHardwareItem()
{
var model = new HardwareItem();
model = (await PrepareComboBoxesAsync(model)) as HardwareItem;
return(View(model));
}
public async Task <IActionResult> EditHardwareItem(string hardwareItemId)
{
HardwareItem hardwareItem = await _applicationDbContext.HardwareItems
.Include(h => h.Receipts)
.Include(h => h.CheckOuts)
.AsQueryable()
.SingleOrDefaultAsync(h => h.InventoryId == hardwareItemId);
hardwareItem = (await PrepareComboBoxesAsync(hardwareItem)) as HardwareItem;
return(View(hardwareItem));
}
private void hardwareDataGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
ItemsDatabase db = new ItemsDatabase();
var row = softwareDataGrid.CurrentCell.RowIndex;
var column = softwareDataGrid.CurrentCell.ColumnIndex;
double weight = Convert.ToDouble(hardwareDataGrid.Rows[row].Cells[0].Value);
string itemID = hardwareDataGrid.Rows[row].Cells[1].Value.ToString();
string itemName = hardwareDataGrid.Rows[row].Cells[2].Value.ToString();
double price = Convert.ToDouble(hardwareDataGrid.Rows[row].Cells[3].Value);
HardwareItem hardwareItem = new HardwareItem(itemID, itemName, price, weight);
db.EditHardwareItem(hardwareItem);
}
private void delHardware_Click(object sender, EventArgs e)
{
ItemsDatabase db = new ItemsDatabase();
var row = softwareDataGrid.CurrentCell.RowIndex;
string itemID = hardwareDataGrid.Rows[row].Cells[1].Value.ToString();
HardwareItem hardwareItem = new HardwareItem(itemID, "", 0.0, 0.0);
db.DeleteHardware(hardwareItem);
MessageBox.Show("Izdelek izbrisan!");
List <HardwareItem> hardwareItems = new List <HardwareItem>();
hardwareItems = db.ReadHardwareItems();
hardwareDataGrid.DataSource = hardwareItems;
}
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");
}
}
private void button1_Click(object sender, EventArgs e)
{
var row = dataGridView1.CurrentCell.RowIndex;
string itemID = dataGridView1.Rows[row].Cells[1].Value.ToString();
itemsBaza db = new itemsBaza();
HardwareItem hardwareItemToDelete = new HardwareItem(itemID, " ", 0.0, 0.0);
db.DeleteHardwareItem(hardwareItemToDelete);
MessageBox.Show("Izdelek izbrisan");
List <HardwareItem> seznamH = new List <HardwareItem>();
seznamH = db.ReadItemsH();
dataGridView1.DataSource = seznamH;
}
public static async void CreateLoan(string username, IEnumerable <string> hardWareItemList)
{
var availableItems = await HardwareRepository.GetHardwareItems();
foreach (var hwItem in hardWareItemList)
{
var newLoan = new LoanItem
{
IsReturned = false,
LoanedAt = DateTime.Now,
LoanedBy = username
};
var hardwareItems = availableItems as HardwareItem[] ?? availableItems.ToArray();
if (hardwareItems.Select(x => x.Name.ToLower()).Contains(hwItem.ToLower()))
{
newLoan.ItemId = hardwareItems.FirstOrDefault(x => string.Equals(x.Name, hwItem, StringComparison.CurrentCultureIgnoreCase)).Id;
}
else
{
var newItem = new HardwareItem
{
Category = "",
ImageUrl = "",
Name = hwItem
};
await HardwareRepository.AddItem(newItem);
newLoan.ItemId = newItem.Id;
}
try
{
await LoanTable.InsertAsync(newLoan);
}
catch (Exception e)
{
//Item allready exist, create duplicate
newLoan.Item.Id = Guid.NewGuid().ToString();
await LoanTable.InsertAsync(newLoan);
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
string itemID = textBox1.Text;
string itemName = textBox2.Text;
double price;
double Weight;
Double.TryParse(textBox3.Text, out price);
Double.TryParse(textBox4.Text, out Weight);
HardwareItem hardwareItem = new HardwareItem(itemID, itemName, price, Weight);
itemsBaza db = new itemsBaza();
db.EditHardware(hardwareItem);
MessageBox.Show("Izdelek urejen");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
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");
}
}
public async Task <IActionResult> AddHardwareItem(HardwareItem hardwareItem)
{
if (ModelState.IsValid)
{
var user = await _userManager.GetUserAsync(User);
var category = new Category()
{
Name = hardwareItem.Category.Name,
User = user,
LastUsed = DateTime.Now.Date
};
var model = new ItemModel()
{
Name = hardwareItem.Model.Name,
User = user,
LastUsed = DateTime.Now.Date
};
var manufacturer = new Manufacturer()
{
Name = hardwareItem.Manufacturer.Name,
User = user,
LastUsed = DateTime.Now.Date
};
var physicalLocation = new PhysicalLocation()
{
Name = hardwareItem.PhysicalLocation.Name,
User = user,
LastUsed = DateTime.Now.Date
};
var dbCategory = await _applicationDbContext.Categories
.ToAsyncEnumerable()
.SingleOrDefaultAsync(c => c.Name == category.Name && c.User == category.User);
var dbModel = await _applicationDbContext.ItemModels
.ToAsyncEnumerable()
.SingleOrDefaultAsync(c => c.Name == model.Name && c.User == model.User);
var dbManufacturer = await _applicationDbContext.Manufacturers
.ToAsyncEnumerable()
.SingleOrDefaultAsync(c => c.Name == manufacturer.Name && c.User == manufacturer.User);
var dbPhysicalLocation = await _applicationDbContext.PhysicalLocations
.ToAsyncEnumerable()
.SingleOrDefaultAsync(c => c.Name == physicalLocation.Name && c.User == physicalLocation.User);
if (dbCategory == null)
{
dbCategory = (await _applicationDbContext.Categories.AddAsync(category)).Entity;
}
else
{
dbCategory.Update(category);
dbCategory.Uses++;
_applicationDbContext.Entry(dbCategory).State = EntityState.Modified;
}
if (dbModel == null)
{
dbModel = (await _applicationDbContext.ItemModels.AddAsync(model)).Entity;
}
else
{
dbModel.Update(model);
dbModel.Uses++;
_applicationDbContext.Entry(dbModel).State = EntityState.Modified;
}
if (dbManufacturer == null)
{
dbManufacturer = (await _applicationDbContext.Manufacturers.AddAsync(manufacturer)).Entity;
}
else
{
dbManufacturer.Update(manufacturer);
dbManufacturer.Uses++;
_applicationDbContext.Entry(dbManufacturer).State = EntityState.Modified;
}
if (dbPhysicalLocation == null)
{
dbPhysicalLocation = (await _applicationDbContext.PhysicalLocations.AddAsync(physicalLocation)).Entity;
}
else
{
dbPhysicalLocation.Update(physicalLocation);
dbPhysicalLocation.Uses++;
_applicationDbContext.Entry(dbPhysicalLocation).State = EntityState.Modified;
}
await _applicationDbContext.SaveChangesAsync();
if (hardwareItem.ReceiptFiles != null && hardwareItem.ReceiptFiles.Count() > 0)
{
var receipts = await hardwareItem.ReceiptFiles
.ToAsyncEnumerable()
.SelectAwait(async h => await GetReceiptAsBytes(h))
.ToListAsync();
hardwareItem.Receipts = receipts;
}
hardwareItem.Category = null;
hardwareItem.Model = null;
hardwareItem.Manufacturer = null;
hardwareItem.PhysicalLocation = null;
var inventoryItems = _applicationDbContext.HardwareItems;
hardwareItem = (await inventoryItems.AddAsync(hardwareItem)).Entity;
//await _applicationDbContext.SaveChangesAsync();
hardwareItem.Category = dbCategory;
hardwareItem.Model = dbModel;
hardwareItem.Manufacturer = dbManufacturer;
hardwareItem.PhysicalLocation = dbPhysicalLocation;
await _applicationDbContext.SaveChangesAsync();
}
hardwareItem = (await PrepareComboBoxesAsync(hardwareItem)) as HardwareItem;
return(View(hardwareItem));
//return RedirectToAction("EditHardwareItem", new { hardwareItem = hardwareItem });
}
public async Task <IActionResult> EditHardwareItem(HardwareItem hardwareItem)
{
hardwareItem = (await PrepareComboBoxesAsync(hardwareItem)) as HardwareItem;
return(View(hardwareItem));
}
private void addButton_Click(object sender, EventArgs e)
{
string itemID = textBox1.Text;
string itemName = textBox2.Text;
double price;
Double.TryParse(textBox3.Text, out price);
if (comboBox1.SelectedIndex == 0)
{
double weight;
Double.TryParse(textBox4.Text, out weight);
HardwareItem hardwareItem = new HardwareItem(itemID, itemName, price, weight);
ItemsDatabase db = new ItemsDatabase();
db.SaveItemHardware(hardwareItem);
MessageBox.Show("Izdelek dodan!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
else if (comboBox1.SelectedIndex == 1)
{
double weight;
int noOfCores;
int amountOfRAM;
int hddSize;
Double.TryParse(textBox10.Text, out weight);
Int32.TryParse(textBox9.Text, out noOfCores);
Int32.TryParse(textBox12.Text, out amountOfRAM);
Int32.TryParse(textBox11.Text, out hddSize);
Computer computer = new Computer(itemID, itemName, price, weight, noOfCores, amountOfRAM, hddSize);
ItemsDatabase db = new ItemsDatabase();
db.SaveItemComputer(computer);
MessageBox.Show("Izdelek dodan!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox10.Text = "";
textBox9.Text = "";
textBox11.Text = "";
textBox12.Text = "";
}
else if (comboBox1.SelectedIndex == 2)
{
double weight;
string resolution = textBox13.Text;
string monitorType = textBox7.Text;
Double.TryParse(textBox8.Text, out weight);
Monitor monitor = new Monitor(itemID, itemName, price, weight, resolution, monitorType);
ItemsDatabase db = new ItemsDatabase();
db.SaveItemMonitor(monitor);
MessageBox.Show("Izdelek dodan!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox8.Text = "";
textBox13.Text = "";
textBox7.Text = "";
}
else if (comboBox1.SelectedIndex == 3)
{
string licenceKey = textBox5.Text;
double sizeInMB;
Double.TryParse(textBox6.Text, out sizeInMB);
SoftwareItem softwareItem = new SoftwareItem(itemID, itemName, price, licenceKey, sizeInMB);
ItemsDatabase db = new ItemsDatabase();
db.SaveItemSoftware(softwareItem);
MessageBox.Show("Izdelek dodan!");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox5.Text = "";
textBox6.Text = "";
}
}
public static async Task UpdateItem(HardwareItem hardwareItem)
{
await hardwareTable.UpdateAsync(hardwareItem);
}
public static async Task AddItem(HardwareItem singleHwItem)
{
await hardwareTable.InsertAsync(singleHwItem);
}
