public bool checkIfIdExists(string personId)
{
DataTable dt = new DataTable();
if (personId.Equals(string.Empty) || personId.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(PersonStringsSql.checkIfIdExists(personId));
}
int num = 0;
foreach (DataRow ms in dt.Rows)
{
num = int.Parse(ms[0].ToString());
}
if (num == 0)
{
return(false);
}
else
{
return(true);
}
}
public int DeletePerson(string personId)
{
int i = 0;
using (SqlCommand command = new SqlCommand())
{
i = ExecuteNonQuery(PersonStringsSql.DeletePerson(personId));
}
return(i);
}
public List <PersonModel> GetAllPersons()
{
DataTable dt = new DataTable();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(PersonStringsSql.GetAllPersons());
}
List <PersonModel> arrPerson = new List <PersonModel>();
foreach (DataRow ms in dt.Rows)
{
arrPerson.Add(PersonModel.ToObject(ms));
}
return(arrPerson);
}
public PersonModel GetOnePersonById(string personId)
{
DataTable dt = new DataTable();
if (personId.Equals(string.Empty) || personId.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
PersonModel personModel = new PersonModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(PersonStringsSql.GetOnePersonById(personId));
}
foreach (DataRow ms in dt.Rows)
{
personModel = PersonModel.ToObject(ms);
}
return(personModel);
}