Exemple #1
0
        public ActionResult <ConfigurationViewModel> Get(string id)
        {
            ConfigurationViewModel result = null;

            try
            {
                if (string.IsNullOrEmpty(id))
                {
                    return(BadRequest("bad request.."));
                }

                var config = new ConfigurationViewModelParam()
                {
                    ConfigGUID = id
                };
                result = _businessAccess.GetConfiguration(config);

                if (string.IsNullOrEmpty(result.SiteConfiguration.WebsiteConfigurationName))
                {
                    return(NotFound(id));
                }
            }
            catch (Exception ex)
            {
                _log.Write("Exception in ConfigurationController; Message: " + ex.Message);
            }
            finally
            {
            }
            return(Ok(result));
        }
        public IDbResponse DeleteConfiguration(ConfigurationViewModelParam param)
        {
            IDbResponse result = new DbResponse();

            try
            {
                result = _dataAccess.DeleteConfiguration(param);
            }
            catch (Exception ex)
            {
                _log.Write("Exception in BusinessAccess; Message: " + ex.Message);
            }
            finally
            {
            }
            return(result);
        }
        public ConfigurationViewModel GetConfiguration(ConfigurationViewModelParam param)
        {
            var result = new ConfigurationViewModel();

            try
            {
                result = _dataAccess.GetConfiguration(param);
            }
            catch (Exception ex)
            {
                _log.Write("Exception in BusinessAccess; Message: " + ex.Message);
            }
            finally
            {
            }
            return(result);
        }
Exemple #4
0
        public ActionResult <IDbResponse> Delete(string id)
        {
            IDbResponse result = null;

            try
            {
                var user = new ConfigurationViewModelParam()
                {
                    ConfigGUID = id
                };
                result = _businessAccess.DeleteConfiguration(user);
            }
            catch (Exception ex)
            {
                _log.Write("Exception in ConfigurationController; Message: " + ex.Message);
            }
            finally
            {
            }
            return(Ok(result));
        }
