public TRClass GetTRClassByKey(System.Int64 classId, string regionCode) { TRClass.CleanError(); using (Database dbObj = Utils.GetMainDB()) { using (IDataReader rs = dbObj.RunSPReturnRS("dbo._TRClass_GetAll", new SqlParameter("@Filter", "ClassId = " + classId.ToString() + " AND RegionCode = '" + regionCode + "'"), new SqlParameter("@Company", SessionState.CompanyName))) { if (dbObj.LastError != null && dbObj.LastError.Length == 0) { HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader col = new HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader(GenerateTRClassCollectionFromReader); TRClassList objCol = (TRClassList)col(rs); rs.Close(); if (objCol.Count > 0) { return(objCol[0]); } else { return(null); } } else { throw new DataException("SQLDataAccessLayer: GetTRClassByKey-> " + dbObj.LastError); } } } }
private CollectionBase GenerateTRClassCollectionFromReader(IDataReader rs) { TRClassList col = new TRClassList(); while (rs.Read()) { //Modified by Sateesh for Setting Scope and MTR Dates (PCF: ACQ 8.10) - 28/05/2009 TRClass obj = new TRClass(Convert.ToInt64(rs["ClassId"]), rs["RegionCode"].ToString().Trim(), TRClass.GetTranslationModeFromString(rs["TranslationMode"].ToString().Trim()), Convert.ToInt32(rs["ModifierId"]), GetProperDate(rs["ModifyDate"])); col.Add(obj); } return(col); }
//Added by venkata 07-10-16 public TRClassList GetAllTRClass(string filter) { using (Database dbObj = Utils.GetMainDB()) { using (IDataReader rs = dbObj.RunSPReturnRS("_TRClass_GetAll", new SqlParameter("@Filter", filter), new SqlParameter("@Company", SessionState.CompanyName))) { if (dbObj.LastError != null && dbObj.LastError.Length == 0) { HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader col = new HyperCatalog.DataAccessLayer.SqlDataAccessLayer.GenerateCollectionFromReader(GenerateTRClassCollectionFromReader); TRClassList objCol = (TRClassList)col(rs); rs.Close(); return(objCol); } else { throw new DataException("SQLDataAccessLayer: GetAllTRClass-> " + dbObj.LastError); } } } }
private void UpdateDataView() { #region RegionList population UpdateClassRegions(); UpdateTermRegions(); #endregion #region Init TranslationMode radio group rdTranslationMode.Items.Clear(); rdTranslationMode.DataSource = Enum.GetValues(typeof(TRClassTranslationMode)); rdTranslationMode.DataBind(); #endregion #region Init ListBar //using (TRClassList iList = TRClass.GetAll(" RegionCode = '"+ ddClassRegions.SelectedValue.ToString()+"'")) //Added by Venkata 07-10-16 using (TRClassList iList = GetAllTRClass(" RegionCode = '" + ddClassRegions.SelectedValue.ToString() + "'")) { foreach (TRClass tr_class in iList) { uwClassList.Groups.FromKey("classes").Items.Add(tr_class.Item.FullName, tr_class.Item.Id.ToString()); } } using (TermTypeList iTypes = TermType.GetAll()) { foreach (TermType termType in iTypes) { uwClassList.Groups.FromKey("others").Items.Add(termType.Name, termType.Code.ToString()); } } uwClassList.SelectedGroup = 0; uwClassList.SelectedItem = uwClassList.Groups[0].Items[0]; #endregion #region Update CheckBoxLists cbMTRDays.Items.Clear(); for (int i = 1; i <= 31; i++) { cbMTRDays.Items.Add(new ListItem(i.ToString(), i.ToString())); } cbCTRDays.Items.Clear(); for (int i = 1; i <= 31; i++) { cbCTRDays.Items.Add(new ListItem(i.ToString(), i.ToString())); } #endregion #region Update Product Line DropDown List using (HyperCatalog.Business.PLList plList = PL.GetAll()) { plList.Sort("Code"); ddPL.DataSource = plList; ddPL.DataBind(); ddPL.Items.Insert(0, new ListItem("->PL<-", null)); ddPL.SelectedIndex = 0; cbPLLanguages.Enabled = false; } #endregion UpdateOptions(uwClassList.Groups[0].Items[0].Key); pnl_ClassPanel.Visible = true; pnl_TermsPanel.Visible = false; }