public RecetteViewModel(Dispatcher dispatcher)
{
_dispatcher = dispatcher;
GestionSharepoint gSP = new GestionSharepoint();
LesRecettes = new ObservableCollection<Recette>(gSP.GetListRecette());
}
public HomeViewModel(Dispatcher dispatcher)
{
_dispatcher = dispatcher;
ChangeSelectedIndexCommand = new GenericCommand<string>(ExecuteChangeSelectedCommand, CanExecuteChangeSelectedCommand);
SelectTaskCommand = new GenericCommand<IcomiTask>(ExecuteSelectTaskCommand, CanExecuteSelectTaskCommand);
AddBPHCommand = new GenericCommand<IcomiTask>(ExecuteAddBPHCommand, CanExecuteAddBPHCommand);
ViewDocumentCommand = new GenericCommand<DocumentMetadataDataContract>(ExecuteViewDocumentCommand, CanExecuteViewDocumentCommand);
GestionSharepoint gSP = new GestionSharepoint();
LesNouveauxDocuments = new ObservableCollection<DocumentMetadataDataContract>(gSP.GetAllChangedDocumentMetaByRubrique("ICOMI_BPH"));
#region toDelete
//LesNouveauxDocuments = new ObservableCollection<DocumentMetadataDataContract>();
//for (int i = 0; i < 20; i++)
//{
// var dmDC = new DocumentMetadataDataContract();
// dmDC.Auteur = "Alexandre Equoy";
// dmDC.Commentaires="Je peux laisser un commentaire sur ce document";
// dmDC.CreateDate = DateTime.Now;
// dmDC.DocumentVersion=1;
// dmDC.Producteur = "ACCESS IT";
// dmDC.RubriqueDocument = "Lutte contre les nuisibles";
// dmDC.SousTypeDocument = "Preuve";
// dmDC.TypeDocument = "Contrat";
// dmDC.RubriqueDocumentCode = "LN";
// dmDC.SousTypeDocumentCode = "PRV";
// dmDC.TypeDocumentCode = "CTN";
// dmDC.Titre = "Catalogue de formation";
// LesNouveauxDocuments.Add(dmDC);
//this.SelectedIndex = LesNouveauxDocuments.Count/2;
//if (UserConnected != null)
//{
//}
//else
//{
// LesTachesToDo = new ObservableCollection<IcomiTask>();
// for (int i = 0; i < 4; i++)
// {
// LesTachesToDo.Add(new IcomiTask() { Title = "Prise de température dans les douches", TileTitle = "Prise de T°", NbOccurence = 1 });
// }
//}
#endregion
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
try
{
this.ProgressInsert.Visibility = Visibility.Visible;
var gSP = new GestionSharepoint();
string fileTest = this.FileTextBox.Text;
string LibraryName = "ICOMI_BPH";
var dmDC = new DocumentMetadataDataContract();
dmDC.Auteur = "Alexandre Equoy";
dmDC.Commentaires = this.Commentaires.Text;
dmDC.CreateDate = DateTime.Now;
dmDC.DocumentVersion = 1;
dmDC.Producteur = this.Producteur.Text;
dmDC.RubriqueDocument = this.Rubrique.Text;
dmDC.SousTypeDocument = this.SousType.Text;
dmDC.TypeDocument = this.Type.Text;
dmDC.RubriqueDocumentCode = RefObjectSPService.GetRubriques().Where(r => r.Libelle.Equals(this.Rubrique.Text)).First().Code;
dmDC.SousTypeDocumentCode = RefObjectSPService.GetSousTypeDocument().Where(r => r.Libelle.Equals(this.SousType.Text)).First().Code;
dmDC.TypeDocumentCode = RefObjectSPService.GetTypeDocument().Where(r => r.Libelle.Equals(this.Type.Text)).First().Code; ;
dmDC.Titre = this.Titre.Text;
var result = gSP.AddFile(LibraryName, dmDC, System.IO.File.ReadAllBytes(fileTest), ".PDF");
if (result != null)
if (ReturnHome != null)
ReturnHome(sender, e);
this.ProgressInsert.Visibility = Visibility.Hidden;
}
catch (Exception ex)
{
}
finally
{
this.Commentaires.Text = string.Empty;
this.Producteur.Text = string.Empty;
this.Titre.Text = string.Empty;
}
}
private ObservableCollection<DocumentMetadataDataContract> RetrieveDocumentsForRubrique(Rubrique laRubrique)
{
try
{
var gSP = new GestionSharepoint();
string LibraryName = "ICOMI_BPH";
string extension = string.Empty;
var l = gSP.GetAllDocumentMetaByRubrique(laRubrique.Code, LibraryName, out extension);
if (l != null)
{
return new ObservableCollection<DocumentMetadataDataContract>(l);
}
}
catch (Exception ex)
{
return null;
}
finally
{
}
return null;
}
/// <summary>
/// Valide l'édition en cours et retourne à l'écran principal
/// </summary>
/// <param name="notUsed"></param>
protected virtual void ExecuteViewDocumentCommand(DocumentMetadataDataContract param)
{
try
{
var leDocument = param.NomDocument;
string savedFile = System.IO.Path.Combine(System.IO.Path.GetTempPath(), leDocument);
if (!File.Exists(savedFile))
{
_dispatcher.Invoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(
delegate()
{
GestionSharepoint gSP = new GestionSharepoint();
string extension = string.Empty;
var document = gSP.GetFile(leDocument, "ICOMI_BPH", out extension);
File.WriteAllBytes(savedFile, document);
}
));
}
System.Diagnostics.Process.Start(savedFile);
}
catch
{
}
}
/// <summary>
/// Valide l'édition en cours et retourne à l'écran principal
/// </summary>
/// <param name="notUsed"></param>
protected virtual void ExecuteConnexionCommand(PasswordBox pwdBox)
{
SessionContext securityContext = new SessionContext();
GestionSharepoint gSP = new GestionSharepoint();
var user = gSP.ConnectUser(UserName, pwdBox.Password);
if (user != null)
{
securityContext.Utilisateur = user;
//new User(){UserName="******",ImgUrl="/ICOMI_SPClient;component/Resources/_alex.jpg"};
Messenger.Default.Send<LoginMessage>(new LoginMessage() { SecurityContext = securityContext });
}
else
ErrorText = "Impossible de se connecter";
}
private void Worker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
var leDocument = e.Argument as string;
if (leDocument != null)
{
string savedFile = System.IO.Path.Combine(System.IO.Path.GetTempPath(), leDocument);
if (!File.Exists(savedFile))
{
Dispatcher.Invoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(
delegate()
{
GestionSharepoint gSP = new GestionSharepoint();
string extension = string.Empty;
this._document = gSP.GetFile(leDocument, "ICOMI_BPH", out extension);
File.WriteAllBytes(savedFile, this._document);
}
));
}
e.Result = savedFile;
}
}
catch
{
e.Result = null;
}
}
static void Main(string[] args)
{
//if (args.Length < 1) { Console.WriteLine("SP_Ctx <url>"); return; }
//string targetSite = args[0];
//using (ClientContext ctx = ClaimClientContext.GetAuthenticatedContext(targetSite))
//{
// if (ctx != null)
// {
// ctx.Load(ctx.Web); // Query for Web
// ctx.ExecuteQuery(); // Execute
// var list = ctx.Web.Lists.GetByTitle("ICOMI_ERP_PLANIF");
// var camlQuery = new CamlQuery
// {
// ViewXml = @"<View/>"
// };
// var listItemCollection = list.GetItems(camlQuery);
// ctx.Load(listItemCollection);
// ctx.ExecuteQuery();
// string s = string.Empty;
// foreach (var item in listItemCollection)
// {
// foreach (var key in item.FieldValues.Keys)
// {
// Console.WriteLine(key);
// Console.WriteLine(item.FieldValues[key]);
// }
// }
// }
//}
//using (ClientContext ctx = ClaimClientContext.GetAuthenticatedContext(GestionSharepoint.SharepointUrl))
//{
// if (ctx != null)
// {
//ctx.Load(ctx.Web); // Query for Web
//ctx.ExecuteQuery(); // Execute
//foreach (var item in ctx.Web.Folders)
//{
// ctx.Load(item.Files);
// ctx.ExecuteQuery();
//}
var gSP = new GestionSharepoint();
//Sharepoint.QueryServiceSoapClient monClient = new Sharepoint.QueryServiceSoapClient();
//monClient.ClientCredentials.UserName.UserName = "******";
//monClient.ClientCredentials.UserName.Password = "******";
//System.Data.DataSet queryResults = monClient.QueryEx(GetXMLString());
var ctx = SharepointContextFactory.GetContext();
var list = ctx.Web.Lists.GetByTitle("ICOMI_ERP_PLANIF");
ctx.Load(list);
ctx.ExecuteQuery();
string dede = @"<View><Query> <Where> <DateRangesOverlap> <FieldRefName='EventDate' /> <FieldRefName='EndDate' /> <FieldRefName='RecurrenceID' /> <ValueType='DateTime'> <Today /> </Value> </DateRangesOverlap> </Where> </Query> <QueryOptions> <ExpandRecurrence>TRUE</ExpandRecurrence> <CalendarDate> <Today /> </CalendarDate> <ViewAttributesScope='RecursiveAll' /> </QueryOptions> </View>";
string dede2 = @"<View><Query> <Where><DateRangesOverlap> <FieldRef Name='EventDate' /> <FieldRef Name='EndDate' /> <FieldRef Name='RecurrenceID'/> <Value Type='DateTime'> <Today /> </Value> </DateRangesOverlap> </Where> </Query></View>";
string dede3 = "<View scope='RecursiveAll'><Query> <Where><And><Eq> <FieldRef Name='User'/> <Value Type='Lookup'>Alexandre Equoy</Value> </Eq> <DateRangesOverlap> <FieldRef Name='EventDate' /> <FieldRef Name='EndDate' /> <FieldRef Name='RecurrenceID'/> <Value Type='DateTime'> <Today /> </Value> </DateRangesOverlap> </And></Where> </Query></View>";
var camlQuery = new CamlQuery
{
ViewXml = dede3
};
// </And>LookupId='TRUE'
var l = list.GetItems(camlQuery);
ctx.Load(l);
ctx.ExecuteQuery();
foreach (var item in l)
{
string s = item.FieldValues["StartTime"].ToString();
foreach (var item2 in item.FieldValues)
{
}
}
ChangeToken ct = null;
var q = list.GetChanges(new ChangeQuery() { Add = true });
//ctx.Web.GetChanges( Add = true, Update = true, File = true });
ctx.Load(q);
ctx.ExecuteQuery();
while (q.Count > 0)
{
}
string tempDir = @"C:\Users\aequoy.ACCESSIT\Documents";
string fileTest = @"C:\Users\aequoy.ACCESSIT\Documents\catalogue_formation_2012_normal.pdf";
string LibraryName = "ICOMI_BPH";
var dmDC = new DocumentMetadataDataContract();
dmDC.Auteur = "Alexandre Equoy";
dmDC.Commentaires="Je peux laisser un commentaire sur ce document";
dmDC.CreateDate = DateTime.Now;
dmDC.DocumentVersion=1;
dmDC.Producteur = "ACCESS IT";
dmDC.RubriqueDocument = "Lutte contre les nuisibles";
dmDC.SousTypeDocument = "Preuve";
dmDC.TypeDocument = "Contrat";
dmDC.RubriqueDocumentCode = "LN";
dmDC.SousTypeDocumentCode = "PRV";
dmDC.TypeDocumentCode = "CTN";
dmDC.Titre = "Catalogue de formation";
//gSP.AddFile(LibraryName, dmDC, System.IO.File.ReadAllBytes(fileTest), ".PDF");
string extension = string.Empty;
var ll = gSP.GetAllDocumentMetaByRubrique("LN", LibraryName, out extension);
// }
//}
Console.ReadLine();
}
