/// <summary>
/// To fetch edtails
/// </summary>
/// <returns></returns>
public CropDiameterList GetCropDiameter()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SELECTCROPDIAMTR";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropDiameterBO objCropDiameter = null;
CropDiameterList CropDiameterList = new CropDiameterList();
while (dr.Read())
{
objCropDiameter = new CropDiameterBO();
objCropDiameter.CROPDIAMETERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDIAMETERID")));
objCropDiameter.CROPDIAMETER = dr.GetString(dr.GetOrdinal("CROPDIAMETER"));
objCropDiameter.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
CropDiameterList.Add(objCropDiameter);
}
dr.Close();
return(CropDiameterList);
}
/// <summary>
/// get details by ID
/// </summary>
/// <param name="CROPDIAMETERID"></param>
/// <returns></returns>
public CropDiameterBO GetCropDiameterById(int CROPDIAMETERID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETSECTCROPDIAMETRID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CROPDIAMETERID_", CROPDIAMETERID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropDiameterBO CropDiameterObj = null;
CropDiameterList CropDiameterList = new CropDiameterList();
CropDiameterObj = new CropDiameterBO();
while (dr.Read())
{
if (ColumnExists(dr, "CROPDIAMETER") && !dr.IsDBNull(dr.GetOrdinal("CROPDIAMETER")))
{
CropDiameterObj.CROPDIAMETER = dr.GetString(dr.GetOrdinal("CROPDIAMETER"));
}
if (ColumnExists(dr, "CROPDIAMETERID") && !dr.IsDBNull(dr.GetOrdinal("CROPDIAMETERID")))
{
CropDiameterObj.CROPDIAMETERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPDIAMETERID")));
}
if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
CropDiameterObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(CropDiameterObj);
}
