public LedorVadorResponse SendPackages(LedorVadorRequest request) {
LedorVadorResponse response = new LedorVadorResponse();
int aceptados = 0, omitidos = 0;
string warningMsg = "", exceptionMsg = "";
//
DbHandler db = new DbHandler(ConfigurationManager.ConnectionStrings["db"].ConnectionString);
request.login = ConfigurationManager.AppSettings.Get("LOGIN");
request.password = ConfigurationManager.AppSettings.Get("PASS");
db.Using(request.login, request.password, (SqlConnection conn) => {
//
foreach (LedorVadorFlowPackage package in request.packages) {
try {
logger.write("Leyendo documento " + package.documento_externId + " cliente " + package.histClinica + " " + package.razonSocial);
string localWarningMsg = "";
localWarningMsg = CheckPackage(package);
if (localWarningMsg == "") { //Si se genero un mensaje de warning se omite directamente el paquete.
localWarningMsg = savePackage(db, conn, package);
if (localWarningMsg == "") {
try {
response.documentosAceptados.Add(Int32.Parse(package.documento_externId));
} catch (Exception e) {
localWarningMsg = "[" + e.Message + "]";
}
}
}
warningMsg += localWarningMsg;
aceptados++;
} catch (Exception e) {
try {
response.documentosOmitidos.Add(Int32.Parse(package.documento_externId));
} catch (Exception ex) {
warningMsg += "[" + ex.Message + "]";
}
logger.write(e.ToString());
exceptionMsg += Environment.NewLine + e.ToString().Substring(0, 300);
omitidos++;
}
}
//
}, (string exMessage) => {
exceptionMsg += Environment.NewLine + exMessage.Substring(0, 300);
});
//
response.responseMessage = " Aceptados [" + aceptados + "]";
response.responseMessage += " Omitidos [" + omitidos + "]";
if (warningMsg != "") {
response.responseMessage += " Warning [" + warningMsg + "]";
}
if (exceptionMsg != "") {
response.responseMessage += Environment.NewLine + " ServerExceptions [" + exceptionMsg + "]";
}
return response;
}
private string savePackage(DbHandler db, SqlConnection conn, LedorVadorFlowPackage package) {
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;
});
return "";
}