public ActionResult Index(StartPieceViewModel vm) { var ctx = new BarCodeContext(); if (vm.FinishPiece == "yes") { var job = new Job { Status = "started", Start = DateTime.Now, End = new DateTime(1900, 01, 01, 00, 00, 00), PieceNo = vm.PieceNo }; ctx.Job.Add(job); ctx.SaveChanges(); vm = viewModel; return View("JobFinish", vm); } else { //var result = ctx.Job.First(a => a.TravellerId == scan.BarCode); var result = ctx.Import.First(a => a.PieceNo == vm.PieceNo); vm.Id = result.Id; vm.Project = result.Project; vm.CompanyName = result.CompanyName; vm.Description = result.Description; vm.JobNo = result.JobNo; viewModel = vm; return View("StartPiece", vm); } }
public ActionResult Index(ImportSettings i) { BarCodeContext db = new BarCodeContext(); Import newImport = new Import(); if (Request.Files["FileUpload"].ContentLength > 0) { string extension = System.IO.Path.GetExtension(Request.Files["FileUpload"].FileName); string path = string.Format("{0}/{1}", Server.MapPath("~/Content/UploadedFolder"),Request.Files["FileUpload"].FileName); //ImportSettings newImportSettings = new ImportSettings(path, extension); if (System.IO.File.Exists(path)) System.IO.File.Delete(path); Request.Files["FileUpload"].SaveAs(path); //string sqlConnectionString = @"Data Source=PRONOY-XPS\XPSSERVER; Database=Import; Trusted_Connection=true;Persist Security Info=True"; //Create connection string to Excel work book string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;Persist Security Info=False"; //Create Connection to Excel work book OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); //Create OleDbCommand to fetch data from Excel OleDbCommand cmd = new OleDbCommand( "Select [Ref],[Customer],[Job No],[Item No], [Labour Code], [Description], [Project], [Company Name] from [Sheet1$]", excelConnection); excelConnection.Open(); OleDbDataReader dReader; dReader = cmd.ExecuteReader(); while (dReader.Read()) { newImport.Ref = (string) dReader["Ref"].ToString(); newImport.Customer = (string) dReader["Customer"].ToString(); newImport.JobNo = (string) dReader["Job No"].ToString(); newImport.ItemNo = (string) dReader["Item No"].ToString(); newImport.PieceNo = newImport.JobNo + '-' + newImport.ItemNo; newImport.LabourCode = (string) dReader["Labour Code"].ToString(); newImport.Description = (string) dReader["Description"].ToString(); newImport.Project = (string) dReader["Project"].ToString(); newImport.CompanyName = (string) dReader["Company Name"].ToString(); if (ModelState.IsValid) { db.Import.Add(newImport); db.SaveChanges(); } } // SqlBulkCopy sqlBulk = new SqlBulkCopy(sqlConnectionString); //Give your Destination table name // sqlBulk.DestinationTableName = "tblStudents"; //sqlBulk.WriteToServer(dReader); excelConnection.Close(); // SQL Server Connection String } return RedirectToAction("Index"); }