public static bool SaveLawyerPerson(ATTLawyerPerson objLawyerPerson)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.LJMS).BeginTransaction();
            double            pID     = 0;

            try
            {
                pID = DLLPerson.AddPersonnelDetails(objLawyerPerson, Tran);

                DLLLawyer.SaveLawyerDetails(pID, objLawyerPerson.LstLawyer, Tran);

                Tran.Commit();

                return(true);
            }
            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
Esempio n. 2
0
        public static bool AddEditLitigants(List <ATTLitigants> LitigantLST, OracleTransaction Tran, double caseID)
        {
            string InsertUpdateSQL = "";
            List <OracleParameter> paramArray;

            try
            {
                foreach (ATTLitigants obj in LitigantLST)
                {
                    double litigantID = 0;
                    if (obj.Action == "A")
                    {
                        InsertUpdateSQL = "SP_ADD_LITIGANTS";
                    }
                    else if (obj.Action == "E")
                    {
                        InsertUpdateSQL = "SP_EDIT_LITIGANTS";
                    }

                    if (obj.PersonOBJ != null)
                    {
                        litigantID = DLLPerson.AddPersonnelDetails(obj.PersonOBJ, Tran);
                    }

                    paramArray = new List <OracleParameter>();

                    paramArray.Add(Utilities.GetOraParam("P_CASE_ID", caseID, OracleDbType.Double, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_LITIGANT_ID", litigantID, OracleDbType.Double, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_LITIGANT_TYPE", obj.LitigantType, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_LITIGANT_SUB_TYPE_ID", obj.LitigantSubTypeID, OracleDbType.Int32, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_DISPLAY_NAME", obj.DisplayName, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_S_NO", obj.SNo, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_IS_PRISONED", obj.IsPrisoned, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_ENTRY_BY", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));

                    SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());

                    obj.CaseID     = caseID;
                    obj.LitigantID = litigantID;

                    if (obj.LitigantPrisonDetailsLST.Count > 0)
                    {
                        DLLLitigantPrisonDetails.AddEditLitigantsPrisonDetails(obj.LitigantPrisonDetailsLST, caseID, litigantID, Tran);
                    }
                }



                return(true);
            }
            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
        }
Esempio n. 3
0
        public static bool SaveFacultyMember(ATTFacultyMember objFacultyMember)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.DLPDS).BeginTransaction();
            double            personID;
            string            InsertUpdatePostSql = "";

            try
            {
                personID = DLLPerson.AddPersonnelDetails(objFacultyMember.ObjPerson, Tran);

                if (objFacultyMember.LstParticipantPost.Count > 0)
                {
                    DLLParticipantPost.SaveParticipantPost(objFacultyMember.LstParticipantPost, Tran, personID);
                }

                OracleParameter[] ParamArray = new OracleParameter[5];
                ParamArray[0] = Utilities.GetOraParam(":p_ORG_ID", objFacultyMember.OrgID, OracleDbType.Int32, ParameterDirection.Input);
                ParamArray[1] = Utilities.GetOraParam(":p_FACULTY_ID", objFacultyMember.FacultyID, OracleDbType.Int32, ParameterDirection.Input);
                ParamArray[2] = Utilities.GetOraParam(":p_P_ID", personID, OracleDbType.Double, ParameterDirection.Input);
                ParamArray[3] = Utilities.GetOraParam(":p_FROM_DATE", objFacultyMember.FromDate, OracleDbType.Varchar2, ParameterDirection.Input);
                ParamArray[4] = Utilities.GetOraParam(":p_TO_DATE", objFacultyMember.ToDate, OracleDbType.Varchar2, ParameterDirection.Input);
                if (objFacultyMember.PID == 0)
                {
                    InsertUpdatePostSql = "SP_ADD_FACULTY_MEMBER";
                }
                else if (objFacultyMember.PID > 0)
                {
                    InsertUpdatePostSql = "SP_EDIT_FACULTY_MEMBER";
                }
                SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePostSql, ParamArray);
                objFacultyMember.PID = personID;
                Tran.Commit();
                return(true);
            }

            catch (OracleException oex)
            {
                PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
                throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
            }
            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
