public Katigoria get_diafora_posou(Oplitis myOplitis) { Dal myDal = new Dal(); Katigoria myKatigoria = new Katigoria(); SqlDataReader dr = myDal.getDiaforaPosou(myOplitis); DataTable dt = new DataTable(); if (dr.HasRows) { dt.Load(dr); } foreach (DataRow row in dt.Rows) { myKatigoria.katDiafora = Convert.ToDecimal(row["diafora"].ToString()); myKatigoria.katPliroteoNew = Convert.ToDecimal(row["katPliroteo_new"].ToString()); myKatigoria.katPliroteoOld = Convert.ToDecimal(row["katPliroteo_old"].ToString()); myKatigoria.newKatName = row["katName_new"].ToString(); myKatigoria.oldKatName = row["katName_old"].ToString(); } return(myKatigoria); }