public List <PersonPreview> GetPreviews(List <short> idlist)
{
List <PersonPreview> personPreviews = new List <PersonPreview>();
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
foreach (short empl in idlist)
{
PersonPreview preview = new PersonPreview();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from hr.employeePreview where emplid = " + empl, conn);
//cmd.Parameters.AddWithValue(@"emplId", empl);
SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
preview.id = Convert.ToInt16(reader.GetValue(0));
preview.fullname = reader.GetValue(1).ToString();
preview.position = reader.GetValue(2).ToString();
preview.phone = reader.GetValue(3).ToString();
}
conn.Close();
personPreviews.Add(preview);
}
}
return(personPreviews);
}
catch (Exception ex)
{
MessageBox.Show("Помилка при виведенні результатів.");
return(null);
}
}
//Employee previews on main screen
public List <PersonPreview> GetPreviews()
{
List <PersonPreview> personPreviews = new List <PersonPreview>();
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from hr.employeePreview;", conn);
SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
PersonPreview preview = new PersonPreview()
{
id = Convert.ToInt16(reader.GetValue(0)),
fullname = reader.GetValue(1).ToString(),
position = reader.GetValue(2).ToString(),
phone = reader.GetValue(3).ToString()
};
personPreviews.Add(preview);
}
return(personPreviews);
}
}
catch (Exception ex)
{
MessageBox.Show("Помилка при завантаженні даних.");
return(null);
}
}