private void Fill(out Banco oObj, NullableDataReader dr)
{
oObj = new Banco(dr.GetInt16("id_Banco"),
dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion"),
dr.GetBoolean("frecuente"),
dr.GetNullableString("webSite") == null ?"":dr.GetString("webSite")
);
}
private void Fill(out Pais oObj, NullableDataReader dr)
{
oObj = new Pais(dr.GetInt16("codigoPais"),
dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion"),
dr.GetNullableString("gentilicio") == null ? "" : dr.GetString("gentilicio"),
dr.GetBoolean("tieneConvenio"),
dr.GetBoolean("mercosur")
);
}
private void Fill(out Devolucion oObj, NullableDataReader dr)
{
oObj = new Devolucion(dr.GetDateTime("fechaMovimiento"),
dr.GetNullableString("destino") == null ? "" : dr.GetString("destino"),
dr.GetNullableString("Observaciones") == null?"":dr.GetString("Observaciones"),
dr.GetNullableString("Certificado") == null ? "" : dr.GetString("Certificado"),
this.TraeFaltanteDevolucionXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaMovimiento").ToShortDateString()),
dr.GetNullableDateTime("fechaNotificacion"),
dr.GetNullableDateTime("fechaPresentacion")
);
}
public static List <EstadoReclamo> Traer_Proximos(int idEstado)
{
string sql = "EstadoReclamo_Proximo";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
DbParameterCollection dbParametros = null;
db.AddInParameter(dbCommand, "@idEstado", DbType.Int32, idEstado);
List <EstadoReclamo> ListEstado = new List <EstadoReclamo>();
EstadoReclamo oEst = null;
try
{
dbParametros = dbCommand.Parameters;
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
oEst = new EstadoReclamo();
oEst.DescEstado = ds["DescEstado"].ToString();
oEst.IdEstado = int.Parse(ds["IdEstado"].ToString());
oEst.Control = ds.GetNullableString("Control");
oEst.ControlTexto = ds.GetNullableString("ControlTexto");
oEst.ControlIdModelo = ds.GetNullableInt32("ControlIdModelo") == null ? 0 : ds.GetInt32("ControlIdModelo");
oEst.EsFinal = ds.GetNullableBoolean("EsFinal") == null ? false : ds.GetBoolean("EsFinal");
oEst.FecManual = ds.GetNullableBoolean("FecManual") == null ? false : ds.GetBoolean("FecManual");
oEst.MensajeInfo = ds.GetNullableString("MensajeInfo");
oEst.EstadoAnme = ds.GetNullableInt32("EstadoAnme") == null ? 0 : ds.GetInt32("EstadoAnme");
oEst.PaseAutomatico = ds.GetNullableBoolean("PaseAutomatico") == null ? false : ds.GetBoolean("PaseAutomatico");
oEst.TieneObservacion = ds.GetNullableBoolean("TieneObservacion") == null ? false : ds.GetBoolean("TieneObservacion");
ListEstado.Add(oEst);
}
ds.Close();
ds.Dispose();
}
return(ListEstado);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}->Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en EstadoDAO.Trae_Todos", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
private void Fill(out Ingresos oObj, NullableDataReader dr)
{
AuxiliaresDatos oAuxDao = new AuxiliaresDatos();
oObj = new Ingresos(dr.GetNullableByte("idTipoIngreso") == null ? null : oAuxDao.Traer_TipoIngreso(dr.GetByte("idTipoIngreso")),
dr.GetNullableDateTime("fechaIngreso"),
this.TraeIngresadosXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaIngreso")),
dr.GetNullableString("observacion") == null ? "" : dr.GetString("observacion")
);
}
private void Fill(out Movimiento_Solicitud oObj, NullableDataReader dr)
{
Estado iEstado = new Estado(dr.GetInt32("cod_estado"), dr.GetString("descripcionEstado"));
Sector iSector = new Sector(dr.GetInt32("cod_sector"), dr.GetString("descripcionSector"));
oObj = new Movimiento_Solicitud(dr.GetDateTime("fecha_Movimiento")
, iEstado
, iSector
, dr.GetNullableString("observaciones") == null ? "":dr.GetString("observaciones")
);
}
private void Fill(out Documento_Causante oObj, NullableDataReader dr)
{
oObj = new Documento_Causante(dr.GetInt64("id_Beneficiario"),
dr.GetString("numDoc"),
dr.GetInt16("codigoDocumento"),
dr.GetString("abrevDTDoc"),
dr.GetBoolean("docADP"),
dr.GetNullableString("abrevPais") == null ? "" : dr.GetString("abrevPais"),
dr.GetNullableInt16("PaisPK"),
dr.GetDateTime("fechaAlta"),
dr.GetNullableDateTime("fechaBaja")
);
}
private void Fill(out SolicitudesEFechasSolicitud oObj, NullableDataReader dr)
{
oObj = new SolicitudesEFechasSolicitud(
dr.GetInt64("id_Beneficiario")
, dr.GetInt16("codPrestacion")
, dr.GetString("ApeNomCompleto")
, dr.GetNullableString("cuip") == null ? "" : dr.GetString("cuip")
, dr.GetString("DescripcionPrestacion")
, dr.GetInt16("pais_PK")
, dr.GetString("PaisDescCompleto")
, dr.GetBoolean("Mercosur")
, dr.GetString("referencia_exterior")
, dr.GetString("ubicacion_Fisica")
, dr.GetDateTime("fAMSolicitud")
, dr.GetDateTime("fechaIngreso")
);
}
private void Fill(out TipoDocumentacion oObj, NullableDataReader dr)
{
oObj = new TipoDocumentacion(dr.GetInt32("codTipoDocumentacion"),
dr.GetNullableString("descripcion") == null ? "" : dr.GetString("descripcion")
);
}
public WorkTimeEstimateDataSet GetWorkTimeEstimateToPrint(
int appId,
int prjId,
string depCode,
string reportType,
Dictionary <string, string> param)
{
LOGGER.Finest("Entering GetWorkTimeEstimateToPrint");
OracleConnection connection = null;
OracleParameter appIdParam = null;
OracleParameter prjIdParam = null;
OracleParameter depCodeParam = null;
OracleParameter reportTypeParam = null;
OracleParameter prjNumberParam = null;
OracleParameter prjNameParam = null;
OracleParameter weightParam = null;
OracleParameter qtyParam = null;
OracleParameter repDateParam = null;
OracleParameter authorParam = null;
OracleParameter itemsParam = null;
OracleParameter itemsDepParam = null;
NullableDataReader nullableReader = null;
//
//
WorkTimeEstimateDataSet result = new WorkTimeEstimateDataSet();
//
//
OracleCommand cmd = new OracleCommand();
cmd.CommandType = CommandType.StoredProcedure;
try
{
connection = getConnection();
cmd.CommandText = "WB_PCK_REPORTS_WORK.get_work_time_estimate";
cmd.Connection = connection;
appIdParam = SQLUtil.CreateInt32OracleParam("P_APP_ID", cmd, appId, ParameterDirection.Input);
prjIdParam = SQLUtil.CreateInt32OracleParam("p_prj_id", cmd, prjId, ParameterDirection.Input);
depCodeParam = SQLUtil.CreateVarcharOracleParam("p_dep_code", cmd, depCode, ParameterDirection.Input);
reportTypeParam = SQLUtil.CreateVarcharOracleParam("p_report_type", cmd, reportType, ParameterDirection.Input);
prjNumberParam = SQLUtil.CreateVarcharOracleParam("o_prj_number", cmd, null, ParameterDirection.Output);
prjNameParam = SQLUtil.CreateVarcharOracleParam("o_prj_name", cmd, null, ParameterDirection.Output);
weightParam = SQLUtil.CreateInt32OracleParam("o_weight", cmd, null, ParameterDirection.Output);
qtyParam = SQLUtil.CreateInt32OracleParam("o_qty", cmd, null, ParameterDirection.Output);
repDateParam = SQLUtil.CreateDateOracleParam("o_rep_date", cmd, null, ParameterDirection.Output);
authorParam = SQLUtil.CreateVarcharOracleParam("o_author", cmd, null, ParameterDirection.Output);
itemsParam = SQLUtil.CreateCursorOracleParameter("o_items", OracleDbType.RefCursor, cmd);
itemsDepParam = SQLUtil.CreateCursorOracleParameter("o_items_dep", OracleDbType.RefCursor, cmd);
cmd.ExecuteNonQuery();
WorkTimeEstimateDataSet.WorkTimeMainTableRow row = result.WorkTimeMainTable.NewWorkTimeMainTableRow();
row.ID = prjId.ToString();
row.ProjNumber = SQLUtil.GetStringValue(prjNumberParam);
row.ProjName = SQLUtil.GetStringValue(prjNameParam);
row.Weight = SQLUtil.GetDecimalValue(weightParam).HasValue ? SQLUtil.GetDecimalValue(weightParam).ToString() : "---";
row.Qty = SQLUtil.GetDecimalValue(qtyParam).HasValue ? SQLUtil.GetDecimalValue(qtyParam).ToString() : "---";
row.AllWeight = SQLUtil.GetDecimalValue(weightParam).HasValue ? SQLUtil.GetDecimalValue(weightParam).ToString() : "---";
row.ReportDate = SQLUtil.GetDateValue(repDateParam).HasValue ? SQLUtil.GetDateValue(repDateParam).Value.Date.ToShortDateString() : "---";
row.Author = SQLUtil.GetStringValue(authorParam);
result.WorkTimeMainTable.AddWorkTimeMainTableRow(row);
if (!((OracleRefCursor)itemsParam.Value).IsNull)
{
nullableReader = new NullableDataReader(((OracleRefCursor)itemsParam.Value).GetDataReader());
string TYPE = string.Empty;
string name = string.Empty;
string drawing_number = string.Empty;
string activePath = string.Empty;
WorkTimeEstimateDataSet.WorkTimePathRow path = null;
while (nullableReader.Read())
{
string iPath = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_path"));
if (string.IsNullOrEmpty(iPath))
{
continue;
}
WorkTimeEstimateDataSet.WorkTimeItemSimpleRow item = result.WorkTimeItemSimple.NewWorkTimeItemSimpleRow();
item.ID = prjId.ToString();
item.ItemID = nullableReader.GetNullableDecimal("pwei_id").ToString();
item.IsProduct = nullableReader.GetNullableDecimal("pwei_is_product").ToString();
item.ParentID = nullableReader.GetNullableDecimal("pwei_parent_pwei_id").ToString();
TYPE = nullableReader.GetNullableString("pwei_itm_type");
name = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_name"));
drawing_number = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_drawing_number"));
item.DrawingNumber = drawing_number;
item.Qty = nullableReader.GetNullableDecimal("pwei_qty").ToString();
item.QtyPerProj = nullableReader.GetNullableDecimal("pwei_qty_per_prj").ToString();
if (nullableReader.GetNullableString("pwei_product_brand") != null)
{
item.ProductBrand = nullableReader.GetNullableString("pwei_product_brand");
}
else
{
item.ProductBrand = "";
}
string tmp_sizeCut = nullableReader.GetNullableString("pwei_size_cut");
string tmp_addInfo = nullableReader.GetNullableString("pwei_add_info");
item.SizeCut = string.IsNullOrEmpty(tmp_sizeCut) ? "" : ConvertUtil.ConvertToSpecialChars(tmp_sizeCut.Replace("X", " x ").Replace("L=", "L= "));
if (!string.IsNullOrEmpty(tmp_addInfo))
{
item.SizeCut += string.Format("\n{0}", tmp_addInfo);
}
item.SizeCut = ConvertUtil.ConvertToSpecialChars(item.SizeCut);
if (param.ContainsKey("productSize"))
{
if (!item.SizeCut.ToLower().Contains(param["productSize"]))
{
continue;
}
}
// material gatunek
string tempPrName = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_pr_name"));
if (!string.IsNullOrEmpty(tempPrName))
{
item.PrName = tempPrName + "\n" + ConvertUtil.ConvertToSpecialChars(item.ProductBrand);
}
else
{
item.PrName = " " + "\n" + ConvertUtil.ConvertToSpecialChars(item.ProductBrand);
}
if (param.ContainsKey("materialType"))
{
if (!item.PrName.ToLower().Contains(param["materialType"]))
{
continue;
}
}
item.ProgramNumber = ConvertUtil.ConvertToSpecialChars(nullableReader.GetNullableString("pwei_program_number"));
decimal?value = nullableReader.GetNullableDecimal("pwei_ls");
item.LS = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.LS.Equals("0,000"))
{
item.LS = "0";
}
value = nullableReader.GetNullableDecimal("pwei_es");
item.ES = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.ES.Equals("0,000"))
{
item.ES = "0";
}
value = nullableReader.GetNullableDecimal("pwei_bn");
item.BN = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.BN.Equals("0,000"))
{
item.BN = "0";
}
value = nullableReader.GetNullableDecimal("pwei_pt");
item.PT = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.PT.Equals("0,000"))
{
item.PT = "0";
}
value = nullableReader.GetNullableDecimal("pwei_bw");
item.BW = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.BW.Equals("0,000"))
{
item.BW = "0";
}
value = nullableReader.GetNullableDecimal("pwei_bz");
item.BZ = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.BZ.Equals("0,000"))
{
item.BZ = "0";
}
value = nullableReader.GetNullableDecimal("pwei_ph");
item.PH = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.PH.Equals("0,000"))
{
item.PH = "0";
}
value = nullableReader.GetNullableDecimal("pwei_wp");
item.WP = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.WP.Equals("0,000"))
{
item.WP = "0";
}
value = nullableReader.GetNullableDecimal("pwei_rp");
item.RP = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.RP.Equals("0,000"))
{
item.RP = "0";
}
value = nullableReader.GetNullableDecimal("pwei_po");
item.PO = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.PO.Equals("0,000"))
{
item.PO = "0";
}
value = nullableReader.GetNullableDecimal("pwei_mw");
item.MW = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.MW.Equals("0,000"))
{
item.MW = "0";
}
value = nullableReader.GetNullableDecimal("pwei_mc");
item.MC = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.MC.Equals("0,000"))
{
item.MC = "0";
}
value = nullableReader.GetNullableDecimal("pwei_ML");
item.ML = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.ML.Equals("0,000"))
{
item.ML = "0";
}
value = nullableReader.GetNullableDecimal("pwei_KO");
item.KO = value.HasValue ? string.Format("{0:f2}", value.Value) : "";
if (item.KO.Equals("0,000"))
{
item.KO = "0";
}
item.PlanNumber = nullableReader.GetNullableDecimal("pwei_lp").HasValue ?
nullableReader.GetNullableDecimal("pwei_lp").Value.ToString() : "";
if (param.ContainsKey("planNo"))
{
if (!(item.PlanNumber.ToLower() == param["planNo"].ToLower()))
{
continue;
}
}
item.WorkTimeMainTableRow = row;
result.WorkTimeItemSimple.AddWorkTimeItemSimpleRow(item);
}
}
}
catch (Exception ex)
{
LOGGER.Error("Problem occured while GetWorkTimeEstimateToPrint!" + ex.Message, ex);
throw new Exception("Problem occured while GetWorkTimeEstimateToPrint!" + ex.Message, ex);
}
finally
{
SQLUtil.Close(appIdParam);
SQLUtil.Close(prjIdParam);
SQLUtil.Close(depCodeParam);
SQLUtil.Close(reportTypeParam);
SQLUtil.Close(prjNumberParam);
SQLUtil.Close(prjNameParam);
SQLUtil.Close(weightParam);
SQLUtil.Close(qtyParam);
SQLUtil.Close(repDateParam);
SQLUtil.Close(authorParam);
SQLUtil.Close(itemsParam);
SQLUtil.Close(itemsDepParam);
SQLUtil.Close(nullableReader);
SQLUtil.Close(cmd);
ReleaseConnection(connection);
}
return(result);
}
