public ActionResult Create([Bind(Include = "Id,Name,Address,RepairTypes")] RepairShop repairShop)
{
if (ModelState.IsValid)
{
repairShop.RepairTypes = new List <RepairType>();
string repairTypeId = Request.Form["RepairTypes"].ToString();
RepairTypeBusiness repairTypeBusiness = new RepairTypeBusiness();
RepairType repairType = repairTypeBusiness.Get(int.Parse(repairTypeId));
db.RepairTypes.Find(repairType).RepairShops.Add(repairShop);
db.RepairShops.Add(repairShop);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RepairTypesList = new SelectList(
db.RepairTypes
.Select(e => new SelectListItem
{
Value = e.Id.ToString(),
Text = e.Name
})
.ToList()
, "Value", "Text");
return(View(repairShop));
}
public ActionResult Create([Bind(Include = "Id,Name")] RepairType repairType)
{
if (ModelState.IsValid)
{
db.RepairTypes.Add(repairType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(repairType));
}
public ActionResult Create([Bind(Include = "ID,studentid,password,fname,lname,faculty,branch,year,roomno,tell,permiss")] student student)
{
if (ModelState.IsValid)
{
db.students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "Id,VinNumber,RegistrationNumber,ManufacturedYear")] Car car)
{
if (ModelState.IsValid)
{
db.Cars.Add(car);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(car));
}
public ActionResult Create([Bind(Include = "ID,employeeid,fname,lname,password,tell,permiss")] employee employee)
{
if (ModelState.IsValid)
{
db.employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Create([Bind(Include = "ID,jobname,descript,datetime,status,studentid,roomno,choich")] repair repair)
{
if (ModelState.IsValid)
{
db.repairs.Add(repair);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(repair));
}
private void buttonPartAddDb_Click(object sender, EventArgs e)
{
Part part = new Part
{
PartName = textBoxPartName.Text,
PartUnit = textBoxPartUnit.Text,
};
db.Parts.Add(part);
db.SaveChanges();
this.Close();
MainForm form = new MainForm();
form.MainForm_Load(sender, e);
}
private void buttonArrivalDocAddDb_Click(object sender, EventArgs e)
{
ArrivalDoc arrivalDoc = new ArrivalDoc
{
ArrivalDocName = textBoxArrivalDocName.Text,
ArrivalDocProvider = textBoxArrivalDocProvider.Text,
ArrivalDocDate = dateTimePickerArrivalDocDate.Value
};
db.ArrivalDocs.Add(arrivalDoc);
db.SaveChanges();
this.Close();
MainForm form = new MainForm();
form.MainForm_Load(sender, e);
}
public void Add(Car Car)
{
using (repairContext = new RepairContext())
{
repairContext.Cars.Add(Car);
repairContext.SaveChanges();
}
}
public void Add(RepairType repairType)
{
using (repairContext = new RepairContext())
{
repairContext.RepairTypes.Add(repairType);
repairContext.SaveChanges();
}
}
private void buttonDepartureDocAddDb_Click(object sender, EventArgs e)
{
DepartureDoc dd = new DepartureDoc
{
DepartureDocName = textBoxDepartureDocNameDb.Text,
DepartureDocSender = textBoxDepartureDocSenderDb.Text,
DepartureDocRecipient = textBoxDepartureDocRecipentDb.Text,
DepartureDocDate = dateTimePickerDepartureDocDb.Value,
};
db.DepartureDocs.Add(dd);
db.SaveChanges();
this.Close();
MainForm form = new MainForm();
form.MainForm_Load(sender, e);
}
public void Update(RepairType repairType)
{
using (repairContext = new RepairContext())
{
var item = repairContext.RepairTypes.Find(repairType.Id);
repairContext.Entry(item).CurrentValues.SetValues(repairType);
repairContext.SaveChanges();
}
}
public void Update(Car Car)
{
using (repairContext = new RepairContext())
{
var item = repairContext.Cars.Find(Car.Id);
repairContext.Entry(item).CurrentValues.SetValues(Car);
repairContext.SaveChanges();
}
}
private void buttonDepartureEdit_Click(object sender, EventArgs e)
{
try
{
int did = Convert.ToInt32(labelId.Text);
var d = db.Departures.Find(did);
d.DepartureDocId = Convert.ToInt32(comboBoxDepartureDocDb.SelectedValue);
d.PartId = Convert.ToInt32(comboBoxDeparturePartDb.SelectedValue);
d.DepartureQuantity = Convert.ToInt32(textBoxDeparureQuantityDb.Text);
db.Entry(d).State = EntityState.Modified;
db.SaveChanges();
this.Close();
MainForm form = new MainForm();
form.MainForm_Load(sender, e);
}
catch (Exception gg)
{
MessageBox.Show(gg.Message);
}
}
public void Delete(int id)
{
using (repairContext = new RepairContext())
{
var item = repairContext.RepairTypes.Find(id);
if (item != null)
{
repairContext.RepairTypes.Remove(item);
repairContext.SaveChanges();
}
}
}
private void buttonArrivalAddDb_Click(object sender, EventArgs e)
{
try
{
decimal arrsum = Convert.ToInt32(textBoxArrivalQuantity.Text) * Convert.ToDecimal(textBoxArrivalCost.Text);
Arrival arrival = new Arrival
{
ArrivalDocId = Convert.ToInt32(comboBoxArrivalDocDb.SelectedValue),
PartId = Convert.ToInt32(comboBoxArrivalPartDb.SelectedValue),
ArrivalQuantity = Convert.ToInt32(textBoxArrivalQuantity.Text),
ArrivalCost = Convert.ToDecimal(textBoxArrivalCost.Text),
ArrivalSum = arrsum,
};
db.Arrivals.Add(arrival);
db.SaveChanges();
this.Close();
MainForm form = new MainForm();
form.MainForm_Load(sender, e);
}
catch (Exception gg)
{
MessageBox.Show(gg.Message);
}
}
private void buttonDepartureDelete_Click(object sender, EventArgs e)
{
try
{
RepairContext db = new RepairContext();
int did = Convert.ToInt32(dataGridViewDeparture.SelectedCells[0].Value);
var d = db.Departures.Find(did);
db.Departures.Remove(d);
db.SaveChanges();
tabControl1_SelectedIndexChanged(sender, e);
}
catch (Exception gg)
{
MessageBox.Show(gg.Message);
}
}
public RepairsController(RepairContext context)
{
_context = context;
if (!context.Repairs.Any())
{
_context.AddRange(new List <Repair>
{
new Repair
{
Requester = new Requester {
Name = "John Smith", PhoneNumber = "0675214572", Email = "*****@*****.**"
},
Asset = new Asset {
Location = "West corner of Microsoft Way, Redmond", AssetType = "Street Light"
}
},
new Repair
{
Requester = new Requester {
Name = "Claire Smith", PhoneNumber = "0622486247", Email = "*****@*****.**"
},
Asset = new Asset {
Location = "Intersection of Four Lanes & Cycle Track, Berlin", AssetType = "Generator"
}
},
new Repair
{
Requester = new Requester {
Name = "Luis Vasque", PhoneNumber = "0614756328", Email = "*****@*****.**"
},
Asset = new Asset {
Location = "Out front of central station, The Hague", AssetType = "Switch Box"
}
}
});
_context.SaveChanges();
}
}
public static void Initialize(RepairContext context)
{
context.Database.EnsureCreated();
// Look for any existing repairs.
if (context.Repair.Any())
{
return; // DB has been seeded
}
var repairs = new Repair[]
{
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("01-16-2017"), RepairType = "Oil Change", Miles = 83015, Workshop = "Home", Workdone = "Used Mobil 1 oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("07-12-2016"), RepairType = "Oil Change", Miles = 74815, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("01-11-2016"), RepairType = "Oil Change", Miles = 68600, Workshop = "Walmart, Lynwood", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("04-12-2009"), RepairType = "Oil Change", Miles = 72431, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("07-28-2015"), RepairType = "Oil Change", Miles = 62717, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("11-19-2008"), RepairType = "Oil Change", Miles = 65420, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("10-29-2007"), RepairType = "Oil Change", Miles = 59528, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("04-06-2007"), RepairType = "Oil Change", Miles = 51323, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("11-21-2006"), RepairType = "Oil Change", Miles = 44111, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "VW GTI 1.8T", RepairDate = DateTime.Parse("05-12-2006"), RepairType = "Oil Change", Miles = 39220, Workshop = "Pepboys", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("01-19-2015"), RepairType = "Oil Change", Miles = 56319, Workshop = "Walmart", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("10-23-2014"), RepairType = "Oil Change", Miles = 51624, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("04-05-2014"), RepairType = "Oil Change", Miles = 45261, Workshop = "Home", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Subaru Impreza", RepairDate = DateTime.Parse("10-05-2013"), RepairType = "Oil Change", Miles = 63990, Workshop = "Subaru dealership", Workdone = "Used Mobil 1 extended perf. oil and filter."
},
new Repair {
Vehicle = "Toyota RAV4 V6 3.5L", RepairDate = DateTime.Parse("10-28-2012"), RepairType = "Oil Change", Miles = 102864, Workshop = "Toyota Dealership, Kirkland", Workdone = "Used Pennzoil Oil and Fram oil filter."
},
new Repair {
Vehicle = "Honda Civic 1.7L", RepairDate = DateTime.Parse("04-02-2006"), RepairType = "Oil Change", Miles = 36441, Workshop = "Honda Dealership, Roseville", Workdone = "Castrol 5W-30 oil and Fram oil filter."
}
};
foreach (Repair r in repairs)
{
context.Repair.Add(r);
}
context.SaveChanges();
}
