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);
            }
        }