public List <Person> GetPersons()
{
using (PersonsDAL personsDAL = new PersonsDAL())
{
return(personsDAL.GetPersons());
}
}
public Person GetPersonByPersonID(Guid PersonID)
{
using (PersonsDAL personsDAL = new PersonsDAL())
{
return(personsDAL.GetPersonByPersonID(PersonID));
}
}
public bool UpdatePerson(Person person)
{
using (PersonsDAL personsDAL = new PersonsDAL())
{
return(personsDAL.UpdatePerson(person));
}
}
public bool DeletePerson(Guid PersonID)
{
using (PersonsDAL personsDAL = new PersonsDAL())
{
return(personsDAL.DeletePerson(PersonID));
}
}
public bool DeletePerson(Person person)
{
using (PersonsDAL personsDAL = new PersonsDAL())
{
return(personsDAL.DeletePerson(person));
}
}
public (bool, Guid) AddPerson(Person person)
{
using (PersonsDAL personsDAL = new PersonsDAL())
{
return(personsDAL.AddPerson(person));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Person p = PersonsDAL.GetPerson(Convert.ToInt32(Request.QueryString["id"]));
tb_firstName.Text = p.FirstName;
tb_lastName.Text = p.LastName;
tb_Address.Text = p.Address;
}
}
protected void btn_SavePerson_Click(object sender, EventArgs e)
{
Person p = new Person();
p.FirstName = tb_FirstName.Text;
p.LastName = tb_LastName.Text;
p.Address = tb_Address.Text;
PersonsDAL.InsertPerson(p);
Response.Redirect(UrlConstants.PHONEBOOK);
}
protected void btn_Update_Click(object sender, EventArgs e)
{
Person p = new Person();
p.FirstName = tb_firstName.Text;
p.LastName = tb_lastName.Text;
p.PersonID = Convert.ToInt32(Request.QueryString["id"]);
p.Address = tb_Address.Text;
PersonsDAL.UpdatePerson(p);
Response.Redirect(UrlConstants.PHONEBOOK);
}
/// <summary>
/// Sorting by field in Ascending or Descending order
/// </summary>
/// <param name="reqname"></param>
/// <param name="count"></param>
protected void loadRepeater(string reqname, int count)
{
if (count == 0)
{
rptPhonebookTabel.DataSource = PersonsDAL.GetPersons(reqname, true); // ASC order
ViewState["count"] = 1;
}
else if (count == 1)
{
rptPhonebookTabel.DataSource = PersonsDAL.GetPersons(reqname, false); // DESC Order
ViewState["count"] = 0;
}
rptPhonebookTabel.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
rptPhonebookTabel.DataSource = PersonsDAL.GetPersonsSearch(tb_SearchText.Text.Trim());
rptPhonebookTabel.DataBind();
}
protected void lbtn_Delete_Command(object sender, CommandEventArgs e)
{
PersonsDAL.DeletePerson(Convert.ToInt32(e.CommandArgument));
FillPersonList();
}
private void FillPersonList()
{
// get the data from the server and bound them
rptPhonebookTabel.DataSource = PersonsDAL.GetPersons();
rptPhonebookTabel.DataBind();
}
