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()); }