public ActionResult Create([Bind(Include = "ProduccionId,NombreProducto,Clima")] Produccion produccion) { if (ModelState.IsValid) { db.Produccion.Add(produccion); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(produccion)); }
public static object AddAssignment(AgroContext context, Assignment am) { if (am == null) { throw new ArgumentException("Assignment is null"); } //am.Customer = CustomerController.GetCustomer(context, am.CustomerId); am.Timesheets = new List <Timesheet>(); if (am.Employees != null) { foreach (User user in am.Employees) { am.Timesheets.Add(new Timesheet() { UserId = user.UserId }); } } context.Assignments.Add(am); context.SaveChanges(); return(true); }
public static object EditCustomer(AgroContext context, Customer customer) { Customer c = GetCustomer(context, customer.CustomerId); c.Name = customer.Name; c.Address = customer.Address; context.SaveChanges(); return(true); }
public bool AddTimeSheet([FromBody] Models.TimesheetRecord timesheet) { _context.TimesheetRecords.Add(timesheet); _context.SaveChanges(); return(true); //using (MySqlConnection conn = await DatabaseConnection.GetConnection()) //{ // int idTimesheet = -1; // string query = "INSERT INTO Timesheet (timesheet.idTimesheet, timesheet.workType, timesheet.startTime, timesheet.endTime, timesheet.totalTime, timesheet.description) " // + "VALUES (@0, @1, @2, @3, @4, @5); SELECT LAST_INSERT_ID()"; // using (MySqlDataReader reader = await MySqlHelper.ExecuteReaderAsync(conn, query, // new MySqlParameter("@0", timesheet.IdTimesheet), // new MySqlParameter("@1", timesheet.WorkType), // new MySqlParameter("@2", timesheet.StartTime), // new MySqlParameter("@3", timesheet.EndTime), // new MySqlParameter("@4", timesheet.TotalTime), // new MySqlParameter("@5", timesheet.Description))) // { // await reader.ReadAsync(); // idTimesheet = reader.GetInt32(0); // } // try // { // query = "INSERT INTO TimeSheetMachine (idTimesheet, idMachine) VALUES (@0, @1)"; // foreach (Machine machine in timesheet.Machines) // await MySqlHelper.ExecuteNonQueryAsync(conn, query, // new MySqlParameter("@0", idTimesheet), // new MySqlParameter("@1", machine.IdMachine)); // query = "INSERT INTO TimeSheetAttachment (idTimesheet, idAttachment) VALUES (@0, @1)"; // foreach (Attachment attachment in timesheet.Attachments) // await MySqlHelper.ExecuteNonQueryAsync(conn, query, // new MySqlParameter("@0", idTimesheet), // new MySqlParameter("@1", attachment.IdAttachment)); // } // catch (Exception ex) // { // return false; // } // return true; //} }
/// <summary> /// Adds user to the database /// </summary> /// <param name="context"></param> /// <param name="user"></param> public static object AddUser(AgroContext context, User user) { user.Username = user.Username.ToLower(); user.PasswordEncrypted = GetEncodedHash(user.Password, "123"); if (GetUser(context, user.Username) != null) { return("Gebruiker bestaat al!"); } context.Users.Add(user); try { context.SaveChanges(); return(true); } catch { return("Er is iets misgegaan!"); } }
/// <summary> /// Edits the givin user with the data received /// </summary> /// <param name="context"></param> /// <param name="changedUser"></param> public static object EditUser(AgroContext context, User changedUser) { User user = GetUser(context, changedUser.UserId); user.Name = changedUser.Name; user.Role = changedUser.Role; user.Username = changedUser.Username.ToLower(); if (changedUser.Password?.Length >= 3) { user.PasswordEncrypted = GetEncodedHash(changedUser.Password, "123"); } try { context.SaveChanges(); return(true); } catch (Exception ex) { return("Ër is iets misgegaan! " + ex.Message); } }
public static object AddCustomer(AgroContext context, Customer customer) { context.Customers.Add(customer); context.SaveChanges(); return(true); }
public object ArchiveUser(int userId) { GetUser(_context, userId).IsArchived = true; _context.SaveChanges(); return(true); }