Exemple #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            txtUsername.Focus();
            persianDate pd = new persianDate();
            string visit_Date = cbxYear.Text + "/" + cbxMonth.Text + "/" + cbxDay.Text;
            string visit_Time = cbxHour.Text + ":" + cbxMin.Text + ":" + "0";

            string realNowTime = string.Empty;
            SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");
            con1.Open();
            SqlCommand c1 = new SqlCommand();
            c1.CommandText = "insert into dailyAct values(N'قرار ملاقات','" + txtdescription.Text + "','" + pd.date() + "','" + pd.time() + "','" + visit_Date + "','" + visit_Time + "','" + txtplace.Text + "','" + txtUsername.Text + "')";

            c1.Connection = con1;
            try
            {
                c1.ExecuteNonQuery();
                MessageBox.Show("ثبت شد");
            }
            catch
            {
                MessageBox.Show("زمان مورد نظر قبلا ثبت شده است");
            }
            con1.Close();
            txtdescription.Clear();
            txtplace.Clear();
            txtUsername.Clear();
            cbxYear.Text = null;
            cbxMonth.Text = null;
            cbxDay.Text = null;
            cbxHour.Text = null;
            cbxMin.Text = null;
            txtUsername.Focus();
        }
 private void button4_Click(object sender, EventArgs e)
 {
     persianDate p = new persianDate();
     string date = cbxYear.Text + "/" + cbxMonth.Text + "/" + cbxDay.Text;
     SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");
     try
     {
         con1.Open();
         SqlDataAdapter da = new SqlDataAdapter("Select noteId,textN,dateN,timeN from note where username='******' and dateN='"+date+"'", con1);
         DataTable dt = new DataTable();
         da.Fill(dt);
         dataGridView1.DataSource = dt.DefaultView;
         dataGridView1.Columns["noteId"].HeaderText = "شماره یادداشت";
         dataGridView1.Columns["textN"].HeaderText = "یادداشت";
         dataGridView1.Columns["dateN"].HeaderText = "تاریخ انجام";
         dataGridView1.Columns["timeN"].HeaderText = "ساعت انجام";
     }
     catch
     {
         MessageBox.Show("خطای اتصال\nدوباره امتحان کنید");
     }
     finally
     {
         con1.Close();
     }
     cbxDay.Text = null;
     cbxMonth.Text = null;
     cbxYear.Text = null;
 }
Exemple #3
0
 private void alarm_Load(object sender, EventArgs e)
 {
     System.Media.SystemSounds.Exclamation.Play();
     //Beep(700, 500);
     persianDate p = new persianDate();
     SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");
     con1.Open();
     SqlDataAdapter da = new SqlDataAdapter("Select typeDA,titr,visitTime from dailyAct where visitDate='" + persianDate.dateTemp + "'and username='******'", con1);
     DataTable dt = new DataTable();
     da.Fill(dt);
     dataGridView1.DataSource = dt.DefaultView;
     con1.Close();
 }
Exemple #4
0
        private void button2_Click_1(object sender, EventArgs e)
        {
            persianDate pd = new persianDate();
            string visit_Date = cbxYear.Text + "/" + cbxMonth.Text + "/" + cbxDay.Text;
            string visit_Time = cbxHour.Text + ":" + cbxMin.Text + ":" + "0";

            string realNowTime = string.Empty;

            SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");
            con1.Open();
            SqlCommand c1 = new SqlCommand();

            //MessageBox.Show(radioButton1.Text + "," + txtdescription.Text + "," + pd.date() + "," + pd.time() + "," + visit_Date + "," + visit_Time + "," + txtplace.Text);
            //if (radioButton1.Checked)
            //{
                c1.CommandText = "insert into dailyAct values(N'" + cmbEventType.Text + "' ,'" + txtdescription.Text + "','" + pd.date() + "','" + pd.time() + "','" + visit_Date + "','" + visit_Time + "',N'" + txtplace.Text + "', '" + persianDate.usernameTemp + "')";
                //c1.CommandText = "insert into dailyAct values('"+radioButton1.Text+"','" + txtdescription.Text + "','" + pd.date() + "','" + pd.time() + "','" + visit_Date + "','" + visit_Time + "','" + txtplace.Text + "', '" + persianDate.usernameTemp + "')";
               // }
            //else if (radioButton2.Checked)
            //{
               // c1.CommandText = "insert into dailyAct values(N'برنامه روزانه',N'" + txtdescription.Text + "','" + pd.date() + "','" + pd.time() + "','" + visit_Date + "','" + visit_Time + "','" + txtplace.Text + "','" + persianDate.usernameTemp + "')";
               // }
            c1.Connection = con1;
            try
            {
                c1.ExecuteNonQuery();
                MessageBox.Show("ثبت شد");
            }
            catch(Exception x)
            {
                MessageBox.Show(x.Message);
                //MessageBox.Show("زمان مورد نظر قبلا ثبت شده است");
            }
            con1.Close();
            txtdescription.Clear();
            txtplace.Clear();
            cbxYear.Text = null;
            cbxMonth.Text = null;
            cbxDay.Text = null;
            cbxHour.Text = null;
            cbxMin.Text = null;
        }
