public ActionResult UploadUacs(HttpPostedFileBase file) { String filename = file.FileName; String contentType = file.ContentType; byte[] filebytes = new byte[file.ContentLength]; var data = file.InputStream.Read(filebytes, 0, Convert.ToInt32(file.ContentLength)); using (var package = new ExcelPackage(file.InputStream)) { var worksheet = package.Workbook.Worksheets[1]; var noOfCol = worksheet.Dimension.End.Column; var noOfRow = worksheet.Dimension.End.Row; //GAA int row = 1; for (int i = 2; i < noOfRow; i++) { UACS uacs = new UACS(); try { uacs.Title = worksheet.Cells[i, 1].Value.ToString(); uacs.Code = worksheet.Cells[i, 2].Value.ToString(); uacs.Line = row++; db.uacs.Add(uacs); } catch { } } db.SaveChanges(); // MOOE } return(RedirectToAction("ExpenseCodes", "ExpenseCodes")); }
public JsonResult SaveExpenseCode(String data) { List <Object> list = JsonConvert.DeserializeObject <List <Object> >(data); Int32 id = 0; foreach (Object s in list) { try { dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString()); //var ps = db.ps.Where(p => p.ID == sb.ID).FirstOrDefault(); id = Convert.ToInt32(sb.ID); var uacs = db.uacs.Where(p => p.ID == id).FirstOrDefault(); uacs.Line = sb.Line; uacs.Title = sb.Title; uacs.Code = sb.Code; try { db.SaveChanges(); } catch { } } catch (Exception ex) { dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString()); try { if (sb.Title != null && sb.Code != null) { UACS uacs = new UACS(); uacs.Line = sb.Line; uacs.Code = sb.Code; uacs.Title = sb.Title; db.uacs.Add(uacs); try { db.SaveChanges(); } catch { } } } catch { } } } return(GetExpenseCodes()); }