/// <summary>
/// To fetch details
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public CropsList GetCrops(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropsBO Cropsobj = null;
CropsList Listobj = new CropsList();
while (dr.Read())
{
Cropsobj = new CropsBO();
Cropsobj.PAP_CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_cropid")));
if (!dr.IsDBNull(dr.GetOrdinal("cropname")))
{
Cropsobj.Cropname = dr.GetString(dr.GetOrdinal("cropname"));
}
if (!dr.IsDBNull(dr.GetOrdinal("croptype")))
{
Cropsobj.Croptype = dr.GetString(dr.GetOrdinal("croptype"));
}
if (!dr.IsDBNull(dr.GetOrdinal("cropdescription")))
{
Cropsobj.Cropdescription = dr.GetString(dr.GetOrdinal("cropdescription"));
}
if (!dr.IsDBNull(dr.GetOrdinal("unitname")))
{
Cropsobj.UnitName = dr.GetString(dr.GetOrdinal("unitname"));
}
if (!dr.IsDBNull(dr.GetOrdinal("quantity")))
{
Cropsobj.QUANTITY = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("quantity")));
}
if (!dr.IsDBNull(dr.GetOrdinal("croprate")))
{
Cropsobj.CROPRATE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("croprate")));
}
Listobj.Add(Cropsobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// To fetch details
/// </summary>
/// <param name="CropId"></param>
/// <returns></returns>
public CropsBO GetData(int CropId)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("c_pap_cropid", CropId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropsBO Cropsobj = null;
CropsList Listobj = new CropsList();
Cropsobj = new CropsBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("pap_cropid")))
{
Cropsobj.PAP_CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_cropid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPID")))
{
Cropsobj.CROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPTYPEID")))
{
Cropsobj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPDESCRIPTIONID")))
{
Cropsobj.CROPDESCRIPTIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDESCRIPTIONID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("UNITOFMEASURE")))
{
Cropsobj.UNITOFMEASURE = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("UNITOFMEASURE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("QUANTITY")))
{
Cropsobj.QUANTITY = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("QUANTITY")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CROPRATE")))
{
Cropsobj.CROPRATE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CROPRATE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("COMMENTS")))
{
Cropsobj.COMMENTS = dr.GetString(dr.GetOrdinal("COMMENTS"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
Cropsobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(Cropsobj);
}
