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;
}
