public PresentacionSaved SetPresentacion(PresentacionNew model, PresentacionSaved modelSaved)
{
var query = "";
try
{
var c = new Connection();
query = "UPDATE Autorizaciones ";
query += " SET PresentacionId = " + modelSaved.Id;
query += " WHERE estado_autorizacion = 'Autorizada'";
query += " AND ncodosoc = " + model.CmsOsId;
query += " AND IDPre = " + model.Matricula;
query += " AND dfec_autorizacion > TO_DATE('" + model.Desde + "', 'DD / MM / YYYY')";
query += " AND dfec_autorizacion <= TO_DATE('" + model.Hasta + "', 'DD / MM / YYYY HH24: MI')";
query += " AND presentacionId IS NULL";
c.QueryNoResult(query);
}
catch (Exception ex)
{
modelSaved.SetError(GetType().Name, GetMethod.ErrorLine(ex), ex.Message, ex.InnerException?.ToString() ?? "", model, query);
}
return(modelSaved);
}
public int GetAuthCount(PresentacionNew model)
{
var query = "";
try
{
query = "SELECT COUNT(*) FROM Autorizaciones WHERE estado_autorizacion = 'Autorizada'";
query += " AND ncodosoc = " + model.CmsOsId;
query += " AND IDPre = " + model.Matricula;
query += " AND dfec_autorizacion > TO_DATE('" + model.Desde + "', 'DD/MM/YYYY')";
query += " AND dfec_autorizacion <= TO_DATE('" + model.Hasta + " 23:58', 'DD/MM/YYYY HH24:MI')";
query += " AND presentacionId IS NULL";
var c = new Connection();
var obj = c.QueryObject(query);
return(Convert.IsDBNull(obj) ? 0 : Convert.ToInt32(obj));
}
catch (Exception ex)
{
var errores = new Errores();
errores.SetError(GetType().Name, GetMethod.ErrorLine(ex), ex.Message, ex.InnerException?.ToString() ?? "", model, query);
return(0);
}
}
