/* * 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); }