예제 #1
0
파일: SCT_DAL.cs 프로젝트: hari316/Projects
        /********************************************************************************************************/
        public SCT_Horizontal getHorizontal_DAL()
        {
            logger.Info("Method : getHorizontal_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 divisionid horizontal_code,divisionname horizontal_Description from division where divisiontype='HZ' and divisionstatus='A'";
                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_Horizontal result = new SCT_Horizontal(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_Horizontal.Horizontal Item = new SCT_Horizontal.Horizontal();
                        Item.ID = item_dr["horizontal_code"].ToString();
                        Item.Label = item_dr["horizontal_Description"].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 - getHorizontal_DAL");
                logger.Debug("Exception Code : " + dbEx.Number.ToString());
                logger.Debug("Exception Description : " + dbEx.Message.ToString());
                logger.Error("Error : getHorizontal_DAL Stop");

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

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

                conn.Dispose();
            }
        }
예제 #2
0
파일: Service.cs 프로젝트: hari316/Projects
    public SCT_Horizontal getHorizontal()
    {
        logger.Info("Method : getHorizontal Start");

        try
        {
            SCT_Horizontal result = new SCT_Horizontal();
            SCTInterface get_SI = new SCTInterface();
            result = get_SI.getHorizontal_SI();

            logger.Info("Method : getHorizontal 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_Horizontal Error = new SCT_Horizontal();
            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 : getHorizontal 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_Horizontal Error = new SCT_Horizontal();
            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 : getHorizontal Stop");

            return Error;
        }
    }