public Katigoria get_Katigoria_By_Id(Oplitis myOplitis)
{
Dal myDal = new Dal();
Katigoria myKatigoria = new Katigoria();
DataTable dt = new DataTable();
SqlDataReader dr = myDal.getKatigoriaById(myOplitis);
if (dr.HasRows)
{
dt.Load(dr);
}
foreach (DataRow row in dt.Rows)
{
myKatigoria.katPerigrafi = row["kat_name"].ToString();
myKatigoria.katKatalogisteo = Convert.ToDecimal(row["kat_katalogisteo"].ToString());
myKatigoria.katKratiseis = Convert.ToDecimal(row["kat_kratiseis"].ToString());
myKatigoria.katPliroteo = Convert.ToDecimal(row["kat_pliroteo"].ToString());
myKatigoria.katDXmas = Convert.ToDecimal(row["kat_dx"].ToString());
myKatigoria.katDPasxa = Convert.ToDecimal(row["kat_dp"].ToString());
}
return(myKatigoria);
}