private string savePackage(DbHandler db, SqlConnection conn, LedorVadorFlowPackage package)
{
try {
DataSet ds = db.Call("MIG_DocumentoFromQTECH_sp", conn, (SqlDataAdapter da) => {
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@HistClinica", DbType.Int32).Value = package.histClinica;
da.SelectCommand.Parameters.AddWithValue("@RazonSocial", DbType.String).Value = package.razonSocial;
da.SelectCommand.Parameters.AddWithValue("@EmpresaID_Propia", DbType.Int32).Value = package.empresaPropia;
da.SelectCommand.Parameters.AddWithValue("@Documento_ExternID", DbType.String).Value = package.documento_externId;
da.SelectCommand.Parameters.AddWithValue("@Establecimiento_Numero", DbType.String).Value = package.establecimiento_numero;
da.SelectCommand.Parameters.AddWithValue("@Documento_Numero", DbType.String).Value = package.documento_numero;
da.SelectCommand.Parameters.AddWithValue("@Fecha", DbType.DateTime).Value = package.fecha;
da.SelectCommand.Parameters.AddWithValue("@Observacion", DbType.String).Value = package.observacion;
da.SelectCommand.Parameters.AddWithValue("@TipoServicioID", DbType.Int32).Value = package.tipoServicioId;
da.SelectCommand.Parameters.AddWithValue("@TipoImpuestoID_IVA", DbType.Int32).Value = package.tipoImpuestoId_Iva;
da.SelectCommand.Parameters.AddWithValue("@Cantidad", DbType.Decimal).Value = package.cantidad;
da.SelectCommand.Parameters.AddWithValue("@ImporteUnitario", DbType.Double).Value = package.importeUnitario;
});
try {
string posibleError = ds.Tables[0].Rows[0].ToString();
return(posibleError);
} catch (Exception) {
return("");
}
} catch (Exception e) {
return(e.Message);
}
}
private string CheckPackage(LedorVadorFlowPackage package)
{
string msg = "";
if (package.histClinica.ToString().Length < 2)
{
msg += "-histClinica";
}
if (package.establecimiento_numero == "")
{
msg += "-establecimiento_numero";
}
if (package.documento_numero == "")
{
msg += "-documento_numero";
}
if (package.razonSocial == "")
{
msg += "-razonSocial";
}
if (package.documento_externId == "")
{
msg += "-documento_externId";
}
//
string id = " | " +
((package.documento_externId == null || package.documento_externId == "") ? "unknow"
: package.documento_externId);
//
if (msg != "")
{
return(id + " requerido-> " + msg);
}
return("");
}
private string CheckPackage(LedorVadorFlowPackage package) {
string msg = "";
if (package.histClinica.ToString().Length < 2) msg += "-histClinica";
if (package.establecimiento_numero == "") msg += "-establecimiento_numero";
if (package.documento_numero == "") msg += "-documento_numero";
if (package.razonSocial == "") msg += "-razonSocial";
if (package.documento_externId == "") msg += "-documento_externId";
//
string id = " | " +
((package.documento_externId == null || package.documento_externId == "") ? "unknow"
: package.documento_externId);
//
if (msg != "") {
return id + " requerido-> " + msg;
}
return "";
}
private string savePackage(DbHandler db, SqlConnection conn, LedorVadorFlowPackage package) {
try {
DataSet ds = db.Call("MIG_DocumentoFromQTECH_sp", conn, (SqlDataAdapter da) => {
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@HistClinica", DbType.Int32).Value = package.histClinica;
da.SelectCommand.Parameters.AddWithValue("@RazonSocial", DbType.String).Value = package.razonSocial;
da.SelectCommand.Parameters.AddWithValue("@EmpresaID_Propia", DbType.Int32).Value = package.empresaPropia;
da.SelectCommand.Parameters.AddWithValue("@Documento_ExternID", DbType.String).Value = package.documento_externId;
da.SelectCommand.Parameters.AddWithValue("@Establecimiento_Numero", DbType.String).Value = package.establecimiento_numero;
da.SelectCommand.Parameters.AddWithValue("@Documento_Numero", DbType.String).Value = package.documento_numero;
da.SelectCommand.Parameters.AddWithValue("@Fecha", DbType.DateTime).Value = package.fecha;
da.SelectCommand.Parameters.AddWithValue("@Observacion", DbType.String).Value = package.observacion;
da.SelectCommand.Parameters.AddWithValue("@TipoServicioID", DbType.Int32).Value = package.tipoServicioId;
da.SelectCommand.Parameters.AddWithValue("@TipoImpuestoID_IVA", DbType.Int32).Value = package.tipoImpuestoId_Iva;
da.SelectCommand.Parameters.AddWithValue("@Cantidad", DbType.Decimal).Value = package.cantidad;
da.SelectCommand.Parameters.AddWithValue("@ImporteUnitario", DbType.Double).Value = package.importeUnitario;
});
try {
string posibleError = ds.Tables[0].Rows[0].ToString();
return posibleError;
} catch (Exception) {
return "";
}
} catch (Exception e) {
return e.Message;
}
}
