/// <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;
}
