Exemplo n.º 1
0
 protected void GdVwViewTypWrk_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     try
     {
         BLTypeOfWork bltow = new BLTypeOfWork();
         if (e.CommandName == "EditTypWrk")
         {
             GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
             int rowIndex = gvr.RowIndex;
             int TypWrkId = Convert.ToInt32(GdVwViewTypWrk.Rows[rowIndex].Cells[1].Text);
             Session["TypWrkId"] = TypWrkId.ToString();
             SqlDataReader dr1 = bltow.getTypeWrkDetailsForUpdate1(TypWrkId);
             if (dr1.HasRows == true)
             {
                 while (dr1.Read())
                 {
                     btnClearTypWrk.Enabled = false;
                     txtTypeOfWork.Text = dr1.GetString(1);
                     bool isdel = dr1.GetBoolean(2);
                     if (isdel == true)
                         rbYesIsDeltypWrk.Checked = true;
                     else
                         rbNoIsDeltypWrk.Checked = true;
                     int approve = dr1.GetInt32(3);
                     if (approve == 1)
                         ChkBxApprovTypOfWrk.Checked = true;
                     else
                         ChkBxApprovTypOfWrk.Checked = false;
                 }
             }
         }
     }
     catch (Exception ex)
     {
         lblCatchError.Text = ex.Message.ToString();
     }
 }
Exemplo n.º 2
0
 protected void ChkbxShowDeletedTypWrk_CheckedChanged(object sender, EventArgs e)
 {
     try
     {
         string strWork = ddlTypWrk.SelectedItem.Text;
         int intIsDeleted;
         if (ChkbxShowDeletedTypWrk.Checked == true)
         intIsDeleted = 1;
         else
         {
             intIsDeleted = 0;
         }
         if (ddlTypWrk.SelectedItem.Text == "--Select--" && ddlApprvtypWrk.SelectedItem.Text == "--Select--" && (ChkbxShowDeletedTypWrk.Checked == true || ChkbxShowDeletedTypWrk.Checked == false))
         {
             BLTypeOfWork blpr = new BLTypeOfWork();
             SqlDataReader dr = blpr.isDelTypWrkChecked1(intIsDeleted);
             DataTable dt = new DataTable();
             if (dr.HasRows == true)
             {
                 dt.Load(dr);
                 GdVwViewTypWrk.DataSource = dt;
                 GdVwViewTypWrk.DataBind();
             }
             else
             {
                 lblErrorMsg.Text = "Records not Available";
                 GdVwViewTypWrk.DataSource = null;
                 GdVwViewTypWrk.DataBind();
             }
             dr.Close();
         }
         if (ddlTypWrk.SelectedItem.Text != "--Select--" && ddlApprvtypWrk.SelectedItem.Text == "--Select--" && (ChkbxShowDeletedTypWrk.Checked == true || ChkbxShowDeletedTypWrk.Checked == false))
         {
             BLTypeOfWork blpr = new BLTypeOfWork();
             SqlDataReader dr = blpr.isDelTypWrkCheckedWork1(strWork, intIsDeleted);
             DataTable dt = new DataTable();
             if (dr.HasRows == true)
             {
                 dt.Load(dr);
                 GdVwViewTypWrk.DataSource = dt;
                 GdVwViewTypWrk.DataBind();
             }
             else
             {
                 lblErrorMsg.Text = "Records not Available";
                 GdVwViewTypWrk.DataSource = null;
                 GdVwViewTypWrk.DataBind();
             }
             dr.Close();
         }
         if (ddlTypWrk.SelectedItem.Text != "--Select--" && ddlApprvtypWrk.SelectedItem.Text != "--Select--" && (ChkbxShowDeletedTypWrk.Checked == true || ChkbxShowDeletedTypWrk.Checked == false))
         {
             int intApprove = int.Parse(ddlApprvtypWrk.SelectedItem.Value);
             BLTypeOfWork blpr = new BLTypeOfWork();
             SqlDataReader dr = blpr.isDelTypWrkAppCheckedWork1(strWork, intApprove, intIsDeleted);
             DataTable dt = new DataTable();
             if (dr.HasRows == true)
             {
                 dt.Load(dr);
                 GdVwViewTypWrk.DataSource = dt;
                 GdVwViewTypWrk.DataBind();
             }
             else
             {
                 lblErrorMsg.Text = "Records not Available";
                 GdVwViewTypWrk.DataSource = null;
                 GdVwViewTypWrk.DataBind();
             }
             dr.Close();
         }
     }
     catch (Exception ex)
     {
         lblCatchError.Text = ex.Message.ToString();
     }
 }