Exemple #5
0
 private void button4_Click(object sender, EventArgs e)
 {
     txtnote.Focus();
     persianDate pd = new persianDate();
     SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");
     con1.Open();
     SqlCommand c1 = new SqlCommand();
     c1.CommandText = "insert into note values('" + pd.date() + "','" + pd.time() + "','" + txtnote.Text + "','"+ persianDate.usernameTemp +"')";
     c1.Connection = con1;
     try
     {
         c1.ExecuteNonQuery();
         MessageBox.Show("ثبت شد");
     }
     catch
     {
         MessageBox.Show("دوباره امتحان کنید");
     }
     con1.Close();
     txtnote.Clear();
 }
Exemple #6
0
        private void button1_Click(object sender, EventArgs e)
        {
            persianDate p = new persianDate();
            SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");

            con1.Open();
            try
            {
                SqlDataAdapter da = new SqlDataAdapter("Select visitTime from dailyAct where username='******'", con1);
                DataTable dt = new DataTable();
                da.Fill(dt);
                dataGridView1.DataSource = dt.DefaultView;
                dataGridView1.Columns["visitTime"].HeaderText = "ساعت ";
            }
            catch
            {
                MessageBox.Show("خطای اتصال\nدوباره امتحان کنید");
            }
            finally
            {
                con1.Close();
            }
        }
        private void cbxevent_SelectedIndexChanged(object sender, EventArgs e)
        {
            persianDate p = new persianDate();
            SqlConnection con1 = new SqlConnection("server=(local); DataBase=itproject ; integrated security=true");

            con1.Open();
            try
            {
                if (cbxevent.Text == "قرار ملاقات")
                {
                    SqlDataAdapter da = new SqlDataAdapter("Select daId,typeDA,titr,visitDate,visitTime,place,recordDate,recordTime from dailyAct where username='******' and typeDA=N'قرار ملاقات'", con1);
                    DataTable dt = new DataTable();

                    da.Fill(dt);

                    dataGridView1.DataSource = dt.DefaultView;

                }
                else if (cbxevent.Text == "برنامه روزانه")
                {
                    SqlDataAdapter da = new SqlDataAdapter("Select daId,typeDA,titr,visitDate,visitTime,place,recordDate,recordTime from dailyAct where username='******' and typeDA=N'برنامه روزانه'", con1);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    dataGridView1.DataSource = dt.DefaultView;
                }
                dataGridView1.Columns["daId"].HeaderText = "شماره رویداد";
                dataGridView1.Columns["typeDa"].HeaderText = "نوع رویداد";
                dataGridView1.Columns["titr"].HeaderText = "توضیحات";
                dataGridView1.Columns["visitDate"].HeaderText = "تاریخ انجام";
                dataGridView1.Columns["visitTime"].HeaderText = "ساعت انجام";
                dataGridView1.Columns["recordDate"].HeaderText = "تاریخ ثبت";
                dataGridView1.Columns["recordTime"].HeaderText = "ساعت ثبت";
                dataGridView1.Columns["place"].HeaderText = "مکان موردنظر";
            }
            catch
            {
                MessageBox.Show("خطای اتصال\nدوباره امتحان کنید");
            }
            finally
            {
                con1.Close();
            }
        }
Exemple #8
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            ///////////
            persianDate p = new persianDate();
            visitDateTextBox.Text = p.date();
            int visitd = dailyActBindingSource.Find("visitDate", visitDateTextBox.Text);
            if (visitd != -1)
            {
                persianDate.dateTemp = visitDateTextBox.Text;
                alarm am = new alarm();
                add.ActiveForm.Hide();
                am.ShowDialog();
            }
            else
            {
                MessageBox.Show("برنامه ی امروز شما آزاد است");
            }

            //////////////////
        }