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