public void SaveDefaultSouceOfFundRecord(Guid TenantID, Guid OrganizationID) { DateTime dt = DateTime.Now; var Sourceoffund = db.SourceOfFunds.ToList(); foreach (SourceOfFunds source in Sourceoffund) { db.SourceOfFundsOrganizationSettings.Add(new SourceOfFundsOrganizationSettings() { SourceOfFundID = source.SourceOfFundID, OrganizationID = OrganizationID, TenantID = TenantID, EnableSourceOFFund = false, DateCreated = dt }); db.SaveChanges(); } var DefaultSourceOFFund1 = "Budgetary allocation/appropriation"; var DefaultSourceOFFundID1 = db.SourceOfFunds.Where(x => x.SourceOfFund.Contains(DefaultSourceOFFund1)).Select(x => x.SourceOfFundID).FirstOrDefault(); var sourceOfFund1 = db.SourceOfFundsOrganizationSettings.Where(x => x.SourceOfFundID == DefaultSourceOFFundID1 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList(); SourceOfFundsOrganizationSettings sourceOfFundsOrganizationSettings = sourceOfFund1.First(); sourceOfFundsOrganizationSettings.EnableSourceOFFund = true; sourceOfFundsOrganizationSettings.DateModified = dt; var DefaultSourceOFFund2 = "Internally generated fund"; var DefaultSourceOFFundID2 = db.SourceOfFunds.Where(x => x.SourceOfFund.Contains(DefaultSourceOFFund2)).Select(x => x.SourceOfFundID).FirstOrDefault(); var sourceOfFund2 = db.SourceOfFundsOrganizationSettings.Where(x => x.SourceOfFundID == DefaultSourceOFFundID2 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList(); sourceOfFundsOrganizationSettings = sourceOfFund2.First(); sourceOfFundsOrganizationSettings.EnableSourceOFFund = true; sourceOfFundsOrganizationSettings.DateModified = dt; var DefaultSourceOFFund3 = "Special intervention fund"; var DefaultSourceOFFundID3 = db.SourceOfFunds.Where(x => x.SourceOfFund.Contains(DefaultSourceOFFund3)).Select(x => x.SourceOfFundID).FirstOrDefault(); var sourceOfFund3 = db.SourceOfFundsOrganizationSettings.Where(x => x.SourceOfFundID == DefaultSourceOFFundID3 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList(); sourceOfFundsOrganizationSettings = sourceOfFund3.First(); sourceOfFundsOrganizationSettings.EnableSourceOFFund = true; sourceOfFundsOrganizationSettings.DateModified = dt; var DefaultSourceOFFund4 = "Power sector intervention fund"; var DefaultSourceOFFundID4 = db.SourceOfFunds.Where(x => x.SourceOfFund.Contains(DefaultSourceOFFund4)).Select(x => x.SourceOfFundID).FirstOrDefault(); var sourceOfFund4 = db.SourceOfFundsOrganizationSettings.Where(x => x.SourceOfFundID == DefaultSourceOFFundID4 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList(); sourceOfFundsOrganizationSettings = sourceOfFund4.First(); sourceOfFundsOrganizationSettings.EnableSourceOFFund = true; sourceOfFundsOrganizationSettings.DateModified = dt; var DefaultSourceOFFund5 = "ETF Special intervention fund"; var DefaultSourceOFFundID5 = db.SourceOfFunds.Where(x => x.SourceOfFund.Contains(DefaultSourceOFFund5)).Select(x => x.SourceOfFundID).FirstOrDefault(); var sourceOfFund5 = db.SourceOfFundsOrganizationSettings.Where(x => x.SourceOfFundID == DefaultSourceOFFundID5 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList(); sourceOfFundsOrganizationSettings = sourceOfFund5.First(); sourceOfFundsOrganizationSettings.EnableSourceOFFund = true; sourceOfFundsOrganizationSettings.DateModified = dt; db.SaveChanges(); }
public ActionResult Edit(SourceOfFundsOrganizationSettings sourceOfFundsOrganizationSettings, bool EnableSourceOFFund) { string email = Request.Headers["Email"]; var tenantId = catalog.GetTenantIDFromClientURL(email); try { if (tenantId == null) { return(Json(new { success = false, message = "TenantId is null", data = new { } }, JsonRequestBehavior.AllowGet)); } DateTime dt = DateTime.Now; var CurrentSourceOfFundID = db.SourceOfFundsOrganizationSettings.FirstOrDefault(s => s.SourceOfFundID == sourceOfFundsOrganizationSettings.SourceOfFundID); if (CurrentSourceOfFundID == null) { LogHelper.Log(Log.Event.UPDATE_SOURCEOFFUNDS, "SourceOfFundID not found"); return(Json(new { success = false, message = "SourceOfFundID not found", data = new { } }, JsonRequestBehavior.AllowGet)); } CurrentSourceOfFundID.EnableSourceOFFund = EnableSourceOFFund; CurrentSourceOfFundID.DateModified = dt; db.SaveChanges(); } catch (Exception ex) { LogHelper.Log(Log.Event.UPDATE_SOURCEOFFUNDS, ex.Message); ExceptionError(ex.Message, ex.StackTrace); } return(Json(new { success = true, message = "Edited successfully", data = db.SourceOfFundsOrganizationSettings.Where(x => x.TenantID == tenantId).Select(x => new { x.SourceOfFundID, x.SourceOfFunds.SourceOfFund, Enabled = x.EnableSourceOFFund }) }, JsonRequestBehavior.AllowGet)); }