public override void Page_Load(object sender, EventArgs e) { try { PageOperations PageOps = new PageOperations(); //List<HocaBilgiObj> lstScreenInfoObj = PageOps.RunQueryForPage<HocaBilgiObj>(DbCommandList.GET_HOCA_BILGI, null, null); List <HocaBilgiObj> lstScreenInfoObj = null; if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.HOCA.ToString()) { lstScreenInfoObj = PageOps.RunQueryForPage <HocaBilgiObj>(DbCommandList.GET_HOCA_BILGI, new string[] { "P_HOCA_ID" }, new object[] { ksfSI.HocaGuid }); } else { lstScreenInfoObj = PageOps.RunQueryForPage <HocaBilgiObj>(DbCommandList.GET_HOCA_BILGI, null, null); } tblRepeater.DataSource = lstScreenInfoObj; tblRepeater.DataBind(); } catch (Exception ex) { standardErr = "İşlem gerçekleştirilirken bir hata oluştu."; RaisePopUp(ex.Message, ResultStatus.Error); } }
public override void Page_Load(object sender, EventArgs e) { try { deleteUrl = pageName + "/DeleteCurrentRow"; PageOperations PageOps = new PageOperations(); List <PageOgrBilgiObj> lstScreenInfoObj = null; if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.HOCA.ToString()) { lstScreenInfoObj = PageOps.RunQueryForPage <PageOgrBilgiObj>(DbCommandList.GET_PAGE_OGR_BILGI, new string[] { "P_HOCA_ID" }, new object[] { ksfSI.HocaGuid }); } else if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.OGRENCI.ToString() || ksfSI.RoleName.ToUpper() == RoleNames.VELI.ToString()) { lstScreenInfoObj = PageOps.RunQueryForPage <PageOgrBilgiObj>(DbCommandList.GET_PAGE_OGR_BILGI, new string[] { "P_OGR_ID" }, new object[] { ksfSI.OgrenciGuid }); } else//Tüm öğrencileri getirir. { lstScreenInfoObj = PageOps.RunQueryForPage <PageOgrBilgiObj>(DbCommandList.GET_PAGE_OGR_BILGI, null, null); } tblRepeater.DataSource = lstScreenInfoObj; tblRepeater.DataBind(); } catch (Exception ex) { standardErr = "İşlem gerçekleştirilirken bir hata oluştu."; RaisePopUp(ex.Message, ResultStatus.Error); } }
public override void Page_Load(object sender, EventArgs e) { try { PageOperations PageOps = new PageOperations(); List <TestCozmeDurumuObj> lstScreenInfoObj = null; string[] paramNames = null; object[] paramValues = null; if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.OGRENCI.ToString() || ksfSI.RoleName.ToUpper() == RoleNames.VELI.ToString()) { paramNames = new string[] { "P_OGR_ID" }; paramValues = new object[] { ksfSI.OgrenciGuid }; lstScreenInfoObj = PageOps.RunQueryForPage <TestCozmeDurumuObj>(DbCommandList.GET_OGR_TEST_REL, paramNames, paramValues); } else//Hem Hocaların hem de öğrencilerin müfredat bilgilerini getirir. { lstScreenInfoObj = PageOps.RunQueryForPage <TestCozmeDurumuObj>(DbCommandList.GET_OGR_TEST_REL, null, null); } tblRepeater.DataSource = lstScreenInfoObj; tblRepeater.DataBind(); } catch (Exception ex) { standardErr = "İşlem gerçekleştirilirken bir hata oluştu."; RaisePopUp(ex.Message, ResultStatus.Error); } }
public override void Page_Load(object sender, EventArgs e) { try { SessionInfo sessionInfo = (SessionInfo)Session["KsfSessionInfo"]; deleteUrl = pageName + "/DeleteCurrentRow"; PageOperations PageOps = new PageOperations(); List <UserTableObj> lstScreenInfoObj = PageOps.RunQueryForPage <UserTableObj>(DbCommandList.GET_USER_INFO, null, null); //Eğer bu oturumdaki kullanıcı adminse ve Owner rolüne sahipse : bu user'ın guid bilgileri boş set edilsin. if (sessionInfo.IsAdmin == 1 && sessionInfo.RoleGuid == 2) { //List<UserTableObj> lstCantDeleted = (List<UserTableObj>)lstScreenInfoObj.Select(x => x.ROLE_GUID == 2 && x.IS_ADMIN == "Evet"); } //lstScreenInfoObj.Where(x=>x.ROLE_GUID==2 && sessionInfo.IsAdmin && sessionInfo.RoleGuid==2?) tblRepeater.DataSource = lstScreenInfoObj; tblRepeater.DataBind(); } catch (Exception ex) { standardErr = "İşlem gerçekleştirilirken bir hata oluştu."; RaisePopUp(ex.Message, ResultStatus.Error); } }
public override void Page_Load(object sender, EventArgs e) { try { PageOperations PageOps = new PageOperations(); List <TestBilgiObj> lstScreenInfoObj = PageOps.RunQueryForPage <TestBilgiObj>(DbCommandList.GET_TEST_BILGI, null, null); tblRepeater.DataSource = lstScreenInfoObj; tblRepeater.DataBind(); } catch (Exception ex) { standardErr = "İşlem gerçekleştirilirken bir hata oluştu."; RaisePopUp(ex.Message, ResultStatus.Error); } }
private bool LoadParameters() { #region FillDersAdı PageOperations PageOps = new PageOperations(); List <NameValue> lstDataSource = new List <NameValue>(); lstDersBilgi = PageOps.RunQueryForPage <DERS_BILGI>(DbCommandList.GET_DERS_BILGI, null, null); lstDataSource = new List <NameValue>(); List <DERS_BILGI> lstCurrentDersBilgiObj = lstDersBilgi.Where <DERS_BILGI>(x => x.SINIF.ToString() == slcSinif.Value).ToList(); foreach (var item in lstCurrentDersBilgiObj) { lstDataSource.Add(new NameValue { Name = item.DERS_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcDersAdi.DataSource = lstDataSource.ToArray(); slcDersAdi.DataTextField = "Name"; slcDersAdi.DataValueField = "Value"; slcDersAdi.DataBind(); } else { slcDersAdi.DataSource = null; slcDersAdi.DataBind(); } #endregion return(true); }
private bool LoadParameters() { #region FillMahalleBilgisi PageOperations PageOps = new PageOperations(); List <NameValue> lstDataSource = new List <NameValue>(); List <BOLGE_INFO> lstBolgeInfo = PageOps.RunQueryForPage <BOLGE_INFO>(DbCommandList.GET_BOLGE_INFO, null, null); lstDataSource.Clear(); lstDataSource = new List <NameValue>(); foreach (var item in lstBolgeInfo) { lstDataSource.Add(new NameValue { Name = item.BOLGE_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcMahalle.DataSource = lstDataSource.ToArray(); slcMahalle.DataTextField = "Name"; slcMahalle.DataValueField = "Value"; slcMahalle.DataBind(); } else { slcMahalle.DataSource = null; slcMahalle.DataBind(); } #endregion return(true); }
private bool LoadParameters() { #region FillHocaBilgisi PageOperations PageOps = new PageOperations(); List <HocaBilgiObj> lstScreenInfoObj = PageOps.RunQueryForPage <HocaBilgiObj>(DbCommandList.GET_HOCA_BILGI, null, null); List <NameValue> lstDataSource = new List <NameValue>(); //Login olan kullanıcı Hoca rolündeyse sadece o hocanın bilgisi gelir. if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.HOCA.ToString()) { lstScreenInfoObj = lstScreenInfoObj.Where(x => x.HOCA_GUID == ksfSI.HocaGuid).ToList(); } foreach (var item in lstScreenInfoObj) { lstDataSource.Add(new NameValue { Name = item.HOCA_ADI + " " + item.HOCA_SOYADI + " - " + item.SINIF + ". sınıf", Value = item.HOCA_GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcHocaBilgi.DataSource = lstDataSource.ToArray(); slcHocaBilgi.DataTextField = "Name"; slcHocaBilgi.DataValueField = "Value"; slcHocaBilgi.DataBind(); } else { slcHocaBilgi.DataSource = null; slcHocaBilgi.DataBind(); } #endregion #region FillMahalleBilgisi List <BOLGE_INFO> lstBolgeInfo = PageOps.RunQueryForPage <BOLGE_INFO>(DbCommandList.GET_BOLGE_INFO, null, null); lstDataSource.Clear(); lstDataSource = new List <NameValue>(); foreach (var item in lstBolgeInfo) { lstDataSource.Add(new NameValue { Name = item.BOLGE_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcMahalle.DataSource = lstDataSource.ToArray(); slcMahalle.DataTextField = "Name"; slcMahalle.DataValueField = "Value"; slcMahalle.DataBind(); } else { slcMahalle.DataSource = null; slcMahalle.DataBind(); } #endregion return(true); }
private bool LoadParameters() { #region Fill User Role Info PageOperations PageOps = new PageOperations(); List <USER_ROLE> lstScreenInfoObj = PageOps.RunQueryForPage <USER_ROLE>(DbCommandList.PRM_USER_ROLES, null, null); List <NameValue> lstDataSource = new List <NameValue>(); foreach (var item in lstScreenInfoObj) { lstDataSource.Add(new NameValue { Name = item.ROLE_NAME, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcRole.DataSource = lstDataSource.ToArray(); slcRole.DataTextField = "Name"; slcRole.DataValueField = "Value"; slcRole.DataBind(); } else { slcRole.DataSource = null; slcRole.DataBind(); } #endregion #region Fill Mahalle Bilgisi List <BOLGE_INFO> lstBolgeInfo = PageOps.RunQueryForPage <BOLGE_INFO>(DbCommandList.GET_BOLGE_INFO, null, null); lstDataSource.Clear(); lstDataSource = new List <NameValue>(); foreach (var item in lstBolgeInfo) { lstDataSource.Add(new NameValue { Name = item.BOLGE_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcMahalle.DataSource = lstDataSource.ToArray(); slcMahalle.DataTextField = "Name"; slcMahalle.DataValueField = "Value"; slcMahalle.DataBind(); } else { slcMahalle.DataSource = null; slcMahalle.DataBind(); } #endregion #region Fill Ogrenci PageOps = new PageOperations(); lstOgrBilgi = PageOps.RunQueryForPage <OGR_BILGI>(DbCommandList.PRM_OGR, null, null); #endregion #region Fill Hoca lstDataSource = null; PageOps = new PageOperations(); lstHocaBilgi = PageOps.RunQueryForPage <HOCA_BILGI>(DbCommandList.PRM_HOCA, null, null); #endregion ViewState.Clear(); ViewState.Add("lstOgrBilgi", lstOgrBilgi); return(true); }
private bool LoadParameters() { #region Fill Hafta PageOperations PageOps = new PageOperations(); List <NameValue> lstDataSource = new List <NameValue>(); List <HOCA_BILGI> lstHocaBilgi = PageOps.RunQueryForPage <HOCA_BILGI>(DbCommandList.PRM_HOCA, null, null); lstDataSource = new List <NameValue>(); List <HAFTA_BILGI> lstHaftaBilgi = PageOps.RunQueryForPage <HAFTA_BILGI>(DbCommandList.GET_HAFTA_BILGI, null, null); lstDataSource = new List <NameValue>(); foreach (var item in lstHaftaBilgi) { lstDataSource.Add(new NameValue { Name = item.HAFTA_ADI + " : " + item.TARIH, Value = item.HAFTA_ID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcHafta.DataSource = lstDataSource.ToArray(); slcHafta.DataTextField = "Name"; slcHafta.DataValueField = "Value"; slcHafta.DataBind(); } else { slcHafta.DataSource = null; slcHafta.DataBind(); } #endregion #region Fill DersAdı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstDersBilgi = PageOps.RunQueryForPage <DERS_BILGI>(DbCommandList.GET_DERS_BILGI, null, null); List <DERS_BILGI> lstCurrentDersBilgiObj = lstDersBilgi.Where <DERS_BILGI>(x => x.SINIF.ToString() == slcSinif.Value).ToList(); foreach (var item in lstCurrentDersBilgiObj) { lstDataSource.Add(new NameValue { Name = item.DERS_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcDersAdi.DataSource = lstDataSource.ToArray(); slcDersAdi.DataTextField = "Name"; slcDersAdi.DataValueField = "Value"; slcDersAdi.DataBind(); } else { slcDersAdi.DataSource = null; slcDersAdi.DataBind(); } #endregion #region Fill KonuAdı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstKonuBilgi = PageOps.RunQueryForPage <DersKonuBilgiObj>(DbCommandList.GET_DERS_KONU_BILGI, null, null); List <DersKonuBilgiObj> lstCurrentKonuBilgiObj = lstKonuBilgi.Where <DersKonuBilgiObj>(x => x.DERS_GUID.ToString() == slcDersAdi.Value).ToList(); foreach (var item in lstCurrentKonuBilgiObj) { lstDataSource.Add(new NameValue { Name = item.KONU, Value = item.DERS_KONU_GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcKonuAdi.DataSource = lstDataSource.ToArray(); slcKonuAdi.DataTextField = "Name"; slcKonuAdi.DataValueField = "Value"; slcKonuAdi.DataBind(); } else { slcKonuAdi.DataSource = null; slcKonuAdi.DataBind(); } #endregion return(true); }
private bool LoadParameters() { #region Fill Kişi PageOperations PageOps = new PageOperations(); List <NameValue> lstDataSource = new List <NameValue>(); lstKisiBilgi = PageOps.RunQueryForPage <HocaAndOgrenciObj>(DbCommandList.GET_HOCA_AND_OGRENCI, null, null); lstDataSource = new List <NameValue>(); if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.HOCA.ToString()) { lstKisiBilgi = lstKisiBilgi.Where(x => x.TIP == 1 && x.HOCA_GUID == ksfSI.HocaGuid).ToList(); foreach (var item in lstKisiBilgi.Where(x => x.TIP == 1 && x.HOCA_GUID == ksfSI.HocaGuid).ToList())//Default olarak öğrenciler dolduruluyor. { lstDataSource.Add(new NameValue { Name = item.AD_SOYAD, Value = item.GUID.ToString() }); } } else { foreach (var item in lstKisiBilgi.Where(x => x.TIP == 1).ToList())//Default olarak öğrenciler dolduruluyor. { lstDataSource.Add(new NameValue { Name = item.AD_SOYAD, Value = item.GUID.ToString() }); } } if (lstDataSource != null && lstDataSource.Count > 0) { slcKisi.DataSource = lstDataSource.ToArray(); slcKisi.DataTextField = "Name"; slcKisi.DataValueField = "Value"; slcKisi.DataBind(); } else { slcKisi.DataSource = null; slcKisi.DataBind(); } #endregion #region Fill Hafta lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); List <HAFTA_BILGI> lstHaftaBilgi = PageOps.RunQueryForPage <HAFTA_BILGI>(DbCommandList.GET_HAFTA_BILGI, null, null); lstDataSource = new List <NameValue>(); bool isFirstIteration = true; foreach (var item in lstHaftaBilgi) { if (isFirstIteration) { lstDataSource.Add(new NameValue { Name = "Hafta Seç..", Value = "" }); isFirstIteration = false; } lstDataSource.Add(new NameValue { Name = item.HAFTA_ADI + " : " + item.TARIH, Value = item.HAFTA_ID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcHafta.DataSource = lstDataSource.ToArray(); slcHafta.DataTextField = "Name"; slcHafta.DataValueField = "Value"; slcHafta.DataBind(); } else { slcHafta.DataSource = null; slcHafta.DataBind(); } #endregion #region Fill Mahalle List <BOLGE_INFO> lstBolgeInfo = PageOps.RunQueryForPage <BOLGE_INFO>(DbCommandList.GET_BOLGE_INFO, null, null); lstDataSource.Clear(); lstDataSource = new List <NameValue>(); isFirstIteration = true; foreach (var item in lstBolgeInfo) { if (isFirstIteration) { lstDataSource.Add(new NameValue { Name = "Mahalle Seç..", Value = "" }); isFirstIteration = false; } lstDataSource.Add(new NameValue { Name = item.BOLGE_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcMahalle.DataSource = lstDataSource.ToArray(); slcMahalle.DataTextField = "Name"; slcMahalle.DataValueField = "Value"; slcMahalle.DataBind(); } else { slcMahalle.DataSource = null; slcMahalle.DataBind(); } #endregion #region Fill Tip if (ksfSI.IsAdmin == 1) { NameValue[] NameValueArr = new NameValue[2]; NameValueArr[0] = new NameValue(); NameValueArr[0].Name = "Öğrenci"; NameValueArr[0].Value = "1"; NameValueArr[1] = new NameValue(); NameValueArr[1].Name = "Hoca"; NameValueArr[1].Value = "2"; slcTip.DataSource = NameValueArr; slcTip.DataTextField = "Name"; slcTip.DataValueField = "Value"; slcTip.DataBind(); } else { NameValue[] NameValueArr = new NameValue[1]; NameValueArr[0] = new NameValue(); NameValueArr[0].Name = "Öğrenci"; NameValueArr[0].Value = "1"; slcTip.DataSource = NameValueArr; slcTip.DataTextField = "Name"; slcTip.DataValueField = "Value"; slcTip.DataBind(); } #endregion return(true); }
private bool LoadParameters() { #region Fill Hoca PageOperations PageOps = new PageOperations(); List <NameValue> lstDataSource = new List <NameValue>(); List <HOCA_BILGI> lstHocaBilgi = PageOps.RunQueryForPage <HOCA_BILGI>(DbCommandList.PRM_HOCA, null, null); if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.HOCA.ToString()) { lstHocaBilgi = lstHocaBilgi.Where(x => x.GUID == ksfSI.HocaGuid).ToList(); } lstDataSource = new List <NameValue>(); foreach (var item in lstHocaBilgi) { lstDataSource.Add(new NameValue { Name = item.HOCA_ADI + " " + item.HOCA_SOYADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcHoca.DataSource = lstDataSource.ToArray(); slcHoca.DataTextField = "Name"; slcHoca.DataValueField = "Value"; slcHoca.DataBind(); } else { slcHoca.DataSource = null; slcHoca.DataBind(); } #endregion #region Fill Hafta lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); List <HAFTA_BILGI> lstHaftaBilgi = PageOps.RunQueryForPage <HAFTA_BILGI>(DbCommandList.GET_HAFTA_BILGI, null, null); lstDataSource = new List <NameValue>(); foreach (var item in lstHaftaBilgi) { lstDataSource.Add(new NameValue { Name = item.HAFTA_ADI + " : " + item.TARIH, Value = item.HAFTA_ID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcHafta.DataSource = lstDataSource.ToArray(); slcHafta.DataTextField = "Name"; slcHafta.DataValueField = "Value"; slcHafta.DataBind(); } else { slcHafta.DataSource = null; slcHafta.DataBind(); } #endregion #region Fill DersAdı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstDersBilgi = PageOps.RunQueryForPage <DERS_BILGI>(DbCommandList.GET_DERS_BILGI, null, null); List <DERS_BILGI> lstCurrentDersBilgiObj = lstDersBilgi.Where <DERS_BILGI>(x => x.SINIF.ToString() == slcSinif.Value).ToList(); foreach (var item in lstCurrentDersBilgiObj) { lstDataSource.Add(new NameValue { Name = item.DERS_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcDersAdi.DataSource = lstDataSource.ToArray(); slcDersAdi.DataTextField = "Name"; slcDersAdi.DataValueField = "Value"; slcDersAdi.DataBind(); } else { slcDersAdi.DataSource = null; slcDersAdi.DataBind(); } #endregion #region Fill KonuAdı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstKonuBilgi = PageOps.RunQueryForPage <DersKonuBilgiObj>(DbCommandList.GET_DERS_KONU_BILGI, null, null); List <DersKonuBilgiObj> lstCurrentKonuBilgiObj = lstKonuBilgi.Where <DersKonuBilgiObj>(x => x.DERS_GUID.ToString() == slcDersAdi.Value).ToList(); foreach (var item in lstCurrentKonuBilgiObj) { lstDataSource.Add(new NameValue { Name = item.KONU, Value = item.DERS_KONU_GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcKonuAdi.DataSource = lstDataSource.ToArray(); slcKonuAdi.DataTextField = "Name"; slcKonuAdi.DataValueField = "Value"; slcKonuAdi.DataBind(); } else { slcKonuAdi.DataSource = null; slcKonuAdi.DataBind(); } #endregion #region Fill TakipDurumu lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); List <PRM_TAKIP_DURUMU> lstTakipDurumu = PageOps.RunQueryForPage <PRM_TAKIP_DURUMU>(DbCommandList.PRM_TAKIP_DURUMU, null, null); foreach (var item in lstTakipDurumu) { lstDataSource.Add(new NameValue { Name = item.DESCRIPTION, Value = item.ID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcTakipDurumu.DataSource = lstDataSource.ToArray(); slcTakipDurumu.DataTextField = "Name"; slcTakipDurumu.DataValueField = "Value"; slcTakipDurumu.DataBind(); } else { slcTakipDurumu.DataSource = null; slcTakipDurumu.DataBind(); } #endregion return(true); }
private bool LoadParameters() { #region Fill Hafta PageOperations PageOps = new PageOperations(); List <NameValue> lstDataSource = new List <NameValue>(); List <HOCA_BILGI> lstHocaBilgi = PageOps.RunQueryForPage <HOCA_BILGI>(DbCommandList.PRM_HOCA, null, null); lstDataSource = new List <NameValue>(); List <HAFTA_BILGI> lstHaftaBilgi = PageOps.RunQueryForPage <HAFTA_BILGI>(DbCommandList.GET_HAFTA_BILGI, null, null); lstDataSource = new List <NameValue>(); foreach (var item in lstHaftaBilgi) { lstDataSource.Add(new NameValue { Name = item.HAFTA_ADI + " : " + item.TARIH, Value = item.HAFTA_ID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcHafta.DataSource = lstDataSource.ToArray(); slcHafta.DataTextField = "Name"; slcHafta.DataValueField = "Value"; slcHafta.DataBind(); } else { slcHafta.DataSource = null; slcHafta.DataBind(); } #endregion #region Fill DersAdı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstDersBilgi = PageOps.RunQueryForPage <DERS_BILGI>(DbCommandList.GET_DERS_BILGI, null, null); List <DERS_BILGI> lstCurrentDersBilgiObj = lstDersBilgi.Where <DERS_BILGI>(x => x.SINIF.ToString() == slcSinif.Value).ToList(); foreach (var item in lstCurrentDersBilgiObj) { lstDataSource.Add(new NameValue { Name = item.DERS_ADI, Value = item.GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcDersAdi.DataSource = lstDataSource.ToArray(); slcDersAdi.DataTextField = "Name"; slcDersAdi.DataValueField = "Value"; slcDersAdi.DataBind(); } else { slcDersAdi.DataSource = null; slcDersAdi.DataBind(); } #endregion #region Fill KonuAdı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstKonuBilgi = PageOps.RunQueryForPage <DersKonuBilgiObj>(DbCommandList.GET_DERS_KONU_BILGI, null, null); List <DersKonuBilgiObj> lstCurrentKonuBilgiObj = lstKonuBilgi.Where <DersKonuBilgiObj>(x => x.DERS_GUID.ToString() == slcDersAdi.Value).ToList(); foreach (var item in lstCurrentKonuBilgiObj) { lstDataSource.Add(new NameValue { Name = item.KONU, Value = item.DERS_KONU_GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcKonuAdi.DataSource = lstDataSource.ToArray(); slcKonuAdi.DataTextField = "Name"; slcKonuAdi.DataValueField = "Value"; slcKonuAdi.DataBind(); } else { slcKonuAdi.DataSource = null; slcKonuAdi.DataBind(); } #endregion #region Test Adı lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstTestBilgi = PageOps.RunQueryForPage <TestBilgiObj>(DbCommandList.GET_TEST_BILGI, null, null); List <TestBilgiObj> lstCurrentTestBilgi = lstTestBilgi.Where <TestBilgiObj>(x => x.KONU_ID.ToString() == slcKonuAdi.Value).ToList(); foreach (var item in lstCurrentTestBilgi) { lstDataSource.Add(new NameValue { Name = item.TEST_NO + ". " + item.TEST_ADI, Value = item.TEST_GUID.ToString() }); } if (lstDataSource != null && lstDataSource.Count > 0) { slcTestAdi.DataSource = lstDataSource.ToArray(); slcTestAdi.DataTextField = "Name"; slcTestAdi.DataValueField = "Value"; slcTestAdi.DataBind(); } else { slcTestAdi.DataSource = null; slcTestAdi.DataBind(); } #endregion #region Fill Ogrenci lstDataSource = null; PageOps = null; PageOps = new PageOperations(); lstDataSource = new List <NameValue>(); lstOgrBilgi = PageOps.RunQueryForPage <OGR_BILGI>(DbCommandList.PRM_OGR, null, null); lstDataSource = new List <NameValue>(); if (ksfSI.RoleName.ToUpperInvariant() == RoleNames.HOCA.ToString()) { lstOgrBilgi = lstOgrBilgi.Where(x => x.HOCA_GUID == ksfSI.HocaGuid).ToList(); List <OGR_BILGI> lstCurrentOgrBilgiObj = lstOgrBilgi.Where <OGR_BILGI>(x => x.CLASS.ToString() == slcSinif.Value && x.HOCA_GUID == ksfSI.HocaGuid).ToList(); foreach (var item in lstCurrentOgrBilgiObj)//Default olarak öğrenciler dolduruluyor. { lstDataSource.Add(new NameValue { Name = item.NAME + " " + item.SURNAME, Value = item.GUID.ToString() }); } } else { foreach (var item in lstOgrBilgi.Where(x => x.CLASS.ToString() == slcSinif.Value).ToList())//Default olarak öğrenciler dolduruluyor. { lstDataSource.Add(new NameValue { Name = item.NAME + " " + item.SURNAME, Value = item.GUID.ToString() }); } } //List<OGR_BILGI> lstCurrentOgrBilgiObj = lstOgrBilgi.Where<OGR_BILGI>(x => x.CLASS.ToString() == slcSinif.Value).ToList(); //foreach (var item in lstCurrentOgrBilgiObj) //{ // lstDataSource.Add(new NameValue // { // Name = item.NAME + " " + item.SURNAME, // Value = item.GUID.ToString() // }); //} if (lstDataSource != null && lstDataSource.Count > 0) { slcOgr.DataSource = lstDataSource.ToArray(); slcOgr.DataTextField = "Name"; slcOgr.DataValueField = "Value"; slcOgr.DataBind(); } else { slcOgr.DataSource = null; slcOgr.DataBind(); } #endregion return(true); }