//Function to update Project
        private void updateProject(string projectID)
        {
            //Check for Condition of Date for End Date to be null
            if (txtEndDate.Text == "")
            {
                checkDate = true;
            }

            if (checkDate == true)
            {
                //function call for Updating information in database
                objProjDtls = new ProjectDeatils();

                string prjNumber = txtProjectNo.Text;
                string prjName   = txtProjectName.Text;

                int    agencyID    = int.Parse(drpAgency.SelectedValue.ToString());
                string dtStartDate = txtStartDate.Text;
                string dtEndDate   = txtEndDate.Text;

                int docCatID = int.Parse(drpDocCat.SelectedValue.ToString());

                objProjDtls.updateProjectDetailsMaster(projectID, prjNumber, prjName, agencyID, dtStartDate, dtEndDate, docCatID);
            }
        }
        //reader for Edit
        private clsEntProjectDetails readForEdit(int Id, string projectNo)
        {
            clsEntProjectDetails objEnt = new clsEntProjectDetails();

            objProjDtls = new ProjectDeatils();
            objEnt      = objProjDtls.readInfo(Id, projectNo);
            return(objEnt);
        }
        //Function to Save
        private void saveProject()
        {
            objProjDtls = new ProjectDeatils();
            string prjNumber = txtProjectNo.Text;
            string prjName   = txtProjectName.Text;

            int    agencyID    = int.Parse(drpAgency.SelectedValue.ToString());
            string dtStartDate = txtStartDate.Text;
            string dtEndDate   = txtEndDate.Text;


            int docCatID = int.Parse(drpDocCat.SelectedValue.ToString());

            //function call for storing information in database
            objProjDtls.AddProjectDetailsMaster(prjNumber, prjName, agencyID, dtStartDate, dtEndDate, docCatID);
        }
        protected void grdProjectDetailsMaster_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            objProj = new ProjectDeatils();
            try
            {
                //Storing the Row Index of Deleted Row
                int rowIndex = int.Parse(grdProjectDetailsMaster.DataKeys[e.RowIndex].Value.ToString());

                //Function call for row delete
                if (objProj.DeleteProjectDetails(rowIndex))
                {
                    UrlParameterPasser urlWrapper = new UrlParameterPasser("ProjectDetailsList.aspx");
                    // Add some values
                    urlWrapper.PassParameters();
                }
            }
            catch (Exception ex)
            {
                logger.Error(ex);
            }
        }