Beispiel #1
0
        /********************************************************************************************************/
        public SCT_PSA getPersonnelSubArea_DAL()
        {
            logger.Info("Method : getPersonnelSubArea_DAL Start");

            databaseLayer dbConStr = new databaseLayer();
            string connStr = dbConStr.connectionInfo;

            logger.Debug("Connection string : " + connStr);

            SqlConnection conn = new SqlConnection(connStr);

            if (conn.State == System.Data.ConnectionState.Closed)
            {
                conn.Open();
                logger.Debug("Connection Status opened ");
            }

            logger.Info("Connetion to the database established");

            try
            {

                string query = "select code sa_id,codedescription sa_desc from codes where codetype='personnelsubarea' and displayorder=1";
                SqlCommand cmd_SCTDetails = new SqlCommand();
                cmd_SCTDetails.Connection = conn;
                cmd_SCTDetails.CommandText = query;

                logger.Info("cmd_SCTDetails Query parameters initialised");

                QueryLog.CmdInfo(cmd_SCTDetails);

                SqlDataAdapter da_SCTDetails = new SqlDataAdapter();
                da_SCTDetails.SelectCommand = cmd_SCTDetails;
                DataSet dSet_SCTDetails = new DataSet();
                da_SCTDetails.Fill(dSet_SCTDetails);

                logger.Info("cmd_SCTDetails excuted by SqlDataAdapter()");

                int Details_count = dSet_SCTDetails.Tables[0].Rows.Count;

                logger.DebugFormat("Row Count : ItemDetails table {0}", Details_count.ToString());

                SCT_PSA result = new SCT_PSA(Details_count);

                if (Details_count > 0)
                {

                    result.SCT_header.StatusFlag = 0;
                    result.SCT_header.StatusMsg = SCT_Constants.Success;

                    int objCounter_item = 0;

                    foreach (DataRow item_dr in dSet_SCTDetails.Tables[0].Rows)
                    {
                        SCT_PSA.PSA Item = new SCT_PSA.PSA();
                        Item.ID = item_dr["SA_ID"].ToString();
                        Item.Label = item_dr["SA_DESC"].ToString();

                        result.SCT_Details[objCounter_item++] = Item;
                    }
                }

                else
                {
                    result.SCT_header.StatusFlag = 1;
                    result.SCT_header.StatusMsg = "No records Found";
                }

                logger.Info("Method : searchEmployee_DAL Stop");

                return result;

            }
            catch (SqlException dbEx)
            {
                logger.Fatal("Exception Occured At SCT_DAL - getPersonnelSubArea_DAL");
                logger.Debug("Exception Code : " + dbEx.Number.ToString());
                logger.Debug("Exception Description : " + dbEx.Message.ToString());
                logger.Error("Error : getPersonnelSubArea_DAL Stop");

                throw dbEx;
            }
            catch (Exception ex)
            {
                logger.Fatal("Exception Occured At SCT_DAL - getPersonnelSubArea_DAL  : " + ex.Message.ToString());
                logger.Error("Error : getPersonnelSubArea_DAL Stop");

                throw ex;
            }
            finally
            {
                logger.Debug("Connection Status Closed ");

                conn.Dispose();
            }
        }
Beispiel #2
0
    public SCT_PSA getPersonnelSubArea()
    {
        logger.Info("Method : getPersonnelSubArea Start");

        try
        {
            SCT_PSA result = new SCT_PSA();
            SCTInterface PSA_SI = new SCTInterface();
            result = PSA_SI.getPersonnelSubArea_SI();

            logger.Info("Method : getPersonnelSubArea Stop");

            return result;
        }
        catch (SqlException ex)
        {
            webServiceExHandling.ExceptionLog(ex);
            //string mailBody = string.Format(SCT_Constants.mail_BodyFormat,System.DateTime.Now.ToString("F"),PReqNo,ex.TargetSite.ToString(),ex.ToString());
            //webServiceExHandling.Send_Email(SCT_Constants.Email_Dic, mailBody);

            SCT_PSA Error = new SCT_PSA();
            Error.SCT_header.StatusFlag = ex.Number;
            string expCode = ExpType(ex);
            Error.SCT_header.StatusMsg = SCT_Constants.cnfgErrMessages[expCode];

            logger.Debug("Return object Error : Status Flag = " + Error.SCT_header.StatusFlag.ToString());
            logger.Debug("Return object Error : Status Message = " + Error.SCT_header.StatusMsg);
            logger.Error("Method : getPersonnelSubArea Stop");

            return Error;
        }

        catch (Exception ex)
        {
            webServiceExHandling.ExceptionLog(ex);
            //string mailBody = string.Format(SCT_Constants.mail_BodyFormat, System.DateTime.Now.ToString("F"), PReqNo, ex.TargetSite.ToString(), ex.ToString());
            //webServiceExHandling.Send_Email(SCT_Constants.Email_Dic, mailBody);

            SCT_PSA Error = new SCT_PSA();
            Error.SCT_header.StatusFlag = 1;
            Error.SCT_header.StatusMsg = SCT_Constants.Error;

            logger.Debug("Return object Error : ErrorCode = " + Error.SCT_header.StatusFlag.ToString());
            logger.Debug("Return object Error : ErrorMessage = " + Error.SCT_header.StatusMsg);
            logger.Error("Method : getPersonnelSubArea Stop");

            return Error;
        }
    }