public ActionResult create(budgetVM model, FormCollection Form)
{
try
{
ViewBag.items = dbcontext.Budget_class_items.ToList();
ViewBag.sign = dbcontext.Currency.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']' + m.symbol, ID = m.ID });
ViewBag.organization = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID });
if ((model.Budget.Year_From + 1) != model.Budget.Year_To)
{
TempData["Message"] = HR.Resource.organ.Differencebetweenyearsmustbeoneyear;
return(View(model));
}
var ID = int.Parse(model.Budget.Organization_unitid);
model.Budget.organization_unit = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == ID);
var budget = new Budget();
var status = new status();
var just = new justification();
budget = model.Budget;
var item = Form["item"].Split(char.Parse(","));
var AmountN = Form["AmountN"].Split(char.Parse(","));
var AmountF = Form["AmountF"].Split(char.Parse(","));
var commentt = Form["commentt"].Split(char.Parse(","));
var ss = new List <Budget_details>();
var ssf = new List <int>();
for (var iii = 0; iii < item.Count(); iii++)
{
if (item[iii] != "" && AmountN[iii] != "" && AmountF[iii] != "")
{
var IDf = int.Parse(item[iii]);
var le = dbcontext.Budget_class_items.FirstOrDefault(m => m.ID == IDf);
var item_de = new Budget_details
{
Budget_class_items = le, amount_forign = float.Parse(AmountF[iii]), amount_native = float.Parse(AmountN[iii]), comment = commentt[iii], sign_forgin = model.Budget.sign_forign, sign_native = model.Budget.sign_native
};
var sss = dbcontext.Budget_details.Add(item_de);
dbcontext.SaveChanges();
ssf.Add(sss.ID);
ss.Add(sss);
}
}
//if (model.Budget.sign_native != null && model.Budget.sign_forign != null)
//{
// var IDSigN = int.Parse(model.Budget.sign_native);
// budget.sign_native = dbcontext.Currency.FirstOrDefault(m => m.ID == IDSigN).symbol;
// var IDSignF = int.Parse(model.Budget.sign_forign);
// budget.sign_forign = dbcontext.Currency.FirstOrDefault(m => m.ID == IDSignF).symbol;
//}
status = model.status;
status.Type = Models.Infra.Type.Budget;
just = model.justification;
var s = dbcontext.status.Add(status);
var j = dbcontext.justification.Add(just);
dbcontext.SaveChanges();
budget.justification = j;
budget.status = s;
budget.Budget_details = ss;
budget.Budget_detailsID = ssf;
dbcontext.Budget.Add(budget);
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("budget card", HR.Models.user.Action.Create, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("index"));
}
catch (Exception e)
{
return(View(model));
}
}
public ActionResult edit(budgetVM model, FormCollection Form)
{
try
{
var newbudget = dbcontext.Budget.FirstOrDefault(m => m.ID == model.Budget.ID);
var status = dbcontext.status.FirstOrDefault(m => m.ID == model.status.ID);
var just = dbcontext.justification.FirstOrDefault(m => m.ID == model.justification.ID);
ViewBag.items = dbcontext.Budget_class_items.ToList();
ViewBag.sign = dbcontext.Currency.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']' + m.symbol, ID = m.ID });
ViewBag.organization = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID });
if (model.Budget.Budget_detailsID != null)
{
for (var itemm = 0; itemm < model.Budget.Budget_detailsID.Count(); itemm++)
{
var idd = model.Budget.Budget_detailsID[itemm];
var t = dbcontext.Budget_details.FirstOrDefault(m => m.ID == idd);
model.Budget.Budget_details[itemm] = t;
}
}
if ((model.Budget.Year_From + 1) != model.Budget.Year_To)
{
TempData["Message"] = HR.Resource.organ.Differencebetweenyearsmustbeoneyear;
return(View(model));
}
/////////////////////////
var ID = int.Parse(model.Budget.Organization_unitid);
newbudget.organization_unit = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == ID);
///////////////////////////
//if (model.Budget.sign_native != null && model.Budget.sign_forign != null)
//{
// var IDSigN = int.Parse(model.Budget.sign_native);
// newbudget.sign_native = dbcontext.Currency.FirstOrDefault(m => m.ID == IDSigN).symbol;
// var IDSignF = int.Parse(model.Budget.sign_forign);
// newbudget.sign_forign = dbcontext.Currency.FirstOrDefault(m => m.ID == IDSignF).symbol;
//}
/////////////////////////
///////////////////////////////
//////////////////////////////
var old_details = model.Budget.Budget_detailsID;
newbudget.Budget_details = null;
newbudget.Budget_detailsID = null;
if (old_details != null)
{
foreach (var iitem in old_details)
{
var de = dbcontext.Budget_details.FirstOrDefault(m => m.ID == iitem);
dbcontext.Budget_details.Remove(de);
dbcontext.SaveChanges();
}
}
var item = Form["item"].Split(char.Parse(","));
var AmountN = Form["AmountN"].Split(char.Parse(","));
var AmountF = Form["AmountF"].Split(char.Parse(","));
var commentt = Form["commentt"].Split(char.Parse(","));
var ss = new List <Budget_details>();
var ssf = new List <int>();
for (var iii = 0; iii < item.Count(); iii++)
{
if (item[iii] != "" && AmountN[iii] != "" && AmountF[iii] != "")
{
var IDf = int.Parse(item[iii]);
var le = dbcontext.Budget_class_items.FirstOrDefault(m => m.ID == IDf);
var item_de = new Budget_details
{
Budget_class_items = le,
amount_forign = float.Parse(AmountF[iii]),
amount_native = float.Parse(AmountN[iii]),
comment = commentt[iii],
sign_forgin = model.Budget.sign_forign,
sign_native = model.Budget.sign_native
};
var sss = dbcontext.Budget_details.Add(item_de);
dbcontext.SaveChanges();
ssf.Add(sss.ID);
ss.Add(sss);
}
}
// newbudget = model.Budget;
newbudget.Code = model.Budget.Code;
newbudget.Organization_unitid = model.Budget.Organization_unitid;
newbudget.sign_forign = model.Budget.sign_forign;
newbudget.sign_native = model.Budget.sign_native;
newbudget.Year_From = model.Budget.Year_From;
newbudget.Year_To = model.Budget.Year_To;
newbudget.amount_native = model.Budget.amount_native;
newbudget.ammount_forigne = model.Budget.ammount_forigne;
newbudget.Remaining_native = model.Budget.Remaining_native;
newbudget.Remaining_forgin = model.Budget.Remaining_forgin;
newbudget.Budget_details = ss;
newbudget.Budget_detailsID = ssf;
newbudget.Currency_rate = model.Budget.Currency_rate;
dbcontext.SaveChanges();
status.approved_by = model.status.approved_by;
status.approved_bydate = model.status.approved_bydate;
status.cancaled_by = model.status.cancaled_by;
status.cancaled_bydate = model.status.cancaled_bydate;
status.created_by = model.status.created_by;
status.created_bydate = model.status.created_bydate;
status.Rejected_by = model.status.Rejected_by;
status.Rejected_bydate = model.status.Rejected_bydate;
status.return_to_reviewby = model.status.return_to_reviewby;
status.return_to_reviewdate = model.status.return_to_reviewdate;
status.statu = model.status.statu;
dbcontext.SaveChanges();
just.justifiaction = model.justification.justifiaction;
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("budget card", HR.Models.user.Action.edit, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("index"));
}
catch (Exception e)
{
return(View(model));
}
}
