public async Task <IActionResult> UploadCV(List <IFormFile> files, [FromQuery] string apikey, [FromQuery] string userkey, [FromQuery] string consumerkey, [FromQuery] string token, [FromQuery] int userid) { //if (AuthenticateUser() == false) //{ // return Unauthorized(); //} // if (apikey != "123") // { // return Unauthorized(); // } //Do something with the files here. String FileName = ""; String NewFileName = ""; String Extention = ""; string conStr = configuration.GetSection("Data").GetSection("ConntectionString").Value; RTS.JobStation.Models.Requestfile RequestFileModel = new RTS.JobStation.Models.Requestfile(); RTS.JobStation.Controller.Requestfile RequestFileController = new RTS.JobStation.Controller.Requestfile(); MySql.Data.MySqlClient.MySqlConnection con = null; MySql.Data.MySqlClient.MySqlTransaction MyTran = null; try { con = RTS.JobStation.DatabaseCommands.OpenConnection(); MyTran = RTS.JobStation.DatabaseCommands.OpenTransaction(ref con); foreach (var file in files) { if (file.Length > 0) { if (file == null || file.Length == 0) { return(Content("file not selected")); } FileName = file.FileName; Extention = System.IO.Path.GetExtension(file.FileName); NewFileName = "cv-1510-" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.DayOfYear.ToString() + "-" + DateTime.Now.Hour.ToString() + "-" + DateTime.Now.Minute.ToString() + "-" + DateTime.Now.Second.ToString() + "-" + DateTime.Now.Millisecond + "-" + DateTime.Now.Ticks.ToString() + "-gd-" + Guid.NewGuid().ToString() + Extention; var path = Path.Combine( Directory.GetCurrentDirectory(), "wwwroot", "cvs", NewFileName); using (var stream = new FileStream(path, FileMode.Create)) { await file.CopyToAsync(stream); } } } return(Ok(NewFileName)); } catch (Exception ex) { return(StatusCode(500)); } finally { RTS.JobStation.DatabaseCommands.CloseTransaction(ref MyTran); RTS.JobStation.DatabaseCommands.CloseConnection(ref con); } }
public async Task <IActionResult> UploadDocument(List <IFormFile> files, int candidateID, int RequestID) { //Do something with the files here. String FileName = ""; String NewFileName = ""; String Extention = ""; string conStr = configuration.GetSection("Data").GetSection("ConntectionString").Value; RTS.JobStation.Models.Requestfile RequestFileModel = new RTS.JobStation.Models.Requestfile(); RTS.JobStation.Controller.Requestfile RequestFileController = new RTS.JobStation.Controller.Requestfile(); MySql.Data.MySqlClient.MySqlConnection con = null; MySql.Data.MySqlClient.MySqlTransaction MyTran = null; try { con = RTS.JobStation.DatabaseCommands.OpenConnection(); MyTran = RTS.JobStation.DatabaseCommands.OpenTransaction(ref con); foreach (var file in files) { if (file.Length > 0) { if (file == null || file.Length == 0) { return(Content("file not selected")); } FileName = file.FileName; Extention = System.IO.Path.GetExtension(file.FileName); NewFileName = Guid.NewGuid().ToString() + Extention; var path = Path.Combine( Directory.GetCurrentDirectory(), "wwwroot", "cvs", NewFileName); using (var stream = new FileStream(path, FileMode.Create)) { await file.CopyToAsync(stream); } } RequestFileModel.UserID = Int32.Parse(Request.Headers["UserID"].ToString()); RequestFileModel.FileName = FileName; RequestFileModel.FileURL = NewFileName; RequestFileModel.MIMEType = Extention; RequestFileModel.RequestID = RequestID; RequestFileModel.UpdatedBy = Request.Headers["UserID"]; RequestFileModel.UpdatedOn = DateTime.Now; RequestFileController.Insert(RequestFileModel, ref con, ref MyTran); } return(Ok()); } catch (Exception ex) { return(StatusCode(500)); } finally { RTS.JobStation.DatabaseCommands.CloseTransaction(ref MyTran); RTS.JobStation.DatabaseCommands.CloseConnection(ref con); } }
public async Task <IActionResult> UploadDocuments(List <IFormFile> files, [FromForm] string CandidateID, [FromForm] string FileTypeID, [FromForm] string FileDisplayName, [FromForm] string RequestID, [FromQuery] string apikey, [FromQuery] string userkey, [FromQuery] string consumerkey, [FromQuery] string token, [FromQuery] int userid) { //if (AuthenticateUser() == false) //{ // return Unauthorized(); //} // if (apikey != "123") // { // return Unauthorized(); // } //Do something with the files here. String FileName = ""; String NewFileName = ""; String Extention = ""; string conStr = configuration.GetSection("Data").GetSection("ConntectionString").Value; RTS.JobStation.Models.Requestfile RequestFileModel = new RTS.JobStation.Models.Requestfile(); RTS.JobStation.Controller.Requestfile RequestFileController = new RTS.JobStation.Controller.Requestfile(); MySql.Data.MySqlClient.MySqlConnection con = null; MySql.Data.MySqlClient.MySqlTransaction MyTran = null; try { con = RTS.JobStation.DatabaseCommands.OpenConnection(); MyTran = RTS.JobStation.DatabaseCommands.OpenTransaction(ref con); if (FileDisplayName.ToString() == "undefined") { FileDisplayName = ""; } foreach (var file in files) { if (file.Length > 0) { RTS.JobStation.Controller.Candidatedocument CandidateDocumentController = new RTS.JobStation.Controller.Candidatedocument(); RTS.JobStation.Models.Candidatedocument CandidateDocumentModel = new RTS.JobStation.Models.Candidatedocument(); RTS.JobStation.Controller.Requestfile RequestfileController = new RTS.JobStation.Controller.Requestfile(); RTS.JobStation.Models.Requestfile RequestfileModel = new RTS.JobStation.Models.Requestfile(); if (file == null || file.Length == 0) { return(Content("file not selected")); } FileName = file.FileName; Extention = System.IO.Path.GetExtension(file.FileName); NewFileName = "cv-1510-" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.DayOfYear.ToString() + "-" + DateTime.Now.Hour.ToString() + "-" + DateTime.Now.Minute.ToString() + "-" + DateTime.Now.Second.ToString() + "-" + DateTime.Now.Millisecond + "-" + DateTime.Now.Ticks.ToString() + "-gd-" + Guid.NewGuid().ToString() + Extention; var path = Path.Combine( Directory.GetCurrentDirectory(), "wwwroot", "cvs", NewFileName); using (var stream = new FileStream(path, FileMode.Create)) { await file.CopyToAsync(stream); } //Save File Information to Database CandidateDocumentModel.CandidateDocumentTypeID = Int32.Parse(FileTypeID); CandidateDocumentModel.DateUploaded = DateTime.Now; CandidateDocumentModel.CandidateID = Int32.Parse(CandidateID); CandidateDocumentModel.FileName = FileDisplayName.ToString().Replace(" ", ""); CandidateDocumentModel.FileLocation = NewFileName.ToString(); CandidateDocumentModel.MimeType = Extention.ToString(); CandidateDocumentModel.UpdatedBy = Request.Headers["userid"]; CandidateDocumentModel.UpdatedOn = DateTime.Now; if (Int32.Parse(RequestID) == 0) { CandidateDocumentController.Insert(CandidateDocumentModel, ref con, ref MyTran); } else { RequestfileModel.RequestID = Int32.Parse(RequestID); RequestfileModel.DateUploaded = DateTime.Now; RequestfileModel.FileURL = NewFileName.ToString().Replace(" ", ""); RequestfileModel.FileName = FileDisplayName.ToString(); RequestfileModel.MIMEType = Extention.ToString(); RequestfileModel.UserID = Int32.Parse(Request.Headers["userid"]); RequestfileModel.UpdatedBy = Request.Headers["userid"]; RequestfileModel.UpdatedOn = DateTime.Now; RequestFileController.Insert(RequestfileModel, ref con, ref MyTran); int RequestFileID = Int32.Parse(JobStation.DatabaseCommands.GetLastInsertedID(ref con, ref MyTran).ToString()); CandidateDocumentModel.WorkFlowRequestFileID = RequestFileID; CandidateDocumentController.Insert(CandidateDocumentModel, ref con, ref MyTran); } } } return(Ok(NewFileName)); } catch (Exception ex) { return(StatusCode(500)); } finally { RTS.JobStation.DatabaseCommands.CloseTransaction(ref MyTran); RTS.JobStation.DatabaseCommands.CloseConnection(ref con); } }