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