public async Task <DataTable> getAllJobs()
{
Configuration config = ConfigurationManager.OpenExeConfiguration(System.Windows.Forms.Application.ExecutablePath);
spJobsite = Convert.ToString(config.AppSettings.Settings["SharePointJobSite"].Value);
O365UserName = Convert.ToString(config.AppSettings.Settings["O365UserName"].Value);
joblistName = Convert.ToString(config.AppSettings.Settings["jobListName"].Value);
string tempString = config.AppSettings.Settings["O365Password"].Value;
O365Password = new SecureString();
foreach (char c in tempString)
{
O365Password.AppendChar(c);
}
using (Microsoft.SharePoint.Client.ClientContext context = new Microsoft.SharePoint.Client.ClientContext(spJobsite))
{
try
{
context.Credentials = new Microsoft.SharePoint.Client.SharePointOnlineCredentials(O365UserName, O365Password);
context.Load(context.Web, w => w.Title);
context.ExecuteQuery();
Microsoft.SharePoint.Client.List list = context.Web.Lists.GetByTitle(joblistName);
context.Load(list);
Microsoft.SharePoint.Client.ListItemCollection listitems = list.GetItems(Microsoft.SharePoint.Client.CamlQuery.CreateAllItemsQuery());
context.Load(listitems);
context.ExecuteQuery();
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("JobNumber", typeof(string));
dt.Columns.Add("SiteUrl", typeof(string));
dt.Columns.Add("ProjectType", typeof(string));
foreach (Microsoft.SharePoint.Client.ListItem item in listitems)
{
DataRow row = dt.NewRow();
row["Name"] = item["JobNumber"] + " - " + item["Title"];
row["JobNumber"] = item["JobNumber"];
Microsoft.SharePoint.Client.FieldUrlValue _url = (Microsoft.SharePoint.Client.FieldUrlValue)item["JobSiteUrl"];
row["SiteUrl"] = _url.Url;
row["ProjectType"] = item["ProjectCategory"];
dt.Rows.Add(row);
}
dt.TableName = "JobSiteInfo";
await Task.Delay(1000);
return(dt);
}
catch (Exception ex)
{
return(null);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String url = Page.Request.QueryString["url"];
String fromMemory = Page.Request.QueryString["memory"];
if (url != null)
{
try
{
lblError.Text = "";
System.Net.HttpWebRequest request = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(url);
request.UseDefaultCredentials = true;
System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
System.IO.Stream responseStream = response.GetResponseStream();
string fileName = Path.GetRandomFileName();
//new System.Drawing.Bitmap(responseStream).Save(@"C:\Digitas\" + fileName + ".tif", System.Drawing.Imaging.ImageFormat.Tiff);
//System.IO.Stream tbStream = File.OpenRead(@"C:\Digitas\" + fileName + ".tif");
decoder = new TiffBitmapDecoder(responseStream, BitmapCreateOptions.PreservePixelFormat, BitmapCacheOption.Default);
int pagecount = decoder.Frames.Count;
//lblError.Text = pagecount.ToString();
TiffBitmapEncoder encoderFile = new TiffBitmapEncoder();
images = new List <System.Drawing.Image>();
for (int i = 0; i < decoder.Frames.Count; i++)
{
MemoryStream ms = new MemoryStream();
TiffBitmapEncoder encoder = new TiffBitmapEncoder();
//ddlPaginas.Items.Add("Página " + (i + 1));
encoder.Frames.Add(decoder.Frames[i]);
encoder.Save(ms);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
images.Add(img);
MemoryStream ms3 = new MemoryStream();
images[i].Save(ms3, System.Drawing.Imaging.ImageFormat.Tiff);
System.Windows.Media.Imaging.BitmapFrame bmFrame = System.Windows.Media.Imaging.BitmapFrame.Create(ms3);
encoderFile.Frames.Add(bmFrame);
}
Session["images"] = images;
System.IO.FileStream fsTemp = new System.IO.FileStream(@"C:\Digitas\" + fileName + ".tif", FileMode.Create);
encoderFile.Save(fsTemp);
fsTemp.Close();
//Response.ContentType = "image/jpeg";
//new System.Drawing.Bitmap(responseStream).Save(@"C:\Digitas\Temp_Tiff.tif", System.Drawing.Imaging.ImageFormat.Tiff);
iTextSharp.text.Document document = new iTextSharp.text.Document(iTextSharp.text.PageSize.LETTER, 5, 5, 5, 5);
iTextSharp.text.pdf.PdfWriter writer = iTextSharp.text.pdf.PdfWriter.GetInstance(document, new System.IO.FileStream(@"C:\Digitas\" + fileName + ".pdf", System.IO.FileMode.Create));
System.Drawing.Bitmap bm = new System.Drawing.Bitmap(@"C:\Digitas\" + fileName + ".tif");
int total = bm.GetFrameCount(System.Drawing.Imaging.FrameDimension.Page);
document.Open();
iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent;
for (int k = 0; k < total; ++k)
{
bm.SelectActiveFrame(System.Drawing.Imaging.FrameDimension.Page, k);
iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(bm, System.Drawing.Imaging.ImageFormat.Bmp);
// scale the image to fit in the page
img.ScaleAbsolute(600, 800);
img.SetAbsolutePosition(0, 0);
cb.AddImage(img);
document.NewPage();
}
document.Close();
Response.ContentType = "Application/pdf";
Response.TransmitFile(@"C:\Digitas\" + fileName + ".pdf");
/*
* System.Drawing.Image img = System.Drawing.Image.FromStream(responseStream);
*
* Tiff image = Tiff.ClientOpen("memory", "r", responseStream, new TiffStream());
*
* if (img == null)
* {
* lblError.Text = "Null image s";
* }
* else
* {
* img.Save(@"C:\Digitas\digit.tif");
* }
*
* if (image == null)
* {
* lblError.Text = "Null image tiff";
* }
* else
* {
* var num = image.NumberOfDirectories();
* lblError.Text = num.ToString();
* }
*/
/*
* MemoryStream ms2 = new MemoryStream();
* images[0].Save(ms2, System.Drawing.Imaging.ImageFormat.Jpeg);
* //BinaryReader br = new BinaryReader(ms2);
* //Byte[] bytes = br.ReadBytes((Int32)ms2.Length);
* byte[] bytes = ms2.ToArray();
* //string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
* string base64String = Convert.ToBase64String(bytes);
* //string base64String = Convert.ToBase64String((byte[])img);
* Image1.ImageUrl = "data:image/jpg;base64," + base64String;
*/
/*
* Session["images"] = images;
*
*
* var document = new Document(PageSize.LETTER, 5, 5, 5, 5);
*
* // Create a new PdfWriter object, specifying the output stream
* var output = new MemoryStream();
* var writer = PdfWriter.GetInstance(document, output);
*
* document.Open();
*
* for (int i = 0; i < images.Count; i++)
* {
* var image = iTextSharp.text.Image.GetInstance(images[i], iTextSharp.text.BaseColor.WHITE);
* image.ScaleAbsolute(600, 800);
* document.Add(image);
* document.NewPage();
* }
*
* document.Close();
*
* Response.ContentType = "application/pdf";
* //Response.AddHeader("Content-Disposition", string.Format("attachment;filename=Receipt-{0}.pdf", txtOrderID.Text));
* Response.BinaryWrite(output.ToArray());
*
*
* // Open the Document for writing
*
* //img.Save(@"C:\Digitas\digit2.jpg");
*
* //Response.ContentType = "image/jpeg";
* //new System.Drawing.Bitmap(ms).Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
*
* //HttpContext.Current.Response.Flush();
* //HttpContext.Current.Response.SuppressContent = true;
* //HttpContext.Current.ApplicationInstance.CompleteRequest();
*
* /*HttpContext.Current.Response.Flush();
* HttpContext.Current.Response.SuppressContent = true;
* HttpContext.Current.ApplicationInstance.CompleteRequest();
*
* /*FileWebRequest request = (FileWebRequest)WebRequest.Create(url);
*
* request.UseDefaultCredentials = true;
*
* System.Net.FileWebResponse response = (System.Net.FileWebResponse)request.GetResponse();*/
//System.IO.Stream responseStream = response.GetResponseStream();
/*System.IO.StreamReader reader = new StreamReader(responseStream);
*
* if (reader == null)
* {
* lblError.Text = "Null";
* }
* else
* {
* MemoryStream ms = new MemoryStream();
* responseStream.CopyTo(ms);
* /*responseStream.Close();
* reader.Close();
*
* Tiff image = Tiff.ClientOpen("memory", "r", ms, new TiffStream());
*
* if (image == null)
* {
* lblError.Text = "Null image";
* }
* lblError.Text = ms.Length.ToString();
* using (FileStream file = new FileStream(@"C:\Digitas\digit.tif", FileMode.Create, System.IO.FileAccess.Write))
* {
* byte[] bytes = new byte[ms.Length];
* ms.Read(bytes, 0, (int)ms.Length);
* file.Write(bytes, 0, bytes.Length);
* //ms.Close();
* //file.Close();
* }
*
* Tiff image = Tiff.Open(@"C:\Digitas\digit.tif", "r");
* if (image == null)
* {
* lblError.Text = "Null image";
* }
* else
* {
* var num = image.NumberOfDirectories();
* lblError.Text = num.ToString();
* }
*
*
* }*/
}
catch (System.Exception ex)
{
lblError.Text = lblError.Text + " 0.- " + ex.Message;
}
}
else if (fromMemory == null)
{
try
{
RPPMain.SharepointLibrary spLibrary = new RPPMain.SharepointLibrary("http://servidors04/sitios/digitalizacion", "Seccion Primera", "autostore", "Rpp1234");
//RPPMain.SharepointLibrary spLibrary = new RPPMain.SharepointLibrary("http://servidors04/sitios/digitalizacion", "Seccion Primera", "administrador", "Zmy45r1");
//int documentoID = int.Parse(Page.Request.QueryString["documentoID"]);
String reg_act_tomo = Page.Request.QueryString["tomo"];
String reg_act_semestre = Page.Request.QueryString["semestre"];
String reg_act_año = Page.Request.QueryString["anio"];
String reg_act_seccion = Page.Request.QueryString["seccion"];
String reg_act_serie = Page.Request.QueryString["serie"];
String reg_act_partida = Page.Request.QueryString["partida"];
String reg_act_libro = Page.Request.QueryString["libro"];
bool firstParameter = true;
bool secondParameter = false;
bool nextParameter = false;
string query = "";
if (reg_act_tomo.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq></And>";
}
}
}
if (reg_act_semestre.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq></And>";
}
}
}
if (reg_act_año.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq></And>";
}
}
}
if (reg_act_seccion.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq></And>";
}
}
}
if (reg_act_serie.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq></And>";
}
}
}
if (reg_act_partida.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq></And>";
}
}
}
if (reg_act_libro.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq></And>";
}
}
}
query = "<View><Query><Where>" + query + "</Where></Query></View>";
query = string.Format(@"<View>
<Query>
<Where>
<And>
<And>
<And>
<And>
<And>
<And>
<Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq>
<Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq>
</And>
<Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq>
</And>
<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq>
</And>
<Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq>
</And>
<Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq>
</And>
<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq>
</And>
</Where>
</Query>
</View>",
reg_act_tomo,
reg_act_semestre,
reg_act_año,
reg_act_seccion,
reg_act_serie,
reg_act_partida,
reg_act_libro);
/*query = string.Format(@query,
* reg_act_tomo,
* reg_act_semestre,
* reg_act_año,
* reg_act_seccion,
* reg_act_serie,
* reg_act_partida,
* reg_act_libro);*/
/*string query = string.Format(@"<View>
* <Query>
* <Where>
* <And>
* <And>
* <And>
* <Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{0}</Value></Eq>
* <Eq><FieldRef Name='Partida' /><Value Type='Text'>{1}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{2}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{3}</Value></Eq>
* </And>
* </Where>
* </Query>
* </View>",
* 2384,
* 1,
* 1,
* "A");*/
System.Collections.ArrayList arlRows = spLibrary.GetLibraryItem(query);
if (arlRows.Count > 0)
{
lblError.Text = "";
Microsoft.SharePoint.Client.ListItem itemRepositorio = (Microsoft.SharePoint.Client.ListItem)arlRows[0];
Dictionary <string, object> dc = (Dictionary <string, object>)itemRepositorio.FieldValues;
Microsoft.SharePoint.Client.FieldUrlValue fURl = (Microsoft.SharePoint.Client.FieldUrlValue)dc["Pagina"];
try
{
System.Net.HttpWebRequest request = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(fURl.Url);
request.UseDefaultCredentials = true;
System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
System.IO.Stream responseStream = response.GetResponseStream();
/*Response.ContentType = "image/jpeg";
* new System.Drawing.Bitmap(responseStream).Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
*
* HttpContext.Current.Response.Flush();
* HttpContext.Current.Response.SuppressContent = true;
* HttpContext.Current.ApplicationInstance.CompleteRequest();*/
}
catch (System.Exception ex)
{
lblError.Text = lblError.Text + " 1.- " + ex.Message;
}
}
}
catch (System.Exception ex)
{
lblError.Text = lblError.Text + " 2.- " + ex.Message;
}
}
else if (fromMemory != null)
{
try
{
images = new List <System.Drawing.Image>();
images = (List <System.Drawing.Image>)Session["images"];
TiffBitmapEncoder encoder = new TiffBitmapEncoder();
MemoryStream ms3 = new MemoryStream();
for (int i = 0; i < images.Count; i++)
{
//ddlPaginas.Items.Add("Página " + (i + 1));
ms3 = new MemoryStream();
images[i].Save(ms3, System.Drawing.Imaging.ImageFormat.Tiff);
System.Windows.Media.Imaging.BitmapFrame bmFrame = System.Windows.Media.Imaging.BitmapFrame.Create(ms3);
encoder.Frames.Add(bmFrame);
}
/*
* MemoryStream ms2 = new MemoryStream();
* images[0].Save(ms2, System.Drawing.Imaging.ImageFormat.Jpeg);
* byte[] bytes = ms2.ToArray();
* string base64String = Convert.ToBase64String(bytes);
* Image1.ImageUrl = "data:image/jpg;base64," + base64String;
*
* /*string fileName = Path.GetTempFileName();
*
* lblError.Text = fileName;
*
* Session["tempFileName"] = fileName;*/
string fileName = Path.GetRandomFileName();
Session["tempFileName"] = fileName + ".tif";
System.IO.FileStream fsTemp = new System.IO.FileStream(@"C:\Digitas\" + fileName + ".tif", FileMode.Create);
encoder.Save(fsTemp);
fsTemp.Close();
iTextSharp.text.Document document = new iTextSharp.text.Document(iTextSharp.text.PageSize.LETTER, 5, 5, 5, 5);
iTextSharp.text.pdf.PdfWriter writer = iTextSharp.text.pdf.PdfWriter.GetInstance(document, new System.IO.FileStream(@"C:\Digitas\" + fileName + ".pdf", System.IO.FileMode.Create));
System.Drawing.Bitmap bm = new System.Drawing.Bitmap(@"C:\Digitas\" + fileName + ".tif");
int total = bm.GetFrameCount(System.Drawing.Imaging.FrameDimension.Page);
document.Open();
iTextSharp.text.pdf.PdfContentByte cb = writer.DirectContent;
for (int k = 0; k < total; ++k)
{
bm.SelectActiveFrame(System.Drawing.Imaging.FrameDimension.Page, k);
iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(bm, System.Drawing.Imaging.ImageFormat.Bmp);
// scale the image to fit in the page
img.ScaleAbsolute(600, 800);
img.SetAbsolutePosition(0, 0);
cb.AddImage(img);
document.NewPage();
}
document.Close();
Response.ContentType = "Application/pdf";
Response.TransmitFile(@"C:\Digitas\" + fileName + ".pdf");
}
catch (Exception exc)
{
lblError.Text = exc.Message;
}
}
}
else
{
//decoder = (TiffBitmapDecoder)Session["decoder"];
images = new List <System.Drawing.Image>();
images = (List <System.Drawing.Image>)Session["images"];
}
}
private void Buscar()
{
try
{
RPPMain.SharepointLibrary spLibrary = new RPPMain.SharepointLibrary("http://servidors04/sitios/digitalizacion", "Seccion Primera", "autostore", "Rpp1234");
lblError.Text = "";
//int documentoID = int.Parse(Page.Request.QueryString["documentoID"]);
String reg_act_tomo = Page.Request.QueryString["tomo"];
String reg_act_semestre = Page.Request.QueryString["semestre"];
String reg_act_año = Page.Request.QueryString["anio"];
String reg_act_seccion = Page.Request.QueryString["seccion"];
String reg_act_serie = Page.Request.QueryString["serie"];
String reg_act_partida = Page.Request.QueryString["partida"];
String reg_act_libro = Page.Request.QueryString["libro"];
bool firstParameter = true;
bool secondParameter = false;
bool nextParameter = false;
string query = "";
if (reg_act_tomo.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq></And>";
}
}
}
if (reg_act_semestre.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq></And>";
}
}
}
if (reg_act_año.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq></And>";
}
}
}
if (reg_act_seccion.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq></And>";
}
}
}
if (reg_act_serie.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq></And>";
}
}
}
if (reg_act_partida.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq></And>";
}
}
}
if (reg_act_libro.Length > 0)
{
if (firstParameter)
{
query = query + "<And><Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq>";
firstParameter = false;
secondParameter = true;
}
else
{
if (secondParameter)
{
query = query + "<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq></And>";
secondParameter = false;
nextParameter = true;
}
else
{
query = "<And>" + query + "<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq></And>";
}
}
}
query = "<View><Query><Where>" + query + "</Where></Query></View>";
/*
* query = string.Format(@"<View>
* <Query>
* <Where>
* <And>
* <And>
* <And>
* <And>
* <And>
* <And>
* <Eq><FieldRef Name='Fec_Reg_Tomo' /><Value Type='Text'>{0}</Value></Eq>
* <Eq><FieldRef Name='Fec_Reg_Semestre' /><Value Type='Text'>{1}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Fec_Reg_A_x00f1_o_x0020_Semestre' /><Value Type='Text'>{2}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>{3}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>{4}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Partida' /><Value Type='Text'>{5}</Value></Eq>
* </And>
* <Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>{6}</Value></Eq>
* </And>
* </Where>
* </Query>
* </View>",
* reg_act_tomo,
* reg_act_semestre,
* reg_act_año,
* reg_act_seccion,
* reg_act_serie,
* reg_act_partida,
* reg_act_libro);
*/
query = string.Format(@query,
reg_act_tomo,
reg_act_semestre,
reg_act_año,
reg_act_seccion,
reg_act_serie,
reg_act_partida,
reg_act_libro);
System.Collections.ArrayList arlRows = spLibrary.GetLibraryItem(query);
if (arlRows.Count > 0)
{
lblError.Text = arlRows.Count.ToString();
List <Prelacion> resultados = new List <Prelacion>();
Prelacion r = new Prelacion();
for (int i = 0; i <= arlRows.Count - 1; i++)
{
Microsoft.SharePoint.Client.ListItem itemRepositorio = (Microsoft.SharePoint.Client.ListItem)arlRows[i];
Dictionary <string, object> dc = (Dictionary <string, object>)itemRepositorio.FieldValues;
Microsoft.SharePoint.Client.FieldUrlValue fURl = (Microsoft.SharePoint.Client.FieldUrlValue)dc["Pagina"];
r = new Prelacion();
r.RepositoryUrl = fURl.Url;
r.Tramitante = dc["No_x002e__x0020_Notaria"].ToString();
resultados.Add(r);
}
gvResultados.DataSource = resultados;
gvResultados.DataBind();
}
}
catch (System.Exception ex)
{
lblError.Text = lblError.Text + " 2.- " + ex.Message;
}
}
private void button1_Click(object sender, EventArgs e)
{
RPPMain.SharepointLibrary spLibrary = null;
try
{
spLibrary = new RPPMain.SharepointLibrary(txtLibreriaSharePoint.Text, "Seccion Primera", "autostore", "Rpp1234");
}
catch (System.Exception ex)
{
MessageBox.Show("Ocurrió un error al intentar conectarse a Sharepoint: " + ex.Message, "Conexión Fallida", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
string query = string.Format(@"<View>
<Query>
<Where>
<And>
<Eq><FieldRef Name='Tipo_x0020_de_x0020_documento' /><Value Type='Text'>{0}</Value></Eq>
<Eq><FieldRef Name='Numero_x0020_de_x0020_Documento' /><Value Type='Text'>{1}</Value></Eq>
</And>
</Where>
</Query>
</View>",
"Escritura Pública",
38773);
query = @"<View>
<Query>
<Where>
<And>
<Eq><FieldRef Name='Partida' /><Value Type='Number'>15</Value></Eq>
<Eq><FieldRef Name='Numero_x0020_de_x0020_Documento' /><Value Type='Text'>38885</Value></Eq>
</And>
<And>
<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>1474</Value></Eq>
<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>1</Value></Eq>
</And>
</Where>
</Query>
</View>";
query = @"<View>
<Query>
<Where>
<And>
<And>
<And>
<Eq><FieldRef Name='Fec_Reg_Seccion' /><Value Type='Text'>I</Value></Eq>
<Eq><FieldRef Name='Fec_Reg_Partida' /><Value Type='Text'>A</Value></Eq>
</And>
<Eq><FieldRef Name='Partida' /><Value Type='Text'>124</Value></Eq>
</And>
<Eq><FieldRef Name='Fec_Reg_Libro' /><Value Type='Text'>1474</Value></Eq>
</And>
</Where>
</Query>
</View>";
ArrayList valores = spLibrary.GetLibraryItem(query);
if (valores.Count > 0)
{
Microsoft.SharePoint.Client.ListItem itemActual = (Microsoft.SharePoint.Client.ListItem)valores[0];
Dictionary <string, object> dc = (Dictionary <string, object>)itemActual.FieldValues;
Microsoft.SharePoint.Client.FieldUrlValue fURl = (Microsoft.SharePoint.Client.FieldUrlValue)dc["Pagina"];
/*
* ArrayList arlResultado = spLibrary.GetLibraryItem(query);
*
* string strUrl = arlResultado[2].ToString().Split('|')[0];
* System.Uri uri = new Uri(strUrl);
*
* var request = System.Net.WebRequest.Create(uri);
*
*/
var request = System.Net.WebRequest.Create(fURl.Url);
request.UseDefaultCredentials = true;
var response = request.GetResponse();
var stream = response.GetResponseStream();
pictureBox1.Image = Bitmap.FromStream(stream);
}
}
public Login()
{
InitializeComponent();
logger = new LogWriter("Login Form Opened");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("es");
DSL obj = new DSL();
DataTable category = obj.getCategories();
DataRow cat_row = category.NewRow();
cat_row["CategoryID"] = -1;
cat_row["CategoryName"] = "--Select--";
category.Rows.InsertAt(cat_row, 0);
cmxCategory.DataSource = category;
cmxCategory.DisplayMember = "CategoryName";
cmxCategory.ValueMember = "CategoryID";
DataTable categoryRC = obj.getCategories();
DataRow categoryRC_row = categoryRC.NewRow();
categoryRC_row["CategoryID"] = -1;
categoryRC_row["CategoryName"] = "--Select--";
categoryRC.Rows.InsertAt(categoryRC_row, 0);
cmbxPositionRC.DataSource = categoryRC;
cmbxPositionRC.DisplayMember = "CategoryName";
cmbxPositionRC.ValueMember = "CategoryID";
worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.DoWork += Worker_DoWork;
worker.ProgressChanged += Worker_ProgressChanged;
// worker.RunWorkerAsync();
qrcode = new QRCodeWinForm();
QRCode_Panel.Controls.Add(qrcode);
Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath);
spJobsite = Convert.ToString(config.AppSettings.Settings["SharePointJobSite"].Value);
spCandidateSite = Convert.ToString(config.AppSettings.Settings["SharePointSafetySite"].Value);
CandidateList = Convert.ToString(config.AppSettings.Settings["quizListName"].Value);
O365UserName = Convert.ToString(config.AppSettings.Settings["O365UserName"].Value);
string tempString = config.AppSettings.Settings["O365Password"].Value;
O365Password = new SecureString();
candidates = new DataTable();
candidates.Columns.Add("CandidateID", typeof(string));
candidates.Columns.Add("First_name", typeof(string));
candidates.Columns.Add("Last_name", typeof(string));
candidates.Columns.Add("Job", typeof(string));
candidates.Columns.Add("Hire_Status", typeof(string));
candidates.Columns.Add("FolderURL", typeof(string));
candidates.Columns.Add("Remaining_Test", typeof(string));
candidates.Columns.Add("DisplayCombobox", typeof(string));
candidates.Columns.Add("Category", typeof(string));
candidates.Columns.Add("Date", typeof(string));
candidates.Columns.Add("DOB", typeof(string));
foreach (char c in tempString)
{
O365Password.AppendChar(c);
}
JobListName = Convert.ToString(config.AppSettings.Settings["jobListName"].Value);
using (Microsoft.SharePoint.Client.ClientContext context = new Microsoft.SharePoint.Client.ClientContext(spJobsite))
{
try
{
context.Credentials = new Microsoft.SharePoint.Client.SharePointOnlineCredentials(O365UserName, O365Password);
context.Load(context.Web, w => w.Title);
context.ExecuteQuery();
Microsoft.SharePoint.Client.List list = context.Web.Lists.GetByTitle(JobListName);
context.Load(list);
Microsoft.SharePoint.Client.ListItemCollection listitems = list.GetItems(Microsoft.SharePoint.Client.CamlQuery.CreateAllItemsQuery());
context.Load(listitems);
context.ExecuteQuery();
foreach (Microsoft.SharePoint.Client.ListItem item in listitems)
{
cmxJobList.Items.Add(item["JobNumber"] + " - " + item["Title"]);
}
cmxJobList.Items.Insert(0, "--Select--");
logger.LogWrite("JobComboBox Populated");
}
catch (Exception ex)
{
logger.LogWrite("JobComboBox Population Failed");
logger.LogWrite(ex.StackTrace);
}
}
using (Microsoft.SharePoint.Client.ClientContext context = new Microsoft.SharePoint.Client.ClientContext(spCandidateSite))
{
context.Credentials = new Microsoft.SharePoint.Client.SharePointOnlineCredentials(O365UserName, O365Password);
context.Load(context.Web, w => w.Title);
context.ExecuteQuery();
Microsoft.SharePoint.Client.List list = context.Web.Lists.GetByTitle(CandidateList);
context.Load(list);
Microsoft.SharePoint.Client.ListItemCollection listitems = list.GetItems(Microsoft.SharePoint.Client.CamlQuery.CreateAllItemsQuery());
context.Load(listitems);
context.ExecuteQuery();
DataRow row_select = candidates.NewRow();
row_select["DisplayCombobox"] = "--Select--";
row_select["CandidateID"] = -1;
candidates.Rows.Add(row_select);
foreach (Microsoft.SharePoint.Client.ListItem item in listitems)
{
// cmbxCandidateList.Items.Add(item["CandidateID"] + " - " + item["First_name"]+"_"+item["Last_name"]);
DataRow row = candidates.NewRow();
row["CandidateID"] = item["CandidateID"];
row["First_name"] = item["First_name"];
row["Last_name"] = item["Last_name"];
row["Job"] = item["Job"];
row["Hire_Status"] = item["Hire_Status"];
Microsoft.SharePoint.Client.FieldUrlValue _url = (Microsoft.SharePoint.Client.FieldUrlValue)item["FolderUrl"];
row["FolderUrl"] = _url.Url;
row["Remaining_Test"] = item["Remaining_Test"];
row["DisplayCombobox"] = item["CandidateID"] + " - " + item["First_name"] + "_" + item["Last_name"];
row["Category"] = item["Category"];
row["Date"] = item["Modified"];
row["DOB"] = item["DOB"];
candidates.Rows.Add(row);
}
cmbxCandidateList.DataSource = candidates;
//cmbxCandidateList.Items.Add(new { Text = "---Select---", Value = -1 });
cmbxCandidateList.DisplayMember = "DisplayCombobox";
cmbxCandidateList.ValueMember = "CandidateID";
cmxJobList.SelectedIndex = 0;
}
}
