public EnsureUserResult EnsureUser(EnsureUserQuery query)
{
DisableCaching();
var result = new EnsureUserResult {
RosterLookupId = -1,
Key = "",
DisplayText = ""
};
try {
RosterConfigService configProvider = new RosterConfigService();
ListMetadataField field = configProvider.GetField(query.FieldMetedataId.ToGuid());
DbFieldUser dbFld = field.GetDbField() as DbFieldUser;
var user = dbFld.EnsureUser(XDocument.Parse(query.XmlText));
result.DisplayText = user.DisplayText;
result.Key = user.Key;
result.RosterLookupId = user.RosterLookupId;
}
catch (Exception ex) {
HandleException(ex);
}
return(result);
}
public string SubmitTimesheet(string procedureName, int workerId, string rosterIDs, string periodStart, string periodEnd)
{
var dataService = new RosterDataService();
{
string currentUserLogin = SPContext.Current.Web.CurrentUser.LoginName;
List <Tuple <string, string> > whereCriteria = new List <Tuple <string, string> > {
new Tuple <string, string>(FieldNames.WORKER_AD_ACCOUNT, currentUserLogin)
};
var currentWorkerId = dataService
.TableContent("WorkerPerson", "Id", "Id", whereCriteria)
.Select(x => { return(x.Item1); }).FirstOrDefault();
if (currentWorkerId == 0)
{
throw new Exception(string.Format("Cannot find '{0}' in Employee list", currentUserLogin));
}
if (currentWorkerId != workerId)
{
throw new Exception("Current timesheet(s) can be submitted only by Worker with ID#" + workerId);
}
List <Guid> ids = rosterIDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(x => x.ToGuid()).ToList();
var rosters = dataService.GetRosterEvents(ids, true);
// get unly rejected OR unconfirmed rosters
var rostersInCorrectStatus = rosters.Where(r =>
{
var _props = r.RosterEventDictionary;
return(_props.ContainsKey(FieldNames.STATUS_ID) &&
(_props[FieldNames.STATUS_ID].ToInt() == 6 || _props[FieldNames.STATUS_ID].ToInt() == 9));
});
var paramCollection = new List <Tuple <string, object> >();
paramCollection.Add(new Tuple <string, object>("@startDate", periodStart));
paramCollection.Add(new Tuple <string, object>("@endDate", periodEnd));
paramCollection.Add(new Tuple <string, object>("@workerId", workerId));
paramCollection.Add(new Tuple <string, object>("@workingRosterIds", string.Join(",", rostersInCorrectStatus.Where(r => r.EventTypeId == 1).Select(r => r.Id))));
paramCollection.Add(new Tuple <string, object>("@timesheetRosterIds", string.Join(",", rostersInCorrectStatus.Where(r => r.EventTypeId == 3).Select(r => r.Id))));
paramCollection.Add(new Tuple <string, object>("@currentUser", DbFieldUser.GetUserRosterId(SPContext.Current.Web.CurrentUser)));
paramCollection.Add(new Tuple <string, object>("@message", string.Format("Sumbit at {0}", DateTime.Now.ToString(CultureInfo.InvariantCulture))));
return(dataService.ExecuteProcedure(procedureName, paramCollection));
}
}
public itemView <string> ExecuteAction(string version, ICollection <abstractSearch> filter)
{
DisableCaching();
var result = new itemView <string>();
try
{
var name = filter.filterTextValue("name");
var dataService = new RosterDataService();
{
var paramCollection = !filter.Any() ? new List <Tuple <string, object> >() :
filter.Select(item => new Tuple <string, object>(item.LabelText, (item as textSearch).searchTerm)).ToList();
var currentUserParam = paramCollection.FirstOrDefault(p => p.Item1.Equals("@currentUser"));
if (currentUserParam != null)
{
paramCollection.Remove(currentUserParam);
paramCollection.Add(new Tuple <string, object>("@currentUser", DbFieldUser.GetUserRosterId(SPContext.Current.Web.CurrentUser)));
}
result.item = dataService.ExecuteProcedure(name, paramCollection);
}
}
catch (Exception ex)
{
result.message.message = ex.Message;
result.message.messageLevel = messageLevelEnum.critical;
//HandleException(ex);
}
return(result);
}
public itemView <bool> SaveRosterEventItem(string version, string listId, int eventTypeId, Entity item)
{
DisableCaching();
var result = new itemView <bool>();
try
{
var service = new RosterDataService();
var config = new RosterConfigService();
var list = config.GetList(listId.ToGuid());
var entity = new RosterEvent
{
Id = item.Key.ToGuid(),
EventTypeId = eventTypeId,
RosterEventProperties = item.Fields.NamedToExpando()
};
if (!entity.RosterEventDictionary.ContainsKey("ContentTypeId"))
{
entity.RosterEventDictionary.Add("ContentTypeId", 1);
}
if (!entity.RosterEventDictionary.ContainsKey("CreatedBy"))
{
entity.RosterEventDictionary.Add("CreatedBy",
DbFieldUser.GetUserRosterId(SPContext.Current.Web.CurrentUser));
}
if (!entity.RosterEventDictionary.ContainsKey("Created"))
{
entity.RosterEventDictionary.Add("Created", DateTime.Now);
}
if (!entity.RosterEventDictionary.ContainsKey("ModifiedBy"))
{
entity.RosterEventDictionary.Add("ModifiedBy",
DbFieldUser.GetUserRosterId(SPContext.Current.Web.CurrentUser));
}
if (!entity.RosterEventDictionary.ContainsKey("Modified"))
{
entity.RosterEventDictionary.Add("Modified", DateTime.Now);
}
if (!entity.RosterEventDictionary.ContainsKey("Id"))
{
entity.RosterEventDictionary.Add("Id", entity.Id);
}
if (!entity.RosterEventDictionary.ContainsKey("RosterEventId"))
{
entity.RosterEventDictionary.Add("RosterEventId", entity.Id);
}
var fields = list.ListMetadataFields.ToList();
fields.ForEach(_ =>
{
if (!entity.RosterEventDictionary.ContainsKey(_.InternalName))
{
if (_.ClrType == typeof(DateTime))
{
entity.RosterEventDictionary.Add(_.InternalName, null);
}
else if (_.ClrType == typeof(Guid))
{
entity.RosterEventDictionary.Add(_.InternalName, null);
}
else if (_.ClrType == typeof(Int32))
{
entity.RosterEventDictionary.Add(_.InternalName, null);
}
else
{
entity.RosterEventDictionary.Add(_.InternalName, _.ClrType.DefaultValue());
}
}
});
service.SaveRosterEvent(entity, list.Id);
result.item = true;
}
catch (Exception ex)
{
//HandleException(ex);
result.message.message = ex.Message;
result.message.messageLevel = messageLevelEnum.critical;
}
return(result);
}
public ExecuteActionResult ExecuteAction(ExecuteActionQuery query)
{
DisableCaching();
var result = new ExecuteActionResult();
try
{
if (query == null)
{
throw new ArgumentNullException("query");
}
var dataService = new RosterDataService();
{
var paramCollection = query.Parameters == null ? new List <Tuple <string, object> >():
query.Parameters.Select(item => new Tuple <string, object>(item.Name, item.Value)).ToList();
var currentUserParam = paramCollection.FirstOrDefault(p => p.Item1.Equals("@currentUser"));
if (currentUserParam != null)
{
// change :: sharepoint user id -> roster user id
paramCollection.Remove(currentUserParam);
paramCollection.Add(new Tuple <string, object>("@currentUser", DbFieldUser.GetUserRosterId(SPContext.Current.Web.CurrentUser)));
}
result.Message = dataService.ExecuteProcedure(query.Name, paramCollection);
}
}
catch (Exception ex)
{
HandleException(ex);
}
return(result);
}
public static void SetControlProperties(this ListMetadataField metaField, DbField dbField)
{
XDocument xDoc = new XDocument(new XElement("Field",
new XAttribute("Type", dbField.TypeAsString)));
XElement root = xDoc.Root;
switch (dbField.Type)
{
case SPFieldType.Text:
root.Add(new XAttribute("MaxLength", (dbField as DbFieldText).MaxLength));
break;
case SPFieldType.Note:
root.Add(new XAttribute("NumLines", (dbField as DbFieldNote).NumberOfLines));
break;
case SPFieldType.Boolean:
break;
case SPFieldType.DateTime:
root.Add(new XAttribute("Format", (dbField as DbFieldDateTime).Format));
break;
case SPFieldType.Number:
DbFieldNumber numFld = dbField as DbFieldNumber;
root.Add(new XAttribute("Decimals", numFld.DecimalPlaces));
root.Add(new XAttribute("Min", numFld.MinValue));
root.Add(new XAttribute("Max", numFld.MaxValue));
break;
case SPFieldType.Recurrence:
dbField = new DbFieldRecurrence(metaField.Id);
break;
case SPFieldType.Choice:
DbFieldChoice chFld = dbField as DbFieldChoice;
root.Add(new XAttribute("Format", chFld.ControlType)); // "Dropdown" or "RadioButtons" or "Checkboxes"
root.Add(new XElement("CHOICES", chFld.Choices.Select(x => new XElement("CHOICE", x))));
break;
case SPFieldType.Lookup:
DbFieldLookup loFld = dbField as DbFieldLookup;
root.Add(new XAttribute("Source", loFld.ListSource));
root.Add(new XAttribute("List", loFld.ListId));
root.Add(new XAttribute("LookupKey", loFld.LookupKey));
root.Add(new XAttribute("LookupField", loFld.LookupField));
if (!String.IsNullOrWhiteSpace(loFld.DependentParent))
{
root.Add(new XAttribute("DependentParent", loFld.DependentParent));
root.Add(new XAttribute("DependentParentField", loFld.DependentParentField));
root.Add(new XAttribute("FilterByField", loFld.FilterByField));
}
break;
case SPFieldType.User:
DbFieldUser usFld = dbField as DbFieldUser;
root.Add(new XAttribute("Source", usFld.ListSource));
root.Add(new XAttribute("List", usFld.ListId));
root.Add(new XAttribute("LookupKey", usFld.LookupKey));
root.Add(new XAttribute("LookupField", usFld.LookupField));
root.Add(new XAttribute("AllowSelection", usFld.AllowSelection));
root.Add(new XAttribute("ChooseFrom", usFld.ChooseFrom));
root.Add(new XAttribute("ChooseFromGroup", usFld.ChooseFromGroup));
break;
default:
break;
}
metaField.ControlProperties = xDoc.ToString(SaveOptions.DisableFormatting);
}
public static DbField GetDbField(this ListMetadataField metaField)
{
DbField dbField = null;
XDocument xDoc = XDocument.Parse(metaField.ControlProperties);
XElement root = xDoc.Root;
XAttribute fieldTypeAttr = root.Attribute("Type");
if (fieldTypeAttr != null)
{
SPFieldType pFldType = EnumHelper.GetEnumByDescription <SPFieldType>(fieldTypeAttr.Value);
switch (pFldType)
{
case SPFieldType.Guid:
dbField = new DbFieldGuid(metaField.Id);
break;
case SPFieldType.Text:
DbFieldText txtFld = new DbFieldText(metaField.Id);
int mLen = 0;
XAttribute maxLengthAttr = root.Attribute("MaxLength");
if (maxLengthAttr != null && Int32.TryParse(maxLengthAttr.Value, out mLen))
{
txtFld.MaxLength = mLen;
}
dbField = txtFld;
break;
case SPFieldType.Note:
DbFieldNote noteFld = new DbFieldNote(metaField.Id);
int nol = 0;
XAttribute nolAttr = root.Attribute("NumLines");
if (nolAttr != null && Int32.TryParse(nolAttr.Value, out nol))
{
noteFld.NumberOfLines = nol;
}
dbField = noteFld;
break;
case SPFieldType.Boolean:
dbField = new DbFieldBoolean(metaField.Id);
break;
case SPFieldType.DateTime:
DbFieldDateTime dtFld = new DbFieldDateTime(metaField.Id);
XAttribute formatAttr = root.Attribute("Format");
if (formatAttr != null && !string.IsNullOrEmpty(formatAttr.Value))
{
dtFld.Format = formatAttr.Value; // "DateOnly" or "DateTime"
}
dbField = dtFld;
break;
case SPFieldType.Number:
DbFieldNumber numFld = new DbFieldNumber(metaField.Id);
int dcp = 0;
XAttribute decAttr = root.Attribute("Decimals");
if (decAttr != null && Int32.TryParse(decAttr.Value, out dcp))
{
numFld.DecimalPlaces = dcp; // -1 = 'Automatic'
}
double minV = 0;
XAttribute minAttr = root.Attribute("Min");
if (minAttr != null && Double.TryParse(minAttr.Value.Replace(',', '.'), NumberStyles.Any, CultureInfo.InvariantCulture, out minV))
{
numFld.MinValue = minV;
}
double maxV = 0;
XAttribute maxAttr = root.Attribute("Max");
if (maxAttr != null && Double.TryParse(maxAttr.Value.Replace(',', '.'), NumberStyles.Any, CultureInfo.InvariantCulture, out maxV))
{
numFld.MaxValue = maxV;
}
dbField = numFld;
break;
case SPFieldType.Recurrence:
dbField = new DbFieldRecurrence(metaField.Id);
break;
case SPFieldType.Choice:
DbFieldChoice chFld = new DbFieldChoice(metaField.Id);
XAttribute chFormatAttr = root.Attribute("Format");
if (chFormatAttr != null && !string.IsNullOrEmpty(chFormatAttr.Value))
{
chFld.ControlType = chFormatAttr.Value; // "Dropdown" or "RadioButtons" or "Checkboxes"
}
XElement choicesEl = root.Element("CHOICES");
if (choicesEl != null)
{
chFld.Choices = choicesEl.Elements("CHOICE").Select(x => x.Value).ToArray();
}
dbField = chFld;
break;
case SPFieldType.Lookup:
var lookFld = new DbFieldLookup(metaField.Id);
var listSourceAttr = root.Attribute("Source");
if (listSourceAttr != null && !string.IsNullOrEmpty(listSourceAttr.Value))
{
lookFld.ListSource = listSourceAttr.Value.ToInt();
}
var listAttr = root.Attribute("List");
if (listAttr != null && !string.IsNullOrEmpty(listAttr.Value))
{
lookFld.ListId = listAttr.Value;
}
var listKeyAttr = root.Attribute("LookupKey");
if (listKeyAttr != null && !string.IsNullOrEmpty(listKeyAttr.Value))
{
lookFld.LookupKey = listKeyAttr.Value;
}
var lfAttr = root.Attribute("LookupField");
if (lfAttr != null && !string.IsNullOrEmpty(lfAttr.Value))
{
lookFld.LookupField = lfAttr.Value;
}
var dependentParentAttr = root.Attribute("DependentParent");
if (dependentParentAttr != null && !string.IsNullOrEmpty(dependentParentAttr.Value))
{
lookFld.DependentParent = dependentParentAttr.Value;
}
var dependentParentFieldAttr = root.Attribute("DependentParentField");
if (dependentParentFieldAttr != null && !string.IsNullOrEmpty(dependentParentFieldAttr.Value))
{
lookFld.DependentParentField = dependentParentFieldAttr.Value;
}
var filterByFieldAttr = root.Attribute("FilterByField");
if (filterByFieldAttr != null && !string.IsNullOrEmpty(filterByFieldAttr.Value))
{
lookFld.FilterByField = filterByFieldAttr.Value;
}
dbField = lookFld;
break;
case SPFieldType.User:
var userFld = new DbFieldUser(metaField.Id);
var listSourceAttr2 = root.Attribute("Source");
if (listSourceAttr2 != null && !string.IsNullOrEmpty(listSourceAttr2.Value))
{
userFld.ListSource = listSourceAttr2.Value.ToInt();
}
var listAttr2 = root.Attribute("List");
if (listAttr2 != null && !string.IsNullOrEmpty(listAttr2.Value))
{
userFld.ListId = listAttr2.Value;
}
var listKeyAttr2 = root.Attribute("LookupKey");
if (listKeyAttr2 != null && !string.IsNullOrEmpty(listKeyAttr2.Value))
{
userFld.LookupKey = listKeyAttr2.Value;
}
var lfAttr2 = root.Attribute("LookupField");
if (lfAttr2 != null && !string.IsNullOrEmpty(lfAttr2.Value))
{
userFld.LookupField = lfAttr2.Value;
}
var asAttr2 = root.Attribute("AllowSelection");
if (asAttr2 != null && !string.IsNullOrEmpty(asAttr2.Value))
{
userFld.AllowSelection = asAttr2.Value;
}
var cfAttr2 = root.Attribute("ChooseFrom");
if (cfAttr2 != null && !string.IsNullOrEmpty(cfAttr2.Value))
{
userFld.ChooseFrom = cfAttr2.Value;
}
var cfgAttr2 = root.Attribute("ChooseFromGroup");
if (cfgAttr2 != null && !string.IsNullOrEmpty(cfgAttr2.Value))
{
userFld.ChooseFromGroup = cfgAttr2.Value;
}
dbField = userFld;
break;
default:
break;
}
if (dbField != null)
{
// common attributes
dbField.ReadOnly = metaField.ReadOnly;
dbField.DisplayName = metaField.FieldName;
dbField.InternalName = metaField.InternalName;
dbField.DefaultValue = metaField.DefaultValue;
dbField.Required = metaField.Required;
dbField.Hidden = metaField.Hidden;
}
}
return(dbField);
}
