/// <summary> /// To Get LOCATION Classification /// </summary> /// <returns></returns> public LocationClassificationList GetLOCATIONClassification() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_LOCATIONCLS"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LocationClassificationBO BOobj = null; LocationClassificationList objlocation = new LocationClassificationList(); while (dr.Read()) { BOobj = new LocationClassificationBO(); BOobj.LOCTNCLASFCTNID = dr.GetInt32(dr.GetOrdinal("LOCTNCLASFCTNID")); BOobj.LOCTNCLASFCTNNAME = dr.GetString(dr.GetOrdinal("LOCTNCLASFCTNNAME")); BOobj.LOCTNCODE = dr.GetString(dr.GetOrdinal("LOCTNCODE")); BOobj.ISDELETED = dr.GetString(dr.GetOrdinal("isdeleted")); objlocation.Add(BOobj); } dr.Close(); return(objlocation); }
/// <summary> /// SET DATA TO Dropdown ddlLocClassification /// </summary> private void BindLocationClassification() { LocationClassificationList ObjLoc = (new LocationClassificationBLL().GetLOCATIONClassification()); ddlLocClassification.DataSource = ObjLoc; ddlLocClassification.DataTextField = "LOCTNCLASFCTNNAME"; ddlLocClassification.DataValueField = "LOCTNCODE"; ddlLocClassification.DataBind(); }
/// <summary> /// To Get Location Classification ID /// </summary> /// <param name="LOCTNCLASFCTNID"></param> /// <returns></returns> public LocationClassificationBO GetLOCTNCLASFCTNID(int LOCTNCLASFCTNID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_LOCATION"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("LOCTNCLASFCTNID_", LOCTNCLASFCTNID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LocationClassificationBO BOobj = null; LocationClassificationList listobj = new LocationClassificationList(); BOobj = new LocationClassificationBO(); while (dr.Read()) { if (ColumnExists(dr, "LOCTNCLASFCTNNAME") && !dr.IsDBNull(dr.GetOrdinal("LOCTNCLASFCTNNAME"))) { BOobj.LOCTNCLASFCTNNAME = dr.GetString(dr.GetOrdinal("LOCTNCLASFCTNNAME")); } if (ColumnExists(dr, "LOCTNCODE") && !dr.IsDBNull(dr.GetOrdinal("LOCTNCODE"))) { BOobj.LOCTNCODE = dr.GetString(dr.GetOrdinal("LOCTNCODE")); } if (ColumnExists(dr, "LOCTNCLASFCTNID") && !dr.IsDBNull(dr.GetOrdinal("LOCTNCLASFCTNID"))) { BOobj.LOCTNCLASFCTNID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LOCTNCLASFCTNID"))); } } dr.Close(); return(BOobj); }