public void Save()
{
var customerGateWay = new CustomerTDG();
int tmpId = customerGateWay.Insert(Name, Surname, Email);
ID = tmpId;
}
public static List <CustomerActiveRecord> Find()
{
List <CustomerActiveRecord> customersList = new List <CustomerActiveRecord>();
var customerGateWay = new CustomerTDG();
DataTable dt = customerGateWay.Find();
foreach (DataRow dr in dt.Rows)
{
customersList.Add(MapResultsetToObject(dr));
}
return(customersList);
}
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);
}