Exemplo n.º 3
0
        protected void ddlApprvtypWrk_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                string strWork = ddlTypWrk.SelectedItem.Text;
                int intApprove = int.Parse(ddlApprvtypWrk.SelectedItem.Value);
                if (ddlTypWrk.SelectedItem.Text == "--Select--" && ddlApprvtypWrk.SelectedItem.Text != "--Select--")
                {
                    // int intApprove = int.Parse(ddlApprvtypWrk.SelectedItem.Value);
                    BLTypeOfWork blpr = new BLTypeOfWork();
                    SqlDataReader dr = blpr.gridFillApproveTypWrk1(intApprove);
                    DataTable dt = new DataTable();
                    if (dr.HasRows == true)
                    {
                        dt.Load(dr);
                        GdVwViewTypWrk.DataSource = dt;
                        GdVwViewTypWrk.DataBind();
                    }
                    else
                    {
                        lblErrorMsg.Text = "Records not Available";
                        GdVwViewTypWrk.DataSource = null;
                        GdVwViewTypWrk.DataBind();
                    }
                    dr.Close();

                }
                if (ddlTypWrk.SelectedItem.Text != "--Select--" && ddlApprvtypWrk.SelectedItem.Text != "--Select--")
                {
                    // int intApprove = int.Parse(ddlApprvtypWrk.SelectedItem.Value);
                    BLTypeOfWork blpr = new BLTypeOfWork();
                    SqlDataReader dr = blpr.gridFillApproveTypWrkName1(strWork, intApprove);
                    DataTable dt = new DataTable();
                    if (dr.HasRows == true)
                    {
                        dt.Load(dr);
                        GdVwViewTypWrk.DataSource = dt;
                        GdVwViewTypWrk.DataBind();
                    }
                    else
                    {
                        lblErrorMsg.Text = "Records not Available";
                        GdVwViewTypWrk.DataSource = null;
                        GdVwViewTypWrk.DataBind();
                    }
                    dr.Close();
                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
Exemplo n.º 4
0
        protected void btnSaveTypWrk_Click(object sender, EventArgs e)
        {
            try
            {
                BLTypeOfWork bltow = new BLTypeOfWork();
                //SqlDataReader dr = bldb.getDocDetailsForUpdate1(intDocumentID);
                setparameters();
                if (Session["TypWrkId"] != null)
                {
                    //setparameters();
                    intTypeofWorkID = int.Parse(Session["TypWrkId"].ToString());
                    bltow.updateTypeOfWork1(intTypeofWorkID, strwork, intIsDeleted, intApprove);
                    fillgrid();
                    lblResult.Visible = true;
                    lblResult.ForeColor = System.Drawing.Color.Green;
                    lblResult.Text = "Type of Work Details are Updated Successfully";
                    lblErrorMsg.Text = "";
                    fillgrid();
                    btnClearTypWrk.Enabled = false;
                    Session["TypWrkId"] = null;
                }
                else
                {
                   string msg = bltow.saveTypeOfWork1(strwork, intIsDeleted, intApprove);
                    fillgrid();
                    if (msg == "1")
                    {
                        lblResult.Visible = true;
                        lblResult.ForeColor = System.Drawing.Color.Green;
                        lblResult.Text = "Type of Work Details are Added Successfully";
                        fillDDLTypWork();
                    }
                    else
                    {
                        lblResult.Visible = true;
                        lblResult.ForeColor = System.Drawing.Color.Red;
                        lblResult.Text = "Type of Work Details are Already Exists";
                    }
                    fillgrid();
                    lblErrorMsg.Text = "";
                    Session["TypWrkId"] = null;

                }
                txtTypeOfWork.Text = "";
                rbYesIsDeltypWrk.Checked = false;
                rbNoIsDeltypWrk.Checked = false;
                ChkBxApprovTypOfWrk.Checked = false;
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }