public async Task <IResponse <ViewModels.PageNew> > GetLabel(ViewModels.PageLabelReq view)
{
var PageLabelRes = new PageNew();
DataTable dt = new DataTable();
Dictionary <string, string> PageRes = new Dictionary <string, string>(StringComparer.OrdinalIgnoreCase);
if (view.FromDate != null)
{
var data = from file in _appContext.Languages_Label
where file.Is_Active == 1 && file.Updated_Date >= view.FromDate
orderby file.Pagename ascending, file.Labelname descending, file.Language_Code descending
select new
{
Key = file.Pagename.Trim() + "_" + file.Labelname.Trim() + "_" + file.Language_Code.Trim(),
value = file.Value.Trim()
};
var labelInfo = await data.ToListAsync();
PageLabelRes.PageKeyValue = new Dictionary <string, string>();
dt = ToDataTable(labelInfo);
foreach (DataRow dr in dt.AsEnumerable())
{
if (!PageLabelRes.PageKeyValue.ContainsKey(dr["Key"].ToString().Trim()))
{
PageLabelRes.PageKeyValue.Add(dr["Key"].ToString().Trim(), dr["value"].ToString().Trim());
}
}
}
else if (view.page_name == "ALL")
{
var data = from file in _appContext.Languages_Label
where file.Is_Active == 1
orderby file.Pagename ascending, file.Labelname descending, file.Language_Code descending
select new
{
Key = file.Pagename.Trim() + "_" + file.Labelname.Trim() + "_" + file.Language_Code.Trim(),
value = file.Value.Trim()
};
var labelInfo = await data.ToListAsync();
PageLabelRes.PageKeyValue = new Dictionary <string, string>();
dt = ToDataTable(labelInfo);
foreach (DataRow dr in dt.AsEnumerable())
{
if (!PageLabelRes.PageKeyValue.ContainsKey(dr["Key"].ToString().Trim()))
{
PageLabelRes.PageKeyValue.Add(dr["Key"].ToString().Trim(), dr["value"].ToString().Trim());
}
}
}
else
{
var data = from file in _appContext.Languages_Label
where file.Is_Active == 1 & file.Pagename == view.page_name || file.Pagename == "Common"
orderby file.Pagename ascending, file.Labelname descending, file.Language_Code descending
select new
{
Key = file.Pagename.Trim() + "_" + file.Labelname.Trim() + "_" + file.Language_Code.Trim(),
value = file.Value.Trim()
};
var labelInfo = await data.ToListAsync();
dt = ToDataTable(labelInfo);
PageLabelRes.PageKeyValue = new Dictionary <string, string>();
foreach (DataRow dr in dt.AsEnumerable())
{
if (!PageLabelRes.PageKeyValue.ContainsKey(dr["Key"].ToString().Trim()))
{
PageLabelRes.PageKeyValue.Add(dr["Key"].ToString().Trim(), dr["value"].ToString().Trim());
}
}
}
return(new LanggResponse(PageLabelRes));
}
public async Task <List <PageData> > GetLabelPortal()
{
var PageLabelRes = new PageNew();
DataTable dt = new DataTable();
Dictionary <string, string> PageRes = new Dictionary <string, string>(StringComparer.OrdinalIgnoreCase);
var pageData = new List <PageData>();
var data = from file in _appContext.Languages_Label
where file.Is_Active == 1
orderby file.Pagename ascending, file.Labelname descending, file.Language_Code descending
select new
{
Id = file.Id,
Key = file.Pagename.Trim() + "_" + file.Labelname.Trim() + "_" + file.Language_Code.Trim(),
value = file.Value.Trim(),
pageName = file.Pagename,
pageDisplayName = file.Page_Displayname,
labelName = file.Labelname,
languageCode = file.Language_Code
};
var labelInfo = await data.ToListAsync();
foreach (var item in labelInfo)
{
var result = new PageData()
{
Id = item.Id,
PageName = item.pageName,
PageDisplayName = item.pageDisplayName,
LabelName = item.labelName,
LanguageCode = item.languageCode,
key = item.Key,
value = item.value,
//keyEn = item.Key,
//keyAr = item.Key,
//valueEn = item.value,
//valueAr = item.value
};
//var labelNames = pageData.Where(x => x.LabelName == item.labelName).FirstOrDefault();
//var pageNames = pageData.Where(x => x.PageName == item.pageName).FirstOrDefault();
//var pageDisplayNames = pageData.Where(x => x.PageDisplayName == item.pageDisplayName).FirstOrDefault();
//var d = pageData.Where(x => x.keyEn == item.Key || x.keyAr == item.Key).FirstOrDefault();
//if (labelNames == null)
//{
// pageData.Add(result);
//}
//// var langCodeEn = pageData.Where(x => x.LanguageCode == item.languageCode).FirstOrDefault();
//var labelName = pageData.Where(x => x.LabelName == item.labelName).FirstOrDefault();
//var pageName = pageData.Where(x => x.PageName == item.pageName).FirstOrDefault();
//var pageDisplayName = pageData.Where(x => x.PageDisplayName == item.pageDisplayName).FirstOrDefault();
//if (labelName != null && pageName != null && pageDisplayName != null)
//{
// if (labelName.LabelName == item.labelName && pageName.PageName == item.pageName && pageDisplayName.PageDisplayName == item.pageDisplayName)
// {
// if (labelName.LanguageCode.Trim() == "ar")
// {
// pageData.LastOrDefault().keyAr = item.Key;
// pageData.LastOrDefault().valueAr = item.value;
// //pageData.Add(result);
// }
// else if (labelName.LanguageCode.Trim() == "en")
// {
// pageData.LastOrDefault().keyEn = item.Key;
// pageData.LastOrDefault().valueEn = item.value;
// //pageData.RemoveAt(pageData.Count() - 1);
// }
// }
// else
// {
// //pageData.Add(result);
// }
//}
pageData.Add(result);
}
return(pageData);
}
