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