public IHttpActionResult PostUser(User user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Users.Add(user); ManageFiles.CreateUserFolder(user.sub, user.given_name); ManageFiles.CreateUserFolder(user.sub, "Shared"); try { db.SaveChanges(); } catch (DbUpdateException) { if (UserExists(user.sub)) { return(Conflict()); } else { throw; } } return(Ok()); }
protected void btnExportPDF_Click(object sender, EventArgs e) { incializarExports(); GridView1.Rows[1].ControlStyle.BackColor = System.Drawing.Color.Black; GridView1.Rows[1].ControlStyle.CssClass = "text-center"; ManageFiles.ExportToPdf(this, GridView1, "ListadeTrabajadores", "Lista de Trabajadores", "azul"); }
public ActionResult LoadFile(FormCollection itemFile) { ViewBag.Instrucoes = false; var fileItem = Request.Files[0]; var uploadFILE1 = itemFile["uploadFILE1"]; string retornoErro = ""; // caminho provisório para teste, este deve receber o valor do input string caminho = itemFile["filePath"]; if (ValidaPadraoDir(caminho)) { List <DocumentoModel> itensPlanilha = new List <DocumentoModel>(); itensPlanilha = ReadSpreadsheet.ObtemItems(fileItem, out retornoErro); @ViewBag.TotalPlanilha = itensPlanilha.Count; if (retornoErro == "") { if (itensPlanilha.Count > 0) { List <ColecaoDocumentosModel> colecaoDocumentos = new List <ColecaoDocumentosModel>(); string dataDiretorio = ""; colecaoDocumentos = ManageFiles.LeArquivos(caminho, itensPlanilha, out retornoErro, out dataDiretorio); new Log("Retorno de leitura de arquivos.", colecaoDocumentos); if (retornoErro == "") { ServicoEmail.EnviaEmail(colecaoDocumentos, itensPlanilha, dataDiretorio, out retornoErro); Sumarizacao(colecaoDocumentos); if (retornoErro != "") { @ViewBag.error = retornoErro; } return(View("Index")); } else { @ViewBag.error = retornoErro; return(View("Index")); } } else { @ViewBag.error = "Não foram retornadas informações a partir da planilha selecionada."; return(View("Index")); } } else { @ViewBag.error = retornoErro; return(View("Index")); } } return(View("Index")); }
private void populatelistView(string p) { try { //dataGridView1.DataSource = null; //dataGridView1.Rows.Clear(); //dataGridView1.Refresh(); label2.Text = ""; //List<Sheets> myMessage= JsonConvert.DeserializeObject<List<Sheets>>(File.ReadAllText(@p)); var reader = new JsonTextReader(new StreamReader(@p, Encoding.GetEncoding(1251))); var serializer = new JsonSerializer { CheckAdditionalContent = false }; List<Sheets> myMessage = (List<Sheets>)serializer.Deserialize(reader, typeof(List<Sheets>)); //using (StreamWriter sw = new StreamWriter(@"c:\json.txt")) // using (JsonWriter writer = new JsonTextWriter(sw)) //{ // myMessage = JsonConvert.DeserializeObject<List<Sheets>>(writer); // //JsonConvert.de // //serializer.Serialize(writer, product); // // {"ExpiryDate":new Date(1230375600000),"Price":0} //} foreach (var file in myMessage) { foreach (Rows r in file.Rows) { if (r.Folders != null) { string strDirIssues = null; foreach (Folder f in r.Folders) { try { if (f.MigrateLoc != null) { if (Directory.Exists(f.MigrateLoc)) { ManageFiles mf = new ManageFiles(); intMigratedfiles = 0; var txtFiles = Directory.EnumerateFiles(f.MigrateLoc, "*.*", SearchOption.TopDirectoryOnly); mf.sheetno = f.SheetLine; mf.Location = f.MigrateLoc; mf.SourceCnt = txtFiles.Count(); mf.MigrateCnt = 0; mf.MigrateUri = Convert.ToInt64(f.RMuri); lstmf.Add(mf); } else { ManageFiles mf = new ManageFiles(); mf.sheetno = f.SheetLine; mf.Location = f.MigrateLoc; mf.SourceCnt = 0; mf.MigrateCnt = 0; mf.Comments = "Not a valid directory"; mf.MigrateUri = Convert.ToInt64(f.RMuri); lstmf.Add(mf); //Loggitt("Source directory issure", f.MigrateLoc + " - " + f.SheetLine.ToString(), LogTypes.dir); strDirIssues += "Not a valid directory("+f.MigrateLoc + ") - SS line No. " + f.SheetLine.ToString() + Environment.NewLine; } } } catch (Exception exp) { ManageFiles mf = new ManageFiles(); mf.sheetno = f.SheetLine; mf.Location = f.MigrateLoc; mf.SourceCnt = 0; mf.MigrateCnt = 0; mf.Comments = "Error: " + exp.Message.ToString(); mf.MigrateUri = Convert.ToInt64(f.RMuri); lstmf.Add(mf); Loggitt("Error", exp.Message.ToString() + " " + f.MigrateLoc + " - " + f.SheetLine.ToString(), LogTypes.err); } if (f.SubFolders != null) { foreach (Subfolder sf in f.SubFolders) { try { if (sf.MigrateLoc != null) { //Console.WriteLine("File Location: " + sf.MigrateLoc); if (Directory.Exists(sf.MigrateLoc)) { ManageFiles mf = new ManageFiles(); intMigratedfiles = 0; var txtFiles = Directory.EnumerateFiles(sf.MigrateLoc, "*.*", SearchOption.TopDirectoryOnly); mf.sheetno = sf.SheetLine; mf.Location = sf.MigrateLoc; mf.SourceCnt = txtFiles.Count(); mf.MigrateCnt = 0; mf.MigrateUri = Convert.ToInt64(sf.RMuri); lstmf.Add(mf); } else { ManageFiles mf = new ManageFiles(); mf.sheetno = sf.SheetLine; mf.Location = sf.MigrateLoc; mf.SourceCnt = 0; mf.MigrateCnt = 0; mf.Comments = "Not a valid directory"; mf.MigrateUri = Convert.ToInt64(sf.RMuri); lstmf.Add(mf); //Loggitt("Source directory issure", sf.MigrateLoc+" - "+sf.SheetLine.ToString(), LogTypes.dir); strDirIssues += "Not a valid directory(" + f.MigrateLoc + ") - SS line No. " + f.SheetLine.ToString() + Environment.NewLine; } } } catch (Exception exp) { ManageFiles mf = new ManageFiles(); mf.sheetno = f.SheetLine; mf.Location = f.MigrateLoc; mf.SourceCnt = 0; mf.MigrateCnt = 0; mf.Comments = "Error: " + exp.Message.ToString(); mf.MigrateUri = Convert.ToInt64(f.RMuri); lstmf.Add(mf); Loggitt("Error", exp.Message.ToString()+" "+sf.MigrateLoc + " - " + sf.SheetLine.ToString(), LogTypes.err); } } } } //build directory log here Loggitt("Source directory issures", strDirIssues, LogTypes.dir); } } } dataGridView1.DataSource = lstmf; } catch (Exception exp) { lblError.Text = exp.Message.ToString(); Loggitt("Error", exp.Message.ToString(), LogTypes.err); } }
protected void btnExportExcel_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToExcel(this, GridView1, "ListadeTrabajadores", "Lista de Trabajadores", "azul"); }
protected void btnExportWord_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToWord(this, GridView1, "ListadeTrabajadores", "Lista de Trabajadores", "rojo"); }
protected void btnExportPDF_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToPdf(this, GridView1, "Planes", "Lista de Planes"); }
protected void btnExportPDF_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToPdf(this, GridView1, "GestionLaboral", "Lista de Gestiones Laborales"); }
protected void btnExportExcel_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToExcel(this, GridView1, "Alarmas", "Lista de Alarmas"); }
protected void btnExportPDF_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToPdf(this, GridView1, "HistoriaClinicaOcupacional", "Lista de examenes"); }
protected void btnExportExcel_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToExcel(this, GridView1, "Accidente_Laboral", "Lista de Accidentes Laborales"); }
protected void btnExportExcel_Click(object sender, EventArgs e) { incializarExports(); ManageFiles.ExportToExcel(this, GridView1, "Puesto_Trabajo", "Lista de Puestos de Trabajo"); }