public static Customer GetCustomer(int id)
{
using (SqlConnection con = new SqlConnection(connString, credentials))
{
try
{
con.Open();
Dictionary <string, object> p = new Dictionary <string, object>
{
{ "@Id", id }
};
return(DBActions.ExecReaderSP <Customer>(con, "getCustomerById", p));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
con.Close();
}
}
}
