Пример #1
0
    private void bindDiary()
    {
        SqlDataAdapter addiary, addiary1;

        // B7
        addiary  = new SqlDataAdapter("select DiaryEntry.DiaryNo,DiaryEntry.Diary,DiaryEntry.Status,DiaryEntry.CourierNo as RefNo,DiaryEntry.IMID as Membership from DiaryEntry where SubmittedTo='Project'and Status='ProReceive' and DiaryNo in (select DairyNo from DairyCount where Department='Project') and ExamSession='" + lblHiddenSeason.Text + "'", con);
        addiary1 = new SqlDataAdapter("select DiaryEntry.DiaryNo,DiaryEntry.Diary,DiaryEntry.Status,DiaryEntry.CourierNo as RefNo,DiaryEntry.IMID as Membership from DiaryEntry where SubmittedTo='Project'and Status='CountDispatch' and DiaryNo in (select DairyNo from DairyCount where Department='Account') and ExamSession='" + lblHiddenSeason.Text + "'", con);
        DataTable ds = new DataTable();

        addiary.Fill(ds);
        addiary1.Fill(ds);
        GridDiaryNo.DataSource = ds;
        GridDiaryNo.DataBind();
        //B6
        addiary = new SqlDataAdapter("select DairyNo,Status,IMID from DairyCount where DairyNo IN (select Distinct DiaryNo From DiaryEntry where Status='CountDispatch' and ExamSession='" + lblHiddenSeason.Text.ToString() + "') and Department='Project' order by DairyNo desc", con);
        DataTable dt = new DataTable();

        addiary.Fill(dt);
        GrdCountDispatch.DataSource = dt;
        GrdCountDispatch.DataBind();
        //B8
        addiary = new SqlDataAdapter("select Status,DairyNo,IMID,DDRcv,DDSub,ProformaARcv,ProformaASub,ProformaBRcv,ProformaBSub,CurrentDate from Projectcount where Session='" + lblHiddenSeason.Text + "' and dairyNo in(select DiaryNo from DiaryEntry where SubmittedTo='Project') order by DairyNo desc", con);
        DataTable dt1 = new DataTable();

        addiary.Fill(dt1);
        GridProject.DataSource = dt1;
        GridProject.DataBind();
    }
Пример #2
0
    protected void txtIDIM_TextChanged(object sender, EventArgs e)
    {
        lblException.Text = "";
        con.Close(); con.Open();
        cmd = new SqlCommand();
        SqlTransaction sTR;

        sTR             = con.BeginTransaction();
        cmd.Connection  = con;
        cmd.Transaction = sTR;
        try
        {
            int i = 0;
            cmd.CommandText = "select * from IM where ID='" + txtIDIM.Text.ToString() + "'";
            reader          = cmd.ExecuteReader();
            if (reader.Read())
            {
                lblIMName.Text       = reader[1].ToString();
                lblIMAddress.Text    = reader[3].ToString();
                lblIMCity.Text       = reader["Address2"].ToString() + ", " + reader[4].ToString() + " ,( " + reader[5].ToString() + " )";
                lblEnrolment.Text    = reader["ID"].ToString();
                lblGroupID.Text      = reader["GID"].ToString();
                btnSubmitAmt.Enabled = true;
                pnlIMInfo.Visible    = true;
                i += 1;
            }
            else
            {
                txtIDIM.Text   = "Invalid ID"; lblIMAddress.Text = ""; lblIMName.Text = "";
                lblIMCity.Text = "Please Insert Valid IM ID."; pnlIMInfo.Visible = false;
                txtIDIM.Focus();
            }
            reader.Close();
            if (i == 1)
            {
                // total(txtIDIM.Text, sTR, cmd);
                txtACNO.Text    = ""; lblexceptionDirary.Text = "";
                cmd.CommandText = "select DairyCount.DairyNo,DairyCount.IMID,DiaryEntry.MemberType from DairyCount left outer join DiaryEntry on  DairyCount.DairyNo=DiaryEntry.DiaryNo where DairyCount.TotalDDRcv > (DairyCount.TotalDDSub+DairyCount.MemberRcv) and DiaryCount.Session='" + lblhiddenSession.Text + "' and DiaryEntry.IMID='" + txtIDIM.Text + "' order by DairyCount.DairyNo desc";
                //cmd.CommandText = "select DiaryNo,MembershipNo,MemberType From DiaryEntry where IMID='" + txtIDIM.Text.ToString() + "' and ExamSession='" + lblhiddenSession.Text.ToString() + "' and Status='Open' order by DiaryNo desc";
                reader = cmd.ExecuteReader();
                GridDiaryNo.DataSource = reader;
                GridDiaryNo.DataBind();
                reader.Close();
                reader.Dispose();
                sTR.Commit();
            }
            txtACNO.Focus();
        }
        catch (Exception ex)
        {
            sTR.Rollback();
        }
        finally
        {
            con.Close();
            con.Dispose();
        }
    }
