private void EditEvent_Load(object sender, EventArgs e)
{
log.Info("************************************************************ Edit Event Start *************************************************************");
InfoEvent ie = this.Owner as InfoEvent;
id = ie.id;
}
private void FeedBackEvent_Load(object sender, EventArgs e)
{
log.Info("********************************************************** Feedback Event Start ***********************************************************");
InfoEvent ie = this.Owner as InfoEvent;
label_name_event.Text = ie.label_name_event.Text.ToString();
getAuthors();
}
private void listView_event_MouseClick(object sender, MouseEventArgs e)
{
foreach (Form f in Application.OpenForms) // не разрешаем открыть еще одну форму
{
if (f.Name == "InfoEvent")
{
MessageBox.Show("Форма уже открыта", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
InfoEvent ie = new InfoEvent();
ie.Owner = this;
ie.Show();
} // просмотр инфы о мероприятии
private void addFeedBack()
{
getAuthorsId();
getMaxIdFeedBack();
InfoEvent ie = this.Owner as InfoEvent;
string proc = "pr_insertFeedback_event";
using (SqlConnection connect = new SqlConnection(connection))
{
connect.Open();
SqlCommand cmd = new SqlCommand(proc, connect);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter id = new SqlParameter
{
ParameterName = @"id",
Value = maxIdFeedBack = maxIdFeedBack + 1
};
cmd.Parameters.Add(id);
SqlParameter id_event = new SqlParameter
{
ParameterName = @"id_event",
Value = ie.id.ToString()
};
cmd.Parameters.Add(id_event);
SqlParameter topic = new SqlParameter
{
ParameterName = @"topic",
Value = textBox_topic.Text.ToString()
};
cmd.Parameters.Add(topic);
SqlParameter text_feedback = new SqlParameter
{
ParameterName = @"text_feedback",
Value = richTextBox_text_feedback.Text.ToString()
};
cmd.Parameters.Add(text_feedback);
SqlParameter id_authors = new SqlParameter
{
ParameterName = @"id_authors",
Value = idAuthor.ToString()
};
cmd.Parameters.Add(id_authors);
SqlParameter rating_event = new SqlParameter
{
ParameterName = @"rating_event",
Value = comboBox_rate.Text.ToString()
};
cmd.Parameters.Add(rating_event);
SqlParameter date_feedback = new SqlParameter
{
ParameterName = @"date_feedback",
Value = System.DateTime.Now.ToString()
};
cmd.Parameters.Add(date_feedback);
cmd.ExecuteScalar();
log.Info($"Отзыв успешно добавлен! id мероприятия: {ie.id.ToString()}, id автора: {idAuthor.ToString()}.");
MessageBox.Show("Запись успешно добавлена", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
} // добавить отзыв