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); }