public void TestCreate(string actualPath, string expectedPath, int id, string fName, string lName, int age)
{
Person p = new Person(Convert.ToUInt32(id), fName, lName, Convert.ToUInt32(age));
dao.ConnectionString = CurrentDirectory + actualPath + fileFormat;
dao.Create(p);
List <Person> actual = (List <Person>)dao.Read();
dao.Delete(p);
dao.ConnectionString = CurrentDirectory + expectedPath + fileFormat;
List <Person> expected = (List <Person>)dao.Read();
PersonAssert(actual, expected);
}
public void CrudListen(string incomeMessage)
{
var packet = master.DecodePacket(incomeMessage);
switch (packet.QueryType)
{
case "READ":
{
string reply = master.CreateResponsePacket(dao.Read());
byte[] replyMessage = Encoding.UTF8.GetBytes(reply);
Reply(replyMessage, null);
break;
}
case "CREATE":
{
dao.Create(packet.Persons[0]);
break;
}
case "UPDATE":
{
dao.Update(packet.Persons[0]);
break;
}
case "DELETE":
{
dao.Delete(packet.Persons[0]);
break;
}
}
}
public bool Delete(int id)
{
try
{
return(personDao.Delete(id));
}
catch (Exception ex)
{
//TO DO logging
return(false);
}
}
public IActionResult Delete(int id)
{
var deletedPerson = _phoneBookDb.GetById(id);
if (deletedPerson != null)
{
_phoneBookDb.Delete(deletedPerson);
TempData["message"] = "Person deleted from database succesfully.";
TempData["status"] = "alert alert-warning";
return(RedirectToAction("Index", "Home"));
}
TempData["message"] = "Person is not exist !";
TempData["status"] = "alert alert-danger";
return(RedirectToAction("Index", "Home"));
}
private void CRUD_Click(object sender, EventArgs e)
{
Button btn = sender as Button;
switch (btn.Text.ToUpper())
{
case "CREATE":
{
db.Create(GetPerson());
break;
}
case "READ":
{
Person p = db.Read(Convert.ToInt32(etId.Text));
SetPerson(p);
break;
}
case "READ ALL":
{
List <Person> p = db.ReadAll().ToList();
FragmentDAOView fragment = new FragmentDAOView(p);
FragmentTransaction transaction = FragmentManager.BeginTransaction();
transaction.Replace(Resource.Id.main_activity_frame, fragment);
transaction.Commit();
break;
}
case "UPDATE":
{
db.Update(GetPerson());
break;
}
case "DELETE":
{
db.Delete(GetPerson());
break;
}
default:
break;
}
}
public void Delete(Person person)
{
db.Delete(person);
}
public void Delete(Person p)
{
dbActive.Delete(p);
}
public void Delete(Person persona)
{
daoDB.Delete(persona);
}
public void Delete(Person p)
{
dao.Delete(p);
}
