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