Beispiel #1
0
        public static bool AddPrivateLawyerInfoList(List <ATTPrivateLawyer> lst)
        {
            string SP = "";

            double PID = 213;

            GetConnection     DBConn = new GetConnection();
            OracleConnection  Conn   = DBConn.GetDbConn(Module.LJMS);
            OracleTransaction Tran   = Conn.BeginTransaction();

            List <OracleParameter> paramArray = new List <OracleParameter>();

            try
            {
                foreach (ATTPrivateLawyer lawyer in lst)
                {
                    if (lawyer.Action == "A")
                    {
                        SP = "SP_ADD_P_LAWYER_INFO";
                    }
                    else if (lawyer.Action == "E")
                    {
                        SP = "SP_EDIT_P_LAWYER_INFO";
                    }
                    else if (lawyer.Action == "D")
                    {
                        SP = "";
                    }

                    paramArray.Add(Utilities.GetOraParam("P_P_ID", PID, OracleDbType.Double, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_LAWYER_TYPE_ID", lawyer.LawyerTypeID, OracleDbType.Int16, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_LICENSE_NO", lawyer.Lisence, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_UNIT_ID", lawyer.UnitID, OracleDbType.Int16, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_FROM_DATE", lawyer.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_TO_DATE", lawyer.ToDate, OracleDbType.Varchar2, ParameterDirection.Input));
                    paramArray.Add(Utilities.GetOraParam("P_ENTRY_BY", lawyer.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));

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

                    DLLPrivateLawyerRenewal.AddPrivateLawyerReenwalList(lawyer.LstRenewal, Tran, PID);
                }
                Tran.Commit();
                return(true);
            }
            catch (Exception ex)
            {
                Tran.Rollback();
                throw ex;
            }
            finally
            {
                DBConn.CloseDbConn();
            }
        }
Beispiel #2
0
        public static bool AddPrivateLawyerInfoList(List <ATTPrivateLawyer> lst, OracleTransaction Tran, double PID)
        {
            string SP = "";

            List <OracleParameter> paramArray = new List <OracleParameter>();

            try
            {
                foreach (ATTPrivateLawyer lawyer in lst)
                {
                    if (lawyer.Action == "A")
                    {
                        SP = "SP_ADD_P_LAWYER_INFO";
                    }
                    else if (lawyer.Action == "E")
                    {
                        SP = "SP_EDIT_P_LAWYER_INFO";
                    }
                    else if (lawyer.Action == "D")
                    {
                        SP = "";
                    }


                    if (SP != "")
                    {
                        paramArray.Add(Utilities.GetOraParam("P_P_ID", PID, OracleDbType.Double, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam("P_LAWYER_TYPE_ID", lawyer.LawyerTypeID, OracleDbType.Int16, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam("P_LICENSE_NO", lawyer.Lisence, OracleDbType.Varchar2, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam("P_UNIT_ID", lawyer.UnitID, OracleDbType.Int16, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam("P_FROM_DATE", lawyer.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam("P_TO_DATE", lawyer.ToDate, OracleDbType.Varchar2, ParameterDirection.Input));
                        paramArray.Add(Utilities.GetOraParam("P_ENTRY_BY", lawyer.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));

                        SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray());
                        SP = "";
                    }
                    paramArray.Clear();

                    if (lawyer.LstRenewal.Count > 0)
                    {
                        if (DLLPrivateLawyerRenewal.AddPrivateLawyerReenwalList(lawyer.LstRenewal, Tran, PID) == false)
                        {
                            return(false);
                        }
                    }
                }
                return(true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }