[Dnsmail-cvs] projeler/ajanda-no nsb.aspx.cs,NONE,1.1

[Ethem E. <et...@us...>]

Update of /cvsroot/dnsmail/projeler/ajanda-no
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv18942/projeler/ajanda-no

Added Files:
	nsb.aspx.cs 
Log Message:


--- NEW FILE: nsb.aspx.cs ---
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default3 : System.Web.UI.Page
{
    
    string[,] bilgiler = new string[13, 32];

    string bilgi;
    int gun, ay;
    
    protected void Page_Load(object sender, EventArgs e)
    {
       
        string text;
        string starih = DateTime.Today.ToShortDateString();
        Label4.Text = starih;
        text = TextBox1.Text;
        

        OleDbConnection baglanti;
        OleDbCommand cmdInsert;
        OleDbDataReader ss;

       

        baglanti = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=KAYITLAR.mdb");
        baglanti.Open();


        cmdInsert = new OleDbCommand("Select kullaniciadi,tarih,bilgi,gun,ay From veriler", baglanti);

        ss = cmdInsert.ExecuteReader();
       
        while (ss.Read())
        {    
            if (ss.GetString(0) == Label3.Text)
            {                
                gun = Convert.ToInt32(ss["gun"]);
                ay = Convert.ToInt32(ss["ay"]);
                bilgi = Convert.ToString(ss["bilgi"]);
                for (int i = 1; i <= 13; i++)
                {
                    for (int j = 1; j <= 32; j++)
                    {
                        if (ay == i && gun == j)
                        {
                           bilgiler[i, j] = bilgi;
                           
                        }
                     }
                }
                      }
                    }

        baglanti.Close();
            }


    protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
    {
        
        CalendarDay gun;
        TableCell hucre;
        gun = e.Day;
        hucre = e.Cell;

        string bilgi = bilgiler[gun.Date.Month, gun.Date.Day];
        if (bilgi != "")
        {
            hucre.Controls.Add(new LiteralControl("<font color=#404040><p>" + bilgi));
        }

    }


    protected void Button2_Click(object sender, EventArgs e)
    {
        OleDbConnection baglanti;

        OleDbCommand cmdInsert,cmd2Insert;
        OleDbDataReader ss,ss1;
       
        baglanti = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=KAYITLAR.mdb");
        baglanti.Open();


        cmdInsert = new OleDbCommand("Select kullaniciadi,sifre From kullanicibilgisi", baglanti);
        cmd2Insert = new OleDbCommand("Select kullaniciadi,tarih,bilgi,gun,ay From veriler", baglanti);



        ss = cmdInsert.ExecuteReader();
       

        while (ss.Read())
        {
            if (ss.GetString(0) == TextBox1.Text && ss.GetString(1) == TextBox2.Text)
            {

                Label3.Text = TextBox1.Text;
                ss1 = cmd2Insert.ExecuteReader();
                while (ss1.Read())
                {
                    if (ss1.GetString(0)==TextBox1.Text)

                {                
                  gun = Convert.ToInt32(ss1["gun"]);
                 ay = Convert.ToInt32(ss1["ay"]);
                 bilgi = Convert.ToString(ss1["bilgi"]);
                   
                 for (int i = 1; i <= 13; i++)
                 {
                    for (int j = 1; j <= 32; j++)
                   {
                     if (ay == i && gun == j)
                    {
                       bilgiler[i, j] = bilgi;

                     }
                  }
                 }
                       }
                     }
                
                Panel3.Visible = true;
                Panel2.Visible = false;

                }
        }  
          baglanti.Close();
        
    }



    protected void Button3_Click(object sender, EventArgs e)
    {

        if (TextBox3.Text != "")
        {
            OleDbConnection baglanti;
            string strInsert;
            OleDbCommand cmdInsert,cmd2Insert;
            OleDbDataReader ss1;

            baglanti = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=KAYITLAR.mdb");
            strInsert = "Insert into veriler( kullaniciadi,bilgi,tarih,gun,ay) Values (@adý,@bilgi,@tarih,@gun,@ay)";
            cmd2Insert = new OleDbCommand("Select kullaniciadi,tarih,bilgi,gun,ay From veriler", baglanti);

            cmdInsert = new OleDbCommand(strInsert, baglanti);
            cmdInsert.Parameters.Add("@adý", Label3.Text);
            cmdInsert.Parameters.Add("@bilgi", TextBox3.Text);
            cmdInsert.Parameters.Add("@tarih", Label5.Text);
            cmdInsert.Parameters.Add("@gun", Label7.Text);
            cmdInsert.Parameters.Add("@ay", Label8.Text);


            baglanti.Open();
            cmdInsert.ExecuteNonQuery();
            
            ss1 = cmd2Insert.ExecuteReader();
            while (ss1.Read())
            {
                if (ss1.GetString(0) == Label3.Text)
                {
                    gun = Convert.ToInt32(ss1["gun"]);
                    ay = Convert.ToInt32(ss1["ay"]);
                    bilgi = Convert.ToString(ss1["bilgi"]);

                    for (int i = 1; i <= 13; i++)
                    {
                        for (int j = 1; j <= 32; j++)
                        {
                            if (ay == i && gun == j)
                            {
                                bilgiler[i, j] = bilgi;

                            }
                        }
                    }
                }
            }
            
            Panel3.Visible = true;
            Panel2.Visible = false;
            TextBox3.Text = "";
            baglanti.Close();

        }
    }

   

   
    protected void Calendar1_SelectionChanged1(object sender, EventArgs e)
    {
        Panel3.Visible = true;
        Panel2.Visible = false;
        TextBox3.Visible = true;
        Button3.Visible = true;
        string selecteddate = Calendar1.SelectedDate.ToShortDateString();

        Label5.Text = selecteddate;
        Label7.Text = Calendar1.SelectedDate.Day.ToString();
        Label8.Text = Calendar1.SelectedDate.Month.ToString();
                    
        

        }    
 
protected void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
    {
        Panel2.Visible = false;
        Panel3.Visible = true;
    }


    
}