/// <summary> /// Get ALL CopMechanism /// </summary> /// <returns></returns> public CopMechanismList GetALLCopMechanism()//(CopMechanism oCopMechanism) { proc = "USP_MST_GETALLCOP_MECHANISM"; cnn = new OracleConnection(con); CopMechanismBO objCopMechanism = null; CopMechanismList lstCopMechanismList = new CopMechanismList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objCopMechanism = new CopMechanismBO(); if (ColumnExists(dr, "cop_mechanismid") && !dr.IsDBNull(dr.GetOrdinal("cop_mechanismid"))) { objCopMechanism.CopMechanismID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("cop_mechanismid"))); } if (ColumnExists(dr, "cop_mechanism") && !dr.IsDBNull(dr.GetOrdinal("cop_mechanism"))) { objCopMechanism.CopMechanismName = dr.GetString(dr.GetOrdinal("cop_mechanism")); } if (ColumnExists(dr, "isdeleted") && !dr.IsDBNull(dr.GetOrdinal("isdeleted"))) { objCopMechanism.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); } lstCopMechanismList.Add(objCopMechanism); } dr.Close(); } catch (Exception ex) { throw ex; } return(lstCopMechanismList); }
//To get coping mechanism from the table MST_COPING_MECHANISM public void Getcopingmechanism() { string COP_MECHANISMID = string.Empty; if (copingmechDropDownList.SelectedValue.ToString() == "") { COP_MECHANISMID = "0"; //msgSaveLabel.Text = null; // if value is select then error msg will display } else { // SHOCKID = typeofshockDropDownList.SelectedValue.ToString(); // get UI screen Value DataSet Ds = new DataSet(); // MajorshockBLL copmech_BLL = new MajorshockBLL(); // Function or object creation for next layer CopMechanismBLL copmech_BLL = new CopMechanismBLL(); //Ds = copmech_BLL.GetCopMech(COP_MECHANISMID); // data pass through object SHOCKID objCopMechanismList = copmech_BLL.GetCopMechanism(); try { //if (Ds.Tables[0].Rows.Count > 0) // Data from BLL if (objCopMechanismList.Count > 0) { copingmechDropDownList.DataSource = objCopMechanismList; //copingmechDropDownList.DataTextField = Ds.Tables[0].Columns[1].ToString(); //copingmechDropDownList.DataValueField = Ds.Tables[0].Columns[0].ToString(); copingmechDropDownList.DataTextField = "CopMechanismName"; copingmechDropDownList.DataValueField = "CopMechanismID"; copingmechDropDownList.DataBind(); // copingmechDropDownList.Items.Insert(0, "--Select--"); } } catch (Exception ee) { throw ee; } finally // set the finally class nothing but Empty the object { copmech_BLL = null; } } }