/// <summary>
/// Created By : Satish Verma
/// Created Date : 1-Dec-2014
/// Purpose : To get Trading Type
/// </summary>
/// <param name="objForgotPasswordBO"></param>
/// <returns></returns>
public DataTable GetTradingType(TradingTypeBO objTradingTypeBO)
{
DataTable objDataTable = new DataTable();
try
{
sqlConnection.Open();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "Sp_GetTradingType";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@ParentId", objTradingTypeBO.ParentId);
sqlDataAdapter = new SqlDataAdapter(sqlCommand);
sqlDataAdapter.Fill(objDataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlDataAdapter.Dispose();
sqlCommand.Dispose();
sqlConnection.Close();
sqlConnection.Dispose();
}
return(objDataTable);
}
public List <TradingTypeBO> GetTradingType(string ParentId)
{
List <TradingTypeBO> lstTradingTypeBO = new List <TradingTypeBO>();
try
{
TradingTypeBO objTradingTypeBO = new TradingTypeBO();
Int32? Id = null;
if (!(ParentId.ToUpper() == "NULL"))
{
Id = Convert.ToInt32(ParentId);
}
objTradingTypeBO.ParentId = Id;
lstTradingTypeBO = new TradingTypeBL().GetTradingType(objTradingTypeBO);
}
catch (Exception ex)
{
throw ex;
}
return(lstTradingTypeBO);
}
/// <summary>
/// Created By : Satish Verma
/// Created Date : 1-Dec-2014
/// Purpose : To get Trading Type
/// </summary>
/// <param name="objTradingTypeBO"></param>
/// <returns></returns>
public List <TradingTypeBO> GetTradingType(TradingTypeBO objTradingTypeBO)
{
DataTable objDataTable = new TradingTypeDA().GetTradingType(objTradingTypeBO);
List <TradingTypeBO> lstTradingTypeBO = new List <TradingTypeBO>();
if (objDataTable.Rows.Count > 0)
{
foreach (DataRow Row in objDataTable.Rows)
{
TradingTypeBO obTradingTypeBO = new TradingTypeBO();
obTradingTypeBO.Id = (Convert.ToInt32(Row["Id"]));
obTradingTypeBO.TradingType = (Convert.ToString(Row["TradingType"]));
obTradingTypeBO.ParentId = Row["ParentId"] == DBNull.Value ? 0 : Convert.ToInt32(Row["ParentId"]);
obTradingTypeBO.IsActive = (Convert.ToBoolean(Row["IsActive"]));
lstTradingTypeBO.Add(obTradingTypeBO);
}
}
else
{
lstTradingTypeBO = null;
}
return(lstTradingTypeBO);
}