// Load ra danh sách các CategoryLevel1 bằng CodeCategpryLevel2 va IDLang
public void Sel_Ext_ByCodeCategoryLevel2_ByIDLang(HttpContext context)
{
String jSonString = "";
bool Disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
string CodeCategoryLevel2 = context.Request.QueryString["CodeCategoryLevel2"] != null && context.Request.QueryString["CodeCategoryLevel2"] != "undefined" ? context.Request.QueryString["CodeCategoryLevel2"] : "-1";
int TitleLenght = context.Request.QueryString["TitleLenght"] != null && context.Request.QueryString["TitleLenght"] != "undefined" ? int.Parse(context.Request.QueryString["TitleLenght"]) : 100;
int Limit = context.Request.QueryString["Limit"] != null && context.Request.QueryString["Limit"] != "undefined" ? int.Parse(context.Request.QueryString["Limit"]) : 100;
string Order = context.Request.QueryString["Order"] != null && context.Request.QueryString["Order"] != "undefined" ? context.Request.QueryString["Order"] : "CategoryLevel1_CategoryNameLevel1";
string IsDesc = context.Request.QueryString["IsDesc"] != null && context.Request.QueryString["IsDesc"] != "undefined" ? context.Request.QueryString["IsDesc"] : "true";
int IDLang = !string.IsNullOrEmpty(context.Request.QueryString["IDLang"]) ? int.Parse(context.Request.QueryString["IDLang"]) : 1;
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
List<vw_CategoryLevel1ViewAll> obj = String.IsNullOrEmpty(context.Request.QueryString["Disable"]) ?
aCategoryLevel1BO.Sel_Ext_ByCodeCategoryLevel2_ByIDLang(CodeCategoryLevel2, IDLang).ToList() :
aCategoryLevel1BO.Sel_Ext_ByCodeCategoryLevel2_ByIDLang(CodeCategoryLevel2, IDLang, Disable).ToList();
List<vw_CategoryLevel1ViewAll> ObjOrder = new List<vw_CategoryLevel1ViewAll>();
switch (Order)
{
case "CategoryLevel1_CategoryNameLevel1":
if (IsDesc == "False")
{
ObjOrder = obj.OrderBy(a => a.CategoryLevel1_CategoryNameLevel1).ToList();
}
else
{
ObjOrder = obj.OrderByDescending(a => a.CategoryLevel1_CategoryNameLevel1).ToList();
}
break;
case "CategoryLevel2_CategoryNameLevel2":
if (IsDesc == "False")
{
ObjOrder = obj.OrderBy(a => a.CategoryLevel2_CategoryNameLevel2).ToList();
}
else
{
ObjOrder = obj.OrderByDescending(a => a.CategoryLevel2_CategoryNameLevel2).ToList();
}
break;
case "CategoryLevel1_ID":
if (IsDesc == "False")
{
ObjOrder = obj.OrderBy(a => a.CategoryLevel1_ID).ToList();
}
else
{
ObjOrder = obj.OrderByDescending(a => a.CategoryLevel1_ID).ToList();
}
break;
default:
ObjOrder = obj;
break;
}
for (int i = 0; i < ObjOrder.Count; i++)
{
if ((TitleLenght > -1) & (ObjOrder[i].CategoryLevel1_CategoryNameLevel1.Length > TitleLenght))
{
ObjOrder[i].CategoryLevel1_CategoryNameLevel1 = ObjOrder[i].CategoryLevel1_CategoryNameLevel1.Substring(0, TitleLenght - 1);
}
}
List<vw_CategoryLevel1ViewAll> ObjOrderLimit = new List<vw_CategoryLevel1ViewAll>();
if ((Limit > -1) & (ObjOrder.Count > Limit))
{
ObjOrderLimit = ObjOrder.GetRange(0, Limit).ToList();
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(ObjOrderLimit, _converter);
}
else
{
if (ObjOrder != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(ObjOrder, _converter);
}
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
