public void InsertMentalCheckInfo(PersonMentalCheck personMental)
{
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into hr.mentalHealthCheck (emplid, series, serialNumber, DateTo, scancopy )" +
"values (@emplid, @series, @serialNumber, @DateTo, @scancopy);", conn);
cmd.Parameters.Add(@"emplId", System.Data.SqlDbType.SmallInt); cmd.Parameters[@"emplId"].Value = Convert.ToInt16(personMental.emplId);
cmd.Parameters.AddWithValue(@"series", Convert.ToString(personMental.series));
cmd.Parameters.AddWithValue(@"serialNumber", Convert.ToString(personMental.serialNumber));
cmd.Parameters.AddWithValue(@"DateTo", Convert.ToDateTime(personMental.dateTo));
cmd.Parameters.AddWithValue(@"scancopy", (byte[])personMental.scancopy);
cmd.ExecuteNonQuery();
conn.Close();
conn.Dispose();
}
}
catch (Exception ex)
{
MessageBox.Show("помилка при відправці даних даних (психдисп.).");
}
}
//mentalhealth info about employee
public async Task <PersonMentalCheck> GetPersonmentalHealthInfo(short emplid)
{
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
PersonMentalCheck employee = new PersonMentalCheck();
await conn.OpenAsync();
SqlCommand cmd = new SqlCommand("EXECUTE hr.GetmentalCheckInfo " + emplid.ToString(), conn);
SqlDataReader reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
employee.emplId = reader.GetInt16(0);
employee.series = reader.GetString(1);
employee.serialNumber = reader.GetString(2);
employee.dateTo = reader.GetString(3);
if (reader.GetValue(4) == (object)0)
{
employee.scancopy = null;
}
else
{
employee.scancopy = (byte[])reader.GetValue(4);
}
}
reader.Close();
return(employee);
}
}
catch (Exception ex)
{
MessageBox.Show("Помилка при завантаженні даних (психічна довідка).");
return(null);
}
}
