protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
ModuleSubmoduleEntity theEntity = (ModuleSubmoduleEntity)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.Submoduleid.ToString()))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("v_submoduleid", theEntity.Submoduleid));
}
// This is the output parameter that is required for Oracle Connection.
// This is required only when the database is oracle as it will return curson.
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr)
{
ModuleSubmoduleEntity theEntity = new ModuleSubmoduleEntity();
theEntity.Moduleid = !dr.IsDBNull(0) ? Int32.Parse(dr.GetValue(0).ToString()) : -1;
theEntity.Modulename = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty;
theEntity.Leafnode = !dr.IsDBNull(2) ? Int32.Parse(dr.GetValue(2).ToString()) : -1;
theEntity.Parentmodule = !dr.IsDBNull(3) ? Int32.Parse(dr.GetValue(3).ToString()) : -1;
theEntity.Submoduleid = !dr.IsDBNull(4) ? Int32.Parse(dr.GetValue(4).ToString()) : -1;
theEntity.Name = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty;
theEntity.Permission = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty;
return(theEntity);
}
public EntityList GetLinkNodes(ModuleSubmoduleEntity ModuleSubModule, string CurrentMod_ID)
{
PageLinkNodeDAO Logdao = new DataAccess.Components.PageLinkNodeDAO();
return(Logdao.GetLinkNodes(ModuleSubModule, CurrentMod_ID));
}
