/// <summary> /// To Get Line Type /// </summary> /// <returns></returns> public TypeOfLineLists GetLineType() { OracleConnection conn = new OracleConnection(connStr); OracleCommand cmd; string proc = " USP_MST_GET_LINETYPE"; cmd = new OracleCommand(proc, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); TypeOfLineLists TypeOfLines = new TypeOfLineLists(); TypeOfLineBO TypeOfLineBOobj = null; while (dr.Read()) { TypeOfLineBOobj = new TypeOfLineBO(); TypeOfLineBOobj.LineTypeId = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LINETYPEID"))); TypeOfLineBOobj.TypeOfLine = dr.GetString(dr.GetOrdinal("TYPEOFLINE")); TypeOfLineBOobj.Rightofwaymeasurement = dr.GetString(dr.GetOrdinal("RIGHTOFWAYMEASUREMENT")); TypeOfLineBOobj.Wayleavemeasurement = dr.GetString(dr.GetOrdinal("WAYLEAVEMEASUREMENT")); TypeOfLineBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); TypeOfLines.Add(TypeOfLineBOobj); } dr.Close(); return(TypeOfLines); }
/// <summary> /// To assign values to TypeLineDropdownList /// </summary> private void LoadTypeLine()//(object sender, EventArgs e) { TypeOfLineBLL oTypeOfLineBLL = new TypeOfLineBLL(); TypeOfLineLists TypeLineList = new TypeOfLineLists(); ddlTypeLine.Items.Clear(); TypeLineList = oTypeOfLineBLL.GetLineType(); ddlTypeLine.DataTextField = "TYPEOFLINE"; ddlTypeLine.DataValueField = "LINETYPEID"; ddlTypeLine.DataSource = TypeLineList; ddlTypeLine.DataBind(); ddlTypeLine.Items.Insert(0, new ListItem("--Select--", "0")); ddlTypeLine.SelectedIndex = 0; }