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