public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Stiftelse stiftelse = db.Stiftelses.Find(id); if (stiftelse == null) { return(HttpNotFound()); } Pageviews pViews; if (db.Pageviews.Where(p => p.Stiftelse.Id == id).Count() != 0) { pViews = db.Pageviews.First(p => p.Stiftelse.Id == id); pViews.ViewCount++; } else { pViews = new Pageviews { ViewCount = 1, Stiftelse = db.Stiftelses.Find(id) }; db.Pageviews.Add(pViews); } db.SaveChanges(); return(View(stiftelse)); }
public ActionResult DeleteConfirmed(int id) { Stiftelse stiftelse = db.Stiftelses.Find(id); db.Stiftelses.Remove(stiftelse); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Stiftelsenr,Aktnr,Orgnr,Län,Stiftelsenamn,Kommun,Adress,CoAdress,Postnr,Postadress,Telefon,Stiftelsetyp,Status,År,Förmögenhet,Ändamål")] Stiftelse stiftelse) { if (ModelState.IsValid) { db.Entry(stiftelse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(stiftelse)); }
// GET: Stiftelses/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Stiftelse stiftelse = db.Stiftelses.Find(id); if (stiftelse == null) { return(HttpNotFound()); } return(View(stiftelse)); }
public ActionResult UploadExcel(Stiftelse stiftelse, HttpPostedFileBase FileUpload) { List <string> data = new List <string>(); if (FileUpload != null) { // tdata.ExecuteCommand("truncate table OtherCompanyAssets"); if (FileUpload.FileName.EndsWith(".xls") || FileUpload.FileName.EndsWith(".xlsx")) { string filename = Path.GetFileName(FileUpload.FileName); string targetpath = Server.MapPath("~\\App_Data\\"); if (!System.IO.Directory.Exists(targetpath)) { System.IO.Directory.CreateDirectory(targetpath); } string pathToExcelFile = Path.Combine(targetpath + filename); FileUpload.SaveAs(pathToExcelFile); var connectionString = ""; if (filename.EndsWith(".xls")) { connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile); } else if (filename.EndsWith(".xlsx")) { connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile); } OleDbDataAdapter adapter; var ds = new DataSet(); //string sheetName = "Norrbotten"; int succeeded = 0; int failed = 0; var excelFile = new ExcelQueryFactory(pathToExcelFile); //var firstRow = excelFile.WorksheetNoHeader().First(); foreach (var sheet in excelFile.GetWorksheetNames()) { string query = string.Format("SELECT * FROM [{0}$]", sheet); adapter = new OleDbDataAdapter(query, connectionString); adapter.Fill(ds, sheet); DataTable dtable = ds.Tables[sheet]; var region = from a in excelFile.Worksheet(sheet) select a; List <string> errors = new List <string>(); foreach (var a in region) { try { string stiftNr = a["Stiftelsenr"]; if (a["Stiftelsenr"] != "" && a["Aktnr"] != "" && a["Stiftelsenamn"] != "" && db.Stiftelses.Where(s => s.Stiftelsenr == stiftNr).Count() == 0) { Stiftelse TU = new Stiftelse { Stiftelsenr = a["Stiftelsenr"], Aktnr = a["Aktnr"], Orgnr = a["Org#nr"], Län = a["Län"], Stiftelsenamn = a["Stiftelsenamn"], Kommun = a["Kommun"], Adress = a["Adress"], CoAdress = a["C/o adress"], Postnr = a["Postnr"], Postadress = a["Postadress"], Telefon = a["Telefon"], Stiftelsetyp = a["Stiftelsetyp"], Status = a["Status"], År = a["År"].ToString(), Förmögenhet = a["Förmögenhet"], Ändamål = a["Ändamål"], LastModified = DateTime.Now }; TU.Förmögenhet = TU.Förmögenhet == "" ? "0" : TU.Förmögenhet; db.Stiftelses.Add(TU); db.SaveChanges(); succeeded++; } else { //data.Add("<ul>"); //if (a["Stiftelsenr"] == "" || a["Stiftelsenr"] == null) errors.Add("Stiftelsenr missing on row " + a.); //if (a["Aktnr"] == "" || a["Aktnr"] == null) data.Add("<li> Address is required</li>"); //if (a["Org#nr"] == "" || a["Org#nr"] == null) data.Add("<li>ContactNo is required</li>"); //data.Add("</ul>"); //data.ToArray(); //return Json(data, JsonRequestBehavior.AllowGet); failed++; } } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } //return Json("success", JsonRequestBehavior.AllowGet); //return Json(new { upload = "success", s = succeeded, f = failed },JsonRequestBehavior.AllowGet); ViewBag.Successes = succeeded; ViewBag.Failures = failed; return(View()); } else { ViewBag.ErrorMsg = "Only .xls and .xlsx file formats allowed"; return(View()); } } else { ViewBag.ErrorMsg = "No file selected"; return(View()); } }