public ActionResult Create([Bind(Include = "Id,LocationId,Name,IsAvailable,JigStr,CtrStr,SnrStr")] Location location)
{
if (ModelState.IsValid)
{
db.Locations.Add(location);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(location));
}
public bool AddRate(Rate rate)
{
Console.WriteLine("\r\n{0} - Adding Rate", DateTime.Now);
using(RatesDBContext context = new RatesDBContext())
{
context.Rates.Add(new Rate() { Value = rate.Value, RateDescription = rate.RateDescription });
context.SaveChanges();
Console.WriteLine("{0} Rate Value : {1}",rate.RateDescription, rate.Value.ToString());
return true;
}
}
public bool AddRole(Role role)
{
Console.WriteLine("\r\n{0} - Adding Role", DateTime.Now);
using(RatesDBContext context = new RatesDBContext())
{
Rate rate = context.Rates.Where(r => r.RateID == role.RateID).FirstOrDefault<Rate>();
if (rate != null)
{
context.Roles.Add(new Role() { RoleName = role.RoleName, Rate = rate });
context.SaveChanges();
Console.WriteLine("Role : {0} with rate : {1}",role.RoleName, rate.Value.ToString());
return true;
}
else
{
return false;
}
}
}
public bool AddEmployee(Employee emp)
{
Console.WriteLine("\r\n{0} - Adding Employee", DateTime.Now);
using(RatesDBContext context = new RatesDBContext())
{
Role role = context.Roles.Where(r => r.RoleID == emp.RoleID).FirstOrDefault<Role>();
if(role != null)
{
context.Employees.Add(new Employee() { EmployeeName = emp.EmployeeName, EmployeeSurname = emp.EmployeeSurname, EmployeeNumber = emp.EmployeeNumber, Role = role });
context.SaveChanges();
Console.WriteLine("Employee Name : {0} To : {1}", emp.EmployeeName,role.RoleName);
return true;
}
else
{
return false;
}
}
}
public void AddCar(SupplierNew s)
{
using (RatesDBContext ctx = new RatesDBContext())
{
Cars c = ctx.Cars.FirstOrDefault(o => o.CarName.Contains(s.CarName));
if (c == null)
{
ctx.Cars.Add(new Cars
{
CarName = s.CarName,
Category = s.Category.Contains("skip") ? s.Category.Substring(4) : s.Category,
Seats = s.Seats,
Transmission = s.Transmission,
SupplierName = s.SupplierName,
SupplierType = s.SupplierType,
IsAssigned = true
});
ctx.SaveChanges();
}
}
}
public bool UpdateRole(Role role)
{
Console.WriteLine("\r\n{0} - Updating Role", DateTime.Now);
using (RatesDBContext context = new RatesDBContext())
{
Role roleRecord = context.Roles.Where(r => r.RoleID == role.RoleID).FirstOrDefault<Role>();
if (roleRecord != null)
{
roleRecord.RoleName = role.RoleName;
roleRecord.RateID = role.RateID;
context.SaveChanges();
Console.WriteLine("Role : {0}", role.RoleName);
return true;
}
else
{
return false;
}
}
}
public bool UpdateRate(Rate rate)
{
Console.WriteLine("\r\n{0} - Updating Rate", DateTime.Now);
using (RatesDBContext context = new RatesDBContext())
{
Rate rateRecord = context.Rates.Where(r => r.RateID == rate.RateID).FirstOrDefault<Rate>();
if (rateRecord != null)
{
rateRecord.RateDescription = rate.RateDescription;
rateRecord.Value = rate.Value;
context.SaveChanges();
Console.WriteLine("{0} Rate Value : {1}", rate.RateDescription, rate.Value.ToString());
return true;
}
else
{
return false;
}
}
}
public bool UpdateEmployee(Employee emp)
{
Console.WriteLine("\r\n{0} - Updating Employee", DateTime.Now);
using (RatesDBContext context = new RatesDBContext())
{
Employee employee = context.Employees.Where(e => e.EmployeeID == emp.EmployeeID).FirstOrDefault<Employee>();
if (employee != null)
{
employee.EmployeeName = emp.EmployeeName;
employee.EmployeeNumber = emp.EmployeeNumber;
employee.EmployeeSurname = emp.EmployeeSurname;
employee.RoleID = emp.RoleID;
context.SaveChanges();
Console.WriteLine("Employee Name : {0}",emp.EmployeeName);
return true;
}
else
{
return false;
}
}
}
