public static List <BorsaIslemModel> getAllRecordsbyID(int borsaID)
{
List <BorsaIslemModel> bimList = new List <BorsaIslemModel>();
using (BorsaEntities en = new BorsaEntities())
{
var list = en.BorsaIslem.Where(x => x.BorsaID == borsaID).OrderByDescending(t => t.Tarih).ToList();
foreach (var bi in list)
{
BorsaIslemModel bim = new BorsaIslemModel()
{
IslemID = bi.IslemID,
BorsaID = bi.BorsaID,
Alis = bi.Alis,
Satis = bi.Satis,
Degisim = bi.Degisim,
Tarih = bi.Tarih
};
bim.Borsa.Adi = bi.Borsa.Adi;
bim.Borsa.Tur = bi.Borsa.Tur;
bimList.Add(bim);
}
return(bimList);
}
}
public static BorsaIslemModel getLastRecord(int borsaID)
{
using (BorsaEntities en = new BorsaEntities())
{
var borsa = en.BorsaIslem.Where(x => x.BorsaID == borsaID).OrderByDescending(x => x.Tarih).FirstOrDefault();
if (borsa != null)
{
BorsaIslemModel don = new BorsaIslemModel()
{
IslemID = borsa.IslemID,
BorsaID = borsa.BorsaID,
Alis = borsa.Alis,
Satis = borsa.Satis,
Degisim = borsa.Degisim,
Tarih = borsa.Tarih
};
don.Borsa.Adi = borsa.Borsa.Adi;
don.Borsa.Tur = borsa.Borsa.Tur;
return(don);
}
else
{
return(null);
}
}
}
private void DovizGuncelle(BorsaIslemModel islem)
{
switch (islem.BorsaID)
{
case 2:
lblDolarAl.Text = islem.Alis.ToString("0.0000");
lblDolarSat.Text = islem.Satis.ToString("0.0000");
lblDolarArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblDolarArtis.ForeColor = Color.Green;
}
else
{
lblDolarArtis.ForeColor = Color.Red;
}
break;
case 3:
lblEuroAl.Text = islem.Alis.ToString("0.0000");
lblEuroSat.Text = islem.Satis.ToString("0.0000");
lblEuroArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblEuroArtis.ForeColor = Color.Green;
}
else
{
lblEuroArtis.ForeColor = Color.Red;
}
break;
case 4:
lblSterlinAl.Text = islem.Alis.ToString("0.0000");
lblSterlinSat.Text = islem.Satis.ToString("0.0000");
lblSterlinArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblSterlinArtis.ForeColor = Color.Green;
}
else
{
lblSterlinArtis.ForeColor = Color.Red;
}
break;
case 5:
lblFrankAl.Text = islem.Alis.ToString("0.0000");
lblFrankSat.Text = islem.Satis.ToString("0.0000");
lblFrankArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblFrankArtis.ForeColor = Color.Green;
}
else
{
lblFrankArtis.ForeColor = Color.Red;
}
break;
case 6:
lblYenAl.Text = islem.Alis.ToString("0.0000");
lblYenSat.Text = islem.Satis.ToString("0.0000");
lblYenArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblYenArtis.ForeColor = Color.Green;
}
else
{
lblYenArtis.ForeColor = Color.Red;
}
break;
case 7:
lblAltinGrAl.Text = islem.Alis.ToString("0.0000");
lblAltinGrSat.Text = islem.Satis.ToString("0.0000");
lblAltinGrArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblAltinGrArtis.ForeColor = Color.Green;
}
else
{
lblAltinGrArtis.ForeColor = Color.Red;
}
break;
case 8:
lblAltinCeyrekAl.Text = islem.Alis.ToString("0.0000");
lblAltinCeyrekSat.Text = islem.Satis.ToString("0.0000");
lblAltinCeyrekArtis.Text = islem.Degisim.ToString("0.0000");
if (islem.Degisim >= 0)
{
lblAltinCeyrekArtis.ForeColor = Color.Green;
}
else
{
lblAltinCeyrekArtis.ForeColor = Color.Red;
}
break;
}
}
