/// <summary> /// Delete record from database /// </summary> /// <param name="personID"></param> /// <returns></returns> public int Delete(int personID) { PersonDAL3 pDAL = new PersonDAL3(); try { return(pDAL.Delete(personID)); } catch { throw; } finally { pDAL = null; } }
/// <summary> /// Update records into database /// </summary> /// <param name="personID"></param> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="age"></param> /// <returns></returns> public int Update(int personID, string firstName, string lastName, int age) { PersonDAL3 pDAL = new PersonDAL3(); try { return(pDAL.Update(personID, firstName, lastName, age)); } catch { throw; } finally { pDAL = null; } }
/// <summary> /// Load records from database /// </summary> /// <returns></returns> public DataTable Load() { PersonDAL3 pDAL = new PersonDAL3(); try { return(pDAL.Load()); } catch { throw; } finally { pDAL = null; } }
/// <summary> /// insert records into database /// </summary> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="age"></param> /// <returns></returns> public int Insert(string firstName, string lastName, int age) { PersonDAL3 pDAL = new PersonDAL3(); try { return(pDAL.Insert(firstName, lastName, age)); } catch { throw; } finally { pDAL = null; } }