Esempio n. 1
0
        public List <BE_Company> GetCompanyGeneral(BECompanyFilter _bECompanyFilter)
        {
            BE_Company                  _BeCompany  = null;
            List <BE_Company>           _lstCompany = new List <BE_Company>();
            Dictionary <string, object> parameters  = new Dictionary <string, object>();

            parameters.Add("_companyCode", _bECompanyFilter.companyCode);//Eliminar en la proxima version
            parameters.Add("_companyTypeList", _bECompanyFilter.CompanyTypeList);
            parameters.Add("_searchFilter", (string.IsNullOrEmpty(_bECompanyFilter.SearchFilter))?"": _bECompanyFilter.SearchFilter);
            parameters.Add("_companyRuc", _bECompanyFilter.companyRUC);
            parameters.Add("_userName", _bECompanyFilter.userName);
            var rows = _database.QuerySP("sps_getCompanyGeneral", parameters);


            foreach (var row in rows)

            {
                _BeCompany              = new BE_Company();
                _BeCompany.companyCode  = row["CompanyCode"];
                _BeCompany.companyLimit = string.IsNullOrEmpty(row["CompanyLimit"]) ? 0 : decimal.Parse(row["CompanyLimit"]);
                _BeCompany.companyName  = row["CompanyName"];
                _BeCompany.companyRUC   = row["CompanyRUC"];
                _BeCompany.companySys   = row["CompanySys"];
                _BeCompany.isEnabled    = string.IsNullOrEmpty(row["IsEnabled"]) ? false : row["IsEnabled"].Equals("1") ? true : false;
                _BeCompany.companyType  = row["companyType"];
                _BeCompany.districtId   = row["districtId"];
                _BeCompany.quantityAuth = row["quantityAuth"];
                _lstCompany.Add(_BeCompany);
            }
            return(_lstCompany);
        }
Esempio n. 2
0
        public BE_Json GetCompanyGeneral([FromBody] BECompanyFilter _bECompanyFilter)
        {
            BE_Json objJson     = null;
            var     objListaAux = string.Empty;

            try
            {
                BL_Company _blCompany = new BL_Company();
                _blCompany.connectionString = AppConfig.DbConnection;
                objListaAux = JsonConvert.SerializeObject(_blCompany.GetCompanyGeneral(_bECompanyFilter));

                objJson        = new BE_Json();
                objJson.data   = objListaAux;
                objJson.status = CManager.RESULTADO_WCF.OK;
            }
            catch (Exception ex)
            {
                objJson        = new BE_Json();
                objJson.data   = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
                objJson.status = CManager.RESULTADO_WCF.ERROR;
                objJson.status = CManager.RESULTADO_WCF.ERROR;
            }
            finally
            {
                objListaAux = null;
            }
            return(objJson);
        }
Esempio n. 3
0
 public List <BE_Company> GetCompanyGeneral(BECompanyFilter _bECompanyFilter)
 {
     _database = new MySQLDatabase(connectionString);
     return(new DA_Company(_database).GetCompanyGeneral(_bECompanyFilter));
 }