Пример #3
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();
    }
Пример #4
0
    private void fillgr()
    {
        SqlDataAdapter addiary = new SqlDataAdapter("select DairyNo from DairyCount where MemberRcv>0 and MemberRcv>MemberSub and IMID='" + txtId.Text + "'", con);
        DataSet        ds      = new DataSet();

        addiary.Fill(ds);
        if (ds.Tables[0].ToString() != "")
        {
            GridDiaryNo.DataSource = ds;
            GridDiaryNo.DataBind();
        }
    }
Пример #5
0
    private void fillDiary()
    {
        SqlDataAdapter addiary = new SqlDataAdapter("select DairyCount.DairyNo,DiaryEntry.IMID,DiaryEntry.MemberType from DairyCount left outer join DiaryEntry on  DairyCount.DairyNo=DiaryEntry.DiaryNo where DiaryEntry.ExamSession='" + lblhiddenSession.Text.ToString() + "' and DiaryEntry.Status='Open' and (DairyCount.TotalDDRcv > (DairyCount.TotalDDSub+DairyCount.MemberRcv)) order by DairyCount.DairyNo desc", con);
        DataSet        ds      = new DataSet();

        addiary.Fill(ds);
        if (ds.Tables[0].ToString() != "")
        {
            GridDiaryNo.DataSource = ds;
            GridDiaryNo.DataBind();
        }
    }
Пример #6
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();
 }
Пример #7
0
    private void bindDiary()
    {
        SqlDataAdapter addiary = new SqlDataAdapter("select Distinct DiaryNo,Diary,Status,CourierNo as RefNo,MembershipNo as Mem_No From DiaryEntry where (Status='CountReceived' OR Status='CountDispatch') and ExamSession='" + lblHiddenSeason.Text + "' order by Diary desc", con);
        DataSet        ds      = new DataSet();

        addiary.Fill(ds);
        GridDiaryNo.DataSource = ds;      //B3
        GridDiaryNo.DataBind();

        SqlDataAdapter countdiary = new SqlDataAdapter("select Distinct DiaryNo,Diary,CourierNo as RefNo,MembershipNo as Mem_No From DiaryEntry where Status='DiaryEntry' and ExamSession='" + lblHiddenSeason.Text + "' order by Diary desc", con);
        DataSet        ds1        = new DataSet();

        countdiary.Fill(ds1);
        GrdCountReceived.DataSource = ds1;      //B2
        GrdCountReceived.DataBind();
    }
    private void bindDiary()
    {
        SqlDataAdapter addiary = new SqlDataAdapter("select Distinct DiaryNo,Diary From DiaryEntry where Status='Open' and ExamSession='" + lblHiddenSeason.Text.ToString() + "' order by Diary desc", con);
        DataSet        ds      = new DataSet();

        addiary.Fill(ds);
        if (ds.Tables[0].ToString() != "")
        {
            GridDiaryNo.DataSource = ds;
            GridDiaryNo.DataBind();
        }
        foreach (GridViewRow rw in GridDiaryNo.Rows)
        {
            rw.Cells[2].Visible = false;
            GridDiaryNo.HeaderRow.Cells[2].Visible = false;
        }
    }
