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