public void InsertDisabilityInfo(PersonDisability disability)
{
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into hr.disabledEmployees (emplid, series, serialNumber, " +
"msecDateFrom, timeIssued, disabilityDateFrom, disabilityDateTo, disabilityGroup, reason, scancopy) " +
"values (@emplid, @series, @serialNumber, @msecDateFrom, @timeIssued, @disabilityDateFrom, @disabilityDateTo, " +
"@disabilityGroup, @reason, @scancopy);", conn);
cmd.Parameters.Add(@"emplId", System.Data.SqlDbType.SmallInt); cmd.Parameters[@"emplId"].Value = Convert.ToInt16(disability.emplId);
cmd.Parameters.AddWithValue(@"series", Convert.ToString(disability.disabSeries));
cmd.Parameters.AddWithValue(@"serialNumber", Convert.ToString(disability.disabNumber));
cmd.Parameters.AddWithValue(@"msecDateFrom", Convert.ToString(disability.msecDateFrom));
cmd.Parameters.AddWithValue(@"timeIssued", Convert.ToString(disability.timeIssued));
cmd.Parameters.AddWithValue(@"disabilityDateFrom", Convert.ToString(disability.disabilityDateFrom));
cmd.Parameters.AddWithValue(@"disabilityDateTo", Convert.ToString(disability.disabilityDateTo));
cmd.Parameters.AddWithValue(@"disabilityGroup", Convert.ToChar(disability.disabilityGroup));
cmd.Parameters.AddWithValue(@"reason", Convert.ToString(disability.reason));
cmd.Parameters.AddWithValue(@"scancopy", (byte[])disability.scancopy);
cmd.ExecuteNonQuery();
conn.Close();
conn.Dispose();
}
}
catch (Exception ex)
{
MessageBox.Show("помилка при відправці даних даних (інв.).");
}
}
//disability info about employee
public async Task <PersonDisability> GetPersonDisabilityInfo(short emplid)
{
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
PersonDisability employee = new PersonDisability();
await conn.OpenAsync();
SqlCommand cmd = new SqlCommand("EXECUTE hr.GetDisabilityInfo " + emplid.ToString(), conn);
SqlDataReader reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
employee.emplId = reader.GetInt16(0);
employee.disabSeries = reader.GetString(1);
employee.disabNumber = reader.GetString(2);
employee.msecDateFrom = reader.GetString(3);
employee.timeIssued = reader.GetString(4);
employee.disabilityDateFrom = reader.GetString(5);
employee.disabilityDateTo = reader.GetString(6);
employee.disabilityGroup = reader.GetString(7);
employee.reason = reader.GetString(8);
if (reader.GetValue(9) == (object)0)
{
employee.scancopy = null;
}
else
{
employee.scancopy = (byte[])reader.GetValue(9);
}
}
reader.Close();
return(employee);
}
}
catch (Exception ex)
{
MessageBox.Show("Помилка при завантаженні даних (інв.).");
return(null);
}
}