public Fmto2AlterxCausaProblemaEspec_E obtenerCodigoAlternativas(int idCultivoCri)
{
Fmto2AlterxCausaProblemaEspec_E fmt2AlterCausaProb_E = new Fmto2AlterxCausaProblemaEspec_E();
try
{
using (cmd = new SqlCommand("SP_OBTENER_CODIGOALTERCAUSAPROB", cnx.CONSel))
{
cnx.CONSel.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDCULTIVOCRIANZA", idCultivoCri);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Fmto2AlterxCausaProblemaEspec_E fmt2AlterCausaProb = new Fmto2AlterxCausaProblemaEspec_E();
fmt2AlterCausaProb.codAlternativa = Convert.ToString(dr["Cod. Alternativa"]);
fmt2AlterCausaProb_E = fmt2AlterCausaProb;
}
}
}
catch (Exception ex)
{
ut.logsave(this, ex);
Debug.WriteLine("Error al obtener alternativa: " + ex.Message.ToString() + ex.StackTrace.ToString());
}
finally
{
cnx.CONSel.Close();
}
return(fmt2AlterCausaProb_E);
}
public List <Fmto2AlterxCausaProblemaEspec_E> listarAlternativas(int idCultCria)
{
List <Fmto2AlterxCausaProblemaEspec_E> listafmt2AlterCausaProb_E = new List <Fmto2AlterxCausaProblemaEspec_E>();
try
{
using (cmd = new SqlCommand("SP_LISTAR_ALTERCAUSAPROB", cnx.CONSel))
{
cnx.CONSel.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IDCULTIVOCRIANZA", idCultCria);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Fmto2AlterxCausaProblemaEspec_E fmt2AlterCausaProb = new Fmto2AlterxCausaProblemaEspec_E();
fmt2AlterCausaProb.nro = Convert.ToInt32(dr["NRO"]);
fmt2AlterCausaProb.idAlternativaxCausaProblemaEspec = Convert.ToInt32(dr["ID"]);
fmt2AlterCausaProb.idCultivoCrianza = Convert.ToInt32(dr["ID CULTIVO"]);
fmt2AlterCausaProb.idCausaxProblema = Convert.ToInt32(dr["ID CAUSA PROB"]);
fmt2AlterCausaProb.codCausaProb = Convert.ToString(dr["CODIGO CAUSA"]);
fmt2AlterCausaProb.codAlternativa = Convert.ToString(dr["CODIGO ALTERN."]);
fmt2AlterCausaProb.descripAlternativa = Convert.ToString(dr["ALTERNATIVA"]);
fmt2AlterCausaProb.completado = Convert.ToBoolean(dr["COMPLETADO"]);
fmt2AlterCausaProb.activo = Convert.ToBoolean(dr["ACTIVO"]);
listafmt2AlterCausaProb_E.Add(fmt2AlterCausaProb);
}
}
}
catch (Exception ex)
{
ut.logsave(this, ex);
Debug.WriteLine("Error al listar alternativa: " + ex.Message.ToString() + ex.StackTrace.ToString());
}
finally
{
cnx.CONSel.Close();
}
return(listafmt2AlterCausaProb_E);
}
public string modificar(Fmto2AlterxCausaProblemaEspec_E objAlterCausa)
{
return(alterCausaProb_D.modificar(objAlterCausa));
}
public string eliminar(Fmto2AlterxCausaProblemaEspec_E objAlterCausa)
{
return(alterCausaProb_D.eliminar(objAlterCausa));
}
public string agregar(Fmto2AlterxCausaProblemaEspec_E objAlterCausa)
{
return(alterCausaProb_D.agregar(objAlterCausa));
}
