//delete from inventory private void button7_Click(object sender, EventArgs e) { item inventory = new item(); try { inventory.name = txtItemName_Inventory.Text; inventory.minStock = Convert.ToInt32(txtMinQuantity_Inventory.Text); inventory.price = Convert.ToInt32(txtUnitPrice_Inventory.Text); inventory.stock = Convert.ToInt32(txtAvalableQuantity_Inventory.Text); inventory.itemID = Convert.ToInt32(txtItemID_Inventory.Text); if (MessageBox.Show("are you sure you want to delete this item?", "delete inventory item", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { db.Entry(inventory).State = EntityState.Modified; var entry = db.Entry(inventory); if (entry.State == EntityState.Detached) { db.items.Attach(inventory); } db.items.Remove(inventory); db.SaveChanges(); fillInventory(); clearInventoryField(); } MessageBox.Show("inventory item deleted"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//update inventory private void button8_Click(object sender, EventArgs e) { item inventory = new item(); try { inventory.name = txtItemName_Inventory.Text; inventory.minStock = Convert.ToInt32(txtMinQuantity_Inventory.Text); inventory.price = Convert.ToInt32(txtUnitPrice_Inventory.Text); inventory.stock = Convert.ToInt32(txtAvalableQuantity_Inventory.Text); inventory.itemID = Convert.ToInt32(txtItemID_Inventory.Text); using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { db.Entry(inventory).State = EntityState.Modified; db.SaveChanges(); fillInventory(); clearInventoryField(); } MessageBox.Show("inventory item updated"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//complete the job from garage private void button7_Click(object sender, EventArgs e) { using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { jobRef = db.jobs.Where(x => x.jobID == jobRef.jobID).FirstOrDefault(); jobRef.specialNote = txtSpecialNote.Text; jobRef.status = state.workDone.ToString(); db.Entry(jobRef).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); updateTextFields(); } }
//add item to list private void button4_Click(object sender, EventArgs e) { //split selected sentence to words by space var spitedWords = selectedString.Split(' '); int selectedItemID = Convert.ToInt32(spitedWords.ElementAt(0)); string selectedItemName = spitedWords.ElementAt(2); jobItem JItemRecord = new jobItem(); item inventoryItem = new item(); using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { try { //filter out the inventory object according to comboBox selection inventoryItem = db.items.Where(x => x.itemID == selectedItemID).FirstOrDefault(); //set jobItem object for submit to job JItemRecord.jobID = jobRef.jobID; int uq = Convert.ToInt32(txtUsedQuantity.Text); JItemRecord.usedQuantity = uq; //check requested quantity are avalable if (uq > inventoryItem.stock) { throw new Exception("the added quantity is not avalable"); } JItemRecord.itemID = inventoryItem.itemID; JItemRecord.unitCost = inventoryItem.price; JItemRecord.totalCost = JItemRecord.unitCost * JItemRecord.usedQuantity; //add item to job jobRef = db.jobs.Where(x => x.jobID == jobRef.jobID).FirstOrDefault(); jobRef.jobItems.Add(JItemRecord); db.Entry(jobRef).State = System.Data.Entity.EntityState.Modified; //reduce the quantity from inventory item updatedItem = db.items.Where(x => x.itemID == selectedItemID).FirstOrDefault(); updatedItem.stock = updatedItem.stock - uq; //db.Entry(updatedItem).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); fillItemList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
//delete user.. private void bunifuThinButton28_Click(object sender, EventArgs e) { user u = new user(); try { u.ID = Convert.ToInt32(txtUserID.Text); u.name = txtUserName.Text; u.password = txtUserPassword.Text; u.isAdmin = radioAdmin.Checked; if (MessageBox.Show("are you sure you want to delete this user?", "delete user", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { db.Entry(u).State = EntityState.Modified; var entry = db.Entry(u); if (entry.State == EntityState.Detached) { db.users.Attach(u); } db.users.Remove(u); db.SaveChanges(); fillUserTable(); fillNextUserID(); clearUserTextFields(); } MessageBox.Show("user deleted"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//click complete job private void bunifuThinButton22_Click(object sender, EventArgs e) { jobRef.date = Date.Value; jobRef.description = txtDescription.Text; jobRef.specialNote = txtSpecialNote.Text; jobRef.serviceCost = Convert.ToInt32(numServiceCost.Value); jobRef.status = state.complete.ToString(); using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { db.Entry(jobRef).State = EntityState.Modified; db.SaveChanges(); } MessageBox.Show("job completed successfully"); fillTextFields(); }
//user edit (save) private void bunifuThinButton25_Click(object sender, EventArgs e) { user u = new user(); u.ID = Convert.ToInt32(txtUserID.Text); u.name = txtUserName.Text; u.password = txtUserPassword.Text; u.isAdmin = radioAdmin.Checked; using (sunilGarageDBEntities db = new sunilGarageDBEntities()) { try { db.Entry(u).State = EntityState.Modified; db.SaveChanges(); fillUserTable(); clearUserTextFields(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }