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