public ActionResult ImportRecords(ImportTransactions model, string practiceId, string clientId)
{
ImportTransactions trans = new ImportTransactions();
trans.Load();
trans.PracticeId = new Guid(practiceId);
trans.ClientId = new Guid(clientId);
trans.DisplayReoccurringTransaction = model.DisplayReoccurringTransaction;
foreach (string file in Request.Files)
{
HttpPostedFileBase hpf = Request.Files[file];
var fp = Path.Combine(HttpContext.Server.MapPath("~/ImportUploads"), Path.GetFileName(hpf.FileName));
try
{
hpf.SaveAs(fp);
}
catch (Exception)
{
//TODO: have to handle this.
}
Session.Add("UploadFile", fp);
}
return View(trans);
}
public ActionResult GetUploadedTransactions(bool displayRepeating)
{
ImportTransactions trans = new ImportTransactions();
trans.Load();
try
{
var file = Session["UploadFile"];
var fileIn = new FileInfo(file.ToString());
var reader = fileIn.OpenText();
var tfp = new TextFieldParser(reader) { TextFieldType = FieldType.Delimited, Delimiters = new[] { "," } };
while (!tfp.EndOfData)
{
//Parse records into domain object and save to database
var currentRow = tfp.ReadFields();
List<Column> columns = new List<Column>();
if (currentRow.Length == 1)
{
if (trans.Headers == null)
trans.Headers = new List<string>();
trans.Headers.Add(currentRow[0]);
}
else
{
Row r = new Row();
r.Columns = new List<string>();
foreach (string currentField in currentRow)
{
if (trans.Rows == null)
trans.Rows = new List<Row>();
string c = currentField;
r.Columns.Add(c);
}
trans.Rows.Add(r);
}
}
}
catch (Exception)
{
}
if (displayRepeating)
trans.Rows = ProcessTransactions(trans.Rows);
return Json(trans.Rows, JsonRequestBehavior.AllowGet);
}
//
// GET: /ImportTransactions/
public ActionResult Index(string practiceId, string clientId)
{
ImportTransactions model = new ImportTransactions();
model.PracticeId = new Guid(practiceId);
model.ClientId = new Guid(clientId);
model.Load();
return View(model);
}