Beispiel #1
0
        protected void btnSaveService_Click(object sender, EventArgs e)
        {
            try
            {
                BLServices bls = new BLServices();
                setparameters();

                if (Session["ServiceId"] != null)
                {
                    intServiceId = int.Parse(Session["ServiceId"].ToString());
                    bls.updateService1(intServiceId, strServiceName, intIsDeleted, intApprove);
                    lblResult.Visible = true;
                    lblResult.Text = "Service Details are Updated Successfully";
                    //Session.Clear();
                    Session["ServiceId"] = null;
                    btnClear.Enabled = true;
                }
                else
                {
                   string msg = bls.saveServices1(strServiceName, intIsDeleted, intApprove);
                   if (msg == "1")
                   {
                       lblResult.Visible = true;
                       lblResult.ForeColor = System.Drawing.Color.Green;
                       lblResult.Text = "Service Details are Added Successfully";
                   }
                   else
                   {
                       lblResult.Visible = true;
                       lblResult.ForeColor = System.Drawing.Color.Red;
                       lblResult.Text = "Service Details are Already Exists";
                   }
                    //Session.Clear();
                    Session["ServiceId"] = null;
                }
                ClearFields();
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
Beispiel #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!Page.IsPostBack)
                {
                    if (Session["ServiceId"] == null)
                    {
                        if ((HttpContext.Current.Session["LoginId"]) == null)
                        {
                            Response.Redirect("~/Login.aspx");
                        }
                    }

                    if (Session["ServiceId"] != null)
                    {
                        SqlConnection con = new SqlConnection(connstr);
                        lblServiceId.Text = Session["ServiceId"].ToString();
                        int intServiceId = int.Parse(Session["ServiceId"].ToString());
                        BLServices blc = new BLServices();
                        con.Open();
                        SqlDataReader dr = blc.getServiceDetailsForUpdate1(intServiceId);
                        if (dr.HasRows)
                        {
                            while (dr.Read())
                            {
                                btnClear.Enabled = false;
                                txtServiceNm.Text = dr.GetString(1);
                                bool isdel = dr.GetBoolean(2);
                                if (isdel == true)
                                    rbYesIsDelSer.Checked = true;
                                else
                                    rbNoIsDelSer.Checked = true;
                                int approve = dr.GetInt32(3);
                                if (approve == 1)
                                    chBxApproveServc.Checked = true;
                                else
                                    chBxApproveServc.Checked = false;
                            }
                            dr.Close();
                        }
                    }
                }
                else
                {
                    lblResult.Text = "";
                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
Beispiel #3
0
        public void fillgridService()
        {
            try
            {
                int intClientID = int.Parse(lblCliId1.Text);
                BLServices blpr = new BLServices();
                SqlDataReader dr = blpr.getServicePrice1(intClientID);
                System.Data.DataTable dt = new System.Data.DataTable();

                if (dr.HasRows)
                {
                    lblServices.Text = "";
                    dt.Load(dr);
                    GVServices.DataSource = dt;
                    GVServices.DataBind();
                    if (ddlCliNm.SelectedItem.Text == "--Select--")
                    {
                        GVServices.DataSource = null;
                        GVServices.DataBind();
                        lblServices.Visible = true;
                        lblServices.Text = "Services are not available for the selected Client";
                    }
                }
                else
                {
                    GVServices.DataSource = null;
                    GVServices.DataBind();
                    lblServices.Visible = true;
                    lblServices.Text = "Services are not available for the selected Client";
                }

                dr.Close();
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
Beispiel #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if ((HttpContext.Current.Session["LoginId"]) == null)
                {
                    Response.Redirect("~/Login.aspx");
                }
                if (!Page.IsPostBack)
                {

                    Session["strFileName"] = null;
                    Session["strFilePath"] = null;
                    Session["chars"] = null;
                    Session["filenew"] = null;
                    //cbpdf.Visible = false;
                    #region------------fill DDLClient------------
                    BLProject blvc = new BLProject();
                    SqlDataReader dr = blvc.getClientNameForProject1();
                    ddlCliNm.Items.Clear();
                    if (dr.HasRows)
                    {
                        while (dr.Read())
                            ddlCliNm.Items.Add(dr.GetString(0));
                        ddlCliNm.Items.Insert(0, new ListItem("--Select--", "-1"));
                        dr.Close();
                    }
                    #endregion

                    #region----------Fill DDLTypeofWork--------------
                    BLProject bltow = new BLProject();
                    SqlDataReader dr1 = bltow.getTypeOfWorkForProject1();
                    ddlTypWrk.Items.Clear();
                    if (dr1.HasRows)
                    {
                        while (dr1.Read())
                            ddlTypWrk.Items.Add(dr1.GetString(1));
                        ddlTypWrk.Items.Insert(0, new ListItem("--Select--", "-1"));
                        dr1.Close();
                    }
                    #endregion

                    ddlStatus.Items.Insert(0, new ListItem("--Select--", "-1"));
                    #region-----------All fillgrid function call--------------
                    fillgridClerk();
                    fillgridPapers();
                    fillgridEmployees();
                    fillgridDocBoy();
                    #endregion

                    #region------------------Show values to date textboxces-----------------
                    txtDate.Text = DateTime.Now.Date.ToShortDateString();
                    txtSoftCopySent.Text = DateTime.Now.Date.ToShortDateString();
                    txtPendingDocRcd.Text = DateTime.Now.Date.ToShortDateString();
                    txtHardCopySent.Text = DateTime.Now.Date.ToShortDateString();
                    //txtPendingDocRcsp.Text = DateTime.Now.Date.ToShortDateString();
                    txtSearchInitiated.Text = DateTime.Now.Date.ToShortDateString();
                    //txtFinalReportSent.Text = DateTime.Now.Date.ToShortDateString();
                    txtSearchReceived.Text = DateTime.Now.Date.ToShortDateString();
                    txtReceiptSearch.Text = DateTime.Now.Date.ToShortDateString();
                    txtStrDtEmp.Text = DateTime.Now.Date.ToShortDateString();
                    txtEndDtEmp.Text = DateTime.Now.Date.ToShortDateString();
                    txtStrStarDtClerk.Text = DateTime.Now.Date.ToShortDateString();
                    txtStrEndDtClerk.Text = DateTime.Now.Date.ToShortDateString();
                    #endregion

                    if (Request.QueryString["ProjectId"] != null)
                    {
                        //dpdwnlstFileNames.Visible = true;
                        lblProjectId.Text = Request.QueryString["ProjectId"].ToString();
                        int intProjectId = int.Parse(lblProjectId.Text);
                        BLProject blc = new BLProject();
                        //btnOpenAddWrk.Enabled = true;
                        //btnDelAddWrk.Enabled = true;
                        //btnEmailAddWrk.Enabled = true;

                        // Code to show selected Documents
                        int gvdocid;
                        //intProjectId = int.Parse(Session["ProjectId"].ToString());
                        SqlDataReader dr3 = blc.showSelectedDoc1(intProjectId);
                        System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add("docid");
                        if (dr3.HasRows)
                        {
                            while (dr3.Read())
                            {
                                int doc = dr3.GetInt32(0);
                                dt.Rows.Add(doc);
                            }
                            dr3.Close();
                        }

                        foreach (GridViewRow gvrow in GVPapers.Rows)
                        {

                            if (gvrow.RowType == DataControlRowType.DataRow)
                            {
                                System.Web.UI.WebControls.Label lblDocumentID = (gvrow.Cells[0].FindControl("lblDocumentId") as System.Web.UI.WebControls.Label);
                                gvdocid = int.Parse(lblDocumentID.Text);
                                System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelDoc") as System.Web.UI.WebControls.CheckBox);
                                for (int i = 0; i < dt.Rows.Count; i++)
                                {
                                    int doc = int.Parse(dt.Rows[i].Field<string>(0));
                                    if (doc == gvdocid)
                                    {
                                        chksel.Checked = true;
                                    }
                                }
                            }
                        }

                        //Code to show selected Employees
                        int gvempid;
                        // intProjectId = int.Parse(Session["ProjectId"].ToString());
                        SqlDataReader dr4 = blc.showSelectedEmployees1(intProjectId);
                        System.Data.DataTable dt1 = new System.Data.DataTable();
                        dt1.Columns.Add("empid");
                        if (dr4.HasRows)
                        {
                            while (dr4.Read())
                            {
                                int emp = dr4.GetInt32(0);
                                dt1.Rows.Add(emp);
                            }
                            dr4.Close();
                        }

                        foreach (GridViewRow gvrow in GVEmployees.Rows)
                        {

                            if (gvrow.RowType == DataControlRowType.DataRow)
                            {
                                System.Web.UI.WebControls.Label lblEmployeeID = (gvrow.Cells[0].FindControl("lblEmployeeID") as System.Web.UI.WebControls.Label);
                                gvempid = Convert.ToInt32(lblEmployeeID.Text);
                                System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelEmp") as System.Web.UI.WebControls.CheckBox);
                                for (int i = 0; i < dt1.Rows.Count; i++)
                                {
                                    int emp = int.Parse(dt1.Rows[i].Field<string>(0));
                                    if (emp == gvempid)
                                    {
                                        chksel.Checked = true;
                                    }
                                }
                            }
                        }

                        //Code To show Selected Document Boys
                        int gvdocboyid;
                        // intProjectId = int.Parse(Session["ProjectId"].ToString());
                        SqlDataReader dr5 = blc.showSelectedDocBoys1(intProjectId);
                        System.Data.DataTable dt2 = new System.Data.DataTable();
                        dt2.Columns.Add("docboyid");
                        if (dr5.HasRows)
                        {

                            while (dr5.Read())
                            {
                                int doc = dr5.GetInt32(0);
                                dt2.Rows.Add(doc);
                            }
                            dr5.Close();
                        }

                        foreach (GridViewRow gvrow in GVDocBoy.Rows)
                        {

                            if (gvrow.RowType == DataControlRowType.DataRow)
                            {
                                System.Web.UI.WebControls.Label lblDocumentBoyID = (gvrow.Cells[0].FindControl("lblDocumentBoyID") as System.Web.UI.WebControls.Label);
                                gvdocboyid = int.Parse(lblDocumentBoyID.Text);
                                System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelDocBoy") as System.Web.UI.WebControls.CheckBox);
                                for (int i = 0; i < dt2.Rows.Count; i++)
                                {
                                    int docboy = int.Parse(dt2.Rows[i].Field<string>(0));
                                    if (docboy == gvdocboyid)
                                    {
                                        chksel.Checked = true;
                                    }
                                }
                            }
                        }

                        //Code to show selected clerk
                        int gvclerkid;
                        //intProjectId = int.Parse(Session["ProjectId"].ToString());
                        SqlDataReader dr6 = blc.showSelectedClerk1(intProjectId);
                        System.Data.DataTable dt3 = new System.Data.DataTable();
                        dt3.Columns.Add("clerkid");
                        if (dr6.HasRows)
                        {
                            while (dr6.Read())
                            {
                                int clerk = dr6.GetInt32(0);
                                dt3.Rows.Add(clerk);
                            }
                        }
                        dr6.Close();
                        foreach (GridViewRow gvrow in GVClerk.Rows)
                        {

                            if (gvrow.RowType == DataControlRowType.DataRow)
                            {
                                System.Web.UI.WebControls.Label lblClerkID = (gvrow.Cells[0].FindControl("lblClerkID") as System.Web.UI.WebControls.Label);
                                gvclerkid = int.Parse(lblClerkID.Text);
                                System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelClerk") as System.Web.UI.WebControls.CheckBox);
                                for (int i = 0; i < dt3.Rows.Count; i++)
                                {
                                    int clerk = int.Parse(dt3.Rows[i].Field<string>(0));
                                    if (clerk == gvclerkid)
                                    {
                                        chksel.Checked = true;
                                    }
                                }
                            }
                        }

                        SqlDataReader dr2 = blc.getProjectDetailsForUpdate1(intProjectId);
                        if (dr2.HasRows)
                        {
                            while (dr2.Read())
                            {
                                Button1.Enabled = false;
                                //btnSaveWordFile.Enabled = true;
                                ddlCliNm.Enabled = false;
                                ddlTypWrk.Enabled = false;
                                //ddlStatus.Visible = false;
                                txtDate.Text = dr2.GetDateTime(1).ToShortDateString();
                                ddlCliNm.SelectedValue = dr2.GetString(3);

                                //code for fill grid of service
                                BLServices blaee = new BLServices();
                                string strClientName1 = Convert.ToString(ddlCliNm.SelectedItem.Text);
                                SqlDataReader dr8 = blaee.getClientIDforService1(strClientName1);
                                if (dr8.HasRows)
                                {
                                    while (dr8.Read())
                                        lblCliId1.Text = dr8.GetInt32(0).ToString();
                                }
                                dr8.Close();

                                int intClientID = int.Parse(lblCliId1.Text);
                                BLServices blpr = new BLServices();
                                SqlDataReader dr9 = blpr.getServicePrice1(intClientID);
                                System.Data.DataTable dt5 = new System.Data.DataTable();
                                if (dr9.HasRows)
                                {
                                    dt5.Load(dr9);
                                    GVServices.DataSource = dt5;
                                    GVServices.DataBind();
                                }
                                dr9.Close();

                                //Code to show selected Services
                                int gvserviceid;
                                // intProjectId = int.Parse(Session["ProjectId"].ToString());
                                SqlDataReader drService = blc.showSelectedServices1(intProjectId);
                                System.Data.DataTable dtService = new System.Data.DataTable(); dtService.Columns.Add("serviceid");
                                if (drService.HasRows)
                                {
                                    while (drService.Read())
                                    {
                                        int service = drService.GetInt32(0);
                                        dtService.Rows.Add(service);
                                    }
                                }
                                drService.Close();

                                foreach (GridViewRow gvrow in GVServices.Rows)
                                {

                                    if (gvrow.RowType == DataControlRowType.DataRow)
                                    {
                                        System.Web.UI.WebControls.Label lblSeviceID = (gvrow.Cells[0].FindControl("lblServiceID") as System.Web.UI.WebControls.Label);
                                        gvserviceid = int.Parse(lblSeviceID.Text);
                                        System.Web.UI.WebControls.CheckBox chksel = (gvrow.Cells[0].FindControl("ChkBxSelService") as System.Web.UI.WebControls.CheckBox);
                                        for (int i = 0; i < dtService.Rows.Count; i++)
                                        {
                                            int service = int.Parse(dtService.Rows[i].Field<string>(0));
                                            if (service == gvserviceid)
                                            {
                                                chksel.Checked = true;
                                            }
                                        }
                                    }
                                }

                                lblTypWrkID.Text = dr2.GetInt32(4).ToString();
                                ddlTypWrk.SelectedValue = dr2.GetString(5);
                                txtCasNm.Text = dr2.GetString(6);

                                bool intExternalWork = dr2.GetBoolean(7);
                                if (intExternalWork == true)
                                    chkBxDsReqExtWrk.Checked = true;
                                else
                                    chkBxDsReqExtWrk.Checked = false;

                                bool intNeedSearch = dr2.GetBoolean(8);
                                if (intNeedSearch == true)
                                    chkBxDsReqSrch.Checked = true;
                                else
                                    chkBxDsReqSrch.Checked = false;

                                txtRemarks.Text = dr2.GetString(9);
                                txtPrice.Text = dr2.GetDecimal(10).ToString();
                                txtOtherCharge.Text = dr2.GetDecimal(11).ToString();
                                txtTotAmt.Text = dr2.GetDecimal(12).ToString();
                                txtStatus.Text = dr2.GetString(13);
                                ddlStatus.SelectedValue = dr2.GetString(13);
                                bool intIsDeleted = dr2.GetBoolean(14);
                                if (intIsDeleted == true)
                                    rbYesIsDel.Checked = true;
                                else
                                    rbNoIsDel.Checked = true;

                                int intApprove = dr2.GetInt32(15);
                                if (intApprove == 1)
                                    ChkBxApprovProject.Checked = true;
                                else
                                    ChkBxApprovProject.Checked = false;

                                txtServiceTax.Text = dr2.GetDecimal(16).ToString();
                                txtRefNo.Text = dr2.GetString(17);
                                if (dr2["LoanNo"] != DBNull.Value)
                                {
                                    txtLoanAcNoAddWrk.Text = dr2.GetString(18);
                                }
                                else
                                {
                                    txtLoanAcNoAddWrk.Text = "";
                                }

                                if (dr2["PropertyAddress"] != DBNull.Value)
                                {
                                    txtPropertyDetails.Text = dr2.GetString(19);
                                }
                                else
                                {
                                    txtPropertyDetails.Text = "";
                                }
                                if (dr2["dt_softcopysent"] != DBNull.Value)
                                {
                                    txtSoftCopySent.Text = dr2.GetDateTime(20).ToShortDateString();
                                }
                                else
                                {
                                    txtSoftCopySent.Text = DateTime.Now.Date.ToShortDateString();
                                }

                                DateTime dt_MISclient = Convert.ToDateTime("1990-01-01 00:00:00.000");

                                if (dr2["dt_search_initiated"] != DBNull.Value)
                                {
                                    txtSearchInitiated.Text = dr2.GetDateTime(22).ToShortDateString();
                                }
                                else
                                {
                                    txtSearchInitiated.Text = DateTime.Now.Date.ToShortDateString();
                                }
                                if (dr2["dt_search_received"] != DBNull.Value)
                                {
                                    txtSearchReceived.Text = dr2.GetDateTime(23).ToShortDateString();
                                }
                                else
                                {
                                    txtSearchReceived.Text = DateTime.Now.Date.ToShortDateString();
                                }
                                if (dr2["dt_search_received_receipt"] != DBNull.Value)
                                {
                                    txtReceiptSearch.Text = dr2.GetDateTime(24).ToShortDateString();
                                }
                                else
                                {
                                    txtReceiptSearch.Text = DateTime.Now.Date.ToShortDateString();
                                }
                                if (dr2["dt_hardcopysent"] != DBNull.Value)
                                {
                                    txtHardCopySent.Text = dr2.GetDateTime(25).ToShortDateString();
                                }
                                else
                                {
                                    txtHardCopySent.Text = DateTime.Now.Date.ToShortDateString();
                                }
                                if (dr2["dt_pendingdocumentsrec"] != DBNull.Value)
                                {
                                    txtPendingDocRcd.Text = dr2.GetDateTime(26).ToShortDateString();
                                }
                                else
                                {
                                    txtPendingDocRcd.Text = DateTime.Now.Date.ToShortDateString();
                                }
                                //if (dr2["dt_pendingdocumentsresp"] != DBNull.Value)
                                //{
                                //    txtPendingDocRcsp.Text = dr2.GetDateTime(27).ToShortDateString();
                                //}
                                //else
                                //{
                                //    txtPendingDocRcsp.Text = DateTime.Now.Date.ToShortDateString();
                                //}
                                //if (dr2["dt_finalreportsent"] != DBNull.Value)
                                //{
                                //    txtFinalReportSent.Text = dr2.GetDateTime(28).ToShortDateString();
                                //}
                                //else
                                //{
                                //    txtPendingDocRcsp.Text = DateTime.Now.Date.ToShortDateString();
                                //}

                                if (dr2["branch"] != DBNull.Value)
                                {
                                    txtBranchAddWrk.Text = dr2.GetString(31);
                                }
                                else
                                {
                                    txtBranchAddWrk.Text = "";
                                }
                                //if (dr2["loanamt"] != DBNull.Value)
                                //{
                                //    txtLoanAmtAddWrk.Text = dr2.GetDecimal(32).ToString();
                                //}
                                //else
                                //{
                                //    txtLoanAmtAddWrk.Text = "";
                                //}
                                if (dr2["worddoc"] != DBNull.Value)
                                {
                                    Byte[] strworddoc = (byte[])dr2["worddoc"];
                                    str = System.Text.Encoding.Default.GetString(strworddoc);
                                    Session["strFilePath"] = str;
                                }
                                else
                                {
                                    Session["strFilePath"] = null;
                                }

                                if (dr2["filename"] != DBNull.Value)
                                {
                                    //string filename = dr2.GetString(30);
                                    //string[] values = filename.Split(',');
                                    //for (int i = 0; i < values.Length; i++)
                                    //{
                                    //    values[i] = values[i].Trim();
                                    //    filename = values[i];
                                    //    dpdwnlstFileNames.Items.Add(filename);
                                    //}
                                    //Session["strFileName"] = dr2.GetString(30);
                                }
                                else
                                {
                                    Session["strFileName"] = null;
                                }
                                //TRy
                                if (dr2["EmailID"] != DBNull.Value)
                                {
                                    //txtEmail.Text = dr2.GetString(33);
                                }

                            }
                            dr2.Close();
                        }
                    }
                }
                else
                {
                    //Span1.InnerHtml = "";

                    lblResult.Text = "";
                    lblCatchError.Text = "";
                    lbltesting.Text = "";
                    lblMessageFile.Text = "";
                    lblDelMsg.Text = "";
                    //CEDate.SelectedDate = DateTime.ParseExact(txtDate.Text, CEDate.Format, null);
                    CalendarExtender9.SelectedDate = DateTime.ParseExact(txtStrDtEmp.Text, CalendarExtender9.Format, null);
                    CalendarExtender10.SelectedDate = DateTime.ParseExact(txtEndDtEmp.Text, CalendarExtender10.Format, null);
                    CalendarExtender11.SelectedDate = DateTime.ParseExact(txtStrStarDtClerk.Text, CalendarExtender11.Format, null);
                    CalendarExtender12.SelectedDate = DateTime.ParseExact(txtStrEndDtClerk.Text, CalendarExtender12.Format, null);

                    CalendarExtender1.SelectedDate = DateTime.ParseExact(txtSoftCopySent.Text, CalendarExtender1.Format, null);
                    CalendarExtender2.SelectedDate = DateTime.ParseExact(txtPendingDocRcd.Text, CalendarExtender2.Format, null);
                    CalendarExtender3.SelectedDate = DateTime.ParseExact(txtHardCopySent.Text, CalendarExtender3.Format, null);
                    //CalendarExtender5.SelectedDate = DateTime.ParseExact(txtPendingDocRcsp.Text, CalendarExtender5.Format, null);
                    CalendarExtender4.SelectedDate = DateTime.ParseExact(txtSearchInitiated.Text, CalendarExtender4.Format, null);
                    //CalendarExtender6.SelectedDate = DateTime.ParseExact(txtFinalReportSent.Text, CalendarExtender6.Format, null);
                    CalendarExtender7.SelectedDate = DateTime.ParseExact(txtSearchReceived.Text, CalendarExtender7.Format, null);
                    CalendarExtender8.SelectedDate = DateTime.ParseExact(txtReceiptSearch.Text, CalendarExtender8.Format, null);

                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
Beispiel #5
0
        protected void ddlApproveSer_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                string strServiceName = ddlSearchByServiceNameSer.SelectedItem.Text;
                int intApprove = int.Parse(ddlApproveSer.SelectedItem.Value);

                if (ddlSearchByServiceNameSer.SelectedItem.Text == "--Select--" && ddlApproveSer.SelectedItem.Text != "--Select--")
                {
                    BLServices blpr = new BLServices();
                    SqlDataReader dr = blpr.gridFillApproveService1(intApprove);
                    DataTable dt = new DataTable();
                    if (dr.HasRows == true)
                    {
                        dt.Load(dr);
                        GdVwViewService.DataSource = dt;
                        GdVwViewService.DataBind();
                    }
                    else
                    {
                        lblErrorMsg.Text = "Records not Available";
                        GdVwViewService.DataSource = dt;
                        GdVwViewService.DataBind();
                    }
                    dr.Close();
                }
                if (ddlSearchByServiceNameSer.SelectedItem.Text != "--Select--" && ddlApproveSer.SelectedItem.Text != "--Select--")
                {
                    BLServices blpr = new BLServices();
                    SqlDataReader dr = blpr.gridFillApproveServiceName1(strServiceName, intApprove);
                    DataTable dt = new DataTable();
                    if (dr.HasRows == true)
                    {
                        dt.Load(dr);
                        GdVwViewService.DataSource = dt;
                        GdVwViewService.DataBind();
                    }
                    else
                    {
                        lblErrorMsg.Text = "Records not Available";
                        GdVwViewService.DataSource = dt;
                        GdVwViewService.DataBind();
                    }
                    dr.Close();
                }
                if (ddlSearchByServiceNameSer.SelectedItem.Text == "--Select--" && ddlApproveSer.SelectedItem.Text == "--Select--")
                {
                    lblErrorMsg.Text = "Records not Available";
                    GdVwViewService.DataSource = null;
                    GdVwViewService.DataBind();
                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }
Beispiel #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if ((HttpContext.Current.Session["LoginId"]) == null)
                {
                    Response.Redirect("~/Login.aspx");
                }

                if (!Page.IsPostBack)
                {
                    BLServices blsr = new BLServices();
                    SqlDataReader dr = blsr.getServiceName1();
                    ddlSearchByServiceNameSer.Items.Clear();
                    ddlSearchByServiceNameSer.Items.Add("--Select--");
                    if (dr.HasRows == true)
                    {
                        while (dr.Read())
                            ddlSearchByServiceNameSer.Items.Add(dr.GetString(0));
                    }
                    else
                    {
                        lblErrorMsg.Text = "Records not available";
                        fillgrid();
                    }
                    dr.Close();
                    fillgrid();
                }
                else
                {
                    lblCatchError.Text = "";
                    lblErrorMsg.Text = "";
                }
            }
            catch (Exception ex)
            {
                lblCatchError.Text = ex.Message.ToString();
            }
        }