internal dynamic GetRefineryList()
{
SqlCommand cmd;
SqlConnection connection = null;
BOMDetails objBOMDetails = new BOMDetails();
connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
connection.Open();
List <GenericTextValue> lstGenericTextValue = new List <GenericTextValue>();
SqlDataReader objSqlDataReader = null;
cmd = new SqlCommand("GetRefineryList", connection);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add(objSqlParameter[0]);
objSqlDataReader = cmd.ExecuteReader();
while (objSqlDataReader.Read())
{
GenericTextValue objGenericTextValue = new GenericTextValue();
objGenericTextValue.RID = Convert.ToString(objSqlDataReader["RefineryID"]);
objGenericTextValue.RName = Convert.ToString(objSqlDataReader["RefineryName"]);
lstGenericTextValue.Add(objGenericTextValue);
objGenericTextValue = null;
}
objSqlDataReader.Close();
connection.Close();
return(lstGenericTextValue);
}
internal dynamic GetSubRefineryList(int userId)
{
SqlCommand cmd;
SqlConnection connection = null;
BOMDetails objBOMDetails = new BOMDetails();
List <GenericTextValue> lstGenericTextValue = new List <GenericTextValue>();
SqlDataReader objSqlDataReader = null;
try {
connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
connection.Open();
SqlParameter[] objSqlParameter = new SqlParameter[1];
objSqlParameter[0] = new SqlParameter();
objSqlParameter[0].ParameterName = "@UserId";
objSqlParameter[0].SqlDbType = SqlDbType.Int;
objSqlParameter[0].Value = userId;
cmd = new SqlCommand("GetSubRefineryList", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(objSqlParameter[0]);
objSqlDataReader = cmd.ExecuteReader();
while (objSqlDataReader.Read())
{
GenericTextValue objGenericTextValue = new GenericTextValue();
objGenericTextValue.RID = Convert.ToString(objSqlDataReader["SubRefinery"]);
objGenericTextValue.RName = Convert.ToString(objSqlDataReader["SubRefinery"]);
lstGenericTextValue.Add(objGenericTextValue);
objGenericTextValue = null;
}
objSqlDataReader.Close();
connection.Close();
}
catch (Exception ex)
{
}
return(lstGenericTextValue);
}