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