public String GetDescr(String Clave)
{
try
{
using (OleDbConnection connection = new OleDbConnection(DbConnString))
{
DatosSat db = new DatosSat();
OleDbDataAdapter adaptador = new OleDbDataAdapter("Select * from c_UsoCFDI where clave='" + Clave + "'", connection);
adaptador.Fill(db, "c_UsoCFDI");
var codigosPostales = from cp in db.c_UsoCFDI select cp;
return(codigosPostales.First().Descripción);
}
}
catch (Exception ex)
{
_mensajeErrorSistema = ex.Message;
GrabarLogError(ex);
return(null);
}
}
public List <uFacturaEDatos.DatosSat.c_FormaPagoRow> GetFormaPago()
{
try
{
using (OleDbConnection connection = new OleDbConnection(DbConnString))
{
DatosSat db = new DatosSat();
OleDbDataAdapter adaptador = new OleDbDataAdapter("Select * from c_FormaPago", connection);
adaptador.Fill(db, "c_FormaPago");
var codigosPostales = from cp in db.c_FormaPago select cp;
return(codigosPostales.ToList());
}
}
catch (Exception ex)
{
_mensajeErrorSistema = ex.Message;
GrabarLogError(ex);
return(new List <uFacturaEDatos.DatosSat.c_FormaPagoRow>());
}
}
public string GetUsoCFDI()
{
try
{
DataTable dt = new DataTable();
DatosSat.c_UsoCFDIDataTable f = new DatosSat.c_UsoCFDIDataTable();
using (OleDbConnection connection = new OleDbConnection(DbConnString))
{
DatosSat db = new DatosSat();
OleDbDataAdapter adaptador = new OleDbDataAdapter("Select * from c_UsoCFDI", connection);
adaptador.Fill(db, "c_UsoCFDI");
var codigosPostales = from cp in db.c_UsoCFDI select cp;
dt = codigosPostales.CopyToDataTable();
var list = new List <Dictionary <string, object> >();
foreach (DataRow row in dt.Rows)
{
var dict = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
dict[col.ColumnName] = (Convert.ToString(row[col]));
}
list.Add(dict);
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
return(serializer.Serialize(list));
}
}
catch (Exception ex)
{
_mensajeErrorSistema = ex.Message;
GrabarLogError(ex);
return(ex.Message);
}
}
public String Regimen(String clave)
{
String strrg;
try
{
using (OleDbConnection connection = new OleDbConnection(DbConnString))
{
DatosSat db = new DatosSat();
OleDbDataAdapter adaptador = new OleDbDataAdapter("Select * from c_RegimenFiscal where clave=" + clave, connection);
adaptador.Fill(db, "c_RegimenFiscal");
var codigosPostales = from cp in db.c_RegimenFiscal select cp;
return(codigosPostales.First().Descripción);
}
}
catch (Exception ex)
{
_mensajeErrorSistema = ex.Message;
GrabarLogError(ex);
return(null);
}
}