Esempio n. 4
0
        public static bool SaveParticipant(ATTParticipant ObjParticipant)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.DLPDS).BeginTransaction();
            double            personID;
            string            InsertUpdatePostSql = "";

            try
            {
                personID = DLLPerson.AddPersonnelDetails(ObjParticipant.ObjPerson, Tran);

                if (ObjParticipant.LstParticipantPost.Count > 0)
                {
                    DLLParticipantPost.SaveParticipantPost(ObjParticipant.LstParticipantPost, Tran, personID);
                }

                OracleParameter[] ParamArray = new OracleParameter[4];
                ParamArray[0] = Utilities.GetOraParam(":p_ORG_ID", ObjParticipant.OrgID, OracleDbType.Int64, ParameterDirection.Input);
                ParamArray[1] = Utilities.GetOraParam(":p_PROGRAM_ID", ObjParticipant.ProgramID, OracleDbType.Int64, ParameterDirection.Input);
                ParamArray[2] = Utilities.GetOraParam(":p_P_ID", personID, OracleDbType.Double, ParameterDirection.Input);
                ParamArray[3] = Utilities.GetOraParam(":p_JOINING_DATE", ObjParticipant.JoiningDate, OracleDbType.Varchar2, ParameterDirection.Input);
                if (ObjParticipant.PID == 0)
                {
                    InsertUpdatePostSql = "SP_ADD_PARTICIPANT";
                }
                else if (ObjParticipant.PID > 0)
                {
                    InsertUpdatePostSql = "SP_EDIT_PARTICIPANT";
                }
                SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePostSql, ParamArray);
                ObjParticipant.PID = personID;
                Tran.Commit();
                return(true);
            }

            catch (OracleException oex)
            {
                PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
                throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
            }
            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
        public static ATTPerson GetPersonWithPersonnelAttributeByID(double personID)
        {
            object conn;

            try
            {
                conn = DLLPerson.GetConnection();
            }
            catch (Exception ex)
            {
                throw ex;
                return(null);
            }

            try
            {
                DataRow row = DLLPerson.GetPersonWithPersonnelAttributeByID(conn, personID).Rows[0];

                ATTPerson person = new ATTPerson();

                person.PId           = double.Parse(row["P_ID"].ToString());
                person.FirstName     = row["FIRST_NAME"].ToString();
                person.MidName       = row["MID_NAME"].ToString();
                person.SurName       = row["SUR_NAME"].ToString();
                person.Gender        = row["GENDER"].ToString();
                person.DOB           = row["DOB"].ToString();
                person.MaritalStatus = row["MARTIAL_STATUS"].ToString();
                person.CountryId     = row["country_id"] == System.DBNull.Value ? (int?)null : int.Parse(row["country_id"].ToString());
                person.BirthDistrict = row["birth_district"] == System.DBNull.Value ? (int?)null : int.Parse(row["birth_district"].ToString());
                person.ReligionId    = row["religion_id"] == System.DBNull.Value ? (int?)null : int.Parse(row["religion_id"].ToString());
                person.Photo         = row["p_photo"] as byte[];

                person.LstPersonAddress       = BLLPersonAddress.GetPersonAddress(conn, personID);
                person.LstPersonPhone         = BLLPersonPhone.GetPersonPhone(conn, personID);
                person.LstPersonEMail         = BLLPersonEMail.GetPersonEMail(conn, personID);
                person.LstPersonQualification = BLLPersonQualification.GetPersonQualification(conn, personID);
                //person.ls

                return(person);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                DLLPerson.CloseConnection(conn);
            }
        }
        public static bool SaveParticipantPost(List <ATTParticipantPost> lstParticipantPost)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.DLPDS).BeginTransaction();
            double            personID;
            string            InsertUpdatePostSql = "";

            try
            {
                personID = DLLPerson.AddPersonnelDetails(lstParticipantPost[0].ObjPerson, Tran);
                foreach (ATTParticipantPost lst in lstParticipantPost)
                {
                    OracleParameter[] ParamArray = new OracleParameter[4];
                    ParamArray[0] = Utilities.GetOraParam(":P_P_ID", personID, OracleDbType.Double, ParameterDirection.Input);
                    ParamArray[1] = Utilities.GetOraParam(":P_POST_ID", lst.PostID, OracleDbType.Int32, ParameterDirection.Input);
                    ParamArray[2] = Utilities.GetOraParam(":P_LEVEL_ID", lst.LevelID, OracleDbType.Int32, ParameterDirection.Input);
                    ParamArray[3] = Utilities.GetOraParam(":P_FROM_DATE", lst.FromDate, OracleDbType.Varchar2, ParameterDirection.Input);
                    if (lst.Action == "A")
                    {
                        InsertUpdatePostSql = "SP_ADD_PARTICIPANT_POST";
                    }
                    else if (lst.Action == "E")
                    {
                        InsertUpdatePostSql = "SP_EDIT_PARTICIPANT_POST";
                    }
                    SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePostSql, ParamArray);
                }

                Tran.Commit();
                return(true);
            }

            catch (OracleException oex)
            {
                PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
                throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
            }
            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
        public static ATTPerson GetPersons(double personID, string personDocActive)
        {
            //List<ATTVDC> lstVDCs = new List<ATTVDC>();
            ATTPerson obj = new ATTPerson();

            foreach (DataRow row in DLLPerson.GetPersonDetails(personID).Rows)
            {
                obj.PId       = double.Parse(row["P_ID"].ToString());
                obj.FirstName = row["FIRST_NAME"].ToString();
                obj.MidName   = (row["MID_NAME"] == System.DBNull.Value) ? "" : row["MID_NAME"].ToString();
                obj.SurName   = row["SUR_NAME"].ToString();

                obj.DOB           = row["DOB"] == System.DBNull.Value ? "" : row["DOB"].ToString();
                obj.Gender        = row["GENDER"] == System.DBNull.Value ? "" : row["GENDER"].ToString();
                obj.MaritalStatus = row["MARTIAL_STATUS"] == System.DBNull.Value ? "" : row["MARTIAL_STATUS"].ToString();
                //this.ddlCountry.SelectedValue
                if (row["BIRTH_DISTRICT"] == System.DBNull.Value)
                {
                    obj.BirthDistrict = null;
                }
                else
                {
                    obj.BirthDistrict = int.Parse(row["BIRTH_DISTRICT"].ToString());
                }

                //obj.BirthDistrict = row["BIRTH_DISTRICT"] == System.DBNull.Value ? 0 :int.Parse( row["BIRTH_DISTRICT"].ToString());
                obj.ReligionId = row["RELIGION_ID"] == System.DBNull.Value ? 0 : int.Parse(row["RELIGION_ID"].ToString());
                //this.txtIdentityMark.Text=objPerson.i
                obj.IniType    = int.Parse(row["INI_TYPE"].ToString());
                obj.IniUnit    = int.Parse(row["INI_UNIT"].ToString());
                obj.EntityType = row["ENTITY_TYPE"].ToString();

                obj.LstPersonAddress   = BLLPersonAddress.GetPersonAddress(null, obj.PId);
                obj.LstPersonPhone     = BLLPersonPhone.GetPersonPhone(null, obj.PId);
                obj.LstPersonEMail     = BLLPersonEMail.GetPersonEMail(null, obj.PId);
                obj.LstRelatives       = BLLRelatives.GetRelatives(null, obj.PId);
                obj.LstPersonDocuments = BLLPersonDocuments.GetPersonDocuments(null, obj.PId, personDocActive);
            }
            return(obj);
        }
        public static bool SaveLawyerDetails(ATTLawyer objLawyer)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.LJMS).BeginTransaction();
            double            pID;

            try
            {
                pID = DLLPerson.AddPersonnelDetails(objLawyer.ObjPerson, Tran);

                objLawyer.PID = pID;

                if (pID > 0)
                {
                    string sp = "SP_ADD_LAWYER_INFO ";

                    OracleParameter[] paramArray = new OracleParameter[6];
                    paramArray[0] = Utilities.GetOraParam(":p_P_ID", pID, OracleDbType.Double, ParameterDirection.Input);
                    paramArray[1] = Utilities.GetOraParam(":P_LAWYER_TYPE_ID", objLawyer.LawyerTypeID, OracleDbType.Int16, ParameterDirection.Input);
                    paramArray[2] = Utilities.GetOraParam(":P_LICENSE_NO", objLawyer.LicenseNo, OracleDbType.Varchar2, ParameterDirection.Input);
                    paramArray[3] = Utilities.GetOraParam(":P_FROM_DATE", objLawyer.FromDate, OracleDbType.Varchar2, ParameterDirection.Input);
                    paramArray[4] = Utilities.GetOraParam(":P_TO_DATE", "", OracleDbType.Varchar2, ParameterDirection.Input);
                    paramArray[5] = Utilities.GetOraParam(":p_ENTRY_BY", objLawyer.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);

                    SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray);

                    if (objLawyer.LstLawyerRenewal.Count > 0)
                    {
                        //DLLLawyerRenewal.SaveLawyerRenewalDetails(objLawyer, Tran);
                        DLLLawyer.SaveLawyerDetails(objLawyer);
                    }

                    //if (objLawyer.LstPrivateLawyer.Count > 0)
                    //{
                    //    DLLLawyer.SaveLawyerDetails(objLawyer);
                    //}

                    Tran.Commit();
                    return(true);
                }
                else
                {
                    Tran.Rollback();
                    return(false);
                }
            }

            catch (OracleException oex)
            {
                PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
                throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
            }

            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
        public static bool SaveEmployeeDetails(ATTEmployee objEmployee)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.PMS).BeginTransaction();
            double            employeeID;

            //double relativeID = 0;
            try
            {
                employeeID = DLLPerson.AddPersonnelDetails(objEmployee.ObjPerson, Tran);

                OracleParameter[] paramArray = new OracleParameter[7];
                paramArray[0] = Utilities.GetOraParam(":p_EMP_ID", employeeID, OracleDbType.Double, ParameterDirection.Input);
                paramArray[1] = Utilities.GetOraParam(":p_SYMBOL_NO", objEmployee.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input);
                paramArray[2] = Utilities.GetOraParam(":p_ORG_EMP_NO", objEmployee.OrgEmpNo, OracleDbType.Varchar2, ParameterDirection.Input);
                paramArray[3] = Utilities.GetOraParam(":p_IDENTITY_MARK", objEmployee.IdentityMark, OracleDbType.Varchar2, ParameterDirection.Input);
                paramArray[4] = Utilities.GetOraParam(":p_ENTRY_BY", objEmployee.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
                paramArray[5] = Utilities.GetOraParam(":p_PF_NO", objEmployee.PFNo, OracleDbType.Varchar2, ParameterDirection.Input);
                paramArray[6] = Utilities.GetOraParam(":p_CIT_NO", objEmployee.CitznNo, OracleDbType.Varchar2, ParameterDirection.Input);

                if (objEmployee.EmpID == 0)
                {
                    SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_ADD_EMPLOYEES", paramArray[0], paramArray);
                }
                else if (objEmployee.EmpID > 0)
                {
                    SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_EDIT_EMPLOYEES", paramArray[0], paramArray);
                }

                if (objEmployee.LstEmployeeVisits.Count > 0)
                {
                    DLLEmployeeVisits.AddEmployeeVisits(objEmployee.LstEmployeeVisits, Tran, employeeID);
                }
                if (objEmployee.LstEmployeeExperience.Count > 0)
                {
                    DLLEmployeeExperience.AddEmployeeExperiences(objEmployee.LstEmployeeExperience, Tran, employeeID);
                }
                if (objEmployee.LstEmployeePosting.Count > 0)
                {
                    DLLEmployeePosting.SaveEmployeePosting(objEmployee.LstEmployeePosting, Tran, employeeID);
                }
                if (objEmployee.LstEmployeePublication.Count > 0)
                {
                    DLLEmployeePublication.AddEmployeePublication(objEmployee.LstEmployeePublication, Tran, employeeID);
                }
                if (objEmployee.LstEmployeeBeneficiary.Count > 0)
                {
                    DLLEmployeeBeneficiary.SaveBeneficiary(objEmployee.LstEmployeeBeneficiary, Tran, employeeID);
                }
                if (objEmployee.LstInsurance.Count > 0)
                {
                    DLLInsurance.SaveEmpInsurance(objEmployee.LstInsurance, Tran, employeeID);
                }
                if (objEmployee.LSTAttachments.Count > 0)
                {
                    DLLPersonAttachments.SaveAttachments(objEmployee.LSTAttachments, Tran, employeeID);
                }
                if (objEmployee.ObjUser.Username != "" && objEmployee.ObjUser.Password != "")
                {
                    DLLUsers.SaveUsers(objEmployee.ObjUser, Tran, employeeID);
                }
                if (objEmployee.OrgUser.Username != "")
                {
                    DLLOrganizationUSers.SaveOrganizationUsers(objEmployee.OrgUser, Tran, employeeID);
                }
                if (objEmployee.LSTEmpDeputation != null)
                {
                    DLLEmployeeDeputation.SaveEmpployeeDeputation(objEmployee.LSTEmpDeputation, Tran, employeeID);
                }
                if (objEmployee.LstManonayan.Count > 0)
                {
                    DLLManonayan.SaveManonayan(objEmployee.LstManonayan, Tran, employeeID);
                }

                objEmployee.EmpID = employeeID;
                Tran.Commit();
                return(true);
            }

            catch (OracleException oex)
            {
                PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
                throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
            }

            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
Esempio n. 10
0
        public static bool SaveMelMilaapKartaa(List <ATTMelMilaapKartaa> MMKLst, List <ATTPerson> PersonList)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.CMS).BeginTransaction();

            string InsertUpdateSQL = "";

            try
            {
                double PID = 0;
                if (PersonList != null)
                {
                    PID = DLLPerson.AddPersonnelDetails(PersonList, Tran);
                }

                foreach (ATTMelMilaapKartaa attMMK in MMKLst)
                {
                    if (PID > 0)
                    {
                        attMMK.PID = PID;
                    }

                    if (attMMK.Action == "")
                    {
                        continue;
                    }

                    if (attMMK.Action == "A")
                    {
                        InsertUpdateSQL = "SP_ADD_MM_KARTAA";
                    }
                    else if (attMMK.Action == "D")
                    {
                        InsertUpdateSQL = "SP_DEL_MM_KARTAA";
                    }
                    else
                    {
                        InsertUpdateSQL = "SP_EDIT_MM_KARTAA";
                    }

                    List <OracleParameter> paramArray = new List <OracleParameter>();
                    paramArray.Add(Utilities.GetOraParam(":P_ORG_ID", attMMK.OrgID, OracleDbType.Int64, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam(":P_PERSON_ID", attMMK.PID, OracleDbType.Double, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam(":P_FROM_DATE", attMMK.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam(":P_POST", attMMK.Post, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam(":P_EXPERIENCE", attMMK.Experience, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", attMMK.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));

                    SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
                    if (attMMK.OathLst != null)
                    {
                        foreach (ATTMelMilapKartaOath obj in attMMK.OathLst)
                        {
                            obj.PersonID = attMMK.PID;
                        }

                        DLLMelMilapKartaOath.SaveMelMilaapKartaaOath(attMMK.OathLst, Tran);
                    }
                }
                Tran.Commit();
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }
        public static bool SaveWitnessPerson(List <ATTWitnessPerson> LstWP)
        {
            GetConnection     GetConn = new GetConnection();
            OracleTransaction Tran    = GetConn.GetDbConn(Module.CMS).BeginTransaction();

            try
            {
                foreach (ATTWitnessPerson objWP in LstWP)
                {
                    if (objWP.Action == "D" && objWP.WitnessID > 0)
                    {
                        string DelSql = "SP_DEL_WITNESS_PERSON";
                        List <OracleParameter> paramArray = new List <OracleParameter>();
                        paramArray.Add(Utilities.GetOraParam(":P_WITNESS_ID", objWP.WitnessID, OracleDbType.Int64, ParameterDirection.InputOutput));
                        SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, DelSql, paramArray.ToArray());
                    }
                    else if (objWP.Action == "A" || objWP.Action == "E")
                    {
                        double personID = objWP.PersonID;
                        objWP.PersonOBJ.PId = personID;
                        if (personID == 0)
                        {
                            personID = int.Parse(DLLPerson.AddPersonnelDetails(objWP.PersonOBJ, Tran).ToString());
                        }
                        string InsertUpdateSQL            = "";
                        List <OracleParameter> paramArray = new List <OracleParameter>();
                        paramArray.Add(Utilities.GetOraParam(":P_CASE_ID", objWP.CaseID, OracleDbType.Int64, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam(":P_LITIGANT_ID", objWP.LitigantID, OracleDbType.Int64, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam(":P_PERSON_ID", personID, OracleDbType.Int64, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam(":P_FROM_DATE", objWP.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam(":P_WITNESS_ID", objWP.WitnessID, OracleDbType.Int32, ParameterDirection.InputOutput));
                        paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objWP.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
                        if (objWP.Action == "A")
                        {
                            InsertUpdateSQL = "SP_ADD_CASE_WITNESS";
                        }
                        else
                        {
                            InsertUpdateSQL = "SP_EDIT_CASE_WITNESS";
                        }

                        SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());

                        objWP.WitnessID = int.Parse(paramArray[4].Value.ToString());
                    }
                    else
                    {
                        continue;
                    }
                }
                Tran.Commit();
                return(true);
            }

            catch (OracleException oex)
            {
                PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
                throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
            }

            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                GetConn.CloseDbConn();
            }
        }