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); }
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); }
public List <BE_Company> GetCompanyGeneral(BECompanyFilter _bECompanyFilter) { _database = new MySQLDatabase(connectionString); return(new DA_Company(_database).GetCompanyGeneral(_bECompanyFilter)); }