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 static LocaleStringResource GetItemByID(int LocaleStringResourceID, int CompanyID)
{
LocaleStringResource item = new LocaleStringResource();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@LocaleStringResourceID", LocaleStringResourceID),
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("LocaleStringResource_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
public static LocaleStringResource AddItem(LocaleStringResource model)
{
int result = 0;
try
{
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "LocaleStringResource_Add", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (int)reader[0];
}
}
}
catch (Exception ObjEx)
{
}
return(GetItemByID(result, model.CompanyID));
}
public static LocaleStringResourceCollection GetAllItem(int CompanyID)
{
LocaleStringResourceCollection collection = new LocaleStringResourceCollection();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("LocaleStringResource_GetAll", sqlParams))
{
while (reader.Read())
{
LocaleStringResource obj = new LocaleStringResource();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
