public static void UpdateContact(Contact contact) { string sqlQuery = "UPDATE Contact SET FirstName=@FirstName,LastName=@LastName,Email=@Email,Phone=@Phone WHERE ContactID=" + contact.ContactID; Database db = new SqlDatabase(DBHelper.GetConnectionString()); DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery); db.AddInParameter(dbCommand, "FirstName", DbType.String, contact.FirstName); db.AddInParameter(dbCommand, "LastName", DbType.String, contact.LastName); db.AddInParameter(dbCommand, "Email", DbType.String, contact.Email); db.AddInParameter(dbCommand, "Phone", DbType.String, contact.Phone); db.ExecuteNonQuery(dbCommand); }
public static Contact InsertContact(Contact contact) { string sqlQuery = "INSERT INTO Contact(FirstName,LastName,Email,Phone) " + " VALUES(@FirstName,@LastName,@Email,@Phone);SELECT @@Identity"; Database db = new SqlDatabase(DBHelper.GetConnectionString()); DbCommand dbCommand = db.GetSqlStringCommand(sqlQuery); db.AddInParameter(dbCommand, "FirstName", DbType.String, contact.FirstName); db.AddInParameter(dbCommand, "LastName", DbType.String, contact.LastName); db.AddInParameter(dbCommand, "Email", DbType.String, contact.Email); db.AddInParameter(dbCommand, "Phone", DbType.String, contact.Phone); contact.ContactID = Convert.ToInt32(db.ExecuteScalar(dbCommand)); return contact; }
public static void UpdateContact(Contact contact) { ContactDB.UpdateContact(contact); }
public static Contact InsertContact(Contact contact) { return ContactDB.InsertContact(contact); }
private static Contact GetContactFromReader(IDataReader dataReader) { Contact contact = new Contact(); contact.ContactID = DBHelper.GetInt(dataReader, "ContactID"); contact.FirstName = DBHelper.GetString(dataReader, "FirstName"); contact.LastName = DBHelper.GetString(dataReader, "LastName"); contact.Phone = DBHelper.GetString(dataReader, "Phone"); contact.Email = DBHelper.GetString(dataReader, "Email"); return contact; }