public void InsertMilitaryInfo(PersonMilitary military) { try { using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into hr.militaryLiable ( emplid, series, serialNumber, militaryDept, militaryRank ) " + "values (@emplId, @series, @serialNumber, @militaryDept, @militaryRank) ;", conn); cmd.Parameters.Add(@"emplId", System.Data.SqlDbType.SmallInt); cmd.Parameters[@"emplId"].Value = Convert.ToInt16(military.emplId); cmd.Parameters.AddWithValue(@"series", Convert.ToString(military.series)); cmd.Parameters.AddWithValue(@"serialNumber", Convert.ToString(military.serialNumber)); cmd.Parameters.AddWithValue(@"militaryDept", Convert.ToString(military.militaryRank)); cmd.Parameters.AddWithValue(@"militaryRank", Convert.ToString(military.militaryDept)); cmd.ExecuteNonQuery(); conn.Close(); conn.Dispose(); } } catch (Exception ex) { MessageBox.Show("помилка при відправці даних даних (Військ.)."); } }
//military info about employee public async Task <PersonMilitary> GetPersonMilitaryInfo(short emplid) { try { using (SqlConnection conn = new SqlConnection(connStr)) { PersonMilitary employee = new PersonMilitary(); await conn.OpenAsync(); SqlCommand cmd = new SqlCommand("EXECUTE hr.GetMilInfo " + 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.militaryDept = reader.GetString(3); employee.militaryRank = reader.GetString(4); } reader.Close(); return(employee); } } catch (Exception ex) { MessageBox.Show("Помилка при завантаженні даних (військовозоб.)."); return(null); } }