Пример #9
0
    private void txtIMID()
    {
        con.Close(); con.Open();
        SqlCommand cmd = new SqlCommand("select ID from IM where ID='" + txtIDIM.Text.ToString() + "'", con);
        string     chk = Convert.ToString(cmd.ExecuteScalar());
        int        i   = 0;

        if (chk == txtIDIM.Text.ToString())
        {
            i += 1;
        }
        else
        {
            txtIDIM.Text   = "Invalid ID"; lblIMAddress.Text = ""; lblIMName.Text = "";
            lblIMCity.Text = "Please Insert Valid IM ID."; pnlIMInfo.Visible = false;
            txtIDIM.Focus();
        }
        if (i == 1)
        {
            cmd = new SqlCommand("select * from IM where ID='" + txtIDIM.Text.ToString() + "'", con);
            SqlDataReader reader;
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                lblIMName.Text    = reader[1].ToString();
                lblIMAddress.Text = reader[3].ToString();
                lblIMCity.Text    = reader["Address2"].ToString() + ", " + reader[4].ToString() + " ,( " + reader[5].ToString() + " )";
                lblEnrolment.Text = reader["ID"].ToString();
                lblGroupID.Text   = reader["GID"].ToString();
                pnlIMInfo.Visible = true;
            }
            reader.Close();
            txtDiaryNo.Text = ""; lblexceptionDirary.Text = "";
            SqlDataAdapter addiary = new SqlDataAdapter("select Distinct DiaryNo From DiaryEntry where IMID='" + txtIDIM.Text.ToString() + "' and ExamSession='" + lblhiddenSession.Text.ToString() + "' and Status='Open' order by DiaryNo desc", con);
            DataSet        ds      = new DataSet();
            addiary.Fill(ds);
            if (ds.Tables[0].ToString() != "")
            {
                GridDiaryNo.DataSource = ds;
                GridDiaryNo.DataBind();
            }
            txtDiaryNo.Focus();
        }
        con.Close();
    }
Пример #10
0
    private void bindDiary()
    {
        SqlDataAdapter addiary = new SqlDataAdapter("select Distinct DiaryNo,Diary,Status,CourierNo as RefNo,MembershipNo as Membership From DiaryEntry where Status='AccReceive' and ExamSession='" + lblHiddenSeason.Text.ToString() + "' order by Diary desc", con);
        DataSet        ds      = new DataSet();

        addiary.Fill(ds);
        if (ds.Tables[0].ToString() != "")
        {
            GridDiaryNo.DataSource = ds;
            GridDiaryNo.DataBind();
        }

        SqlDataAdapter countDispatch = new SqlDataAdapter("select DairyNo,Status,IMID from DairyCount where DairyNo IN (select Distinct DiaryNo From DiaryEntry where Status='CountDispatch' and ExamSession='" + lblHiddenSeason.Text.ToString() + "')  order by DairyNo desc ", con);
        DataSet        ds1           = new DataSet();

        countDispatch.Fill(ds1);
        if (ds1.Tables[0].ToString() != "")
        {
            GrdCountDispatch.DataSource = ds1;
            GrdCountDispatch.DataBind();
        }
    }
Пример #11
0
 protected void txtdevYearSeason_TextChanged(object sender, EventArgs e)
 {
     txtDiaryNo.Text       = "";
     lblhiddenSession.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
     GridDiaryNo.Focus();
 }
Пример #12
0
 protected void txtIDIM_TextChanged(object sender, EventArgs e)
 {
     txtIMID();
     con.Dispose();
     GridDiaryNo.Focus();
 }