public List <UpisDetailModel> GetDetailMaster()
{
List <UpisDetailModel> masterDetails = new List <UpisDetailModel>();
using (SqlConnection conn = new SqlConnection(conString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "UpisiMasterDetails";
cmd.Connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UpisDetailModel master = new UpisDetailModel();
master.Ime = reader["Ime"].ToString();
master.Prezime = reader["Prezime"].ToString();
master.Email = reader["Email"].ToString();
master.Naziv = reader["Naziv"].ToString();
master.Opis = reader["Opis"].ToString();
master.DatumUpisa = DateTime.Parse(reader["DatumUpisa"].ToString());
masterDetails.Add(master);
}
}
}
return(masterDetails);
}
public List <UpisDetailModel> GetUpis()
{
List <UpisDetailModel> upisDetailsList = new List <UpisDetailModel>();
using (SqlConnection conn = new SqlConnection(conString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "upisimasterdetails";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UpisDetailModel details = new UpisDetailModel();
details.Ime = reader["Ime"].ToString();
details.Prezime = reader["Prezime"].ToString();
details.Email = reader["Email"].ToString();
details.DatumUpisa = DateTime.Parse(reader["IdPolaznik"].ToString());
details.Naziv = reader["Naziv"].ToString();
details.Opis = reader["Opis"].ToString();
upisDetailsList.Add(details);
}
}
}
return(upisDetailsList);
}
