/*
* public static void Insert(string title, string author, string isbn, string date, string price, string adtext, string course, string mail)
* {
* string cmd = String.Format("INSERT INTO BookAd VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", title, author, isbn, date, price, adtext, course, mail);
* DataBaseConnect.ExecuteSelectCommand(cmd, CommandType.Text);
* }
*/
public static int Insert(string title, string author, string isbn, string date, int price, string adtext, string course, string mail)
{
string cmd = String.Format("INSERT INTO BookAd VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", title, isbn, author, date, price, adtext, course, mail); //String.Format för att underlätta inmatning
int rowsAffected = 0;
rowsAffected = DataBaseConnect.ExecuteNonQuery(cmd, CommandType.Text);
return(rowsAffected);
}
//Lägger till en ny användare i databasen
public static int Insert(string LName, string FName, string PhoneNbr, string Mail, string City, string Password)
{
string cmd = String.Format("INSERT INTO Seller VALUES('{0}','{1}','{2}','{3}','{4}','{5}')", LName, FName, PhoneNbr, Mail, City, Password); //String.Format för att underlätta inmatning
int rowsAffected = 0;
rowsAffected = DataBaseConnect.ExecuteNonQuery(cmd, CommandType.Text);
return(rowsAffected);
}
