public int Insert(Payment payment)
{
helper.CommandText = "INSERT INTO Payment (PaymentType) VALUES(@paymentType)";
helper.Parameters.Clear();
helper.Parameters.Add("@paymentType", payment.PaymentType);
return(helper.ExecuteQuery());
}
public int Insert(Publisher publisher)
{
helper.CommandText = "INSERT INTO Publishers VALUES(@publisherName)";
helper.Parameters.Clear();
helper.Parameters.Add("@publisherName", publisher.PublisherName);
return(helper.ExecuteQuery());
}
public int Insert(MemberBookList bookList)
{
helper.CommandText = "insert into MemberBookList (BookID,MemberID) values(@bookID,@memberID)";
helper.Parameters.Clear();
helper.Parameters.Add("@bookID", bookList.BookID);
helper.Parameters.Add("@memberID", bookList.MemberID);
return(helper.ExecuteQuery());
}
public int Insert(Author author)
{
helper.CommandText = "INSERT INTO Authors(FirstName,LastName) VALUES(@firstName,@lastName)";
helper.Parameters.Clear();
helper.Parameters.Add("@firstName", author.FirstName);
helper.Parameters.Add("@lastName", author.LastName);
return(helper.ExecuteQuery());
}
public int Insert(Admin admin)
{
helper.CommandText = "INSERT INTO Admins(FirstName,LastName,Mail,Password) VALUES(@firstName,@lastName,@mail,@pasword)";
helper.Parameters.Clear();
helper.Parameters.Add("@firstName", admin.FirstName);
helper.Parameters.Add("@lastName", admin.LastName);
helper.Parameters.Add("@mail", admin.Mail);
helper.Parameters.Add("@password", admin.Password);
return(helper.ExecuteQuery());
}
public int Insert(Rent rent)
{
helper.CommandText = "INSERT INTO Rent(MemberID,BookID,RentDate,RequiredDate,DeliveryDate,PaymentID) VALUES(@memberID,@bookID,@rentDate,@requiredDate,@deliveryDate,@paymentID)";
helper.Parameters.Clear();
helper.Parameters.Add("@memberID", rent.MemberID);
helper.Parameters.Add("@bookID", rent.BookID);
helper.Parameters.Add("@rentDate", DateTime.Now);
helper.Parameters.Add("@requiredDate", DateTime.Now.AddDays(10));
helper.Parameters.Add("@deliveryDate", rent.DeliveryDate);
helper.Parameters.Add("@paymentID", rent.PaymentID);
return(helper.ExecuteQuery());
}
public int Insert(Members member)
{
helper.CommandText = "INSERT INTO Members(AdminID,FirstName,LastName,Mail,Password,MemberDate,IsActive) VALUES(@adminID,@firstName,@lastName,@mail,@password,@memberDate,@isActive)";
helper.Parameters.Clear();
helper.Parameters.Add("@adminID", member.AdminID);
helper.Parameters.Add("@firstName", member.FirstName);
helper.Parameters.Add("@lastName", member.LastName);
helper.Parameters.Add("@mail", member.Mail);
helper.Parameters.Add("@password", member.Password);
helper.Parameters.Add("@memberDate", member.MemberDate);
helper.Parameters.Add("@isActive", member.IsActive);
return(helper.ExecuteQuery());
}
public int Insert(Book book)
{
helper.CommandText = "INSERT INTO Books(PublisherID,AuthorID,BookName,Pages,PublicationDate,Summary,DamageStatus,Price,BookStatus) VALUES(@publisherID,@authorID,@bookName,@pages,@publicDate,@summary,@damageStatus,@price,@bookStatus)";
helper.Parameters.Clear();
helper.Parameters.Add("@publisherID", book.PublisherID);
helper.Parameters.Add("@authorID", book.AuthorID);
helper.Parameters.Add("@bookName", book.BookName);
helper.Parameters.Add("@pages", book.Pages);
helper.Parameters.Add("@publicDate", book.PublicationDate);
helper.Parameters.Add("@summary", book.Summary);
helper.Parameters.Add("@damageStatus", book.DamageStatus);
helper.Parameters.Add("@price", book.Price);
helper.Parameters.Add("@bookStatus", book.BookStatus);
return(helper.ExecuteQuery());
}