public List <ModelSoundItem> GetListSoundItemByChuyen(int idChuyen) { List <ModelSoundItem> listItem = null; try { string sqlReadConfig = "Select Id from SOUND_ReadConfig where IdChuyen=" + idChuyen + " and IsActive=1 and IsDeleted=0"; DataTable dtReadConfig = dbclass.TruyVan_TraVe_DataTable(sqlReadConfig); if (dtReadConfig != null && dtReadConfig.Rows.Count > 0) { foreach (DataRow row in dtReadConfig.Rows) { int idConfig = int.Parse(row["Id"].ToString()); string sqlReadConfigDetail = "Select IntType, IdSound, IdIntConfig from SOUND_ReadConfigDetail where IdReadConfig=" + idConfig + " and IsActive=1 and IsDeleted=0 order by OrderIndex ASC"; DataTable dtReadConfigDetail = dbclass.TruyVan_TraVe_DataTable(sqlReadConfigDetail); if (dtReadConfigDetail != null && dtReadConfigDetail.Rows.Count > 0) { listItem = new List <ModelSoundItem>(); foreach (DataRow rowDetail in dtReadConfigDetail.Rows) { ModelSoundItem item = new ModelSoundItem(); int intType = 0; int.TryParse(rowDetail["IntType"].ToString(), out intType); item.FileType = intType; if (intType == 0) { int idIntConfig = 0; int.TryParse(rowDetail["IdIntConfig"].ToString(), out idIntConfig); string formula = soundIntConfigDAO.GetFormulaById(idIntConfig); if (!string.IsNullOrEmpty(formula)) { formula = formula.Replace('[', ' '); formula = formula.Replace(']', ' '); item.Formula = formula; } } else { int idSound = 0; int.TryParse(rowDetail["IdSound"].ToString(), out idSound); string path = soundDAO.GetPathById(idSound); if (!string.IsNullOrEmpty(path)) { item.SoundPath = path; } } listItem.Add(item); } } } } } catch (Exception ex) { throw ex; } return(listItem); }
public static List <ModelSoundItem> GetListSoundItemByChuyen(int idChuyen, int configType) { var returnList = new List <ModelSoundItem>(); try { var db = new PMSEntities(); var cfs = db.SOUND_ReadConfigDetail.Where(x => !x.IsDeleted && !x.SOUND_ReadConfig.IsDeleted && x.IsActive && x.SOUND_ReadConfig.IsActive && x.SOUND_ReadConfig.IdChuyen == idChuyen && x.SOUND_ReadConfig.ConfigType == configType).OrderBy(x => x.OrderIndex).ToList(); if (cfs != null && cfs.Count > 0) { var soundInts = db.SOUND_IntConfig.Where(x => !x.IsDeleted && x.IsActive).ToList(); var sounds = db.SOUNDs.ToList(); foreach (var item in cfs) { var soundItem = new ModelSoundItem(); soundItem.FileType = item.IntType; if (item.IntType == 0) { var intCF = soundInts.FirstOrDefault(x => x.Id == item.IdIntConfig); if (intCF != null) { soundItem.Formula = intCF.Formula; soundItem.IsProductivity = intCF.IsProductivity; } } else { var s = sounds.FirstOrDefault(x => x.Id == item.IdSound); soundItem.SoundPath = s != null ? s.Path : string.Empty; } returnList.Add(soundItem); } } } catch (Exception) { } return(returnList); }