public bool Insert(string name, string nameArea) { try { AreaService areaService = new AreaService(_context); Area area = areaService.GetArea(nameArea); if (area == null) { return(false); } Tables tables = new Tables { nameTable = name, status = false, Note = null }; tables.Area = area; _context.Tables.Add(tables); _context.SaveChanges(); return(true); } catch (Exception) { } return(false); }
public bool updateTables(object tables) { try { DataTable dataTable = new DataTable(); dataTable.Clear(); dataTable.Columns.Add("Id", typeof(string)); dataTable.Columns.Add("nameTable", typeof(string)); dataTable.Columns.Add("status", typeof(bool)); dataTable.Columns.Add("Note", typeof(string)); dataTable.Columns.Add("nameArea", typeof(string)); AreaService areaService = new AreaService(_context); dataTable = tables as DataTable; int i = 0; foreach (DataRow item in dataTable.Rows) { Guid IdTable = new Guid(item.Table.Rows[i]["Id"].ToString()); string nameTable = item.Table.Rows[i]["nameTable"].ToString(); bool status = (bool)(item.Table.Rows[i]["status"]); string Note = item.Table.Rows[i]["Note"].ToString(); string nameArea = item.Table.Rows[i]["nameArea"].ToString(); Area area = areaService.GetArea(nameArea); if (area != null) { var table = _context.Tables.Where(x => x.Id == IdTable).Include(x => x.Area).SingleOrDefault(); table.nameTable = nameTable; table.status = status; table.Note = Note; table.Area = area; _context.SaveChanges(); } i++; } return(true); } catch (Exception) { } return(false); }