public async Task <ActionResult> DeleteConfirmed(int id)
{
UploadAuditTrail uploadAuditTrail = await db.UploadAuditTrails.FindAsync(id);
db.UploadAuditTrails.Remove(uploadAuditTrail);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult SheetUpload(ImportExcel importExcel, UploadAuditTrail uploadAuditTrail)
{
if (ModelState.IsValid)
{
string path = Server.MapPath("~/Upload/" + importExcel.file.FileName);
uploadAuditTrail.file = importExcel.file.FileName;
uploadAuditTrail.PostedDate = DateTime.Now;
uploadAuditTrail.UserIPAddress = Request.UserHostAddress;
uploadAuditTrail.CreatedBy = "wale";
db.UploadAuditTrails.Add(uploadAuditTrail);
db.SaveChanges();
//if (!Directory.Exists(path))
//{
// Directory.CreateDirectory(path);
//}
//Fetch the File Name.
importExcel.file.SaveAs(path);
string excelConnectionString = @"Provider='Microsoft.ACE.OLEDB.12.0';Data Source='" + path + "';Extended Properties='Excel 12.0 Xml;IMEX=1'";
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
//Sheet Name
excelConnection.Open();
string tableName = excelConnection.GetSchema("Tables").Rows[0]["TABLE_NAME"].ToString();
excelConnection.Close();
//End
OleDbCommand cmd = new OleDbCommand("Select * from [" + tableName + "]", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
SqlBulkCopy sqlBulk = new SqlBulkCopy(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)
{
//Give your Destination table name
DestinationTableName = "sale"
};
//Mappings
sqlBulk.ColumnMappings.Add("Date", "AddedOn");
sqlBulk.ColumnMappings.Add("Region", "Region");
sqlBulk.ColumnMappings.Add("Person", "Person");
sqlBulk.ColumnMappings.Add("Item", "Item");
sqlBulk.ColumnMappings.Add("Units", "Units");
sqlBulk.ColumnMappings.Add("Unit Cost", "UnitCost");
sqlBulk.ColumnMappings.Add("Total", "Total");
sqlBulk.WriteToServer(dReader);
excelConnection.Close();
ViewBag.Result = "Successfully Imported";
}
return(View());
}
public async Task <ActionResult> Edit([Bind(Include = "ID,file,CreatedBy,UserIPAddress,PostedDate")] UploadAuditTrail uploadAuditTrail)
{
if (ModelState.IsValid)
{
db.Entry(uploadAuditTrail).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(uploadAuditTrail));
}
// GET: UploadAuditTrails/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UploadAuditTrail uploadAuditTrail = await db.UploadAuditTrails.FindAsync(id);
if (uploadAuditTrail == null)
{
return(HttpNotFound());
}
return(View(uploadAuditTrail));
}
