public void SaveSubAllotmentsAmount(String fsh, 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());
if (UacsHelper.ExpenseExist(Convert.ToString(sb.expense_title)))
{
id = Convert.ToInt32(sb.ID);
var fsa = db.fsa.Where(p => p.ID == id && p.fundsource == fsh).FirstOrDefault();
fsa.expense_title = sb.expense_title;
fsa.amount = Convert.ToDouble(sb.amount);
try { db.SaveChanges(); } catch { }
}
}
catch (Exception ex)
{
dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString());
try
{
if (UacsHelper.ExpenseExist(Convert.ToString(sb.expense_title)))
{
if (sb.expense_title != null)
{
Object uacs_obj = sb.expense_title;
String uacs = uacs_obj.ToString();
var expense_exist = (from exist in db.fsa where exist.expense_title == uacs && exist.fundsource == fsh select exist).ToList();
if (expense_exist.Count <= 0)
{
FundSourceAmount fsa = new FundSourceAmount();
fsa.expense_title = sb.expense_title;
try { fsa.amount = Convert.ToDouble(sb.amount); } catch { fsa.amount = 0.00; }
fsa.fundsource = fsh;
db.fsa.Add(fsa);
try { db.SaveChanges(); } catch { }
}
}
}
}
catch { }
}
}
}
public JsonResult SaveExpenseSubAllotment(FormCollection collection)
{
List <Object> list = JsonConvert.DeserializeObject <List <Object> >(collection.Get("data"));
Int32 id = 0;
foreach (Object s in list)
{
try
{
dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString());
id = Convert.ToInt32(sb.ID);
// var fsa = db.expense_suballotment_expensecode.Where(p => p.ID == id ).FirstOrDefault();
//fsa.expensecode = sb.expense_code;
// fsa.amount = Convert.ToDouble(sb.amount);
try { db.SaveChanges(); } catch { }
}
catch (Exception ex)
{
dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString());
try
{
if (sb.expense_code != null)
{
Object uacs_obj = sb.expense_code;
String uacs = uacs_obj.ToString();
var expense_exist = (from exist in db.fsa where exist.expense_title == uacs && exist.fundsource == collection.Get("fundsource") select exist).ToList();
if (expense_exist.Count <= 0)
{
FundSourceAmount fsa = new FundSourceAmount();
fsa.expense_title = sb.expense_title;
try { fsa.amount = Convert.ToDouble(sb.amount); } catch { fsa.amount = 0.00; }
fsa.fundsource = collection.Get("fundsource");
db.fsa.Add(fsa);
try { db.SaveChanges(); } catch { }
}
}
}
catch { }
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveOrsObligation(FormCollection collection)
{
Int32 id = Convert.ToInt32(collection.Get("ID"));
String data = collection.Get("data");
Int32 line_id = 0;
List <Object> list = JsonConvert.DeserializeObject <List <Object> >(data);
foreach (Object s in list)
{
try
{
dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString());
String expenese_title = (String)sb.expense_title;
var uacs = db.uacs.Where(p => p.Title == expenese_title).FirstOrDefault();
if (uacs != null)
{
line_id = Convert.ToInt32(sb.ID);
var ors_uacs = db.ors_expense_codes.Where(p => p.ID == line_id).FirstOrDefault();
if (User.IsInRole("Admin") || User.IsInRole("Employee"))
{
ors_uacs.uacs = sb.expense_title;
try { ors_uacs.amount = Convert.ToDouble(sb.amount); } catch { ors_uacs.amount = 0.00; }
try { ors_uacs.NetAmount = Convert.ToDouble(sb.NetAmount); } catch { ors_uacs.NetAmount = 0.00; }
try { ors_uacs.TaxAmount = Convert.ToDouble(sb.TaxAmount); } catch { ors_uacs.TaxAmount = 0.00; }
try { ors_uacs.Others = Convert.ToDouble(sb.Others); } catch { ors_uacs.Others = 0.00; }
}
else if (User.IsInRole("Cashier"))
{
try { ors_uacs.NetAmount = Convert.ToDouble(sb.NetAmount); } catch { ors_uacs.NetAmount = 0.00; }
try { ors_uacs.TaxAmount = Convert.ToDouble(sb.TaxAmount); } catch { ors_uacs.TaxAmount = 0.00; }
try { ors_uacs.Others = Convert.ToDouble(sb.Others); } catch { ors_uacs.Others = 0.00; }
}
try { db.SaveChanges(); } catch { }
}
}
catch (Exception ex)
{
dynamic sb = JsonConvert.DeserializeObject <dynamic>(s.ToString());
try
{
String expenese_title = (String)sb.expense_title;
var uacs = db.uacs.Where(p => p.Title == expenese_title).FirstOrDefault();
if (uacs != null)
{
if (User.IsInRole("Admin") || User.IsInRole("Cashier"))
{
var uacs_exist = (from exist in db.ors_expense_codes where exist.uacs == expenese_title && exist.ors_obligation == id select exist).ToList();
if (uacs_exist.Count <= 0)
{
ORS_EXPENSE_CODES oec = new ORS_EXPENSE_CODES();
oec.uacs = sb.expense_title;
oec.ors_obligation = id;
try { oec.amount = Convert.ToDouble(sb.amount); } catch { oec.amount = 0.00; }
try { oec.TaxAmount = Convert.ToDouble(sb.TaxAmount); } catch { oec.TaxAmount = 0.00; }
try { oec.NetAmount = Convert.ToDouble(sb.NetAmount); } catch { oec.NetAmount = 0.00; }
try { oec.Others = Convert.ToDouble(sb.Others); } catch { oec.Others = 0.00; }
db.ors_expense_codes.Add(oec);
db.SaveChanges();
ORSHelper.InsertORSNo(id);
var ors_allotments = (from ors in db.ors
join allotments in db.allotments on ors.allotment equals allotments.ID
where ors.ID == id
select new
{
_allotment = allotments.ID,
fundsource_id = (from _fsh in db.fsh where _fsh.allotment == allotments.ID.ToString() && _fsh.Code == ors.FundSource select _fsh.ID).FirstOrDefault()
}).FirstOrDefault();
var ors_fundsource_uacs = (from _fsa in db.fsa where _fsa.fundsource == ors_allotments.fundsource_id.ToString() && _fsa.expense_title == oec.uacs select _fsa.ID).ToList();
if (ors_fundsource_uacs.Count <= 0)
{
FundSourceAmount new_fsa = new FundSourceAmount();
new_fsa.expense_title = oec.uacs;
new_fsa.amount = 0;
new_fsa.fundsource = ors_allotments.fundsource_id.ToString();
db.fsa.Add(new_fsa);
db.SaveChanges();
}
}
}
}
}
catch (Exception innerex) { }
}
}
return(GetORSUacs(id.ToString()));
}