public static void CreateNoteColumn(this SPWeb web, string group, string description, string name, string displayName, int numberOfLines, bool richText = true) { try { if (!web.Fields.ContainsField(name)) { string fieldName = web.Fields.Add(name, SPFieldType.Note, false); SPFieldMultiLineText field = (SPFieldMultiLineText)web.Fields.GetField(name); field.Group = group; field.RichText = richText; field.NumberOfLines = numberOfLines; field.StaticName = name; field.Title = displayName; field.NoCrawl = false; field.Description = description; field.Update(); } } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("CORE:HELPERS", TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected, String.Format("Exception happened in Helpers:CreateNoteColumn. MESSAGE: {0}. EXCEPTION TRACE: {1} ", ex.Message, ex.StackTrace), ex.StackTrace); } }
public ArtDevField CreateFieldMultiLineText(string Name) { SPFieldMultiLineText Field = NewOrRefMultiLineText(Name); ArtDevField ArtDevField = new ArtDevField(Field); return(ArtDevField); }
public SPFieldMultiLineText NewOrRefMultiLineText(string Name) { string NoteName = this.Web().Fields.ContainsField(Name) ? Name : this.Web().Fields.Add(Name, SPFieldType.Note, false); SPFieldMultiLineText NoteField = (SPFieldMultiLineText)this.Web().Fields.GetFieldByInternalName(NoteName); NoteField.Group = this.columnGroup; return(NoteField); }
protected void AddRichTexField(String FieldName, Boolean Required) { String RichTextFieldName = List.Fields.Add(FieldName, SPFieldType.Note, Required); SPFieldMultiLineText RichTextField = (SPFieldMultiLineText)List.Fields.GetFieldByInternalName(RichTextFieldName); RichTextField.RichText = true; RichTextField.RichTextMode = SPRichTextMode.FullHtml; RichTextField.Update(); }
public override void AddFieldTo(SPFieldCollection fieldCollection) { AddFieldTo(fieldCollection, f => { SPFieldMultiLineText field = (SPFieldMultiLineText)f; field.AppendOnly = AppendOnly; field.RichText = RichText; field.RichTextMode = RichTextMode; }); }
private void LoadData(SPListItemCollection currentUserDetails) { DataTable leavetable = LeavestableStructure(); if (currentUserDetails.Count > 0) { foreach (SPListItem spListItem in currentUserDetails) { DataRow dataRow = leavetable.NewRow(); var requestedto = new SPFieldLookupValue(spListItem["RequestedTo"].ToString()); dataRow["Requested To"] = requestedto.LookupValue; var requestedFrom = new SPFieldLookupValue(spListItem["RequestedFrom"].ToString()); dataRow["Requested From"] = requestedFrom.LookupValue; dataRow["Leave Type"] = spListItem[Utilities.LeaveType].ToString(); dataRow["Starting Date"] = DateTime.Parse(spListItem[Utilities.StartingDate].ToString()).ToShortDateString(); dataRow["Ending Date"] = DateTime.Parse(spListItem[Utilities.EndingDate].ToString()).ToShortDateString(); dataRow["Leave Days"] = spListItem[Utilities.LeaveDays].ToString(); if (spListItem[Utilities.Remarks] != null) { dataRow["Remarks"] = spListItem[Utilities.Remarks].ToString(); } dataRow["Status"] = spListItem[Utilities.Status].ToString(); if (spListItem["Purpose of Leave"] != null) { SPFieldMultiLineText mlt = spListItem.Fields.GetField("Purpose of Leave") as SPFieldMultiLineText; dataRow["Reason"] = mlt.GetFieldValueAsText(spListItem["Purpose of Leave"]); } string url = "'" + SPContext.Current.Site.Url + "/Pages/CancelLeaves.aspx?LeaveId=" + spListItem.ID + "'"; if (spListItem[Utilities.Status].ToString() == "Approved") { dataRow["Cancel"] = "<a href=\"JavaScript:openDialog(" + url + ");\">Cancel</a>"; } leavetable.Rows.Add(dataRow); } } DataView dataView = new DataView(leavetable); dataView.Sort = "Starting Date DESC"; ViewState["Result"] = dataView.Table; }
/// <summary> /// Bind timsheet details /// </summary> /// <param name="timesheetId"></param> private void BindTimesheetData(int timesheetId) { try { using (SPSite site = new SPSite(SPContext.Current.Site.Url)) { using (SPWeb web = site.OpenWeb()) { TimesheetRespository objRepository = new TimesheetRespository(); SPListItem item = objRepository.GetListItemById(web, Constants.TimesheetListName, timesheetId); if (item != null) { lblCategory.Text = Convert.ToString(item["Category"]); lblDescription.Text = Convert.ToString(item["Description"]); lblDate.Text = Convert.ToDateTime(item["TimesheetDate"]).ToString("yyyy-MM-dd"); lblHours.Text = Convert.ToString(item["Hours"]); SPFieldMultiLineText multilineField = item.Fields.GetField("Description") as SPFieldMultiLineText; if (multilineField != null) { txtDescription.Text = multilineField.GetFieldValueAsText(item["Description"]); } ddlCategory.ClearSelection(); if (ddlCategory.Items.FindByValue(Convert.ToString(item["Category"])) != null) { ddlCategory.Items.FindByValue(Convert.ToString(item["Category"])).Selected = true; } dtDate.SelectedDate = Convert.ToDateTime(item["TimesheetDate"]); txtHours.Text = Convert.ToString(item["Hours"]); } } } } catch (Exception ex) { Common.HandleException(ex, SPContext.Current.Web.Url, "BindTimesheetData", "ManageTimesheetUserControl", SPContext.Current.Web.CurrentUser.Name); lblMsg.Text = Constants.ErrorMsg; } }
private void LoadLeaveDetails() { try { DataTable leavetable = LeavestableStructure(); using (var site = new SPSite(SPContext.Current.Site.Url)) { using (var web = site.OpenWeb()) { var leaveList = web.Lists.TryGetList(Utilities.LeaveRequest); if (leaveList != null) { SPUser user = web.CurrentUser; string currentUser = user.Name; SPListItemCollection currentUserDetails; currentUserDetails = GetListItemCollection(leaveList, "RequestedFrom", currentUser, "Employee Status", "Active"); if (currentUserDetails.Count > 0) { foreach (SPListItem spListItem in currentUserDetails) { DataRow dataRow = leavetable.NewRow(); var requestedto = new SPFieldLookupValue(spListItem["RequestedTo"].ToString()); dataRow["Requested To"] = requestedto.LookupValue; var requestedFrom = new SPFieldLookupValue(spListItem["RequestedFrom"].ToString()); dataRow["Requested From"] = requestedFrom.LookupValue; dataRow["Leave Type"] = spListItem[Utilities.LeaveType].ToString(); dataRow["Starting Date"] = DateTime.Parse(spListItem[Utilities.StartingDate].ToString()).ToShortDateString(); dataRow["Ending Date"] = DateTime.Parse(spListItem[Utilities.EndingDate].ToString()).ToShortDateString(); dataRow["Leave Days"] = spListItem[Utilities.LeaveDays].ToString(); if (spListItem[Utilities.Remarks] != null) { dataRow["Remarks"] = spListItem[Utilities.Remarks].ToString(); } dataRow["Status"] = spListItem[Utilities.Status].ToString(); if (spListItem["Purpose of Leave"] != null) { SPFieldMultiLineText mlt = spListItem.Fields.GetField("Purpose of Leave") as SPFieldMultiLineText; dataRow["Reason"] = mlt.GetFieldValueAsText(spListItem["Purpose of Leave"]); } leavetable.Rows.Add(dataRow); } } DataView dataView = new DataView(leavetable); dataView.Sort = "Starting Date DESC"; ViewState["Result"] = dataView.Table; } } } } catch (Exception ex) { lblErr.Text = ex.Message; } }
//Create Site Columns public void CreateSiteColumns() { using (SPWeb oSPWeb = oSPSite.RootWeb) { try { //if (!oSPWeb.Fields.ContainsField("Codigo")) //{ //Codigo de Documento string codigoField = oSPWeb.Fields.Add("Codigo", SPFieldType.Text, false); SPFieldText Codigo = (SPFieldText)oSPWeb.Fields.GetFieldByInternalName(codigoField); Codigo.Group = groupColumn; Codigo.Update(); //} //if (!oSPWeb.Fields.ContainsField("Referencia")) //{ string referenciaField = oSPWeb.Fields.Add("Referencia", SPFieldType.Text, false); SPFieldText Referencia = (SPFieldText)oSPWeb.Fields.GetFieldByInternalName(referenciaField); Referencia.Group = groupColumn; Referencia.Update(); //} //if (!oSPWeb.Fields.ContainsField("Comentario")) { string comentarioField = oSPWeb.Fields.Add("Comentario", SPFieldType.Text, false); SPFieldText Comentario = (SPFieldText)oSPWeb.Fields.GetFieldByInternalName(comentarioField); Comentario.Group = groupColumn; Comentario.Update(); //} //if (!oSPWeb.Fields.ContainsField("Remitente")) //{ string remitenteField = oSPWeb.Fields.Add("Remitente", SPFieldType.Text, false); SPFieldText Remitente = (SPFieldText)oSPWeb.Fields.GetFieldByInternalName(remitenteField); Remitente.Group = groupColumn; Remitente.Update(); //} //if (!oSPWeb.Fields.ContainsField("Factura")) { string facturaField = oSPWeb.Fields.Add("Factura", SPFieldType.Number, false); SPFieldNumber Factura = (SPFieldNumber)oSPWeb.Fields.GetFieldByInternalName(facturaField); Factura.Group = groupColumn; Factura.Update(); //} //if (!oSPWeb.Fields.ContainsField("Fecha Receopcion")) { string fechaRecepcionField = oSPWeb.Fields.Add("Fecha Recepcion", SPFieldType.DateTime, true); SPFieldDateTime FechaRecepcion = (SPFieldDateTime)oSPWeb.Fields.GetFieldByInternalName(fechaRecepcionField); FechaRecepcion.Group = groupColumn; FechaRecepcion.Update(); //} //Method 3 using Field schema //if (!oSPWeb.Fields.ContainsField("Nota")) //{ string notaField = oSPWeb.Fields.Add("Nota", SPFieldType.Note, false); SPFieldMultiLineText Nota = (SPFieldMultiLineText)oSPWeb.Fields.GetFieldByInternalName(notaField); Nota.Group = groupColumn; Nota.Update(); //} //if (!oSPWeb.Fields.ContainsField("Gerencias")) //{ // Lookup Column SPList gerenciasList = oSPWeb.Lists.TryGetList("Gerencias"); string GerenciaField = oSPWeb.Fields.AddLookup("Gerencia", gerenciasList.ID, true); SPFieldLookup gerenciaLookup = (SPFieldLookup)oSPWeb.Fields.GetFieldByInternalName(GerenciaField); gerenciaLookup.Group = groupColumn; gerenciaLookup.LookupField = "Title"; gerenciaLookup.Update(); //} SPList listas = oSPWeb.Lists.TryGetList("Listas"); //if (!oSPWeb.Fields.ContainsField("Nivel Prioridad")) //{ string nivelPrioridadField = oSPWeb.Fields.AddLookup("Nivel Prioridad", listas.ID, true); SPFieldLookup nivelPrioridadLookup = (SPFieldLookup)oSPWeb.Fields.GetFieldByInternalName(nivelPrioridadField); nivelPrioridadLookup.Group = groupColumn; nivelPrioridadLookup.LookupField = "Title"; nivelPrioridadLookup.Update(); //} //if (!oSPWeb.Fields.ContainsField("Clasificacion")) //{ string clasificacionField = oSPWeb.Fields.AddLookup("Clasificacion", listas.ID, true); SPFieldLookup clasificacionLookup = (SPFieldLookup)oSPWeb.Fields.GetFieldByInternalName(clasificacionField); clasificacionLookup.Group = groupColumn; clasificacionLookup.LookupField = "Title"; clasificacionLookup.Update(); //} //if (!oSPWeb.Fields.ContainsField("Estado")) //{ string estadoField = oSPWeb.Fields.AddLookup("Estado", listas.ID, false); SPFieldLookup estadoLookup = (SPFieldLookup)oSPWeb.Fields.GetFieldByInternalName(estadoField); estadoLookup.Group = groupColumn; estadoLookup.LookupField = "Title"; estadoLookup.Update(); //} } catch (Exception) { throw; } } }
public override void FeatureActivated(SPFeatureReceiverProperties properties) { SPWeb web = (SPWeb)properties.Feature.Parent; SPSite site = web.Site; web.AllowUnsafeUpdates = true; Lists listRoot = GetListsInfo(properties); foreach (List listInfo in listRoot.Items) { SPList tempList = null; if (listInfo.name != null) { listName = listInfo.name.Trim(); } else { throw new Exception(Constants.LIST_NAME_ERROR); } descName = listInfo.description; if (CheckList(web, listName)) { tempList = web.Lists[web.Lists.Add(listName, descName, SPListTemplateType.GenericList)]; } else { tempList = web.Lists[listName]; } if (tempList != null) { foreach (Field fields in listInfo.Fields) { SPFieldType fldType = SPFieldType.Text; ClearFlags(); if (fields.name != null) { fieldname = fields.name.Trim(); } else { throw new Exception(Constants.FIELD_NAME_ERROR + listName); } if (fields.datatype != null) { fieldtype = fields.datatype.Trim(); } if (fields.required != null) { required = fields.required.Trim(); } if (fields.defaultvalue != null) { defaultValue = fields.defaultvalue.Trim(); } if (fields.textformat != null) { textFormat = fields.textformat.Trim(); } if (fields.displaychoicesusing != null) { displayChoicesUsing = fields.displaychoicesusing.Trim(); } if (fields.lookuplist != null) { lookupList = fields.lookuplist.Trim(); } if (fields.lookupfield != null) { lookupfield = fields.lookupfield.Trim(); } switch (fieldtype.ToLower()) { case Constants.SINGLE_LINE_TEXT_TYPE: fldType = SPFieldType.Text; break; case Constants.MULTIPLE_LINE_TEXT_TYPE: fldType = SPFieldType.Note; break; case Constants.DATETIME_TYPE: fldType = SPFieldType.DateTime; break; case Constants.NUMBER_TYPE: fldType = SPFieldType.Number; break; case Constants.CURRENCY_TYPE: fldType = SPFieldType.Currency; break; case Constants.YESNO_TYPE: fldType = SPFieldType.Boolean; break; case Constants.PERSON_GROUP_TYPE: fldType = SPFieldType.User; break; case Constants.HYPERLINK_PICTURE_TYPE: fldType = SPFieldType.URL; break; case Constants.CHOICE_TYPE: if (displayChoicesUsing.ToLower().Trim().Equals(Constants.MULTICHECKBOX)) { fldType = SPFieldType.MultiChoice; } else { fldType = SPFieldType.Choice; } break; case Constants.LOOKUP_TYPE: fldType = SPFieldType.Lookup; break; } SPField field = tempList.Fields.CreateNewField(fldType.ToString(), fieldname); field.DefaultValue = defaultValue; field.Description = fielddesc; field.Required = (required.ToLower().Trim().Equals(Constants.YES) ? true : false); if (!tempList.Fields.ContainsField(fieldname)) { tempList.Fields.Add(field); } if ((tempList.Fields[fieldname] as SPFieldText) != null) { int maxLength; int.TryParse(maxCount, out maxLength); var fldText = tempList.Fields[fieldname] as SPFieldText; if (fldText != null && maxLength > 0) { fldText.MaxLength = maxLength; fldText.Update(); tempList.Update(); } continue; } if ((tempList.Fields[fieldname] as SPFieldMultiLineText) != null) { int noOfLines; int.TryParse(NoOfLines, out noOfLines); SPFieldMultiLineText fldMultiText = tempList.Fields[fieldname] as SPFieldMultiLineText; fldMultiText.NumberOfLines = (noOfLines > 0) ? noOfLines : fldMultiText.NumberOfLines; fldMultiText.RichText = (textFormat.ToLower().Trim().Equals(Constants.RICHTEXT)) ? true : false; fldMultiText.Update(); tempList.Update(); continue; } if ((tempList.Fields[fieldname] as SPFieldBoolean) != null) { SPFieldBoolean fldBoolean = (tempList.Fields[fieldname]) as SPFieldBoolean; // useful in future tempList.Update(); continue; } if ((tempList.Fields[fieldname] as SPFieldUser) != null) { SPFieldUser fldUser = tempList.Fields[fieldname] as SPFieldUser; // useful in future tempList.Update(); continue; } if (tempList.Fields[fieldname] as SPFieldMultiChoice != null) { SPFieldMultiChoice fldMultiChoice = tempList.Fields[fieldname] as SPFieldMultiChoice; foreach (Choice choiceNodes in fields.Choices) { fldMultiChoice.Choices.Add(choiceNodes.Value); } fldMultiChoice.Update(); tempList.Update(); continue; } if ((tempList.Fields[fieldname] as SPFieldChoice) != null) { SPFieldChoice fldChoice = tempList.Fields[fieldname] as SPFieldChoice; if (displayChoicesUsing.ToLower().Trim().Equals(Constants.DROPDOWNMENU)) { fldChoice.EditFormat = SPChoiceFormatType.Dropdown; } if (displayChoicesUsing.ToLower().Trim().Equals(Constants.RADIOBUTTONS)) { fldChoice.EditFormat = SPChoiceFormatType.RadioButtons; } // Add the choices foreach (Choice choiceNodes in fields.Choices) { fldChoice.Choices.Add(choiceNodes.Value); } fldChoice.Update(); tempList.Update(); continue; } if ((tempList.Fields[fieldname] as SPFieldLookup) != null) { SPFieldLookup fldLookup = tempList.Fields[fieldname] as SPFieldLookup; SPList parentList = web.Lists[lookupList]; fldLookup.LookupList = parentList.ID.ToString(); fldLookup.LookupField = parentList.Fields[lookupfield].InternalName; fldLookup.Update(); tempList.Update(); continue; } } } } web.Update(); web.AllowUnsafeUpdates = true; }
public static SPList CreateList(SPWeb web, string listName, string description, string displayName, string templateName) { SPList list = web.Lists.TryGetList(listName); try { if (list == null) { web.AllowUnsafeUpdates = true; var lstTemp = web.Site.GetCustomListTemplates(web); var template = lstTemp[templateName]; var listId = web.Lists.Add(listName, description, template); list = web.Lists[listId]; list.Title = listName; if (listName.Equals("BreakThroughProcertProjectsTracking")) { string[] colName = { "Bacground Attachments", "Problem Attachments", "ProjectMetrics Attachments", "Benifits Attachments", "Costs Attachments", "Financial Attachments", "Milestones Attachments", "Define Attachments", "Measure Attachments", "Analyze Attachments", "Investigate Attachments", "Control Attachments", "FinalReport Attachments" }; for (int i = 0; i < colName.Length; i++) { SPFieldMultiLineText multiLineField = (SPFieldMultiLineText)list.Fields.CreateNewField( SPFieldType.Note.ToString(), colName[i]); multiLineField.RichText = true; multiLineField.RichTextMode = SPRichTextMode.FullHtml; multiLineField.ShowInEditForm = false; multiLineField.ShowInNewForm = false; multiLineField.ShowInDisplayForm = true; multiLineField.ShowInViewForms = true; SPFieldCollection fields = list.Fields; if (!fields.ContainsField(colName[i])) { list.Fields.Add(multiLineField); } list.Update(); //int viewsCount = list.Views.Count; //for (int j = 0; j < viewsCount; j++) //{ // SPView view = list.Views[j]; // if (!view.ViewFields.Exists(colName[j])) // { // view.ViewFields.Add(list.Fields[colName[i]]); // view.Update(); // } //} } } list.Update(); if (listName.Equals("BreakThroughProcertProjectsTracking")) { AddCustomAction(list, "HideProperties"); SPFieldCollection Tagfields = list.Fields; string[] TagcolName = { "Tags" }; if (!Tagfields.ContainsField(TagcolName[0])) { TaxonomySession taxonomySession = new TaxonomySession(SPContext.Current.Site); TermStore termStore = taxonomySession.TermStores["Managed Metadata Service"]; termStore = taxonomySession.DefaultSiteCollectionTermStore; Group GroupTerm = termStore.CreateGroup("BreakThroughProcertProjectsTracking"); TermSet termset = GroupTerm.CreateTermSet("Tags"); termStore.CommitAll(); TaxonomyField taxonomyField = list.Fields.CreateNewField("TaxonomyFieldType", "Tags") as TaxonomyField; taxonomyField.AllowMultipleValues = true; list.Fields.Add(taxonomyField); TaxonomyField field = list.Fields["Tags"] as TaxonomyField; field.Title = "Tags"; field.Update(true); taxonomyField.SspId = termset.Id; field.Update(true); } } list.Update(); web.AllowUnsafeUpdates = false; } } catch (Exception ex) { // ULSLogger.LogErrorInULS(ex.Message, TraceSeverity.Unexpected); } return(list); }
private SPList EnsureGlymaExportsList() { bool isNewList = false; SPList list = Site.EnsureList(GlymaLists.GlymaExportsList, ref isNewList); SPField titleColumn = list.Fields[SPBuiltInFieldId.Title]; titleColumn.Indexed = true; titleColumn.Title = "WorkItem ID"; titleColumn.EnforceUniqueValues = true; titleColumn.Update(); bool isNewColumn = false; SPField exportStatus = list.EnsureColumn(GlymaColumns.ExportStatus, false, ref isNewColumn); exportStatus.Required = true; exportStatus.Update(); isNewColumn = false; SPField exportType = list.EnsureColumn(GlymaColumns.ExportType, false, ref isNewColumn); exportType.Required = true; exportType.Update(); isNewColumn = false; SPField mapType = list.EnsureColumn(GlymaColumns.MapType, false, ref isNewColumn); mapType.Required = true; mapType.Update(); isNewColumn = false; SPField percentageCompletedField = list.EnsureColumn(GlymaColumns.PercentageComplete, false, ref isNewColumn); SPFieldNumber percentComplete = percentageCompletedField as SPFieldNumber; percentComplete.Required = true; percentComplete.ShowAsPercentage = true; percentComplete.MaximumValue = 1; percentComplete.MinimumValue = 0; percentComplete.Update(); isNewColumn = false; SPField domainUid = list.EnsureColumn(GlymaColumns.DomainUid, false, ref isNewColumn); domainUid.Required = true; domainUid.Update(); isNewColumn = false; SPField rootMapUid = list.EnsureColumn(GlymaColumns.RootMapUid, false, ref isNewColumn); rootMapUid.Required = true; rootMapUid.Update(); isNewColumn = false; SPField exportPropertiesField = list.EnsureColumn(GlymaColumns.ExportProperties, false, ref isNewColumn); SPFieldMultiLineText exportProperties = exportPropertiesField as SPFieldMultiLineText; exportProperties.Required = false; exportProperties.AppendOnly = false; exportProperties.RichText = false; exportProperties.Update(); isNewColumn = false; SPField logMessagesField = list.EnsureColumn(GlymaColumns.LogMessages, false, ref isNewColumn); SPFieldMultiLineText logMessages = logMessagesField as SPFieldMultiLineText; logMessages.Required = false; logMessages.AppendOnly = true; logMessages.RichText = false; logMessages.Update(); SPField lastModifiedField = list.Fields[SPBuiltInFieldId.Modified]; // Configure the default view for the list. SPView defaultView = list.DefaultView; defaultView.ViewFields.DeleteAll(); defaultView.ViewFields.Add(titleColumn); defaultView.ViewFields.Add(exportStatus); defaultView.ViewFields.Add(exportType); defaultView.ViewFields.Add(mapType); defaultView.ViewFields.Add(percentComplete); defaultView.ViewFields.Add(domainUid); defaultView.ViewFields.Add(rootMapUid); defaultView.ViewFields.Add(exportProperties); defaultView.ViewFields.Add(logMessages); defaultView.Query = "<OrderBy><FieldRef Name=\"" + lastModifiedField.InternalName + "\" Ascending=\"FALSE\" /></OrderBy>"; defaultView.Update(); return(list); }
public static string GetRichTextMode(this SPFieldMultiLineText field) { return(field.RichTextMode.ToString()); }
public void LoadDetails() { try { using (var site = new SPSite(SPContext.Current.Site.Url)) { using (var web = site.OpenWeb()) { var leavestatus = new DataTable(); leavestatus.Columns.Add("Id"); leavestatus.Columns.Add("RequestedFrom"); leavestatus.Columns.Add("Leave Type"); leavestatus.Columns.Add("Starting Date"); leavestatus.Columns.Add("Employee Type"); leavestatus.Columns.Add("Ending Date"); leavestatus.Columns.Add("Duration"); leavestatus.Columns.Add("Reason"); leavestatus.Columns.Add("Remarks"); leavestatus.Columns.Add("Status"); var emplist = web.Lists.TryGetList(Utilities.LeaveRequest); if (emplist != null) { SPUser user = web.CurrentUser; string currentUser = user.Name; SPListItemCollection currentUserDetails; if (IsMemberInGroup("Admin")) { currentUserDetails = GetListItemCollection(emplist, "Status", "Pending", "Year", hdnCurrentYear.Value, "Employee Status", "Active"); } else { currentUserDetails = GetListItemCollection(emplist, "RequestedTo", currentUser, "Status", "Pending", "Year", hdnCurrentYear.Value, "Employee Status", "Active"); } if (currentUserDetails.Count > 0) { foreach (SPListItem item in currentUserDetails) { var spv = new SPFieldLookupValue(item["RequestedFrom"].ToString()); DataRow dataRow = leavestatus.NewRow(); dataRow["Id"] = item.ID; dataRow["RequestedFrom"] = spv.LookupValue;//item["RequestedFrom"].ToString(); dataRow["Leave Type"] = item["Leave Type"].ToString(); //dataRow["Applied Date"] = item["Starting Date"].ToString(); dataRow["Starting Date"] = DateTime.Parse(item["Starting Date"].ToString()).ToShortDateString(); dataRow["Ending Date"] = DateTime.Parse(item["Ending Date"].ToString()).ToShortDateString(); dataRow["Duration"] = item["Leave Days"].ToString(); if (item["Purpose of Leave"] != null) { SPFieldMultiLineText mlt = item.Fields.GetField("Purpose of Leave") as SPFieldMultiLineText; dataRow["Reason"] = mlt.GetFieldValueAsText(item["Purpose of Leave"]); } //dataRow["Reason"] = (item["Purpose of Leave"] == null) ? "" : item["Purpose of Leave"].ToString(); dataRow["Remarks"] = (item["Remarks"] == null) ? "" : item["Remarks"].ToString(); //dataRow["App/Rej by Remarks"] = item.ToString(); dataRow["Status"] = item["Status"].ToString(); leavestatus.Rows.Add(dataRow); } } else { BtnApprove.Visible = false; BtnReject.Visible = false; // lblErr.Text = "No records found"; } } DataView dataView = new DataView(leavestatus); dataView.Sort = "Id DESC"; //grid.DataSource = leavestatus; //grid.DataBind(); ViewState["Results"] = leavestatus; } } } catch (Exception ex) { lblErr.Text = ex.Message; } }
internal static string GetExportValue(SPWeb exportWeb, object val, SPField field, string locale, bool forceDate, string mulSep) { string colVal; int pos; DateTime dtVal; SPFieldDateTime dtField = field as SPFieldDateTime; SPFieldLookup pgField = field as SPFieldLookup; SPFieldMultiLineText rtField = field as SPFieldMultiLineText; SPFieldMultiChoiceValue mcv; XmlDocument doc; if (field is SPFieldCalculated) { val = ((SPFieldCalculated)field).GetFieldValueAsText(val); } if (field is SPFieldUrl) { val = ((SPFieldUrl)field).GetFieldValue(val + string.Empty); } if (forceDate && (DateTime.TryParse(val + string.Empty, out dtVal) || DateTime.TryParse(val + string.Empty, JsonSchemaManager.Property.Type.LocaleChoice.GetCulture(locale), DateTimeStyles.AllowWhiteSpaces, out dtVal))) { val = dtVal; } if ((val is DateTime) && ((dtField != null) || forceDate)) { colVal = ((DateTime)val).ToString((dtField == null) ? "m" : ((dtField.DisplayFormat == SPDateTimeFieldFormatType.DateOnly) ? "d" : "g"), JsonSchemaManager.Property.Type.LocaleChoice.GetCulture(locale)); } else if (val is SPFieldUrlValue) { colVal = ((SPFieldUrlValue)val).Url; } else if (val is SPFieldLookupValueCollection) { colVal = string.Join(mulSep, ((SPFieldLookupValueCollection)val).ConvertAll <string> ((lv) => { return(lv.LookupValue); }).ToArray()); } else if (val is SPFieldLookupValue) { colVal = ((SPFieldLookupValue)val).LookupValue; } else if ((mcv = val as SPFieldMultiChoiceValue) != null) { colVal = string.Empty; for (int i = 0; i < mcv.Count; i++) { colVal += (mulSep + mcv [i]); } if (colVal.Length > mulSep.Length) { colVal = colVal.Substring(mulSep.Length); } } else if (((pgField = field as SPFieldLookup) != null) || (((rtField = field as SPFieldMultiLineText) != null) && rtField.RichText)) { colVal = val + string.Empty; if (pgField != null) { if ((pos = colVal.IndexOf(";#", StringComparison.InvariantCultureIgnoreCase)) >= 0) { colVal = colVal.Substring(pos + 2); } if ((pos = colVal.IndexOf(";#")) > 0) { colVal = colVal.Substring(0, pos); } } colVal = htmlRegex.Replace(colVal.Replace(WEIRD_CHAR, string.Empty).Replace("<br>", "\r\n").Replace("<BR>", "\r\n").Replace("<br/>", "\r\n").Replace("<BR/>", "\r\n").Replace("<br />", "\r\n").Replace("<BR />", "\r\n"), string.Empty); } else { colVal = val + string.Empty; } if (colVal.StartsWith("<roxhtml/>")) { colVal = htmlRegex.Replace(colVal.Substring("<roxhtml/>".Length).Replace(WEIRD_CHAR, string.Empty).Replace("<br>", "\r\n").Replace("<BR>", "\r\n").Replace("<br/>", "\r\n").Replace("<BR/>", "\r\n").Replace("<br />", "\r\n").Replace("<BR />", "\r\n"), string.Empty); try { doc = new XmlDocument(); doc.LoadXml(colVal); colVal = doc.DocumentElement.InnerText; } catch { } colVal = colVal.Replace('\r', ' ').Replace('\n', ' ').Trim(); } return(colVal); }
private void LoadLeaveDetails() { DataTable leavetable = LeavestableStructure(); try { using (var site = new SPSite(SPContext.Current.Site.Url)) { using (var web = site.OpenWeb()) { var leaveList = web.Lists.TryGetList(Utilities.LeaveRequest); if (leaveList != null) { SPUser user = web.CurrentUser; string currentUser = user.Name; SPListItemCollection currentUserDetails; currentUserDetails = GetListItemCollection(leaveList, "RequestedFrom", currentUser, "Year", hdnCurrentYear.Value, "Employee Status", "Active"); if (currentUserDetails.Count > 0) { // var itemCollection = leaveList.Items; foreach (SPListItem spListItem in currentUserDetails) { DataRow dataRow = leavetable.NewRow(); var requestedto = new SPFieldLookupValue(spListItem["RequestedTo"].ToString()); dataRow["Requested To"] = requestedto.LookupValue; dataRow["Leave Type"] = spListItem[Utilities.LeaveType].ToString(); dataRow["Starting Date"] = DateTime.Parse(spListItem[Utilities.StartingDate].ToString()).ToShortDateString(); dataRow["Ending Date"] = DateTime.Parse(spListItem[Utilities.EndingDate].ToString()).ToShortDateString(); dataRow["Leave Days"] = spListItem[Utilities.LeaveDays].ToString(); if (spListItem[Utilities.Remarks] != null) { dataRow["Remarks"] = spListItem[Utilities.Remarks].ToString(); } dataRow["Status"] = spListItem[Utilities.Status].ToString(); if (spListItem["Purpose of Leave"] != null) { SPFieldMultiLineText mlt = spListItem.Fields.GetField("Purpose of Leave") as SPFieldMultiLineText; dataRow["Reason"] = mlt.GetFieldValueAsText(spListItem["Purpose of Leave"]); } string url = "'" + site.Url + "/Pages/CancelLeaves.aspx?LeaveId=" + spListItem.ID + "'"; if (spListItem[Utilities.Status].ToString() == "Pending") { dataRow["Cancel"] = "<a href=\"JavaScript:openDialog(" + url + ");\">Cancel</a>"; } leavetable.Rows.Add(dataRow); } } DataView dataView = new DataView(leavetable); dataView.Sort = "Starting Date DESC"; ViewState["Result"] = dataView.Table; } } } } catch (Exception ex) { lblErr.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { culture = CultureInfo.CurrentUICulture.TwoLetterISOLanguageName; if (!string.IsNullOrEmpty(Convert.ToString(Request.QueryString["AttachmentColumn"]))) { AttachedColumn = Convert.ToString(Request.QueryString["AttachmentColumn"]); } if (!string.IsNullOrEmpty(Convert.ToString(Request.QueryString["ItemId"]))) { itemId = Convert.ToString(Request.QueryString["ItemId"]); } TasksVariables(); try { if (!Page.IsPostBack) { string urlSite = SPContext.Current.Web.Url; string COLUMN_NAME = AttachedColumn; using (SPSite currentsite = new SPSite(urlSite)) { using (SPWeb DestWeb = currentsite.OpenWeb()) { SPList listdata = DestWeb.Lists[new Guid(Request.QueryString["ListId"])]; SPListItem listitemtoadd = listdata.GetItemById(Convert.ToInt16(Convert.ToString(Request.QueryString["ItemId"]))); SPFieldMultiLineText multilineField = listitemtoadd.Fields.GetField(COLUMN_NAME) as SPFieldMultiLineText; if (multilineField != null) { // Get the field value as HTML string text = multilineField.GetFieldValueAsHtml(listitemtoadd[COLUMN_NAME], listitemtoadd); if (!string.IsNullOrEmpty(text)) { string sharePointNewLine = "<br/>"; XmlDocument doc = new XmlDocument(); //string finalHtml=divAttachments.InnerHtml.fi string attachmentHTML = "<div>" + text + "</div>"; doc.LoadXml(attachmentHTML); XmlNodeList nodeList = doc.GetElementsByTagName("a"); string newhtml = string.Empty; DataTable dtActionLog = new DataTable(); DataColumn c1 = new DataColumn("link", typeof(string)); dtActionLog.Columns.Add(c1); foreach (XmlNode node in nodeList) { DataRow drw = dtActionLog.NewRow(); drw[0] = node.InnerXml; dtActionLog.Rows.Add(drw); dtActionLog.AcceptChanges(); } grdview.DataSource = dtActionLog; grdview.DataBind(); } else { lblerror.Text = "No Attachment Found."; btnsave.Style["Display"] = "none"; trerror.Style["Display"] = ""; btnRemoveFile.Style["Display"] = "none"; } } } } GetConfigurations(AttachedColumn, itemId); if (isallowDeletionoffiles) { btnRemoveFile.Visible = true; } else { btnRemoveFile.Visible = false; } } } catch (Exception ex) { } }
private static string GetFieldType(SPField oField, out string senum, out string senumkeys, out string sFormat, out string sRange, SPWeb oWeb) { var currencyFormatDictionary = new Dictionary <int, string> { { 0, "$n" }, { 1, "n$" }, { 2, "$ n" }, { 3, "n $" } }; senum = ""; senumkeys = ""; sFormat = ""; sRange = ""; switch (oField.Type) { case SPFieldType.Boolean: return("Bool"); case SPFieldType.DateTime: SPFieldDateTime oDTField = (SPFieldDateTime)oField; string dateFormat = GetExampleDateFormat(oWeb, "yyyy", "M", "d"); sFormat = oDTField.GetProperty("Format").Equals("DateOnly") ? dateFormat : string.Format("{0} h:mm tt", dateFormat); return("Date"); case SPFieldType.Currency: var currenvyCultureInfo = new CultureInfo(((SPFieldCurrency)oField).CurrencyLocaleId); NumberFormatInfo numberFormatInfo = currenvyCultureInfo.NumberFormat; sFormat = currencyFormatDictionary[numberFormatInfo.CurrencyPositivePattern] .Replace("$", numberFormatInfo.CurrencySymbol) .Replace("n", string.Format(",0.{0}", new string('0', numberFormatInfo.CurrencyDecimalDigits))); return("Float"); case SPFieldType.Note: SPFieldMultiLineText field = (SPFieldMultiLineText)oField; if (field.RichText) { return("Html"); } else { return("Lines"); } case SPFieldType.Number: string percentageSign = string.Empty; if (((SPFieldNumber)oField).ShowAsPercentage) { //sFormat = "0\\%;0\\%;0\\%"; return("Float"); } switch (((SPFieldNumber)oField).DisplayFormat) { case SPNumberFormatTypes.Automatic: sFormat = ",#0.##########" + percentageSign; break; case SPNumberFormatTypes.NoDecimal: sFormat = ",#0" + percentageSign; break; case SPNumberFormatTypes.OneDecimal: sFormat = ",#0.0" + percentageSign; break; case SPNumberFormatTypes.TwoDecimals: sFormat = ",#0.00" + percentageSign; break; case SPNumberFormatTypes.ThreeDecimals: sFormat = ",#0.000" + percentageSign; break; case SPNumberFormatTypes.FourDecimals: sFormat = ",#0.0000" + percentageSign; break; case SPNumberFormatTypes.FiveDecimals: sFormat = ",#0.00000" + percentageSign; break; } return("Float"); case SPFieldType.Choice: SPFieldChoice oCField = (SPFieldChoice)oField; foreach (string sChoice in oCField.Choices) { senum += ";" + sChoice; } return("Enum"); case SPFieldType.Lookup: SPFieldLookup oLField = (SPFieldLookup)oField; if (oLField.AllowMultipleValues) { sRange = "1"; } SPList oLookupList = oWeb.Lists[new Guid(oLField.LookupList)]; foreach (SPListItem li in oLookupList.Items) { senum += ";" + li.Title.Replace(";", ""); senumkeys += ";" + li.ID; } return("Enum"); case SPFieldType.MultiChoice: SPFieldMultiChoice oMCField = (SPFieldMultiChoice)oField; foreach (string sChoice in oMCField.Choices) { senum += ";" + sChoice; } sRange = "1"; return("Enum"); case SPFieldType.User: DataTable dtResources = EPMLiveCore.API.APITeam.GetResourcePool("<Pool><Columns>SimpleColumns</Columns></Pool>", oWeb); foreach (DataRow dr in dtResources.Rows) { senum += ";" + dr["Title"].ToString(); senumkeys += ";" + dr["SPID"].ToString(); } SPFieldUser oUField = (SPFieldUser)oField; if (oUField.AllowMultipleValues) { sRange = "1"; } return("Enum"); default: return("Text"); } }
private void LoadLeaves(string leaveId) { try { hdnLeaveId.Value = leaveId; using (var site = new SPSite(SPContext.Current.Site.Url)) { using (var web = site.OpenWeb()) { var leavelist = web.Lists.TryGetList(Utilities.LeaveRequest); var emplist = web.Lists.TryGetList(Utilities.EmployeeScreen); var levitem = leavelist.GetItemById(Convert.ToInt16(leaveId)); var spv = new SPFieldLookupValue(levitem["RequestedTo"].ToString()); SPUser user = new SPFieldUserValue(web, levitem["RequestedFrom"].ToString()).User; SPListItemCollection empDetails = GetListItemCollection(emplist, "Employee Name", user.Name); hdnCurrentUsername.Value = user.Name; foreach (SPListItem empDetail in empDetails) { lblEmpID.Text = empDetail["Title"].ToString(); lblDepartment.Text = empDetail["Department"].ToString(); lblDesgination.Text = empDetail["Designation"].ToString(); } txtDuration.InnerText = levitem["Leave Days"].ToString(); hdnLeaveDuration.Value = levitem["Leave Days"].ToString(); if (levitem["Purpose of Leave"] != null) { SPFieldMultiLineText mlt = levitem.Fields.GetField("Purpose of Leave") as SPFieldMultiLineText; txtPurpose.Text = mlt.GetFieldValueAsText(levitem["Purpose of Leave"]); } ddlTypeofLeave.SelectedItem.Text = levitem["Leave Type"].ToString().Trim(); if (levitem["Leave Type"].ToString().Trim() != "Optional") { Selecteddates.Visible = true; optinalDates.Visible = false; } else { txtOptionalLeaves.Text = DateTime.Parse(levitem["Starting Date"].ToString()).ToShortDateString(); Selecteddates.Visible = false; optinalDates.Visible = true; } ddlReportingTo.Text = spv.LookupValue; dateTimeEndDate.SelectedDate = DateTime.Parse(levitem["Ending Date"].ToString()); dateTimeStartDate.SelectedDate = DateTime.Parse(levitem["Starting Date"].ToString()); hdnStrtDate.Value = DateTime.Parse(levitem["Starting Date"].ToString()).ToString(CultureInfo.InvariantCulture); hdnEndDate.Value = DateTime.Parse(levitem["Ending Date"].ToString()).ToString(CultureInfo.InvariantCulture); ddlTypeofLeave.Enabled = false; } } } catch (Exception ex) { lblError.Text = ex.Message; } }