public static StClass SpClassMasterGetDataStructById(string ClassId)
{ // get a configured DbCommand object
DbCommand comm = DataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "SpClassMasterGetDataStructById";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@ClassId";
param.Value = ClassId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
//execute procedure and store data in table
DataTable table = DataAccess.ExecuteSelectCommand(comm);
//create object of structure
StClass details = new StClass();
//check there is row in table or not
if (table.Rows.Count > 0)
{ //create data reader
DataRow dr = table.Rows[0];
//store individually each field into object
details.ClassId = Convert.ToInt32(dr["ClassId"]);
details.ClassName = dr["ClassName"].ToString();
details.Description = dr["Description"].ToString();
}
//return object with data
return(details);
}
protected override void Store(IObjectContainerAdapter objectContainer)
{
for (var i = 0; i < 10; i++)
{
var cls = new StClass
();
var v = new ArrayList(10);
v.Add(IntArrayData);
v.Add(StringArrayData);
cls.SetId(i);
cls.SetVect(v);
objectContainer.Store(cls);
}
}
protected override void Store(IObjectContainerAdapter objectContainer)
{
for (var i = 0; i < 10; i++)
{
var cls = new StClass
();
var v = new ArrayList(10);
v.Add(IntArrayData);
v.Add(StringArrayData);
cls.SetId(i);
cls.SetVect(v);
objectContainer.Store(cls);
}
}
