public ModuleName FillModuleType(int Flag) { NewDAL.DBManager objDB = new DBManager(); objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString; objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString); objDB.Open(); objDB.CreateParameters(1); objDB.AddParameters(0, "Flag", Flag, DbType.Int32); IDataReader dr = (IDataReader)objDB.ExecuteReader(CommandType.StoredProcedure, "Module"); ModuleName listOfTitle = new ModuleName(); while (dr.Read()) { var item = new EduMetaDataDM.Module(); item.ID = Education.DataHelper.GetInt(dr, "ID"); item.Title = Education.DataHelper.GetString(dr, "Title"); listOfTitle.Add(item); } objDB.DataReader.Close(); objDB.Connection.Close(); objDB = null; return(listOfTitle); }
public void Parse(ProtoBuf.ProtoReader source) { int fieldNumber = 0; while ((fieldNumber = source.ReadFieldHeader()) > 0) { switch (fieldNumber) { default: source.SkipField(); break; case 1: //ID LABEL_REQUIRED TYPE_SINT32 ZigZag source.Hint(ProtoBuf.WireType.SignedVariant); ID = source.ReadInt32(); break; case 2: //ModuleName LABEL_REPEATED TYPE_STRING TwosComplement int ModuleNamefield = source.FieldNumber; do { ModuleName.Add(source.ReadString()); } while(source.TryReadFieldHeader(ModuleNamefield)); break; case 3: //RequiredBundles LABEL_REPEATED TYPE_STRING TwosComplement int RequiredBundlesfield = source.FieldNumber; do { RequiredBundles.Add(source.ReadString()); } while(source.TryReadFieldHeader(RequiredBundlesfield)); break; } } }