Пример #1
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        dtinfo.DateSeparator    = "/";
        dtinfo.ShortDatePattern = "dd/MM/yyyy";
        Projectcls pcl = new Projectcls();
        string     sts = pcl.CountStatusDairy(txtDiaryNo.Text.ToString(), ddlExamSeason.SelectedValue.ToString() + txtYearSeason.Text);

        if (sts == "NotSubmitted" && txtDiaryNo.Text != "" && ddlDiaryType.SelectedValue.ToString() != "select")
        {
            con.Close(); con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd = new SqlCommand("update DiaryEntry set Status=@Status,DiaryType=@DiaryType,SubmittedTo=@SubmittedTo,OpenedDate=@OpenedDate where DiaryNo='" + txtDiaryNo.Text.ToString() + "' and ExamSession='" + lblHiddenSeason.Text.ToString() + "'", con);
            cmd.Parameters.AddWithValue("@Status", "CountDispatch");
            cmd.Parameters.AddWithValue("@DiaryType", ddlDiaryType.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@SubmittedTo", ddlSupplyTo.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@OpenedDate", DateTime.Now);
            cmd.ExecuteNonQuery();
            cmd = new SqlCommand("insert into DairyCount(DairyNo,Session,Department,CurrentDate,DairyType,IMID,LatterTo,LatterFrom,Status,TotalDDRcv,TotalNoForm) Values(@DiaryNo,@Session,@Department,@CurrentDate,@DairyType,@IMID,@LatterTo,@LatterFrom,@Status,@TotalDDRcv,@TotalNoForm)", con);
            cmd.Parameters.AddWithValue("@DiaryNo", txtDiaryNo.Text.ToString());
            cmd.Parameters.AddWithValue("@Session", ddlExamSeason.SelectedValue.ToString() + txtYearSeason.Text);
            cmd.Parameters.AddWithValue("@Department", ddlSupplyTo.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@CurrentDate", DateTime.Now);
            cmd.Parameters.AddWithValue("@DairyType", ddlDiaryType.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@IMID", lblIMID.Text);
            cmd.Parameters.AddWithValue("@LatterTo", "N/A");
            cmd.Parameters.AddWithValue("@LatterFrom", "N/A");
            if (txtDD.Text == "" | txtForms.Text == "")
            {
                cmd.Parameters.AddWithValue("@Status", "NotOpen");
            }
            else
            {
                cmd.Parameters.AddWithValue("@Status", "Open");
            }
            cmd.Parameters.AddWithValue("@TotalDDRcv", txtDD.Text);
            cmd.Parameters.AddWithValue("@TotalNoForm", txtForms.Text);
            cmd.ExecuteNonQuery();
            cmd = new SqlCommand("Insert into ProjectCount(DairyNo,Session,IMID,CurrentDate,Status) Values(@DairyNo,@Session,@IMID,@CurrentDate,@Status)", con);
            cmd.Parameters.AddWithValue("@DairyNo", txtDiaryNo.Text.ToString());
            cmd.Parameters.AddWithValue("@Session", lblHiddenSeason.Text.ToString());
            cmd.Parameters.AddWithValue("@IMID", lblIMID.Text.ToString());
            cmd.Parameters.AddWithValue("@CurrentDate", DateTime.Now);
            cmd.Parameters.AddWithValue("@Status", "Submitted");
            cmd.ExecuteNonQuery();
            con.Close();
            bindDiary();
            con.Dispose();
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Successfully Submitted')", true);
            txtDD.Text = ""; txtForms.Text = ""; txtDiaryNo.Text = ""; lblIMID.Text = "";
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Please insert Correct value')", true);
        }
        GridDiaryNo.Focus();
    }
Пример #2
0
 protected void btnClear_Click(object sender, EventArgs e)
 {
     txtDOB.Text  = DateTime.Now.ToString("dd/MM/yyyy");
     txtDDNO.Text = ""; txtNarration.Text = ""; txtAmt.Text = "0";
     ddlCurrancy.SelectedIndex = 0;
     lblCurrancyText.Visible   = false;
     lblCurrancyName.Visible   = false;
     txtCurrancyValue.Visible  = false;
     txtCurrancyValue.Text     = "1";
     calculate(txtAmt.Text, txtCurrancyValue.Text);
     lblException.Text = "";
     GridDiaryNo.Focus();
 }
Пример #3
0
 protected void txtdevYearSeason_TextChanged(object sender, EventArgs e)
 {
     txtDiaryNo.Text       = "";
     lblhiddenSession.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
     GridDiaryNo.Focus();
 }
Пример #4
0
 protected void txtIDIM_TextChanged(object sender, EventArgs e)
 {
     txtIMID();
     con.Dispose();
     GridDiaryNo.Focus();
 }