public void Save() { var librarianGateWay = new LibrarianTDG(); int tmpId = librarianGateWay.Insert(Name, Surname, Email); ID = tmpId; }
public static List <LibrarianActiveRecord> Find() { List <LibrarianActiveRecord> librariansList = new List <LibrarianActiveRecord>(); var librarianGateWay = new LibrarianTDG(); DataTable dt = librarianGateWay.Find(); foreach (DataRow dr in dt.Rows) { librariansList.Add(MapResultsetToObject(dr)); } return(librariansList); }
public static RentalActiveRecord MapResultsetToObject(DataRow dr) { RentalActiveRecord NewRental = new RentalActiveRecord(); var librarianTemp = new LibrarianTDG(); var customerTemp = new CustomerTDG(); NewRental.ID = Convert.ToInt32(dr.ItemArray[0].ToString()); NewRental.Librarian = LibrarianActiveRecord.MapResultsetToObject(librarianTemp.GetLibrarianByID(Convert.ToInt32(dr.ItemArray[1].ToString())).Rows[0]); NewRental.Customer = CustomerActiveRecord.MapResultsetToObject(customerTemp.GetCustomerByID(Convert.ToInt32(dr.ItemArray[2].ToString())).Rows[0]); NewRental.RentalDate = Convert.ToDateTime(dr.ItemArray[3].ToString()); if (dr.ItemArray[4] == DBNull.Value) { NewRental.ReturnDate = null; } else { NewRental.ReturnDate = Convert.ToDateTime(dr.ItemArray[4].ToString()); } NewRental.Vraceno = Convert.ToBoolean(dr.ItemArray[5].ToString()); NewRental.Extended = Convert.ToBoolean(dr.ItemArray[6].ToString()); return(NewRental); }