/// <summary>
/// To get details from database
/// </summary>
/// <returns></returns>
public object GetAllCropDetails()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ALLCROPTYPES";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropTypeBO CropTypeBOObj = new CropTypeBO();
CropTypeList CropTypeListObj = new CropTypeList();
CropTypeBOObj = new CropTypeBO();
while (dr.Read())
{
CropTypeBOObj = new CropTypeBO();
CropTypeBOObj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID")));
CropTypeBOObj.CropType = dr.GetString(dr.GetOrdinal("CROPTYPE"));
//CropTypeBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME"));
CropTypeBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
CropTypeListObj.Add(CropTypeBOObj);
}
dr.Close();
return(CropTypeListObj);
}
/// <summary>
/// To get details by ID
/// </summary>
/// <param name="CROPTYPEID"></param>
/// <returns></returns>
public CropTypeBO GetCropTypeById(int CROPTYPEID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SEL_CROPTYPE ";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("C_CROPTYPEID", CROPTYPEID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CropTypeBO CropTypeBOObj = null;
CropTypeList CropTypeListObj = new CropTypeList();
CropTypeBOObj = new CropTypeBO();
while (dr.Read())
{
if (ColumnExists(dr, "CROPTYPEID") && !dr.IsDBNull(dr.GetOrdinal("CROPTYPEID")))
{
CropTypeBOObj.CROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CROPTYPEID")));
}
if (ColumnExists(dr, "CROPTYPE") && !dr.IsDBNull(dr.GetOrdinal("CROPTYPE")))
{
CropTypeBOObj.CropType = dr.GetString(dr.GetOrdinal("CROPTYPE"));
}
//if (ColumnExists(dr, "UNITNAME") && !dr.IsDBNull(dr.GetOrdinal("UNITNAME")))
// CropTypeBOObj.UnitName = dr.GetString(dr.GetOrdinal("UNITNAME"));
if (ColumnExists(dr, "ISDELETED") && !dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
CropTypeBOObj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(CropTypeBOObj);
}
