public PhoneTypeList GetAll() { Database database = new Database("Employer"); database.Command.Parameters.Clear(); database.Command.CommandType = System.Data.CommandType.StoredProcedure; database.Command.CommandText = "tblPhoneTypeGetAll"; DataTable dt = database.ExecuteQuery(); PhoneType blank = new PhoneType(); blank.Type = "Select a Phone Type"; _List.Add(blank); foreach (DataRow dr in dt.Rows) { PhoneType e = new PhoneType(); e.Initialize(dr); e.InitializeBusinessData(dr); e.IsNew = false; e.IsDirty = false; e.Savable += PhoneType_Savable; _List.Add(e); } return(this); }
private void _List_AddingNew(object sender, AddingNewEventArgs e) { e.NewObject = new PhoneType(); PhoneType PhoneType = (PhoneType)e.NewObject; PhoneType.Savable += PhoneType_Savable; }
public PhoneTypeList GetAll() { StudentDB database = new StudentDB("Student"); database.Command.Parameters.Clear(); database.Command.CommandType = System.Data.CommandType.StoredProcedure; database.Command.CommandText = "tblPhoneType_GETALL"; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { PhoneType phonetype = new PhoneType(); phonetype.Initialize(dr); phonetype.InitializeBusinessData(dr); phonetype.isNew = false; phonetype.isDirty = false; _List.Add(phonetype); } return(this); }
public PhoneTypeList GetAll() { Database database = new Database("Employer"); database.Command.Parameters.Clear(); database.Command.CommandType = CommandType.StoredProcedure; database.Command.CommandText = "tblPhoneTypeGetAll"; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { PhoneType p = new PhoneType(); p.Initialize(dr); p.InitializeBusinessData(dr); p.IsNew = false; p.IsDirty = false; p.Savable += Phonetype_Savable; _List.Add(p); } return(this); }