Exemple #1
0
        /// <summary>
        /// to fetch all details
        /// </summary>
        /// <returns></returns>
        public GrievanceList Getcategory()
        {
            OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
            OracleCommand    cmd;
            string           proc = "USP_TRN_GET_GRIEV_CATEGORY";

            cmd             = new OracleCommand(proc, con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
            cmd.Connection.Open();
            OracleDataReader dr      = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            GrievancesBO     BOobj   = null;
            GrievanceList    Listobj = new GrievanceList();

            while (dr.Read())
            {
                BOobj = new GrievancesBO();
                BOobj.GrievCategoryID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRIEVANCECATEGID"))));
                BOobj.GrievCategory   = dr.GetValue(dr.GetOrdinal("GRIEVANCECATEGORY")).ToString();

                Listobj.Add(BOobj);
            }

            dr.Close();
            return(Listobj);
        }
Exemple #2
0
        /// <summary>
        /// to fetch all details
        /// </summary>
        /// <param name="householdID"></param>
        /// <returns></returns>
        public GrievanceList Getgrievancedata(int householdID)
        {
            OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
            OracleCommand    cmd;

            string proc = "USP_TRN_SEL_GRIEVANCE";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("HHID_", householdID);
            cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();
            OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            GrievancesBO  GrievancesBOObj  = null;
            GrievanceList GrievanceListObj = new GrievanceList();

            while (dr.Read())
            {
                GrievancesBOObj = new GrievancesBO();
                if (!dr.IsDBNull(dr.GetOrdinal("GRIEVANCEID")))
                {
                    GrievancesBOObj.GrievanceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRIEVANCEID")));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("PAPNAME")))
                {
                    GrievancesBOObj.PapName = dr.GetString(dr.GetOrdinal("PAPNAME"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("GRIEVANCECATEGORY")))
                {
                    GrievancesBOObj.GrievCategory = dr.GetString(dr.GetOrdinal("GRIEVANCECATEGORY"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("CREATEDDATE")))
                {
                    GrievancesBOObj.CreatedDate = dr.GetDateTime(dr.GetOrdinal("CREATEDDATE"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("GREVDESCRIPTION")))
                {
                    GrievancesBOObj.Description = dr.GetString(dr.GetOrdinal("GREVDESCRIPTION"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
                {
                    GrievancesBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
                }
                if (!dr.IsDBNull(dr.GetOrdinal("RESOLUTIONSTATUS")))
                {
                    GrievancesBOObj.ResolutionStatus = dr.GetString(dr.GetOrdinal("RESOLUTIONSTATUS"));
                }
                GrievanceListObj.Add(GrievancesBOObj);
            }

            dr.Close();

            return(GrievanceListObj);
        }
Exemple #3
0
        /// <summary>
        /// to assign the data from database to the textbox's districtTextBox, countyTextBox
        /// subcountyTextBox,parishTextBox,villageTextBox
        /// </summary>
        /// <param name="hhid"></param>
        private void screenIntialization(int hhid)
        {
            GrievancesBLL objGrievancesBLL = new GrievancesBLL();
            GrievancesBO  GrievancesBOobj  = new GrievancesBO();

            GrievancesBOobj = objGrievancesBLL.getscreenIntialization(hhid);

            districtTextBox.Text  = GrievancesBOobj.District;
            countyTextBox.Text    = GrievancesBOobj.County;
            subcountyTextBox.Text = GrievancesBOobj.SubCounty;
            parishTextBox.Text    = GrievancesBOobj.Parish;
            villageTextBox.Text   = GrievancesBOobj.Village;
        }
Exemple #4
0
        /// <summary>
        /// To Insert into Database
        /// </summary>
        /// <param name="GrievancesBOobj"></param>
        /// <returns></returns>
        public int Insert(GrievancesBO GrievancesBOobj)
        {
            GrievancesDAL GrievancesDALobj = new GrievancesDAL(); //Data pass -to Database Layer

            try
            {
                return(GrievancesDALobj.Insert(GrievancesBOobj));
            }
            catch
            {
                throw;
            }
            finally
            {
                GrievancesDALobj = null;
            }
        }
Exemple #5
0
        /// <summary>
        /// get Grievance data from database
        /// </summary>
        public void getGrievance()
        {
            GrievancesBLL objGrievancesBLL = new GrievancesBLL();
            GrievancesBO  GrievancesBOobj  = new GrievancesBO();

            //GrievancesBO GrievancesBOobj = (new GrievancesBLL()).getGrievance(Convert.ToInt32(ViewState["GrievanceID"]));
            //if (GrievancesBOobj != null)
            //    lblCategoryAssign.Text = GrievancesBOobj.GrievCategory;
            //lblCreatedDateAssign.Text = GrievancesBOobj.CreatedDate.ToString();
            //descriptionTextBox.Text = GrievancesBOobj.Description;

            int GrievanceID = Convert.ToInt32(ViewState["GrievanceID"]);

            GrievancesBOobj = objGrievancesBLL.GetGrievanceClosure(GrievanceID);
            if (GrievancesBOobj != null)
            {
                lblCategoryAssign.Text    = GrievancesBOobj.GrievCategory;
                lblCreatedDateAssign.Text = GrievancesBOobj.CreatedDate.ToString(UtilBO.DateFormatFull);
                txtClosureComments.Text   = GrievancesBOobj.ClosureComments;
            }
        }
Exemple #6
0
        /// <summary>
        /// update Grievance status to close
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnClose_Click(object sender, EventArgs e)
        {
            string       updateStatus = "C";
            GrievancesBO objGrievance = new GrievancesBO();

            objGrievance.Hhid        = Convert.ToInt32(Session["HH_ID"]);
            objGrievance.GrievanceID = Convert.ToInt32(ViewState["GrievanceID"]);
            if (txtClosureComments.Text.Length > 499)
            {
                objGrievance.ClosureComments = txtClosureComments.Text.Trim().Substring(0, 499);
            }
            else
            {
                objGrievance.ClosureComments = txtClosureComments.Text.Trim();
            }
            objGrievance.UpdatedBy        = Convert.ToInt32(Session["USER_ID"]);
            objGrievance.ResolutionStatus = updateStatus;
            MyTasks_ApprovalBLL objMytaskApprovalBLL = new MyTasks_ApprovalBLL();

            objMytaskApprovalBLL.UPdateGrievance(objGrievance);

            ClientScript.RegisterStartupScript(this.GetType(), "GrivanceClosure", "GrivanceClosure();", true);
        }
Exemple #7
0
        /// <summary>
        /// to update data
        /// </summary>
        /// <param name="GrievancesBOobj"></param>
        /// <returns></returns>
        public int EditGRIEVANCE(GrievancesBO GrievancesBOobj)
        {
            OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);

            cnn.Open();
            OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_GRIEVANCE", cnn);

            dcmd.CommandType = CommandType.StoredProcedure;
            int count = Convert.ToInt32(dcmd.CommandType);

            try
            {
                dcmd.Parameters.Add("R_GRIEVANCEID", GrievancesBOobj.GrievanceID);
                dcmd.Parameters.Add("R_GRIEVANCECATEGID", GrievancesBOobj.GrievCategoryID);
                dcmd.Parameters.Add("R_GREVDESCRIPTION", GrievancesBOobj.Description);
                dcmd.Parameters.Add("R_ACTIONTAKEN", GrievancesBOobj.ActionTaken);

                if (GrievancesBOobj.ActionTakenDate != DateTime.MinValue)
                {
                    dcmd.Parameters.Add("R_ACTIONTAKENDATE", GrievancesBOobj.ActionTakenDate);
                }
                else
                {
                    dcmd.Parameters.Add("R_ACTIONTAKENDATE", DBNull.Value);
                }

                if (GrievancesBOobj.ActionTakenBy > 0)
                {
                    dcmd.Parameters.Add("ACTIONTAKENBY", GrievancesBOobj.ActionTakenBy);
                }
                else
                {
                    dcmd.Parameters.Add("ACTIONTAKENBY", DBNull.Value);
                }

                dcmd.Parameters.Add("R_BASICFACTS", GrievancesBOobj.BasicFacts);
                dcmd.Parameters.Add("R_RESOLUTION", GrievancesBOobj.Resolution);

                if (GrievancesBOobj.ResolutionDate != DateTime.MinValue)
                {
                    dcmd.Parameters.Add("R_RESOLUTIONDATE", GrievancesBOobj.ResolutionDate);
                }
                else
                {
                    dcmd.Parameters.Add("R_RESOLUTIONDATE", DBNull.Value);
                }

                if (GrievancesBOobj.ResolvedBy > 0)
                {
                    dcmd.Parameters.Add("R_RESOLVEDBY", GrievancesBOobj.ResolvedBy);
                }
                else
                {
                    dcmd.Parameters.Add("R_RESOLVEDBY", DBNull.Value);
                }

                dcmd.Parameters.Add("R_UPDATEDBY", GrievancesBOobj.CreatedBy);
                dcmd.Parameters.Add("ResolutionStatus_", GrievancesBOobj.ResolutionStatus);

                return(dcmd.ExecuteNonQuery());
            }
            catch
            {
                throw;
            }
            finally
            {
                dcmd.Dispose();
                cnn.Close();
                cnn.Dispose();
            }
        }
Exemple #8
0
        /// <summary>
        /// to fetch all details
        /// </summary>
        /// <param name="GrievanceID"></param>
        /// <returns></returns>
        public GrievancesBO GetGrievancedatarow(int GrievanceID)
        {
            OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
            OracleCommand    cmd;

            string proc = "USP_TRN_GET_GRIEVANCE";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("R_GRIEVANCEID", GrievanceID);
            cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();

            OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            GrievancesBO     GrievancesBOObj  = null;
            GrievanceList    GrievanceListObj = new GrievanceList();

            GrievancesBOObj = new GrievancesBO();
            while (dr.Read())
            {
                if (!dr.IsDBNull(dr.GetOrdinal("grievanceid")))
                {
                    GrievancesBOObj.GrievanceID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("grievanceid")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("grievancecategid")))
                {
                    GrievancesBOObj.GrievCategoryID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("grievancecategid")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("grevdescription")))
                {
                    GrievancesBOObj.Description = Convert.ToString(dr.GetValue(dr.GetOrdinal("grevdescription")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("actiontaken")))
                {
                    GrievancesBOObj.ActionTaken = Convert.ToString(dr.GetValue(dr.GetOrdinal("actiontaken")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("actiontakendate")))
                {
                    GrievancesBOObj.ActionTakenDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("actiontakendate")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("actiontakenby")))
                {
                    GrievancesBOObj.ActionTakenBy = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("actiontakenby")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("basicfacts")))
                {
                    GrievancesBOObj.BasicFacts = Convert.ToString(dr.GetValue(dr.GetOrdinal("basicfacts")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("resolution")))
                {
                    GrievancesBOObj.Resolution = Convert.ToString(dr.GetValue(dr.GetOrdinal("resolution")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("resolutiondate")))
                {
                    GrievancesBOObj.ResolutionDate = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("resolutiondate")));
                }

                if (!dr.IsDBNull(dr.GetOrdinal("resolvedby")))
                {
                    GrievancesBOObj.ResolvedBy = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("resolvedby")));
                }
            }
            dr.Close();


            return(GrievancesBOObj);
        }
Exemple #9
0
        /// <summary>
        /// to fetch all details
        /// </summary>
        /// <param name="hhid"></param>
        /// <returns></returns>
        public GrievancesBO getscreenIntialization(int hhid)
        {
            OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
            OracleCommand    cmd;

            string proc = "USP_MST_GET_GRIEVANCEIDDATA";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("hhid_", hhid);
            cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            cmd.Connection.Open();

            OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            GrievancesBO  GrievancesBOObj  = null;
            GrievanceList GrievanceListObj = new GrievanceList();

            GrievancesBOObj = new GrievancesBO();

            while (dr.Read())
            {
                if (ColumnExists(dr, "HHID") && !dr.IsDBNull(dr.GetOrdinal("HHID")))
                {
                    GrievancesBOObj.Hhid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID")));
                }

                if (ColumnExists(dr, "PAPNAME") && !dr.IsDBNull(dr.GetOrdinal("PAPNAME")))
                {
                    GrievancesBOObj.PapName = dr.GetString(dr.GetOrdinal("PAPNAME"));
                }

                if (ColumnExists(dr, "PLOTREFERENCE") && !dr.IsDBNull(dr.GetOrdinal("PLOTREFERENCE")))
                {
                    GrievancesBOObj.PlotReference = dr.GetString(dr.GetOrdinal("PLOTREFERENCE"));
                }

                if (ColumnExists(dr, "DISTRICT") && !dr.IsDBNull(dr.GetOrdinal("DISTRICT")))
                {
                    GrievancesBOObj.District = dr.GetString(dr.GetOrdinal("DISTRICT"));
                }

                if (ColumnExists(dr, "COUNTY") && !dr.IsDBNull(dr.GetOrdinal("COUNTY")))
                {
                    GrievancesBOObj.County = dr.GetString(dr.GetOrdinal("COUNTY"));
                }

                if (ColumnExists(dr, "SUBCOUNTY") && !dr.IsDBNull(dr.GetOrdinal("SUBCOUNTY")))
                {
                    GrievancesBOObj.SubCounty = dr.GetString(dr.GetOrdinal("SUBCOUNTY"));
                }

                if (ColumnExists(dr, "PARISH") && !dr.IsDBNull(dr.GetOrdinal("PARISH")))
                {
                    GrievancesBOObj.Parish = dr.GetString(dr.GetOrdinal("PARISH"));
                }

                if (ColumnExists(dr, "VILLAGE") && !dr.IsDBNull(dr.GetOrdinal("VILLAGE")))
                {
                    GrievancesBOObj.Village = dr.GetString(dr.GetOrdinal("VILLAGE"));
                }
            }
            dr.Close();

            return(GrievancesBOObj);
        }
Exemple #10
0
        /// <summary>
        /// To UPdate Grievance
        /// </summary>
        /// <param name="objGrievance"></param>
        ///
        public void UPdateGrievance(GrievancesBO objGrievance)
        {
            MyTasks_ApprovalDAL objMyTaskApprovalDAL = new MyTasks_ApprovalDAL();

            objMyTaskApprovalDAL.UPdateGrievance(objGrievance);
        }
Exemple #11
0
        /// <summary>
        /// to Save the data to the database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSave_Click(object sender, EventArgs e)
        {
            int           count            = 0;
            string        descriptionText  = "";
            string        message          = "";
            GrievancesBLL objGrievancesBLL = new GrievancesBLL();
            GrievancesBO  GrievancesBOobj  = null;

            if (Convert.ToInt32(ViewState["GRIEVANCEID"]) > 0)
            {
                try
                {
                    string hhid = Session["HH_ID"].ToString();

                    GrievancesBOobj = new GrievancesBO();

                    GrievancesBOobj.GrievanceID     = Convert.ToInt32(ViewState["GRIEVANCEID"]);
                    GrievancesBOobj.GrievCategoryID = Convert.ToInt32(categoryDropDownList.SelectedValue);

                    descriptionText = descriptionTextBox.Text.Trim();
                    if (descriptionText.Length >= 1000)
                    {
                        descriptionText = descriptionText.Substring(0, 1000);
                    }

                    GrievancesBOobj.Description = descriptionText;

                    descriptionText = actionTextBox.Text.Trim();
                    if (descriptionText.Length >= 500)
                    {
                        descriptionText = descriptionText.Substring(0, 500);
                    }

                    GrievancesBOobj.ActionTaken = descriptionText;

                    if (actionDatePicker.Text.Trim() != "")
                    {
                        GrievancesBOobj.ActionTakenDate = Convert.ToDateTime(actionDatePicker.Text.ToString());
                    }

                    GrievancesBOobj.ActionTakenBy = Convert.ToInt32(actionDropDownList.SelectedValue.ToString().Trim());

                    descriptionText = basicTextBox.Text.Trim();
                    if (descriptionText.Length >= 500)
                    {
                        descriptionText = descriptionText.Substring(0, 500);
                    }

                    GrievancesBOobj.BasicFacts = descriptionText;

                    descriptionText = resolutionTextBox.Text.Trim();
                    if (descriptionText.Length >= 500)
                    {
                        descriptionText = descriptionText.Substring(0, 500);
                    }

                    GrievancesBOobj.Resolution = descriptionText;

                    if (resolutionDatePicker.Text.Trim() != "")
                    {
                        GrievancesBOobj.ResolutionDate = Convert.ToDateTime(resolutionDatePicker.Text.ToString());
                    }

                    GrievancesBOobj.ResolvedBy = Convert.ToInt32(resolDropDownList.SelectedValue.ToString().Trim());
                    GrievancesBOobj.CreatedBy  = Convert.ToInt32(Session["USER_ID"]);

                    GrievancesBLL objGrievancBLL = new GrievancesBLL();

                    if ((resolDropDownList.SelectedItem.Value.ToString()) == "0")
                    {
                        GrievancesBOobj.ResolutionStatus = "P";
                        count   = objGrievancBLL.EditGRIEVANCE(GrievancesBOobj);
                        message = "Data updated successfully";
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('" + message + "');", true);
                    }
                    else
                    {
                        bool approverExists = CheckApprover(); //Send email for Approval if Approver Exists

                        if (approverExists)
                        {
                            GrievancesBOobj.ResolutionStatus = "S";
                            count   = objGrievancBLL.EditGRIEVANCE(GrievancesBOobj);
                            message = "Data updated successfully";
                            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('" + message + "');", true);

                            string scriptContent = string.Format("SendApprovalEmail('{0}',{1},{2},{3},'{4}',{5});",
                                                                 UtilBO.WorkflowGrievances,
                                                                 Convert.ToInt32(Session["PROJECT_ID"]),
                                                                 Convert.ToInt32(Session["USER_ID"]),
                                                                 Convert.ToInt32(Session["HH_ID"]),
                                                                 UtilBO.WorkflowGrievances,
                                                                 Convert.ToInt32(ViewState["GRIEVANCEID"])
                                                                 );
                            ScriptManager.RegisterStartupScript(this, this.GetType(), "Updated2", scriptContent, true);
                        }
                        else
                        {
                            message = "You are trying to resolve the status, but the Approver for Grievance Resolution is not defined.";
                        }
                    }

                    ClearDetails();
                    SetUpdateMode(false);
                    BindGrid();
                    ResolutionStatusChange.Visible = false;
                }
                catch (Exception ex)
                {
                    throw ex;
                }

                finally
                {
                    objGrievancesBLL = null;
                }
            }
            else
            {
                // insert

                try
                {
                    string hhid = Session["HH_ID"].ToString();

                    GrievancesBOobj             = new GrievancesBO();
                    GrievancesBOobj.GrievanceID = Convert.ToInt32(ViewState["GRIEVANCEID"]);

                    GrievancesBOobj.GrievCategoryID = Convert.ToInt32(categoryDropDownList.SelectedValue);

                    descriptionText = descriptionTextBox.Text.Trim();
                    if (descriptionText.Length >= 1000)
                    {
                        descriptionText = descriptionText.Substring(0, 1000);
                    }

                    GrievancesBOobj.Description = descriptionText;

                    GrievancesBOobj.ActionTaken = actionTextBox.Text.ToString().Trim();

                    if (actionDatePicker.Text.Trim() != "")
                    {
                        GrievancesBOobj.ActionTakenDate = Convert.ToDateTime(actionDatePicker.Text.ToString());
                    }

                    GrievancesBOobj.ActionTakenBy = Convert.ToInt32(actionDropDownList.SelectedValue.ToString().Trim());

                    descriptionText = basicTextBox.Text.Trim();
                    if (descriptionText.Length >= 500)
                    {
                        descriptionText = descriptionText.Substring(0, 500);
                    }

                    GrievancesBOobj.BasicFacts = descriptionText;

                    descriptionText = resolutionTextBox.Text.Trim();
                    if (descriptionText.Length >= 500)
                    {
                        descriptionText = descriptionText.Substring(0, 500);
                    }

                    GrievancesBOobj.Resolution = descriptionText;


                    if (resolutionDatePicker.Text.Trim() != "")
                    {
                        GrievancesBOobj.ResolutionDate = Convert.ToDateTime(resolutionDatePicker.Text.ToString());
                    }

                    GrievancesBOobj.ResolvedBy = Convert.ToInt32(resolDropDownList.SelectedValue.ToString().Trim());
                    if ((resolDropDownList.SelectedItem.Value.ToString()) == "0")
                    {
                        GrievancesBOobj.ResolutionStatus = "P";
                    }
                    else
                    {
                        GrievancesBOobj.ResolutionStatus = "P";
                    }

                    GrievancesBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
                    GrievancesBOobj.Hhid      = Convert.ToInt32(hhid);


                    GrievancesBLL GrievancesBLL = new GrievancesBLL();
                    count = GrievancesBLL.Insert(GrievancesBOobj);
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
                    ClearDetails();
                    SetUpdateMode(false);
                    BindGrid();
                }
                catch (Exception ex)
                {
                    throw ex;
                }

                finally
                {
                    objGrievancesBLL = null;
                }
            }
            //projectFrozen();
            //ChangeRequestStatusGrievances();
        }
Exemple #12
0
/// <summary>
/// to get the grievance  data row by row
/// </summary>
        private void GetGrievancedatarow()
        {
            GrievancesBLL objGrievancesBLL = new GrievancesBLL();
            int           GrievanceID      = 0;

            if (ViewState["GRIEVANCEID"] != null)
            {
                GrievanceID = Convert.ToInt32(ViewState["GRIEVANCEID"]);
            }
            //For Upload Documents Added by Anjankumar
            lnkUploadDoc.Attributes.Clear();
            lnkViewUploadDoc.Attributes.Clear();
            int    hhid           = Convert.ToInt32(Session["HH_ID"]);
            int    userID         = Convert.ToInt32(Session["USER_ID"]);
            string paramUploadDoc = string.Format("OpenUploadDocumnet({0},{1},{2},'{3}','{4}','{5}');", Convert.ToInt32(Session["PROJECT_ID"]),
                                                  hhid, userID, Session["PROJECT_CODE"].ToString(), "GRV", GrievanceID);
            string paramViewDocs = string.Format("OpenUploadDocumnetlist({0},{1},{2},'{3}','{4}','{5}');", Convert.ToInt32(Session["PROJECT_ID"]),
                                                 hhid, userID, Session["PROJECT_CODE"].ToString(), "GRV", GrievanceID);

            lnkUploadDoc.Attributes.Add("onclick", paramUploadDoc);
            lnkViewUploadDoc.Attributes.Add("onclick", paramViewDocs);

            // End Documnts
            GrievancesBO GrievancesBOobj = new GrievancesBO();

            GrievancesBOobj = objGrievancesBLL.GetGrievancedatarow(GrievanceID);

            categoryDropDownList.ClearSelection();
            if (categoryDropDownList.Items.FindByValue(GrievancesBOobj.GrievCategoryID.ToString()) != null)
            {
                categoryDropDownList.Items.FindByValue(GrievancesBOobj.GrievCategoryID.ToString()).Selected = true;
            }

            //Getactionby();
            actionDropDownList.ClearSelection();
            if (actionDropDownList.Items.FindByValue(GrievancesBOobj.ActionTakenBy.ToString()) != null)
            {
                actionDropDownList.Items.FindByValue(GrievancesBOobj.ActionTakenBy.ToString()).Selected = true;
            }

            //Getresolby();
            resolDropDownList.ClearSelection();
            if (resolDropDownList.Items.FindByValue(GrievancesBOobj.ResolvedBy.ToString()) != null)
            {
                resolDropDownList.Items.FindByValue(GrievancesBOobj.ResolvedBy.ToString()).Selected = true;
            }

            descriptionTextBox.Text = GrievancesBOobj.Description.ToString();
            actionTextBox.Text      = GrievancesBOobj.ActionTaken.ToString();

            if (GrievancesBOobj.ActionTakenDate != DateTime.MinValue)
            {
                actionDatePicker.Text = GrievancesBOobj.ActionTakenDate.ToString(UtilBO.DateFormat);
            }

            basicTextBox.Text      = GrievancesBOobj.BasicFacts.ToString();
            resolutionTextBox.Text = GrievancesBOobj.Resolution.ToString();

            if (GrievancesBOobj.ResolutionDate != DateTime.MinValue)
            {
                resolutionDatePicker.Text = GrievancesBOobj.ResolutionDate.ToString(UtilBO.DateFormat);
            }
        }