public VolunteerForm()
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen;
SqlConnection connection = UserVolunteer.GetDBConnection();
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
using (SqlCommand sql = new SqlCommand())
{
SqlCommand sqlCom = new SqlCommand(@"SELECT * FROM dbo.Worker WHERE ID = @ID", connection);
sqlCom.Transaction = transaction;
sqlCom.Parameters.Add("@ID", SqlDbType.Int);
sqlCom.Parameters["@ID"].Value = Convert.ToInt32(ID);
SqlDataReader reader = sqlCom.ExecuteReader();
reader.Read();
label7.Text = reader.GetString(0);
label8.Text = reader.GetString(1);
label9.Text = reader.GetString(2);
reader.Close();
SqlCommand sqlCom2 = new SqlCommand(@"SELECT * FROM dbo.MedicalBook WHERE WorkerID = @ID", connection);
sqlCom2.Transaction = transaction;
sqlCom2.Parameters.Add("@ID", SqlDbType.Int);
sqlCom2.Parameters["@ID"].Value = Convert.ToInt32(ID);
SqlDataReader reader2 = sqlCom2.ExecuteReader();
reader2.Read();
if (reader2.GetBoolean(1) == false)
{
label12.Text = "Болен";
button2.Text = "Сообщить о выздоровлении";
}
else
{
label12.Text = "Здоров";
}
reader2.Close();
SqlCommand sqlCom1 = new SqlCommand(@"SELECT * FROM dbo.VPB WHERE WorkerID = @ID", connection);
sqlCom1.Transaction = transaction;
sqlCom1.Parameters.Add("@ID", SqlDbType.Int);
sqlCom1.Parameters["@ID"].Value = Convert.ToInt32(ID);
SqlDataReader reader1 = sqlCom1.ExecuteReader();
reader1.Read();
label10.Text = reader1.GetInt32(1).ToString();
label11.Text = reader1.GetInt32(2).ToString();
reader1.Close();
transaction.Commit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка");
transaction.Rollback();
}
connection.Close();
}
public IActionResult Volunteer(int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = _dbContext.AppUsers.Include(j => j.UserVolunteers)
.SingleOrDefault(j => j.Id == _usermgr.GetUserId(HttpContext.User));
var i = _dbContext.initiatives.Include(k => k.UserVolunteers).SingleOrDefault(k => k.InitiativeId == id);
if (i != null)
{
var uv = new UserVolunteer
{
initiative = i, initiativeId = i.InitiativeId, user = user, userId = user?.Id
};
user?.UserVolunteers.Add(uv);
i.UserVolunteers.Add(uv);
}
_dbContext.Update(user ?? throw new InvalidOperationException());
_dbContext.Update(i ?? throw new InvalidOperationException());
_dbContext.SaveChanges();
return(RedirectToAction("Category", "Initiatives", i.categoryId));
}
private void Button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
SqlConnection connection = UserVolunteer.GetDBConnection();
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
using (SqlCommand sql = new SqlCommand())
{
SqlCommand sqlCom =
new SqlCommand(@"SELECT WorkerID FROM Appointment WHERE ID = @ID", connection);
sqlCom.Transaction = transaction;
sqlCom.Parameters.Add("@ID", SqlDbType.Int);
sqlCom.Parameters["@ID"].Value = Convert.ToInt32(textBox1.Text);
SqlDataReader reader = sqlCom.ExecuteReader();
if (reader.Read() && reader.GetInt32(0).ToString() == ID)
{
reader.Close();
DialogResult result = MessageBox.Show(
"Вы уверены?",
"Сообщение",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
if (result == DialogResult.Yes)
{
sqlCom =
new SqlCommand(@"DELETE FROM Appointment WHERE ID = @ID", connection);
sqlCom.Parameters.Add("@ID", SqlDbType.Int);
sqlCom.Parameters["@ID"].Value = Convert.ToInt32(textBox1.Text);
sqlCom.ExecuteNonQuery();
UpdateTable();
}
}
else
{
MessageBox.Show("Такого номера нет в таблице.", "Ошибка");
}
}
transaction.Commit();
} catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так! Обратитесь к разработчику.", "Ошибка");
transaction.Rollback();
}
connection.Close();
}
else
{
MessageBox.Show("Вы не ввели никакого номера.", "Ошибка");
}
}
private void Button2_Click(object sender, EventArgs e) //сообщить о болезни
{
SqlConnection connection = UserVolunteer.GetDBConnection();
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try {
if (label12.Text == "Здоров")
{
DialogResult result = MessageBox.Show(
"Вы уверены? \n" +
"Ваше действие уберет Вас со всех мероприятий следующей недели!",
"Сообщение",
MessageBoxButtons.YesNo,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
if (result == DialogResult.Yes)
{
using (SqlCommand sql = new SqlCommand())
{
SqlCommand sqlCom = new SqlCommand(@"UPDATE dbo.MedicalBook SET IsHealthy = 0 WHERE WorkerID = @ID", connection);
sqlCom.Transaction = transaction;
sqlCom.Parameters.Add("@ID", SqlDbType.Int);
sqlCom.Parameters["@ID"].Value = Convert.ToInt32(ID);
sqlCom.ExecuteNonQuery();
label12.Text = "Болен";
button2.Text = "Сообщить о выздоровлении";
MessageBox.Show("Выздоравливайте!", "Сообщение");
}
}
transaction.Commit();
}
else
{
using (SqlCommand sql = new SqlCommand())
{
SqlCommand sqlCom = new SqlCommand(@"UPDATE dbo.MedicalBook SET IsHealthy = 1 WHERE WorkerID = @ID", connection);
sqlCom.Transaction = transaction;
sqlCom.Parameters.Add("@ID", SqlDbType.Int);
sqlCom.Parameters["@ID"].Value = Convert.ToInt32(ID);
sqlCom.ExecuteNonQuery();
label12.Text = "Здоров";
button2.Text = "Сообщить о болезни";
MessageBox.Show("Рады видеть Вас снова в строю!", "Сообщение");
}
transaction.Commit();
}
} catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так! Обратитесь к разработчику.", "Ошибка");
transaction.Rollback();
}
connection.Close();
}
public ActionResult AddUserVolunteer(UserVolunteer createRequest)
{
//if (_validator.Validate(createRequest))
// return BadRequest(new { error = "customer must have a First Name, Last Name and Email " });
foreach (var userService in createRequest.VolunteerServiceIds)
{
var userVolunteer = _userVolunteerRepository.AddUserVolunteer(userService, createRequest.UserId);
_eventVolunteerServiceRepository.UpdateEventVolunteerService(userVolunteer.Id, createRequest.EventId, userService);
}
return(Ok( ));
}
public void UpdateTable()
{
SqlConnection connection = UserVolunteer.GetDBConnection();
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
using (SqlCommand sql = new SqlCommand())
{
SqlCommand sqlCom =
new SqlCommand(@"SELECT Appointment.ID, Event_.NameE, EventZone.NameEZ, TimeStart, TimeEnd FROM dbo.Appointment
JOIN Event_ ON Event_.ID = Appointment.EventID
JOIN EventZone ON EventZone.ID = Appointment.ZoneID
WHERE WorkerID = @ID", connection);
sqlCom.Transaction = transaction;
sqlCom.Parameters.Add("@ID", SqlDbType.Int);
sqlCom.Parameters["@ID"].Value = Convert.ToInt32(ID);
SqlDataReader reader = sqlCom.ExecuteReader();
listView1.Items.Clear();
while (reader.Read())
{
ListViewItem lvi = new ListViewItem(new string[] {
reader.GetInt32(0).ToString(),
reader.GetString(1),
reader.GetString(2),
reader.GetDateTime(3).ToString("dd/MM/yyyy HH:mm"),
reader.GetDateTime(4).ToString("dd/MM/yyyy HH:mm")
});
listView1.Items.Add(lvi);
}
reader.Close();
}
transaction.Commit();
} catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так! Обратитесь к разработчику.", "Ошибка");
transaction.Rollback();
}
connection.Close();
}
