public ActionResult UploadPrexc(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[2]; var noOfCol = worksheet.Dimension.End.Column; var noOfRow = worksheet.Dimension.End.Row; //GAA int row = 1; for (int i = 0; i < noOfRow; i++) { PREXC prexc = new PREXC(); try { prexc.Desc = worksheet.Cells[i, 1].Value.ToString(); prexc.Code1 = worksheet.Cells[i, 2].Value.ToString(); prexc.Code2 = worksheet.Cells[i, 3].Value.ToString(); prexc.Line = row++; db.prexc.Add(prexc); } catch { } } db.SaveChanges(); // MOOE } return(RedirectToAction("Prexc", "ExpenseCodes")); }
public JsonResult SavePrexc(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 prexc = db.prexc.Where(p => p.ID == id).FirstOrDefault(); prexc.Line = sb.Line; prexc.Desc = sb.Desc; prexc.Code1 = sb.Code1; prexc.Code2 = sb.Code2; try { db.SaveChanges(); } catch { } } catch (Exception ex) { dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString()); try { if (sb.Desc != null && sb.Code1 != null && sb.Code2 != null) { PREXC prexc = new PREXC(); prexc.Line = sb.Line; prexc.Desc = sb.Desc; prexc.Code1 = sb.Code1; prexc.Code2 = sb.Code2; db.prexc.Add(prexc); try { db.SaveChanges(); } catch { } } } catch { } } } return(GetPrexc()); }