//making job object.............
private void makeJob()
{
job jb = new job();
using (sunilGarageDBEntities db = new sunilGarageDBEntities())
{
try
{
jb.customerNIC = comboBoxCusNIC.SelectedItem.ToString();
jb.jobID = Convert.ToInt32(txtJobID_JobSheet.Text);
jb.description = txt_JobDescription_JobSheet.Text;
jb.vehicle = MTB_VehicleID_JobSheet.Text;
jb.status = state.created.ToString();
jb.customer = db.customers.Where(x => x.customerNIC == comboBoxCusNIC.SelectedItem.ToString()).FirstOrDefault();
jb.specialNote = "";
jb.date = null;
jb.serviceCost = 0;
db.jobs.Add(jb);
db.SaveChanges();
MessageBox.Show("job creater succesfully.. JobID is:" + jb.jobID);
fillNextJobID();
//clear the job sheet
txt_JobDescription_JobSheet.Text = null;
comboBoxCusNIC.Text = "";
MTB_VehicleID_JobSheet.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//fill item list.... and update total item cost
private void fillItemList()
{
using (sunilGarageDBEntities db = new sunilGarageDBEntities())
{
jobRef = db.jobs.Where(x => x.jobID == jobRef.jobID).FirstOrDefault();
var jobItemList = jobRef.jobItems;
List <usedItemStruct> usedList = new List <usedItemStruct>();
int total = 0;
foreach (jobItem x in jobItemList)
{
string itemName = db.items.Where(p => p.itemID == x.itemID).FirstOrDefault().name;
usedList.Add(new usedItemStruct {
itemID = x.itemID, itemName = itemName, unitCost = Convert.ToInt32(x.unitCost), usedQuantity = Convert.ToInt32(x.usedQuantity), totalCost = Convert.ToInt32(x.totalCost)
});
total = total + Convert.ToInt32(x.totalCost);
}
//update total item cost for job
jobRef.itemsCost = total;
db.SaveChanges();
var source = new BindingSource();
source.DataSource = usedList;
dgvItemList.DataSource = usedList;
LBL_totalCost.Text = total.ToString();
}
}
//customer registration...........................................................................................................................
//add customer
private void button12_Click(object sender, EventArgs e)
{
customer cus = new customer();
using (sunilGarageDBEntities db = new sunilGarageDBEntities())
{
try
{
cus.customerNIC = txtCustomerID_people.Text;
cus.name = txtCustomerName_People.Text;
cus.mobile = Convert.ToInt32(txtcustomerMobile_People.Text);
cus.address = txtCustomerAddress_People.Text;
cus.email = txtCustomerEmail_People.Text;
db.customers.Add(cus);
db.SaveChanges();
clearCustomerFields();
fillCustomerReg();
MessageBox.Show("customer added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//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);
}
}
}
//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 registration details.........................................................................................................................................
//user add button
private void bunifuThinButton27_Click(object sender, EventArgs e)
{
using (sunilGarageDBEntities db = new sunilGarageDBEntities())
{
string name = txtUserName.Text;
string password = txtUserPassword.Text;
bool admin = radioAdmin.Checked;
user u = new user();
u.isAdmin = admin;
u.name = name;
u.password = password;
db.users.Add(u);
db.SaveChanges();
MessageBox.Show("user added done");
clearUserTextFields();
}
}
//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);
}
}
private void additem()//add a new inventory item
{
item inventory = new item();
using (sunilGarageDBEntities db = new sunilGarageDBEntities())
{
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);
db.items.Add(inventory);
db.SaveChanges();
MessageBox.Show("new inventory item added");
fillInventory();
clearInventoryField();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//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);
}
}
}
