public static void AddBreakMessage(BreakMessage breakMessage) { breakMessage.ID = SQLDataAccess.ExecuteScalar<int>("INSERT INTO [dbo].[BreakMessage] ([MessageID], [Name], [Email]) VALUES (@MessageID, @Name, @Email); SELECT SCOPE_IDENTITY();", CommandType.Text, new SqlParameter("@MessageID", breakMessage.MessageID), new SqlParameter("@Name", breakMessage.Name), new SqlParameter("@Email", breakMessage.Email) ); }
public static void AddBreakMessage(BreakMessage breakMessage) { breakMessage.ID = SQLDataAccess.ExecuteScalar <int>("INSERT INTO [dbo].[BreakMessage] ([MessageID], [Name], [Email]) VALUES (@MessageID, @Name, @Email); SELECT SCOPE_IDENTITY();", CommandType.Text, new SqlParameter("@MessageID", breakMessage.MessageID), new SqlParameter("@Name", breakMessage.Name), new SqlParameter("@Email", breakMessage.Email) ); }
public static void UpdateBreakMessage(BreakMessage breakMessage) { SQLDataAccess.ExecuteNonQuery("UPDATE [dbo].[BreakMessage] SET MessageID = @MessageID, Name = @Name, Email = @Email WHERE ID = @ID", CommandType.Text, new SqlParameter("@MessageID", breakMessage.MessageID), new SqlParameter("@Name", breakMessage.Name), new SqlParameter("@Email", breakMessage.Email), new SqlParameter("@ID", breakMessage.ID) ); }