示例#1
0
        public void Save()
        {
            var librarianGateWay = new LibrarianTDG();
            int tmpId            = librarianGateWay.Insert(Name, Surname, Email);

            ID = tmpId;
        }
示例#2
0
        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);
        }
示例#3
0
        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);
        }