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