public static List <ResultTaxpayer> SearchTaxpayer(int documentTypeId, string documentNumber, string name, string iibb, int personTypeId, int societyTypeId) { List <ResultTaxpayer> result = new List <ResultTaxpayer>(); DataSet ds = db.ExecuteDataSet("spTaxpayerSearch", name); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { //TODO: Falta hacer control de cantidad de resultados y paginacion ResultTaxpayer res = new ResultTaxpayer(); res.CUIT = dr["CUIT"].ToString(); res.TaxpayerName = dr["TaxpayerName"].ToString(); res.Name = dr["Name"].ToString(); res.NameType = dr["NameType"].ToString(); res.DocumentType = dr["DocumentType"].ToString(); res.Document = dr["DocumentNumber"].ToString(); //res.Action = "<a href=\"~/MemberPages/Contribuyente.aspx?solapa=contrib&id=" + dr["Id"].ToString() + "\">ver mas...</a>"; res.Action = "Contribuyente.aspx?solapa=contrib&id=" + dr["Id"].ToString(); result.Add(res); } } return(result); }
public static List <ResultTaxpayer> SearchTaxpayer() { List <ResultTaxpayer> result = new List <ResultTaxpayer>(); ResultTaxpayer res1 = new ResultTaxpayer(); res1.CUIT = "30-25252525-3"; res1.TaxpayerName = "Nombre Empresa 1"; res1.Name = "Carolina Directora"; res1.NameType = "Director"; res1.PersonType = "PJ"; res1.IIBB = "1111"; res1.DocumentType = "DNI"; res1.Document = "25252525"; res1.Action = "<a href=\"~/MemberPages/Contribuyente.aspx?solapa=contrib&id=1\">ver mas...</a>"; result.Add(res1); ResultTaxpayer res2 = new ResultTaxpayer(); res2.CUIT = "20-28282828-3"; res2.TaxpayerName = "Carolina Contribuyente"; res2.Name = "Carolina Contribuyente"; res2.NameType = "Contribuyente"; res2.PersonType = "PF"; res2.IIBB = "222222"; res2.DocumentType = "DNI"; res2.Document = "28282828"; res2.Action = "<a href=\"~/MemberPages/Contribuyente.aspx?solapa=contrib&id=2\">ver mas...</a>"; result.Add(res2); ResultTaxpayer res3 = new ResultTaxpayer(); res3.CUIT = "33-22222222-3"; res3.TaxpayerName = "Nombre Empresa 3"; res3.Name = "Carolina Socio 1"; res3.NameType = "Socio"; res3.PersonType = "PJ"; res3.IIBB = "3333"; res3.DocumentType = "DNI"; res3.Document = "22222222"; res3.Action = "<a href=\"~/MemberPages/Contribuyente.aspx?solapa=contrib&id=3\">ver mas...</a>"; result.Add(res3); ResultTaxpayer res4 = new ResultTaxpayer(); res4.CUIT = "22-27272727-3"; res4.TaxpayerName = "Nombre Empresa 4"; res4.Name = "Carolina Esposa"; res4.NameType = "Esposa"; res4.PersonType = "PF"; res4.IIBB = "44444"; res4.DocumentType = "DNI"; res4.Document = "27272727"; res4.Action = "<a href=\"~/MemberPages/Contribuyente.aspx?solapa=contrib&id=4\">ver mas...</a>"; result.Add(res4); /*DataSet ds = new DataSet(); * DataTable dt = new DataTable(); * dt.Columns.Add("CUIT"); * dt.Columns.Add("Name"); * dt.Columns.Add("NameType"); * dt.Columns.Add("PersonType"); * dt.Columns.Add("IIBB"); * DataRow dr1 = dt.NewRow(); * dr1.ItemArray = new string[] { "CUIT", "Name", "NameType", "PersonType", "IIBB" }; * dt.Rows.Add(dr1); * ds.Tables.Add(dt);*/ return(result); }