protected void Page_Load(object sender, EventArgs e)
{
if (Session["kullanici"] != null)
{
kullaniciadi = Session["kullanici"].ToString();
if (Convert.ToInt32(Session["kulid"]).Equals(16) || Convert.ToInt32(Session["kulid"]).Equals(12))
{
RPT_GORUSME_LISTE.DataSource = DBIslem.DtGetir("SELECT * FROM View_GorusmeListesi"); // burdan çekicez
RPT_GORUSME_LISTE.DataBind();
}
//LISTE
else
{
//LISTE
RPT_GORUSME_LISTE.DataSource = DBIslem.DtGetir("SELECT * FROM View_GorusmeListesi where gKULLANICI_ID='" + Session["kulid"] + "'"); // burdan çekicez
RPT_GORUSME_LISTE.DataBind();
}
}
else
{
Response.Redirect("girisYap.aspx");
}
//
}
private void MUSTERI_LISTESI_GETIR()
{
if (kullaniciadi == "admin" || Convert.ToInt32(Session["kulid"]) == 16)
{
RPT_GORUSME_LISTE.DataSource = DBIslem.DtGetir("SELECT * FROM View_GorusmeListesi order by gID desc");
RPT_GORUSME_LISTE.DataBind();
DataTable düzenlenecek = DBIslem.DtGetir(" SELECT ( sTAKSIT_SAYISI - (Select COUNT(TBL_TAHSILAT.tID) FROM TBL_TAHSILAT WHERE TBL_TAHSILAT.gID = View_Satis.gID) ) AS Kalan_Taksit , TOPLAM_TAHSIL = ISNULL((SELECT SUM(Convert(money, ISNULL((TBL_GECICI.TUTAR), 0))) FROM TBL_GECICI WHERE IsActive = 1 AND TBL_GECICI.GID = View_Satis.gID GROUP BY AD_SOYAD), 0), *FROM View_Satis left join TBL_KULLANICI on View_Satis.sKULID = TBL_KULLANICI.kID order by gID desc");
RPT_SOZLEME_LISTE.DataSource = düzenlenecek;
RPT_SOZLEME_LISTE.DataBind();
}
else
{
// DataTable düzenlenecek = DBIslem.DtGetir("SELECT ( sTAKSIT_SAYISI - (Select COUNT(TBL_TAHSILAT.tID) FROM TBL_TAHSILAT WHERE TBL_TAHSILAT.gID = View_Satis.gID) ) AS Kalan_Taksit , TOPLAM_TAHSIL = ISNULL((SELECT SUM(Convert(money, ISNULL((TBL_GECICI.TUTAR), 0))) FROM TBL_GECICI WHERE IsActive = 1 AND TBL_GECICI.GID = View_Satis.gID GROUP BY AD_SOYAD), 0), *FROM TBL_GORUSME inner JOIN View_Satis on View_Satis.gID = TBL_GORUSME.gID WHERE sKULID = "+Convert.ToInt32(Session["kulid"])+" order by View_Satis.gID desc");
RPT_GORUSME_LISTE.DataSource = DBIslem.DtGetir("SELECT * FROM View_GorusmeListesi where gKULLANICI_ID='" + Session["kulid"] + "'");;
RPT_GORUSME_LISTE.DataBind();
//RPT_GORUSME_LISTE1.DataSource = DBIslem.DtGetir("select gNOT from View_GorusmeListesi where gKULLANICI_ID='" + Session["kulid"] + "' and gMUSTERID =' " + RPT_GORUSME_LISTE);
//RPT_GORUSME_LISTE1.DataBind();
RPT_SOZLEME_LISTE.DataSource = DBIslem.DtGetir("SELECT ( sTAKSIT_SAYISI - (Select COUNT(TBL_TAHSILAT.tID) FROM TBL_TAHSILAT WHERE TBL_TAHSILAT.gID = View_Satis.gID) ) AS Kalan_Taksit , TOPLAM_TAHSIL = ISNULL((SELECT SUM(Convert(money, ISNULL((TBL_GECICI.TUTAR), 0))) FROM TBL_GECICI WHERE IsActive = 1 AND TBL_GECICI.GID = View_Satis.gID GROUP BY AD_SOYAD), 0), *FROM View_Satis left join TBL_KULLANICI on View_Satis.sKULID = TBL_KULLANICI.kID where sKULID = " + Convert.ToInt32(Session["kulid"]) + " order by gID desc");
RPT_SOZLEME_LISTE.DataBind();
}
}