Exemple #5
0
        public ActionResult <IDbResponse> Post([FromBody] ConfigurationViewModelParam config)
        {
            IDbResponse result = null;

            try
            {
                if (config == null || string.IsNullOrEmpty(config.SiteConfiguration.WebsiteConfigurationName))
                {
                    return(BadRequest("bad request.."));
                }

                result = _businessAccess.AddConfiguration(config);
            }
            catch (Exception ex)
            {
                _log.Write("Exception in ConfigurationController; Message: " + ex.Message);
            }
            finally
            {
            }
            return(Ok(result));
        }
        public IDbResponse DeleteConfiguration(ConfigurationViewModelParam param)
        {
            IDbResponse result = new DbResponse();

            try
            {
                using (SqlConnection conn = _connectionHelper.DefaultConnectionDB())
                {
                    using (SqlCommand cmd = new SqlCommand(SpHelper.DeleteConfiguration, conn))
                    {
                        conn.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@LoginUser", param.LoginUser);
                        cmd.Parameters.AddWithValue("@ConfigGUID", param.ConfigGUID);

                        using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                        {
                            // get details from reader
                            if (rdr.HasRows)
                            {
                                while (rdr.Read())
                                {
                                    result.IsSuccess = rdr.CustomGetValue <bool>("IsSuccess");
                                    result.Message   = rdr.CustomGetValue <string>("Message");
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                _log.Write("Exception in DataAccess; Message: " + ex.Message);
            }
            finally
            {
            }
            return(result);
        }
        public IDbResponse UpdateConfiguration(ConfigurationViewModelParam param)
        {
            IDbResponse result = new DbResponse();

            try
            {
                using (SqlConnection conn = _connectionHelper.DefaultConnectionDB())
                {
                    using (SqlCommand cmd = new SqlCommand(SpHelper.UpdateConfiguration, conn))
                    {
                        conn.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@LoginUser", param.LoginUser);
                        cmd.Parameters.AddWithValue("@ConfigGUID", param.ConfigGUID);
                        cmd.Parameters.AddWithValue("@WebsiteConfigurationName", param.SiteConfiguration.WebsiteConfigurationName);
                        cmd.Parameters.AddWithValue("@ScrapingMechanism", param.SiteConfiguration.ScrapingMechanism);
                        cmd.Parameters.AddWithValue("@ShouldRotateProxy", param.SiteConfiguration.ShouldRotateProxy);
                        cmd.Parameters.AddWithValue("@RequireInputValues", param.SiteConfiguration.RequireInputValues);
                        cmd.Parameters.AddWithValue("@ShouldDisableJavaScript", param.SiteConfiguration.ShouldDisableJavaScript);
                        cmd.Parameters.AddWithValue("@WaitingTimeAfterPageLoad", param.SiteConfiguration.WaitingTimeAfterPageLoad);
                        cmd.Parameters.AddWithValue("@WebsiteNamePrefix", param.WebsiteDetail.WebsiteNamePrefix);
                        cmd.Parameters.AddWithValue("@WebscrapeType", param.WebsiteDetail.WebscrapeType);
                        cmd.Parameters.AddWithValue("@WebsiteURL", param.WebsiteDetail.WebsiteURL);
                        cmd.Parameters.AddWithValue("@WebsiteURLs", param.WebsiteDetail.DbWebsiteURLs);
                        cmd.Parameters.AddWithValue("@DoesHaveSearchButton", param.WebsiteDetail.DoesHaveSearchButton);
                        cmd.Parameters.AddWithValue("@SearchButtonPathType", param.WebsiteDetail.SearchButtonPathType);
                        cmd.Parameters.AddWithValue("@SearchButton", param.WebsiteDetail.SearchButton);
                        cmd.Parameters.AddWithValue("@DoesHaveResetButton", param.WebsiteDetail.DoesHaveResetButton);
                        cmd.Parameters.AddWithValue("@ResetButtonPathType", param.WebsiteDetail.ResetButtonPathType);
                        cmd.Parameters.AddWithValue("@ResetButton", param.WebsiteDetail.ResetButton);
                        cmd.Parameters.AddWithValue("@OverallContainerPathType", param.ProductDetail.OverallContainerPathType);
                        cmd.Parameters.AddWithValue("@OverallContainer", param.ProductDetail.OverallContainer);
                        cmd.Parameters.AddWithValue("@ProductContainerPathType", param.ProductDetail.ProductContainerPathType);
                        cmd.Parameters.AddWithValue("@ProductContainer", param.ProductDetail.ProductContainer);
                        cmd.Parameters.AddWithValue("@PagingType", param.PaginationDetail.PagingType);
                        cmd.Parameters.AddWithValue("@PaginationContainerPathType", param.PaginationDetail.PaginationContainerPathType);
                        cmd.Parameters.AddWithValue("@PaginationContainer", param.PaginationDetail.PaginationContainer);
                        cmd.Parameters.AddWithValue("@DoesHaveNextButton", param.PaginationDetail.DoesHaveNextButton);
                        cmd.Parameters.AddWithValue("@NextButtonPathType", param.PaginationDetail.NextButtonPathType);
                        cmd.Parameters.AddWithValue("@NextButton", param.PaginationDetail.NextButton);
                        cmd.Parameters.AddWithValue("@ActiveClassForCurrentPage", param.PaginationDetail.ActiveClassForCurrentPage);
                        cmd.Parameters.AddWithValue("@DisabledClassForLastPage", param.PaginationDetail.DisabledClassForLastPage);
                        cmd.Parameters.AddWithValue("@ShouldLimitPaging", param.PaginationDetail.ShouldLimitPaging);
                        cmd.Parameters.AddWithValue("@PagingLimit", param.PaginationDetail.PagingLimit);
                        cmd.Parameters.AddWithValue("@ShouldSendMail", param.MailingInformation.ShouldSendMail);
                        cmd.Parameters.AddWithValue("@MailToAddress", param.MailingInformation.MailToAddress);
                        cmd.Parameters.AddWithValue("@MailCCAddress", param.MailingInformation.MailCCAddress);
                        cmd.Parameters.AddWithValue("@MailBCCAddress", param.MailingInformation.MailBCCAddress);
                        cmd.Parameters.AddWithValue("@DbInputFieldDetail", param.WebsiteDetail.DbInputFields);
                        cmd.Parameters.AddWithValue("@DbOutputFieldDetail", param.ProductDetail.DbFields);


                        using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                        {
                            // get details from reader
                            if (rdr.HasRows)
                            {
                                while (rdr.Read())
                                {
                                    result.IsSuccess = rdr.CustomGetValue <bool>("IsSuccess");
                                    result.Message   = rdr.CustomGetValue <string>("Message");
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                _log.Write("Exception in DataAccess; Message: " + ex.Message);
            }
            finally
            {
            }
            return(result);
        }
        public ConfigurationViewModel GetConfiguration(ConfigurationViewModelParam param)
        {
            var result = new ConfigurationViewModel();

            try
            {
                using (SqlConnection conn = _connectionHelper.DefaultConnectionDB())
                {
                    using (SqlCommand cmd = new SqlCommand(SpHelper.GetConfiguration, conn))
                    {
                        conn.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.AddWithValue("@ConfigGUID", param.ConfigGUID);

                        using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                        {
                            // get details from reader
                            if (rdr.HasRows)
                            {
                                while (rdr.Read())
                                {
                                    result.IsSuccess = rdr.CustomGetValue <bool>("IsSuccess");
                                    result.Message   = rdr.CustomGetValue <string>("Message");
                                }
                            }

                            if (rdr.NextResult())
                            {
                                while (rdr.Read())
                                {
                                    result.ConfigID   = rdr.CustomGetValue <string>("ConfigID");
                                    result.ConfigGUID = rdr.CustomGetValue <string>("ConfigGUID");
                                    result.CreatedOn  = rdr.CustomGetValue <string>("CreatedOn");
                                    result.CreatedBy  = rdr.CustomGetValue <string>("CreatedBy");
                                    result.UpdatedOn  = rdr.CustomGetValue <string>("UpdatedOn");
                                    result.UpdatedBy  = rdr.CustomGetValue <string>("UpdatedBy");


                                    result.SiteConfiguration = new SiteConfiguration()
                                    {
                                        WebsiteConfigurationName = rdr.CustomGetValue <string>("Configuration_WebsiteConfigurationName"),
                                        ScrapingMechanism        = rdr.CustomGetValue <string>("Configuration_ScrapingMechanism"),
                                        ShouldRotateProxy        = rdr.CustomGetValue <bool>("Configuration_ShouldRotateProxy"),
                                        RequireInputValues       = rdr.CustomGetValue <bool>("Configuration_RequireInputValues"),
                                        ShouldDisableJavaScript  = rdr.CustomGetValue <bool>("Configuration_ShouldDisableJavaScript"),
                                        WaitingTimeAfterPageLoad = rdr.CustomGetValue <string>("Configuration_WaitingTimeAfterPageLoad")
                                    };

                                    result.WebsiteDetail = new WebsiteDetail()
                                    {
                                        WebsiteNamePrefix    = rdr.CustomGetValue <string>("WebsiteDetail_WebsiteNamePrefix"),
                                        WebscrapeType        = rdr.CustomGetValue <string>("WebsiteDetail_WebscrapeType"),
                                        WebsiteURL           = rdr.CustomGetValue <string>("WebsiteDetail_WebsiteURL"),
                                        DoesHaveSearchButton = rdr.CustomGetValue <bool>("WebsiteDetail_DoesHaveSearchButton"),
                                        SearchButtonPathType = rdr.CustomGetValue <string>("WebsiteDetail_SearchButtonPathType"),
                                        SearchButton         = rdr.CustomGetValue <string>("WebsiteDetail_SearchButton"),
                                        DoesHaveResetButton  = rdr.CustomGetValue <bool>("WebsiteDetail_DoesHaveResetButton"),
                                        ResetButtonPathType  = rdr.CustomGetValue <string>("WebsiteDetail_ResetButtonPathType"),
                                        ResetButton          = rdr.CustomGetValue <string>("WebsiteDetail_ResetButton")
                                    };

                                    result.ProductDetail = new ProductDetail()
                                    {
                                        OverallContainerPathType = rdr.CustomGetValue <string>("ProductDetail_OverallContainerPathType"),
                                        OverallContainer         = rdr.CustomGetValue <string>("ProductDetail_OverallContainer"),
                                        ProductContainerPathType = rdr.CustomGetValue <string>("ProductDetail_ProductContainerPathType"),
                                        ProductContainer         = rdr.CustomGetValue <string>("ProductDetail_ProductContainer")
                                    };

                                    result.PaginationDetail = new PaginationDetail()
                                    {
                                        PagingType = rdr.CustomGetValue <string>("PaginationDetail_PagingType"),
                                        PaginationContainerPathType = rdr.CustomGetValue <string>("PaginationDetail_PaginationContainerPathType"),
                                        PaginationContainer         = rdr.CustomGetValue <string>("PaginationDetail_PaginationContainer"),
                                        DoesHaveNextButton          = rdr.CustomGetValue <bool>("PaginationDetail_DoesHaveNextButton"),
                                        NextButtonPathType          = rdr.CustomGetValue <string>("PaginationDetail_NextButtonPathType"),
                                        NextButton = rdr.CustomGetValue <string>("PaginationDetail_NextButton"),
                                        ActiveClassForCurrentPage = rdr.CustomGetValue <string>("PaginationDetail_ActiveClassForCurrentPage"),
                                        DisabledClassForLastPage  = rdr.CustomGetValue <string>("PaginationDetail_DisabledClassForLastPage"),
                                        ShouldLimitPaging         = rdr.CustomGetValue <bool>("PaginationDetail_ShouldLimitPaging"),
                                        PagingLimit = rdr.CustomGetValue <string>("PaginationDetail_PagingLimit")
                                    };

                                    result.MailingInformation = new MailingInformation()
                                    {
                                        ShouldSendMail = rdr.CustomGetValue <bool>("MailingInformation_ShouldSendMail"),
                                        MailToAddress  = rdr.CustomGetValue <string>("MailingInformation_MailToAddress"),
                                        MailCCAddress  = rdr.CustomGetValue <string>("MailingInformation_MailCCAddress"),
                                        MailBCCAddress = rdr.CustomGetValue <string>("MailingInformation_MailBCCAddress")
                                    };
                                }
                            }

                            if (rdr.NextResult())
                            {
                                while (rdr.Read())
                                {
                                    string url = rdr.CustomGetValue <string>("WebsiteURL");
                                    result.WebsiteDetail.WebsiteURLs.Add(url);
                                }
                            }

                            if (rdr.NextResult())
                            {
                                while (rdr.Read())
                                {
                                    var inputField = new InputField()
                                    {
                                        FieldName                     = rdr.CustomGetValue <string>("FieldName"),
                                        FieldPathType                 = rdr.CustomGetValue <string>("FieldPathType"),
                                        FieldPath                     = rdr.CustomGetValue <string>("FieldPath"),
                                        HasPartnerElement             = rdr.CustomGetValue <bool>("HasPartnerElement"),
                                        TargetType                    = rdr.CustomGetValue <string>("TargetType"),
                                        WaitingTimeAfterElementChange = rdr.CustomGetValue <string>("WaitingTimeAfterElementChange")
                                    };

                                    result.WebsiteDetail.InputFields.Add(inputField);
                                }
                            }

                            if (rdr.NextResult())
                            {
                                while (rdr.Read())
                                {
                                    var field = new Field()
                                    {
                                        FieldName                = rdr.CustomGetValue <string>("FieldName"),
                                        FieldPathType            = rdr.CustomGetValue <string>("FieldPathType"),
                                        FieldPath                = rdr.CustomGetValue <string>("FieldPath"),
                                        ShouldCheckElementInBody = rdr.CustomGetValue <bool>("ShouldCheckElementInBody"),
                                        RemoveText               = rdr.CustomGetValue <string>("RemoveText"),
                                        AttributeName            = rdr.CustomGetValue <string>("AttributeName")
                                    };

                                    result.ProductDetail.Fields.Add(field);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                _log.Write("Exception in DataAccess; Message: " + ex.Message);
            }
            finally
            {
            }
            return(result);
        }
Exemple #9
0
 public ConfigurationViewModel(ConfigurationViewModelParam param) : this()
 {
     LoginUser = param.LoginUser;
 }