public static List<EmailListItem> GetAllEmailListItems(SPWeb web)
{
SPList list = Utility.GetListFromURL(Constants.EMAIL_LIST_URL, web);
if (list == null) return null;
CAMLListQuery<EmailListItem> query = new CAMLListQuery<EmailListItem>(list);
return query.ExecuteListQuery(string.Empty);
}
public static EmailTemplate GetTemplateByName(string url, string name)
{
var spList = Utility.GetListFromURL(url);
CAMLListQuery<EmailTemplate> queryer = new CAMLListQuery<EmailTemplate>(spList);
string CAML = Camlex.Query()
.Where(x => (string)x["Title"] == name).ToString();
return queryer.ExecuteSingleQuery(CAML);
}
public static EmailListItem GetItemByKey(string key, SPWeb web)
{
SPList list = Utility.GetListFromURL(Constants.EMAIL_LIST_URL, web);
if (list == null) return null;
CAMLListQuery<EmailListItem> query = new CAMLListQuery<EmailListItem>(list);
string caml = Camlex.Query().Where(x => (string)x[SPBuiltInFieldId.Title] == key).ToString();
return query.ExecuteSingleQuery(caml);
}
public static List <Model.Entities.NewsItem> GetNewsByCategory(SPList list, int itemCount, string pagingInfo, out SPListItemCollection collection)
{
CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list);
string caml = string.Empty;
caml = Camlex.Query()
.Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0")
.OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc)
.ToString();
return(query.ExecuteListQuery(caml, itemCount, pagingInfo, out collection));
}
public static List <Model.Entities.NewsItem> GetOtherNews(SPList list, int exceptId, int itemCount)
{
CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list);
string caml = string.Empty;
caml = Camlex.Query()
.Where(x => (int)x[SPBuiltInFieldId.ID] != exceptId && x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0")
.OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc)
.ToString();
return(query.ExecuteListQuery(caml, itemCount));
}
public static Model.Entities.NewsItem GetLatestNewsInCategory(SPList list)
{
CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list);
string caml = string.Empty;
caml = Camlex.Query()
.Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0")
.OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc)
.ToString();
return(query.ExecuteListQuery(caml, 1).FirstOrDefault());
}
//public static List<Model.Entities.NewsItem> GetLastestNews(SPWeb web, int itemCount, bool hotNewsOnly)
//{
// CAMLSiteQuery<NewsItem> query = new CAMLSiteQuery<NewsItem>(ListTemplateIds.NEWS_TEMPLATE_ID, web);
// string caml = string.Empty;
// if (hotNewsOnly)
// {
// var orderByList = new List<Expression<Func<SPListItem, object>>>();
// orderByList.Add(x => x["OrderNumber"] as Camlex.Asc);
// orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc);
// caml = Camlex.Query()
// .Where(x => (bool)x["IsHotNews"] == true &&
// x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0")
// .OrderBy(x => x["OrderNumber"] as Camlex.Desc)
// .ToString();
// }
// return query.ExecuteListQuery(caml, itemCount);
//}
public static List<Model.Entities.NewsItem> GetLastestNews(SPList list, int itemCount, bool hotNewsOnly)
{
CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list);
string caml = string.Empty;
if (hotNewsOnly)
{
var orderByList = new List<Expression<Func<SPListItem, object>>>();
orderByList.Add(x => x["OrderNumber"] as Camlex.Asc);
orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc);
caml = Camlex.Query()
.Where(x => (bool)x["IsHotNews"] == true &&
x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0")
.OrderBy(x => x["OrderNumber"] as Camlex.Desc)
.ToString();
}
return query.ExecuteListQuery(caml, itemCount);
}
//public static List<Model.Entities.NewsItem> GetLastestNews(SPWeb web, int itemCount, bool hotNewsOnly)
//{
// CAMLSiteQuery<NewsItem> query = new CAMLSiteQuery<NewsItem>(ListTemplateIds.NEWS_TEMPLATE_ID, web);
// string caml = string.Empty;
// if (hotNewsOnly)
// {
// var orderByList = new List<Expression<Func<SPListItem, object>>>();
// orderByList.Add(x => x["OrderNumber"] as Camlex.Asc);
// orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc);
// caml = Camlex.Query()
// .Where(x => (bool)x["IsHotNews"] == true &&
// x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0")
// .OrderBy(x => x["OrderNumber"] as Camlex.Desc)
// .ToString();
// }
// return query.ExecuteListQuery(caml, itemCount);
//}
public static List <Model.Entities.NewsItem> GetLastestNews(SPList list, int itemCount, bool hotNewsOnly)
{
CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list);
string caml = string.Empty;
if (hotNewsOnly)
{
var orderByList = new List <Expression <Func <SPListItem, object> > >();
orderByList.Add(x => x["OrderNumber"] as Camlex.Asc);
orderByList.Add(x => x[SPBuiltInFieldId.Created] as Camlex.Desc);
caml = Camlex.Query()
.Where(x => (bool)x["IsHotNews"] == true &&
x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat) "0")
.OrderBy(x => x["OrderNumber"] as Camlex.Desc)
.ToString();
}
return(query.ExecuteListQuery(caml, itemCount));
}
public static Model.Entities.NewsItem CreateInstance(SPListItem item)
{
CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(item.ParentList);
return(query.CreateInstance(item));
}
public static Model.Entities.NewsItem GetNewsById(SPList list, int id)
{
CAMLListQuery <NewsItem> query = new CAMLListQuery <NewsItem>(list);
return(query.GetItemById(id));
}
public static Model.Entities.NewsItem GetLatestNewsInCategory(SPList list)
{
CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list);
string caml = string.Empty;
caml = Camlex.Query()
.Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0")
.OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc)
.ToString();
return query.ExecuteListQuery(caml, 1).FirstOrDefault();
}
public static Model.Entities.NewsItem CreateInstance(SPListItem item)
{
CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(item.ParentList);
return query.CreateInstance(item);
}
public static List<Model.Entities.NewsItem> GetOtherNews(SPList list, int exceptId, int itemCount)
{
CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list);
string caml = string.Empty;
caml = Camlex.Query()
.Where(x => (int)x[SPBuiltInFieldId.ID] != exceptId && x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0")
.OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc)
.ToString();
return query.ExecuteListQuery(caml, itemCount);
}
public static Model.Entities.NewsItem GetNewsById(SPList list, int id)
{
CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list);
return query.GetItemById(id);
}
public static List<Model.Entities.NewsItem> GetNewsByCategory(SPList list, int itemCount, string pagingInfo, out SPListItemCollection collection)
{
CAMLListQuery<NewsItem> query = new CAMLListQuery<NewsItem>(list);
string caml = string.Empty;
caml = Camlex.Query()
.Where(x => x[SPBuiltInFieldId._ModerationStatus] == (DataTypes.ModStat)"0")
.OrderBy(x => x[SPBuiltInFieldId.Created] as Camlex.Desc)
.ToString();
return query.ExecuteListQuery(caml, itemCount, pagingInfo, out collection);
}
private void codeActivity2_ExecuteCode(object sender, EventArgs e)
{
var list = this.workflowProperties.TaskList;
CAMLListQuery<TaskItem> query = new CAMLListQuery<TaskItem>(list);
string caml = Camlex.Query().Where(p => (Guid)p[SPBuiltInFieldId.WorkflowInstanceID] == WorkflowInstanceId).ToString();
var items = query.ExecuteListQuery(caml);
foreach (var item in items)
{
SPFieldUserValue fv = new SPFieldUserValue(workflowProperties.Web, item.AssignedTo);
_allApprovers.Add(fv.User.LoginName);
}
}
