public NoteDO Save(string note) { NotesDAL dal = new NotesDAL(); NoteDO savedNote = dal.Save(note); return(savedNote); }
public NoteDO Fetch(int id) { NotesDAL dal = new NotesDAL(); NoteDO result = dal.Fetch(id); return(result); }
public IHttpActionResult Post(NoteDO body) { try { NotesBS BS = new NotesBS(); NoteDO noteDO = BS.Save(body.body); return(Ok(noteDO)); } catch (Exception) { Console.WriteLine("Something went wrong. Try again!"); throw; } }
public IHttpActionResult GetOneNote(int id) { try { NotesBS BS = new NotesBS(); NoteDO noteDO = BS.Fetch(id); return(Ok(noteDO)); } catch (Exception) { Console.WriteLine("Something went wrong. Try again!"); throw; } }
public List <NoteDO> Fetch() { List <NoteDO> fetchedDOs = new List <NoteDO>(); if (table != null) { DataRow[] result = table.Select(); foreach (DataRow row in result) { NoteDO singleNoteDO = new NoteDO(); singleNoteDO.id = int.Parse(row[0].ToString()); singleNoteDO.body = row[1].ToString(); fetchedDOs.Add(singleNoteDO); } } return(fetchedDOs); }
public List <NoteDO> Fetch(string content) { List <NoteDO> fetchedDOs = new List <NoteDO>(); if (table != null) { string whereClause = "body like '%" + content.ToString() + "%'"; DataRow[] result = table.Select(whereClause); foreach (DataRow row in result) { NoteDO singleNoteDO = new NoteDO(); singleNoteDO.id = int.Parse(row[0].ToString()); singleNoteDO.body = row[1].ToString(); fetchedDOs.Add(singleNoteDO); } } return(fetchedDOs); }
public NoteDO Fetch(int id) { NoteDO fetchedDO = new NoteDO(); if (table != null) { string whereClause = "id = " + id.ToString(); DataRow[] result = table.Select(whereClause); if (result.Count() == 1) { foreach (DataRow row in result) { fetchedDO.id = int.Parse(row[0].ToString()); fetchedDO.body = row[1].ToString(); } } } return(fetchedDO); }
public NoteDO Save(string body) { NoteDO savedDO = new NoteDO(); if (body != null) { if (table == null) { table = InitializeDataTable(); id = 0; } id++; table.Rows.Add(id, body); string whereClause = "id = " + id.ToString(); DataRow[] result = table.Select(whereClause); foreach (DataRow row in result) { savedDO.id = int.Parse(row[0].ToString()); savedDO.body = row[1].ToString(); } } return(savedDO); }