//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);
}
}
}
