public static LocaleStringResourceCollection Search(SearchFilter value)
{
LocaleStringResourceCollection items = new LocaleStringResourceCollection();
string key = string.Format(SETTINGS_Search_KEY, value.Keyword, value.Page, value.PageSize, value.OrderBy, value.OrderDirection, value.Condition);
if (SystemConfig.AllowSearchCache)
{
object obj2 = HttpCache.Get(key);
if ((obj2 != null))
{
return((LocaleStringResourceCollection)obj2);
}
}
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.PostAsJsonAsync(Resource + "?method=search", value).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
items = response.Content.ReadAsAsync <LocaleStringResourceCollection>().GetAwaiter().GetResult();
}
}
if (SystemConfig.AllowSearchCache)
{
HttpCache.Max(key, items);
}
return(items);
}
public static LocaleStringResourceCollection Search(SearchFilter SearchKey)
{
LocaleStringResourceCollection collection = new LocaleStringResourceCollection();
using (var reader = SqlHelper.ExecuteReader("DNHLocaleStringResource_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
LocaleStringResource obj = new LocaleStringResource();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public virtual DataTable ImportData(DataTable objList)
{
IEnumerable <LocaleStringResource> myList = objList.ToList <LocaleStringResource>();
LocaleStringResourceCollection ErrorList = new LocaleStringResourceCollection();
foreach (LocaleStringResource objitem in myList)
{
try
{
Save(objitem);
}
catch (Exception objEx)
{
objitem.ErrorMesssage = "<div class='error'>" + objEx.Message + "</div>";
ErrorList.Add(objitem);
}
}
return(ErrorList.ToDataTable <LocaleStringResource>());
}
public static LocaleStringResourceCollection GetbyUser(string CreatedUser, int CompanyID)
{
LocaleStringResourceCollection collection = new LocaleStringResourceCollection();
LocaleStringResource obj;
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CreatedUser", CreatedUser),
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("LocaleStringResource_GetAll_byUser", sqlParams))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static LocaleStringResourceCollection GetAll(int CompanyID)
{
LocaleStringResourceCollection items = new LocaleStringResourceCollection();
string key = String.Format(SETTINGS_ALL_KEY, CompanyID);
object obj2 = HttpCache.Get(key);
if ((obj2 != null))
{
return((LocaleStringResourceCollection)obj2);
}
using (var client = WebApiHelper.myclient(HouseEndpoint, SystemConst.APIJosonReturnValue))
{
HttpResponseMessage response = client.GetAsync(string.Format(Resource + "?CompanyID={0}", CompanyID)).GetAwaiter().GetResult();
if (response.IsSuccessStatusCode)
{
items = response.Content.ReadAsAsync <LocaleStringResourceCollection>().GetAwaiter().GetResult();
}
}
HttpCache.Max(key, items);
return(items);
}