public static SPFieldMultiChoiceValue TypeToValue(int value)
{
var res = new SPFieldMultiChoiceValue();
if (((value & (int)TemplateTypeEnum.AllItemEvents) == (int)TemplateTypeEnum.AllItemEvents))
{
res.Add(TemplateCT.TypeChoices.All);
}
else
{
if (((value & (int)TemplateTypeEnum.ItemAdded) == (int)TemplateTypeEnum.ItemAdded))
{
res.Add(TemplateCT.TypeChoices.ItemAdded);
}
if (((value & (int)TemplateTypeEnum.ItemRemoved) == (int)TemplateTypeEnum.ItemRemoved))
{
res.Add(TemplateCT.TypeChoices.ItemRemoved);
}
if (((value & (int)TemplateTypeEnum.ItemUpdated) == (int)TemplateTypeEnum.ItemUpdated))
{
res.Add(TemplateCT.TypeChoices.ItemUpdated);
}
}
return(res);
}
protected override void MapProperties(object modelHost, Hashtable fileProperties, ContentPageDefinitionBase definition)
{
base.MapProperties(modelHost, fileProperties, definition);
var typedDefinition = definition.WithAssertAndCast<FilterDisplayTemplateDefinition>("model", value => value.RequireNotNull());
fileProperties[BuiltInInternalFieldNames.ContentTypeId] = "0x0101002039C03B61C64EC4A04F5361F38510660400F643FF79F6BD764F8A469B6F153396EE";
if (!string.IsNullOrEmpty(typedDefinition.CrawlerXSLFileURL))
{
var crawlerXSLFileValue = new SPFieldUrlValue { Url = typedDefinition.CrawlerXSLFileURL };
if (!string.IsNullOrEmpty(typedDefinition.CrawlerXSLFileDescription))
crawlerXSLFileValue.Description = typedDefinition.CrawlerXSLFileDescription;
fileProperties["CrawlerXSLFile"] = crawlerXSLFileValue.ToString();
}
if (!string.IsNullOrEmpty(typedDefinition.CompatibleManagedProperties))
fileProperties["CompatibleManagedProperties"] = typedDefinition.CompatibleManagedProperties;
if (typedDefinition.CompatibleSearchDataTypes.Count > 0)
{
var multiChoiceValue = new SPFieldMultiChoiceValue();
foreach (var value in typedDefinition.CompatibleSearchDataTypes)
multiChoiceValue.Add(value);
fileProperties["CompatibleSearchDataTypes"] = multiChoiceValue.ToString();
}
}
protected override void MapProperties(object modelHost, Hashtable fileProperties, ContentPageDefinitionBase definition)
{
base.MapProperties(modelHost, fileProperties, definition);
var typedTemplateModel = definition.WithAssertAndCast <ItemControlTemplateDefinitionBase>("model", value => value.RequireNotNull());
if (typedTemplateModel.TargetControlTypes.Count > 0)
{
var multiChoiceValue = new SPFieldMultiChoiceValue();
foreach (var value in typedTemplateModel.TargetControlTypes)
{
multiChoiceValue.Add(value);
}
fileProperties["TargetControlType"] = multiChoiceValue.ToString();
}
if (!string.IsNullOrEmpty(typedTemplateModel.PreviewURL))
{
var htmlPreviewValue = new SPFieldUrlValue {
Url = typedTemplateModel.PreviewURL
};
if (!string.IsNullOrEmpty(typedTemplateModel.PreviewDescription))
{
htmlPreviewValue.Description = typedTemplateModel.PreviewDescription;
}
fileProperties["HtmlDesignPreviewUrl"] = htmlPreviewValue.ToString();
}
}
protected override void MapProperties(object modelHost, Hashtable fileProperties, ContentPageDefinitionBase definition)
{
base.MapProperties(modelHost, fileProperties, definition);
var typedTemplateModel = definition.WithAssertAndCast<ItemControlTemplateDefinitionBase>("model", value => value.RequireNotNull());
if (typedTemplateModel.TargetControlTypes.Count > 0)
{
var multiChoiceValue = new SPFieldMultiChoiceValue();
foreach (var value in typedTemplateModel.TargetControlTypes)
multiChoiceValue.Add(value);
fileProperties["TargetControlType"] = multiChoiceValue.ToString();
}
if (!string.IsNullOrEmpty(typedTemplateModel.PreviewURL))
{
var htmlPreviewValue = new SPFieldUrlValue { Url = typedTemplateModel.PreviewURL };
if (!string.IsNullOrEmpty(typedTemplateModel.PreviewDescription))
htmlPreviewValue.Description = typedTemplateModel.PreviewDescription;
fileProperties["HtmlDesignPreviewUrl"] = htmlPreviewValue.ToString();
}
}
private static SPFieldMultiChoiceValue CreateMultiValue(string input)
{
SPFieldMultiChoiceValue values = new SPFieldMultiChoiceValue();
values.Add(input);
return(values);
}
private void OnMultiChoiceValueChanged(object sender, string fieldName)
{
SPFieldMultiChoiceValue collection = new SPFieldMultiChoiceValue();
foreach (string item in (IEnumerable)sender)
{
collection.Add(item);
}
this[fieldName] = collection.ToString();
}
public static void ReadFrom(this SPFieldMultiChoiceValue choiceValue, string[] values)
{
if (values != null)
{
for (int x = 0; x < values.Length; x++)
{
choiceValue.Add(values[x]);
}
}
}
/// <summary>
/// Formats the value for SpFieldChoice
/// </summary>
/// <param name="input">List of values to insert</param>
/// <returns></returns>
public SPFieldMultiChoiceValue FormatValuesForMultiChoice(List <string> input)
{
var multiChoiceValue = new SPFieldMultiChoiceValue();
foreach (string s in input)
{
multiChoiceValue.Add(s);
}
return(multiChoiceValue);
}
internal static void Set_SPFieldMultiChoiceValue(SPListItem item, string col, System.Collections.ArrayList komponenty)
{
SPFieldMultiChoiceValue fmcv = new SPFieldMultiChoiceValue();
foreach (string s in komponenty)
{
fmcv.Add(s);
}
item[col] = fmcv;
}
public object ToSpValue(object value)
{
if (value == null)
return null;
var strings = ((IEnumerable<string>) value).ToList();
var fieldValues = new SPFieldMultiChoiceValue();
strings.ForEach(s => fieldValues.Add(s));
return fieldValues;
}
protected override void MapProperties(object modelHost, System.Collections.Hashtable fileProperties, ContentPageDefinitionBase definition)
{
var typedTemplateModel = definition.WithAssertAndCast<MasterPagePreviewDefinition>("model", value => value.RequireNotNull());
fileProperties[BuiltInInternalFieldNames.ContentTypeId] = BuiltInContentTypeId.MasterPagePreview;
if (typedTemplateModel.UIVersion.Count > 0)
{
var value = new SPFieldMultiChoiceValue();
foreach (var v in typedTemplateModel.UIVersion)
value.Add(v);
fileProperties["UIVersion"] = value.ToString();
}
}
protected override void MapProperties(object modelHost, Hashtable fileProperties, ContentPageDefinitionBase definition)
{
var typedDefinition = definition.WithAssertAndCast<WebPartGalleryFileDefinition>("model", value => value.RequireNotNull());
if (!string.IsNullOrEmpty(typedDefinition.Group))
fileProperties["Group"] = typedDefinition.Group;
if (!string.IsNullOrEmpty(typedDefinition.Description))
fileProperties["WebPartDescription"] = typedDefinition.Description;
var recSettingsValue = new SPFieldMultiChoiceValue();
foreach (var value in typedDefinition.RecommendationSettings)
recSettingsValue.Add(value);
fileProperties["QuickAddGroups"] = recSettingsValue.ToString();
}
protected override void MapProperties(object modelHost, Hashtable fileProperties, ContentPageDefinitionBase definition)
{
var typedDefinition = definition.WithAssertAndCast <WebPartGalleryFileDefinition>("model", value => value.RequireNotNull());
if (!string.IsNullOrEmpty(typedDefinition.Group))
{
fileProperties["Group"] = typedDefinition.Group;
}
if (!string.IsNullOrEmpty(typedDefinition.Description))
{
fileProperties["WebPartDescription"] = typedDefinition.Description;
}
var recSettingsValue = new SPFieldMultiChoiceValue();
foreach (var value in typedDefinition.RecommendationSettings)
{
recSettingsValue.Add(value);
}
fileProperties["QuickAddGroups"] = recSettingsValue.ToString();
}
private static object ConvertToMultiChoiceValue(string[] values)
{
var value = new SPFieldMultiChoiceValue();
if (values != null)
foreach (string val in values)
value.Add(val);
return value;
}
/// <summary>
/// Update SPListItem with correcsponding data parse from actions.
/// </summary>
/// <param name="item"></param>
/// <param name="updatedField"></param>
/// <param name="data"></param>
private void DoUpdateItem(SPListItem item, SPField updatedField, string data)
{
switch (updatedField.Type)
{
case SPFieldType.Boolean:
item[updatedField.Id] = Convert.ToBoolean(data);
break;
case SPFieldType.File:
case SPFieldType.Calculated:
case SPFieldType.Computed:
case SPFieldType.Currency:
case SPFieldType.Integer:
case SPFieldType.Note:
case SPFieldType.Number:
case SPFieldType.Text:
item[updatedField.Id] = data;
break;
case SPFieldType.Choice:
SPFieldChoice fieldChoice = (SPFieldChoice)updatedField;
item[updatedField.Id] = data;
break;
case SPFieldType.DateTime:
SPFieldDateTime fieldDate = (SPFieldDateTime)updatedField;
item[updatedField.Id] = Convert.ToDateTime(data);
break;
case SPFieldType.Lookup:
SPFieldLookup fieldLookup = (SPFieldLookup)updatedField;
if (fieldLookup.AllowMultipleValues)
{
SPFieldLookupValueCollection multiValues = new SPFieldLookupValueCollection();
foreach (var s in data.Split("|".ToCharArray()))
{
multiValues.Add(new SPFieldLookupValue(s));
}
item[updatedField.Id] = multiValues;
}
else
{
//int id = fieldLookup.GetLookupIdFromValue(data);
SPFieldLookupValue singleLookupValue = new SPFieldLookupValue(data);
item[updatedField.Id] = singleLookupValue;
}
break;
case SPFieldType.MultiChoice:
SPFieldMultiChoice fieldMultichoice = (SPFieldMultiChoice)updatedField;
string [] items = data.Split("|".ToCharArray());
SPFieldMultiChoiceValue values = new SPFieldMultiChoiceValue();
foreach (string choice in items)
{
values.Add(choice);
}
item[updatedField.Id] = values;
break;
case SPFieldType.User:
SPFieldUser fieldUser = (SPFieldUser)updatedField;
SPFieldUserValueCollection fieldValues = new SPFieldUserValueCollection();
string[] entities = data.Split("|".ToCharArray());
foreach (string entity in entities)
{
SPUser user = item.Web.EnsureUser(entity.Split(";#".ToCharArray())[2]);
if(user!= null)
fieldValues.Add(new SPFieldUserValue(item.Web, user.ID, user.Name));
}
item[updatedField.Id] = fieldValues;
break;
case SPFieldType.Invalid:
if (string.Compare(updatedField.TypeAsString, Constants.LOOKUP_WITH_PICKER_TYPE_NAME, true) == 0)
{
item[updatedField.Id] = data;
}
break;
}
}
private void DeployPage(object modelHost, SPList list, SPFolder folder, MasterPageDefinition definition)
{
var web = list.ParentWeb;
var targetPage = GetCurrentObject(folder, definition);
InvokeOnModelEvent(this, new ModelEventArgs
{
CurrentModelNode = null,
Model = null,
EventType = ModelEventType.OnProvisioning,
Object = targetPage == null ? null : targetPage.File,
ObjectType = typeof(SPFile),
ObjectDefinition = definition,
ModelHost = modelHost
});
if (targetPage == null)
{
targetPage = CreateObject(modelHost, folder, definition);
}
InvokeOnModelEvent(this, new ModelEventArgs
{
CurrentModelNode = null,
Model = null,
EventType = ModelEventType.OnProvisioned,
Object = targetPage.File,
ObjectType = typeof(SPFile),
ObjectDefinition = definition,
ModelHost = modelHost
});
ModuleFileModelHandler.WithSafeFileOperation(list, folder,
targetPage.Url,
GetSafePageFileName(definition),
definition.Content,
definition.NeedOverride,
null,
afterFile =>
{
var pageItem = afterFile.Properties;
//pageItem[BuiltInInternalFieldNames.Title] = definition.Title;
pageItem["vti_title"] = definition.Title;
pageItem["MasterPageDescription"] = definition.Description;
pageItem[BuiltInInternalFieldNames.ContentTypeId] = BuiltInContentTypeId.MasterPage;
if (definition.UIVersion.Count > 0)
{
var value = new SPFieldMultiChoiceValue();
foreach (var v in definition.UIVersion)
{
value.Add(v);
}
pageItem["UIVersion"] = value.ToString();
}
pageItem["DefaultCssFile"] = definition.DefaultCSSFile;
//pageItem.Update();
//pageItem.SystemUpdate();
});
}
public void TestInit()
{
using (SPSite site = new SPSite("http://sp2013test"))
{
using (SPWeb web = site.OpenWeb(webUrl))
{
TestList = web.Lists.TryGetList(this.listName);
if (TestList == null)
{
Guid listId = web.Lists.Add(this.listName, "Test list for SPQueryUtil querystring", SPListTemplateType.GenericList);
web.Update();
TestList = web.Lists[listId];
TestList.Fields.Add("TextCol", SPFieldType.Text, false);
TestList.Fields.Add("MultiTextCol", SPFieldType.Note, false);
TestList.Fields.Add("NumberCol", SPFieldType.Number, false);
TestList.Fields.Add("DateTimeCol", SPFieldType.DateTime, false);
TestList.Fields.Add("BoolCol", SPFieldType.Boolean, false);
TestList.Fields.Add("ChoiceCol", SPFieldType.Choice, false);
TestList.Fields.Add("MultiChoiceCol", SPFieldType.MultiChoice, false);
TestList.Fields.Add("GuidCol", SPFieldType.Guid, false);
TestList.Fields.Add("UrlCol", SPFieldType.URL, false);
TestList.Fields.Add("UserCol", SPFieldType.User, false);
TestList.Update();
SPListItem textItem = TestList.AddItem();
textItem["TextCol"] = "text1";
textItem.Update();
SPListItem textItemMulti = TestList.AddItem();
textItemMulti["MultiTextCol"] = "Multi text";
textItemMulti.Update();
SPListItem numberItem = TestList.AddItem();
numberItem["NumberCol"] = 100;
numberItem.Update();
SPListItem dateTimeCol = TestList.AddItem();
dateTimeCol["DateTimeCol"] = new DateTime(2000, 1, 1, 5, 10, 59);
dateTimeCol.Update();
SPListItem boolItem = TestList.AddItem();
boolItem["BoolCol"] = true;
boolItem.Update();
SPListItem choiceItem = TestList.AddItem();
choiceItem["ChoiceCol"] = "choice1";
choiceItem.Update();
var choicevalues = new SPFieldMultiChoiceValue();
choicevalues.Add("Green");
choicevalues.Add("Blue");
SPListItem chioceItemMulti = TestList.AddItem();
chioceItemMulti["MultiChoiceCol"] = choicevalues;
chioceItemMulti.Update();
SPListItem guidItem = TestList.AddItem();
guidItem["GuidCol"] = new Guid("96D74029-8482-4C52-8C4F-4A4040A77BC5");
guidItem.Update();
SPListItem urlItem = TestList.AddItem();
urlItem["UrlCol"] = "http://www.google.com";
urlItem.Update();
//SPListItem userItem = TestList.AddItem();
//textItemMulti["UserCol"] = "";
//userItem.Update();
}
}
using (SPWeb web = site.OpenWeb(this.webUrl))
{
TestList = web.Lists[this.listName];
}
}
}
static void CreateSPListItems(SPList list)
{
int i = 1;
string line = "";
foreach (DataRow row in dt.Rows)
{
SPListItem item = list.AddItem();
i++;
foreach (Column column in columnList)
{
if (!row.IsNull(column.Name))
{
string v = row[column.Name].ToString();
if (column.FieldType == Microsoft.SharePoint.SPFieldType.User)
{
SPUser user = list.ParentWeb.EnsureUser(v);
item[column.Name] = user;
}
else if (column.FieldType == Microsoft.SharePoint.SPFieldType.MultiChoice)
{
string[] singleValues = v.Split(';');
var choicevalues = new SPFieldMultiChoiceValue();
foreach (var s in singleValues)
{
choicevalues.Add(s);
}
item[column.Name] = choicevalues;
}
else if (column.FieldType == Microsoft.SharePoint.SPFieldType.Boolean)
{
v = v.ToLower();
bool?newValue = null;
if (v == "falsch" || v == "nein" || v == "0" || v == "no" || v == "false")
{
newValue = false;
}
else if (v == "ja" || v == "wahr" || v == "1" || v == "yes" || v == "true")
{
newValue = true;
}
if (newValue.HasValue)
{
item[column.Name] = newValue.Value;
}
}
else if (column.FieldType == Microsoft.SharePoint.SPFieldType.DateTime)
{
DateTime dateTime;
if (DateTime.TryParse(v, out dateTime))
{
item[column.Name] = dateTime;
}
else
{
throw new Exception(string.Format("Can not convert value [{0}] in column [{1}] to Double (Row: {2})", v, column.Name, i));
}
}
else if (column.FieldType == Microsoft.SharePoint.SPFieldType.Number)
{
double d;
if (double.TryParse(v, out d))
{
item[column.Name] = d;
}
else
{
throw new Exception(string.Format("Can not convert value [{0}] in column [{1}] to Double (Row: {2})", v, column.Name, i));
}
}
else if (column.FieldType == Microsoft.SharePoint.SPFieldType.Lookup)
{
var lookupField = list.Fields[column.Name] as SPFieldLookup;
var lookupList = list.ParentWeb.Lists[new Guid(lookupField.LookupList)];
SPQuery query = new SPQuery();
query.RowLimit = 1;
query.Query = "<Where><Eq><FieldRef Name='" + lookupField.LookupField + "' /><Value Type='Text'>" + v + "</Value></Eq></Where>";
query.ViewFieldsOnly = true;
query.ViewFields = "<FieldRef Name='ID' />";
SPListItemCollection itemCollection = lookupList.GetItems(query);
if (itemCollection.Count > 0)
{
var lookupitem = itemCollection[0];
var lookupValue = new SPFieldLookupValue(lookupitem.ID, lookupitem.ID.ToString());
item[column.Name] = lookupValue;
}
}
else
{
item[column.Name] = v;
}
}
}
item.Update();
string backup = new string('\b', line.Length);
Console.Write(backup);
line = string.Format("Create Item {0} of {1}", i, dt.Rows.Count - 1);
Console.ForegroundColor = ConsoleColor.Green;
Console.Write(line);
Console.ForegroundColor = ConsoleColor.White;
}
}
private string SaveUpdate()
{
using (SPSite site = new SPSite(SPContext.Current.Web.Url, SPContext.Current.Site.SystemAccount.UserToken))
{
using (web = site.OpenWeb())
{
SPList list = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PerubahanAnggaranDasarDanDataPerseroan"));
SPList listPemegangSaham = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PerubahanPemegangSaham"));
SPList listKomisarisDireksi = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PerubahanKomisarisDireksi"));
SPList listDokumen = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "PerubahanAnggaranDasarDokumen"));
SPList listPerusahaanBaru = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PerusahaanBaru"));
SPListItem itemlistPerusahaanBaru = listPerusahaanBaru.GetItemById(Convert.ToInt32(hfIDCompany.Value));
web.AllowUnsafeUpdates = true;
SPListItem item = null;
try
{
if (IDP == 0)
{
item = list.Items.Add();
item["Title"] = Util.GenerateRequestCode(web, this.CodeName, DateTime.Now.Month, DateTime.Now.Year);
item["Created By"] = SPContext.Current.Web.CurrentUser.ID.ToString();
item["Step"] = StepWF[0];
if (!string.IsNullOrEmpty(rdPerubahanModal.SelectedValue))
item["PerubahanModal"] = (rdPerubahanModal.SelectedValue.Equals("Yes") ? true : false);
if (!string.IsNullOrEmpty(rdPerubahanNama.SelectedValue))
item["PerubahanNamaDanTempat"] = (rdPerubahanNama.SelectedValue.Equals("Yes") ? true : false);
}
else
{
item = list.GetItemById(IDP);
item["Modified By"] = SPContext.Current.Web.CurrentUser.ID.ToString();
}
item["Tanggal"] = Convert.ToDateTime(ltrDate.Text);
item["Requestor"] = hfIDPemohon.Value;
SPFieldMultiChoiceValue multiValue = new SPFieldMultiChoiceValue();
foreach (ListItem itemCheckBox in chkBoxListJenisPerubahan.Items)
{
if (itemCheckBox.Selected) multiValue.Add(itemCheckBox.Text);
}
item["JenisPerubahan"] = multiValue;
item["AlasanPerubahan"] = txtAlasanPerubahan.Text.Trim();
item["BNRI"] = (rbBNRI.SelectedValue.Equals("Yes") ? true : false);
item["MataUang"] = ddlMataUang.SelectedValue;
item["ModalDasar"] = (!string.IsNullOrEmpty(txtModalDasarNominalSemula.Text) ? txtModalDasarNominalSemula.Text.Trim() : "0");
item["ModalSetor"] = (!string.IsNullOrEmpty(txtModalSetorNominalSemula.Text) ? txtModalSetorNominalSemula.Text.Trim() : "0");
item["Nominal"] = (!string.IsNullOrEmpty(txtNominalMataUang.Text) ? txtNominalMataUang.Text.Trim() : "0");
item["NominalModalDasar"] = Convert.ToDouble(item["ModalDasar"]) * Convert.ToDouble(item["Nominal"]);
item["NominalModalSetor"] = Convert.ToDouble(item["ModalSetor"]) * Convert.ToDouble(item["Nominal"]);
item["Keterangan"] = txtRemarks.Text.Trim();
item["CompanyCode"] = hfIDCompany.Value.Trim();
item.Web.AllowUnsafeUpdates = true;
item.Update();
ViewState["ID"] = item.ID;
if (item.ID > 0)
{
#region UpdatePerusahaanBaru
itemlistPerusahaanBaru["CompanyCodeAPV"] = txtCompanyCode.Text;
itemlistPerusahaanBaru["NamaPerusahaan"] = txtCompanyName.Text;
itemlistPerusahaanBaru["TempatKedudukan"] = ddlTempatKedudukan.SelectedValue;
itemlistPerusahaanBaru["MaksudTujuan"] = ddlMaksudDanTujuan.SelectedValue;
itemlistPerusahaanBaru["MataUang"] = ddlMataUang.SelectedValue;
itemlistPerusahaanBaru.Web.AllowUnsafeUpdates = true;
itemlistPerusahaanBaru.Update();
#endregion
}
/* Pemegang Saham */
if (ViewState["PemegangSahamMenjadi"] != null)
{
List<PemegangSaham> collPemegangSaham = ViewState["PemegangSahamMenjadi"] as List<PemegangSaham>;
foreach (PemegangSaham i in collPemegangSaham)
{
if (!i.IsDeleted)
{
SPListItem itemPemegangSaham = null;
if (i.ID == 0)
itemPemegangSaham = listPemegangSaham.Items.Add();
else
itemPemegangSaham = listPemegangSaham.Items.GetItemById(i.ID);
itemPemegangSaham["PerubahanAnggaranDasar"] = ViewState["ID"].ToString();
itemPemegangSaham["Title"] = i.Nama;
itemPemegangSaham["JumlahSaham"] = i.JumlahSaham;
itemPemegangSaham["JumlahNominal"] = i.JumlahNominal;
itemPemegangSaham["Percentages"] = i.Percentages;
itemPemegangSaham["Partner"] = i.Partner;
itemPemegangSaham["TanggalMulaiMenjabat"] = i.MulaiMenjabat;
itemPemegangSaham["TanggalAkhirMenjabat"] = i.AkhirMenjabat;
itemPemegangSaham["Created By"] = SPContext.Current.Web.CurrentUser.ID.ToString();
itemPemegangSaham.Web.AllowUnsafeUpdates = true;
itemPemegangSaham.Update();
}
else
{
if (i.ID > 0)
listPemegangSaham.GetItemById(i.ID).Recycle();
}
}
}
/* Komisaris */
if (ViewState["KomisarisDireksiMenjadi"] != null)
{
List<KomisarisDireksi> collKomisarisDireksi = ViewState["KomisarisDireksiMenjadi"] as List<KomisarisDireksi>;
foreach (KomisarisDireksi i in collKomisarisDireksi)
{
if (!i.IsDeleted)
{
SPListItem itemKomisarisDireksi = null;
if (i.ID == 0)
itemKomisarisDireksi = listKomisarisDireksi.Items.Add();
else
itemKomisarisDireksi = listKomisarisDireksi.Items.GetItemById(i.ID);
itemKomisarisDireksi["PerubahanAnggaranDasar"] = ViewState["ID"].ToString();
itemKomisarisDireksi["Title"] = i.Nama;
itemKomisarisDireksi["Jabatan"] = i.IDJabatan;
itemKomisarisDireksi["NoKTP"] = i.NoKTP;
itemKomisarisDireksi["NoNPWP"] = i.NoNPWP;
itemKomisarisDireksi["TanggalMulaiMenjabat"] = i.MulaiMenjabat;
itemKomisarisDireksi["TanggalAkhirMenjabat"] = i.AkhirMenjabat;
itemKomisarisDireksi["Created By"] = SPContext.Current.Web.CurrentUser.ID.ToString();
itemKomisarisDireksi.Web.AllowUnsafeUpdates = true;
itemKomisarisDireksi.Update();
}
else
{
if (i.ID > 0)
listKomisarisDireksi.GetItemById(i.ID).Recycle();
}
}
}
if (IDP != 0)
{
if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == "PIC Update Akta")
{
/* Akte */
item["NoAkte"] = txtNoAkte.Text.Trim();
item["TanggalAkte"] = dtTanggalAkte.SelectedDate;
if (!string.IsNullOrEmpty(txtNotarisAkte.Text))
item["NotarisAkte"] = GetNotarisID(txtNotarisAkte.Text.Trim());
item["KeteranganAkte"] = txtKeteranganAkte.Text.Trim();
item["PembuatAkte"] = SPContext.Current.Web.CurrentUser.ID.ToString();
}
/* SKDP */
if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == "PIC Upload SKDP")
{
/* BNRI */
item["NoBNRI"] = txtBNRINo.Text.Trim();
item["TanggalMulaiBerlakuBNRI"] = dtBNRIMulaiBerlaku.SelectedDate;
item["KeteranganBNRI"] = txtBNRIKeterangan.Text.Trim();
item["PembuatBNRI"] = SPContext.Current.Web.CurrentUser.ID.ToString();
item["NoSKDP"] = txtSKDPNo.Text.Trim();
item["TanggalMulaiBerlakuSKDP"] = dtSKDPTanggalMulai.SelectedDate;
item["TanggalAkhirBerlakuSKDP"] = dtSKDPTanggalAkhir.SelectedDate;
item["KeteranganSKDP"] = txtSKDPKeterangan.Text.Trim();
item["AlamatSKDP"] = txtAlamatSKDP.Text.Trim();
item["PembuatSKDP"] = SPContext.Current.Web.CurrentUser.ID.ToString();
itemlistPerusahaanBaru["AlamatSKDP"] = txtAlamatSKDP.Text.Trim();
itemlistPerusahaanBaru.Update();
}
if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == "PIC Upload NPWP dan SKT")
{
/* NPWP */
if (ViewState["NPWP"] != null)
{
List<NPWP> collNPWP = ViewState["NPWP"] as List<NPWP>;
foreach (NPWP i in collNPWP)
{
SPFolder document = web.Folders["PerubahanNPWP"];
if (!i.IsDeleted)
{
SPFile file = document.Files.Add(i.NamaFile, i.Attachment, true);
SPItem itemDocument = file.Item;
itemDocument["Title"] = Path.GetFileNameWithoutExtension(i.NamaFile);
itemDocument["PerubahanAnggaranDasar"] = Convert.ToInt32(ViewState["ID"]);
itemDocument["NoNPWP"] = i.NoNPWP;
itemDocument["Keterangan"] = i.Keterangan;
itemDocument["Created By"] = SPContext.Current.Web.CurrentUser.ID.ToString();
itemDocument.Update();
}
else
{
if (i.ID > 0)
document.Item.ListItems.DeleteItemById(i.ID);
}
}
}
/* NPWP */
item["NoNPWP"] = txtNoNPWP.Text.Trim();
item["TanggalMulaiBerlakuNPWP"] = dtTanggalTerdaftarNPWP.SelectedDate;
item["KeteranganNPWP"] = txtKeteranganNPWP.Text.Trim();
item["NamaKPPNPWP"] = txtNamaKPP.Text.Trim();
item["PembuatNPWP"] = SPContext.Current.Web.CurrentUser.ID.ToString();
/* SKT */
item["NoSKT"] = txtNOSKTNPWP.Text.Trim();
item["PembuatSKT"] = SPContext.Current.Web.CurrentUser.ID.ToString();
}
if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == "PIC Upload APV")
{
/* APV */
item["CompanyCodeAPV"] = txtKodePerusahaanAPV.Text.Trim();
item["NoAPV"] = txtNoAPV.Text.Trim();
item["TanggalAPV"] = dtTanggalAPV.SelectedDate;
item["KeteranganAPV"] = txtKeteranganAPV.Text.Trim();
}
if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == "PIC Upload Setoran Modal")
{
/* Setoran */
item["TanggalSetoran"] = dtTanggalSetoran.SelectedDate;
item["KeteranganSetoran"] = txtKeteranganSetoran.Text.Trim();
item["StatusSetoran"] = chkStatusSetoran.Checked;
item["PembuatSetoran"] = SPContext.Current.Web.CurrentUser.ID.ToString();
item["PembuatAPV"] = SPContext.Current.Web.CurrentUser.ID.ToString();
}
if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == "PIC Upload SK Persetujuan")
{
/* SK */
item["NoSK"] = txtSKNo.Text.Trim();
item["TanggalMulaiBerlakuSK"] = dtSKMulaiBerlaku.SelectedDate;
item["KeteranganSK"] = txtSKKeterangan.Text.Trim();
item["PembuatSK"] = SPContext.Current.Web.CurrentUser.ID.ToString();
}
item.Web.AllowUnsafeUpdates = true;
item.Update();
ViewState["ID"] = item.ID;
string message = string.Empty;
message = SaveDocument(fuSK, Convert.ToInt32(hfIDCompany.Value), "SK");
if (message != string.Empty)
return message;
message = string.Empty;
message = SaveDocument(fuAkte, Convert.ToInt32(hfIDCompany.Value), "AKTA");
if (message != string.Empty)
return message;
message = SaveDocument(fuSKDP, Convert.ToInt32(hfIDCompany.Value), "SKDP");
if (message != string.Empty)
return message;
message = SaveDocument(fuNPWP, Convert.ToInt32(hfIDCompany.Value), "NPWP");
if (message != string.Empty)
return message;
message = SaveDocument(fuSKT, Convert.ToInt32(hfIDCompany.Value), "SKT");
if (message != string.Empty)
return message;
message = SaveDocument(fuAPV, Convert.ToInt32(hfIDCompany.Value), "APV");
if (message != string.Empty)
return message;
message = SaveDocument(fuSetoranModal, Convert.ToInt32(hfIDCompany.Value), "Setoran Modal");
if (message != string.Empty)
return message;
}
web.AllowUnsafeUpdates = false;
}
catch (Exception ex)
{
string err = ex.Message + "," + ex.StackTrace;
if (IDP == 0)
return SR.SaveFail + "\n" + err;
else
return SR.UpdateFail + "\n" + err;
}
}
}
return string.Empty;
}
private void DeployPage(object modelHost, SPList list, SPFolder folder, MasterPageDefinition definition)
{
var web = list.ParentWeb;
var targetPage = GetCurrentObject(folder, definition);
InvokeOnModelEvent(this, new ModelEventArgs
{
CurrentModelNode = null,
Model = null,
EventType = ModelEventType.OnProvisioning,
Object = targetPage == null ? null : targetPage.File,
ObjectType = typeof(SPFile),
ObjectDefinition = definition,
ModelHost = modelHost
});
if (targetPage == null)
targetPage = CreateObject(modelHost, folder, definition);
InvokeOnModelEvent(this, new ModelEventArgs
{
CurrentModelNode = null,
Model = null,
EventType = ModelEventType.OnProvisioned,
Object = targetPage.File,
ObjectType = typeof(SPFile),
ObjectDefinition = definition,
ModelHost = modelHost
});
ModuleFileModelHandler.WithSafeFileOperation(list, folder,
targetPage.Url,
GetSafePageFileName(definition),
definition.Content,
definition.NeedOverride,
null,
afterFile =>
{
var pageItem = afterFile.Properties;
//pageItem[BuiltInInternalFieldNames.Title] = definition.Title;
pageItem["vti_title"] = definition.Title;
pageItem["MasterPageDescription"] = definition.Description;
pageItem[BuiltInInternalFieldNames.ContentTypeId] = BuiltInContentTypeId.MasterPage;
if (definition.UIVersion.Count > 0)
{
var value = new SPFieldMultiChoiceValue();
foreach (var v in definition.UIVersion)
value.Add(v);
pageItem["UIVersion"] = value.ToString();
}
pageItem["DefaultCssFile"] = definition.DefaultCSSFile;
//pageItem.Update();
//pageItem.SystemUpdate();
});
}
// public static void ImportListData(string siteURL, string spListName, string PathToCSV)
static void ImportListData(SPWeb spWeb, string spListName, string[] TheData)
{
//string str = siteURL;
//string str2 = spListName;
//string str3 = PathToCSV;
Console.Write(string.Format("Adding data for list {0} ...", spListName));
//SPSite site = new SPSite(str);
//SPList list = site.OpenWeb().Lists[str2];
SPList list = spWeb.Lists[spListName];
Console.WriteLine("Done");
//Console.Write(string.Format("Importing Data from file {0} ...", str3));
//StreamReader reader = new StreamReader(str3);
// string str4 = null;
List<SPField> list2 = null;
// while ((str4 = reader.ReadLine()) != null)
foreach (string str4 in TheData)
{
string[] strArray = str4.Split(new char[] { ',' });
// adding fields first time through
if (list2 == null)
{
list2 = new List<SPField>();
foreach (string str5 in strArray)
{
SPField field = list.Fields[str5];
list2.Add(field);
}
}
else // adding the data since we already got the fields
{
SPListItem item = list.Items.Add();
for (int i = 0; i < list2.Count; i++)
{
string str5 = strArray[i];
string typeAsString = list2[i].TypeAsString;
if (typeAsString.StartsWith("Lookup"))
{
if (!string.IsNullOrEmpty(str5))
{
XmlDocument document = new XmlDocument();
document.LoadXml(list2[i].SchemaXml);
XmlNode node = document.GetElementsByTagName("Field")[0];
Guid guid = new Guid(node.Attributes["List"].Value);
string lookupFieldInternalName = node.Attributes["ShowField"].Value;
SPList lookupList = spWeb.Lists[guid];
if (typeAsString == "LookupMulti")
{
item[list2[i].InternalName] = GetLookupValueCollectionString(lookupList, lookupFieldInternalName, str5);
}
else
{
item[list2[i].InternalName] = GetLookupValueID(lookupList, lookupFieldInternalName, str5);
}
}
}
else if (typeAsString.StartsWith("MultiChoice"))
{
if (!string.IsNullOrEmpty(str5))
{
string[] strArray2 = str5.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
SPFieldMultiChoiceValue value2 = new SPFieldMultiChoiceValue();
foreach (string str8 in strArray2)
{
value2.Add(str8);
}
item[list2[i].InternalName] = value2;
}
}
else if (typeAsString.StartsWith("User"))
{
if (!string.IsNullOrEmpty(str5))
{
int lookupId = int.Parse(str5);
SPFieldUserValue value3 = new SPFieldUserValue(item.Web, lookupId, null);
item[list2[i].InternalName] = value3;
}
}
else
{
item[list2[i].InternalName] = str5;
}
}
item.Update();
Console.Write(".");
}
}
Console.WriteLine(" Done");
}
public void TestInit()
{
using (SPSite site = new SPSite("http://sp2013test"))
{
using (SPWeb web = site.OpenWeb(webUrl))
{
TestList = web.Lists.TryGetList(this.listName);
if (TestList == null)
{
Guid listId = web.Lists.Add(this.listName, "Test list for SPQueryUtil querystring", SPListTemplateType.GenericList);
web.Update();
TestList = web.Lists[listId];
TestList.Fields.Add("TextCol", SPFieldType.Text, false);
TestList.Fields.Add("MultiTextCol", SPFieldType.Note, false);
TestList.Fields.Add("NumberCol", SPFieldType.Number, false);
TestList.Fields.Add("DateTimeCol", SPFieldType.DateTime, false);
TestList.Fields.Add("BoolCol", SPFieldType.Boolean, false);
TestList.Fields.Add("ChoiceCol", SPFieldType.Choice, false);
TestList.Fields.Add("MultiChoiceCol", SPFieldType.MultiChoice, false);
TestList.Fields.Add("GuidCol", SPFieldType.Guid, false);
TestList.Fields.Add("UrlCol", SPFieldType.URL, false);
TestList.Fields.Add("UserCol", SPFieldType.User, false);
TestList.Update();
SPListItem textItem = TestList.AddItem();
textItem["TextCol"] = "text1";
textItem.Update();
SPListItem textItemMulti = TestList.AddItem();
textItemMulti["MultiTextCol"] = "Multi text";
textItemMulti.Update();
SPListItem numberItem = TestList.AddItem();
numberItem["NumberCol"] = 100;
numberItem.Update();
SPListItem dateTimeCol = TestList.AddItem();
dateTimeCol["DateTimeCol"] = new DateTime(2000, 1, 1, 5, 10, 59);
dateTimeCol.Update();
SPListItem boolItem = TestList.AddItem();
boolItem["BoolCol"] = true;
boolItem.Update();
SPListItem choiceItem = TestList.AddItem();
choiceItem["ChoiceCol"] = "choice1";
choiceItem.Update();
var choicevalues = new SPFieldMultiChoiceValue();
choicevalues.Add("Green");
choicevalues.Add("Blue");
SPListItem chioceItemMulti = TestList.AddItem();
chioceItemMulti["MultiChoiceCol"] = choicevalues;
chioceItemMulti.Update();
SPListItem guidItem = TestList.AddItem();
guidItem["GuidCol"] = new Guid("96D74029-8482-4C52-8C4F-4A4040A77BC5");
guidItem.Update();
SPListItem urlItem = TestList.AddItem();
urlItem["UrlCol"] = "http://www.google.com";
urlItem.Update();
//SPListItem userItem = TestList.AddItem();
//textItemMulti["UserCol"] = "";
//userItem.Update();
}
}
using (SPWeb web = site.OpenWeb(this.webUrl))
{
TestList = web.Lists[this.listName];
}
}
}
private static SPListItem setItemFields(List <SPFieldValue> fields, SPListItem item)
{
foreach (SPFieldValue value2 in fields)
{
string[] strArray;
SPFieldLookupValueCollection values;
int num;
switch (value2.Type)
{
case "Text":
{
item[value2.InternalName] = value2.value;
continue;
}
case "Note":
{
item[value2.InternalName] = value2.value;
continue;
}
case "Number":
{
item[value2.InternalName] = decimal.Parse(value2.value);
continue;
}
case "DateTime":
{
item[value2.InternalName] = Convert.ToDateTime(value2.value);
continue;
}
case "Lookup":
{
item[value2.InternalName] = new SPFieldLookupValue(int.Parse(value2.value), "");
continue;
}
case "LookupMulti":
strArray = value2.value.Split(new char[] { ',' });
values = new SPFieldLookupValueCollection();
num = 0;
goto Label_0216;
case "RelatedCustomLookupQuery":
{
item[value2.InternalName] = new SPFieldLookupValue(int.Parse(value2.value), "");
continue;
}
case "File":
{
item[value2.InternalName] = new SPFieldLookupValue(int.Parse(value2.value), "");
continue;
}
case "CustomComputedField":
{
continue;
}
case "Choice":
{
item[value2.InternalName] = value2.value;
continue;
}
case "MultiChoice":
{
string[] strArray2 = value2.value.Split(new char[] { ',' });
SPFieldMultiChoiceValue value3 = new SPFieldMultiChoiceValue();
num = 0;
while (num < strArray2.Length)
{
value3.Add(strArray2[num]);
num++;
}
item[value2.InternalName] = value3;
continue;
}
case "Boolean":
{
item[value2.InternalName] = value2.value;
continue;
}
case "User":
{
if (value2.value == null)
{
goto Label_034A;
}
item[value2.InternalName] = new SPFieldUserValue(SPContext.Current.Web, int.Parse(value2.value), "");
continue;
}
default:
{
continue;
}
}
Label_01F7:
values.Add(new SPFieldLookupValue(int.Parse(strArray[num]), ""));
num++;
Label_0216:
if (num < strArray.Length)
{
goto Label_01F7;
}
item[value2.InternalName] = values;
continue;
Label_034A:
item[value2.InternalName] = null;
}
return(item);
}
private static object GetDrivingPaths(string dPaths)
{
var value = new SPFieldMultiChoiceValue();
if (!String.IsNullOrEmpty(dPaths))
foreach (string dPath in dPaths.Split(','))
value.Add(dPath);
return value;
}
internal static void Set_SPFieldMultiChoiceValue(SPListItem item, string col, System.Collections.ArrayList komponenty)
{
SPFieldMultiChoiceValue fmcv = new SPFieldMultiChoiceValue();
foreach (string s in komponenty)
{
fmcv.Add(s);
}
item[col] = fmcv;
}
private static SPFieldMultiChoiceValue CreateMultiValue(string input)
{
SPFieldMultiChoiceValue values = new SPFieldMultiChoiceValue();
values.Add(input);
return values;
}
protected SPFieldMultiChoiceValue MapCollectionToMultiChoiceValue(IEnumerable<string> collection)
{
var values = new SPFieldMultiChoiceValue();
foreach (var item in collection)
{
values.Add(item);
}
return values;
}
private static SPFieldMultiChoiceValue GetSPListItemsFromCheckBoxes(CheckBoxList inputCheckBoxList)
{
SPFieldMultiChoiceValue values = new SPFieldMultiChoiceValue();
foreach (ListItem boxItem in inputCheckBoxList.Items)
if (boxItem.Selected == true)
values.Add(boxItem.Value);
return values;
}
public static void UpdateFieldValue(this SPListItem item, SPField updatedField, string data)
{
if (string.IsNullOrEmpty(data) || data.CompareTo(";#") == 0)
{
return;
}
switch (updatedField.Type)
{
case SPFieldType.Boolean:
item[updatedField.Id] = Convert.ToBoolean(data);
break;
case SPFieldType.File:
case SPFieldType.Calculated:
case SPFieldType.Computed:
case SPFieldType.Currency:
case SPFieldType.Integer:
case SPFieldType.Note:
case SPFieldType.Number:
case SPFieldType.Text:
item[updatedField.Id] = data;
break;
case SPFieldType.Choice:
SPFieldChoice fieldChoice = (SPFieldChoice)updatedField;
item[updatedField.Id] = data;
break;
case SPFieldType.DateTime:
SPFieldDateTime fieldDate = (SPFieldDateTime)updatedField;
item[updatedField.Id] = Convert.ToDateTime(data);
break;
case SPFieldType.Lookup:
SPFieldLookup fieldLookup = (SPFieldLookup)updatedField;
if (fieldLookup.AllowMultipleValues)
{
SPFieldLookupValueCollection multiValues = new SPFieldLookupValueCollection();
foreach (var s in data.Split("|".ToCharArray()))
{
multiValues.Add(new SPFieldLookupValue(s));
}
item[updatedField.Id] = multiValues;
}
else
{
//int id = fieldLookup.GetLookupIdFromValue(data);
SPFieldLookupValue singleLookupValue = new SPFieldLookupValue(data);
item[updatedField.Id] = singleLookupValue;
}
break;
case SPFieldType.MultiChoice:
SPFieldMultiChoice fieldMultichoice = (SPFieldMultiChoice)updatedField;
string[] items = data.Split("|".ToCharArray());
SPFieldMultiChoiceValue values = new SPFieldMultiChoiceValue();
foreach (string choice in items)
{
values.Add(choice);
}
item[updatedField.Id] = values;
break;
case SPFieldType.User:
SPFieldUser fieldUser = (SPFieldUser)updatedField;
SPFieldUserValueCollection fieldValues = new SPFieldUserValueCollection();
string[] entities = data.Split("|".ToCharArray());
foreach (string entity in entities)
{
SPUser user = item.Web.EnsureUser(entity.Split(";#".ToCharArray())[2]);
if (user != null)
{
fieldValues.Add(new SPFieldUserValue(item.Web, user.ID, user.Name));
}
}
item[updatedField.Id] = fieldValues;
break;
}
}
