public ArtDevField CreateFieldText(string Name)
{
SPFieldText Field = NewOrRefText(Name);
ArtDevField ArtDevField = new ArtDevField(Field);
return(ArtDevField);
}
/// <summary>
///
/// </summary>
/// <param name="web"></param>
/// <param name="group"></param>
/// <param name="description"></param>
/// <param name="name"></param>
/// <param name="displayName"></param>
/// <param name="maxLength"></param>
public static void CreateTextColumn(this SPWeb web, string group, string description, string name, string displayName, int maxLength = 255)
{
try
{
if (!web.Fields.ContainsField(name))
{
string fieldName = web.Fields.Add(name, SPFieldType.Text, false);
SPFieldText field = (SPFieldText)web.Fields.GetField(name);
field.Group = group;
field.MaxLength = maxLength;
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:CreateTextColumn. MESSAGE: {0}. EXCEPTION TRACE: {1} ", ex.Message, ex.StackTrace), ex.StackTrace);
}
}
private static void Create_SPFieldText(SPList list, string targetColumn)
{
SPFieldText f = (SPFieldText)list.Fields.CreateNewField(SPFieldType.Text.ToString(), targetColumn);
list.Fields.Add(f);
list.Update();
}
public SPFieldText NewOrRefText(string Name)
{
string TextName = this.Web().Fields.ContainsField(Name) ? Name : web.Fields.Add(Name, SPFieldType.Text, false);
SPFieldText TextField = (SPFieldText)web.Fields.GetFieldByInternalName(TextName);
TextField.Group = this.columnGroup;
return(TextField);
}
private void EnsureTextFieldExists(SPList extendedList, string fieldName, bool showInEdit)
{
if (!extendedList.Fields.ContainsField(fieldName))
{
extendedList.Fields.Add(fieldName, SPFieldType.Text, false);
SPFieldText textField = extendedList.Fields[fieldName] as SPFieldText;
textField.Hidden = false; //!showInEdit;
textField.ShowInEditForm = showInEdit;
textField.Update();
extendedList.Update();
}
}
//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 void processResource(SPWeb web, Guid resGuid, SPWeb resWeb)
{
WebSvcResource.ResourceDataSet rds = pResource.ReadResource(resGuid);
try
{
SPUser user = null;
SPGroup group = null;
if (!rds.Resources[0].IsWRES_ACCOUNTNull())
{
try
{
user = resWeb.SiteUsers[rds.Resources[0].WRES_ACCOUNT];
}
catch { }
if (user == null)
{
string email = "";
if (!rds.Resources[0].IsWRES_EMAILNull())
{
email = rds.Resources[0].WRES_EMAIL;
}
resWeb.SiteUsers.Add(rds.Resources[0].WRES_ACCOUNT, email, rds.Resources[0].RES_NAME, "");
user = resWeb.SiteUsers[rds.Resources[0].WRES_ACCOUNT];
}
}
else
{
try
{
group = resWeb.SiteGroups[rds.Resources[0].RES_NAME];
}
catch { }
}
SPList list = resWeb.Lists["Resources"];
if (!list.Fields.ContainsField("ResUid"))
{
SPFieldText fldResUid = (SPFieldText)list.Fields.CreateNewField(SPFieldType.Text.ToString(), "ResUid");
fldResUid.Hidden = true;
fldResUid.Required = false;
list.Fields.Add(fldResUid);
list.Update();
}
DataRow [] drFields = rds.ResourceCustomFields.Select("RES_UID='" + rds.Resources[0].RES_UID + "'");
foreach (DataRow drField in drFields)
{
try
{
string fname = "ENT" + drField["MD_PROP_ID"];
if (!list.Fields.ContainsField(fname))
{
addField(list, drField["MD_PROP_ID"].ToString(), drField["FIELD_TYPE_ENUM"].ToString());
}
}
catch { }
}
SPQuery query = new SPQuery();
if (user != null)
{
query.Query = "<Where><Eq><FieldRef Name='SharePointAccount'/><Value Type='User'>" + user.Name + "</Value></Eq></Where>";
}
else if (group != null)
{
query.Query = "<Where><Eq><FieldRef Name='SharePointAccount'/><Value Type='User'>" + group.Name + "</Value></Eq></Where>";
}
else
{
query.Query = "<Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + rds.Resources[0].RES_NAME + "</Value></Eq></Where>";
}
SPListItemCollection lic = list.GetItems(query);
SPListItem li = null;
if (lic.Count > 0)
{
li = lic[0];
}
else
{
li = list.Items.Add();
}
if (user != null)
{
li["SharePointAccount"] = new SPFieldUserValue(resWeb, user.ID, user.Name);
}
if (group != null)
{
li["SharePointAccount"] = new SPFieldUserValue(resWeb, group.ID, group.Name);
}
li["ResUid"] = resGuid.ToString();
if (li != null)
{
string name = rds.Resources[0].RES_NAME;
string firstname = "";
try
{
firstname = name.Split(' ')[0];
}
catch { }
string lastname = "";
try
{
lastname = name.Substring(firstname.Length + 1);
}
catch { }
li["Title"] = rds.Resources[0].RES_NAME;
li["FirstName"] = firstname;
li["LastName"] = lastname;
if (!rds.Resources[0].IsWRES_EMAILNull())
{
li["Email"] = rds.Resources[0].WRES_EMAIL;
}
if (!rds.Resources[0].IsRES_TIMESHEET_MGR_UIDNull())
{
if (rds.Resources[0].RES_TIMESHEET_MGR_UID != rds.Resources[0].RES_UID)
{
WebSvcResource.ResourceDataSet tsRds = pResource.ReadResource(rds.Resources[0].RES_TIMESHEET_MGR_UID);
if (tsRds.Resources.Count > 0)
{
try
{
SPUser tuser = null;
try
{
tuser = resWeb.SiteUsers[tsRds.Resources[0].WRES_ACCOUNT];
}
catch { }
if (tuser == null)
{
resWeb.SiteUsers.Add(tsRds.Resources[0].WRES_ACCOUNT, tsRds.Resources[0].WRES_EMAIL, tsRds.Resources[0].RES_NAME, "");
tuser = resWeb.SiteUsers[tsRds.Resources[0].WRES_ACCOUNT];
}
li["TimesheetManager"] = new SPFieldUserValue(resWeb, tuser.ID, tuser.Name);
}
catch { }
}
}
}
foreach (DataRow drField in drFields)
{
try
{
string fname = "ENT" + drField["MD_PROP_ID"];
if (list.Fields.ContainsField(fname))
{
string fVal = getfieldvalue(drField);
li[list.Fields.GetFieldByInternalName("ENT" + drField["MD_PROP_ID"]).Id] = fVal;
}
}
catch { }
}
li.SystemUpdate();
}
}
catch { }
}
