public object GetResult(ccEntities db, CC.Data.Services.IPermissionsBase permissionsBase) { var source = from c in db.Clients.Where(permissionsBase.ClientsFilter) where c.Id == this.ClientId from item in c.UnmetNeeds1 where item.ClientId == this.ClientId select new { StartDate = item.StartDate, WeeklyHours = item.WeeklyHours }; var filtered = source; var ordered = filtered.OrderByField(this.sSortCol_0, this.sSortDir_0 == "asc"); return(new jQueryDataTableResult { sEcho = this.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = source.Count(), aaData = ordered.Skip(this.iDisplayStart).Take(this.iDisplayLength).ToList().Select(f => new { StartDate = f.StartDate.ToShortDateString(), IsoStartDate = f.StartDate.ToString("s"), WeeklyHours = f.WeeklyHours.ToString() }) }); }
public override void Load(ccEntities db, IPermissionsBase permissions, int id) { base.Load(db, permissions, id); this.Comments = db.Comments.Where(f => f.MainReportInternalComments.Any(m => m.Id == id)).OrderByDescending(f => f.Date) .Select(f => new CommentViewModel() { Content = f.Content, UserName = f.User.UserName, Date = f.Date }).OrderByDescending(f => f.Date).ToList(); switch ((FixedRoles)this.User.RoleId) { case FixedRoles.Admin: case FixedRoles.RegionOfficer: case FixedRoles.GlobalOfficer: this.CanAddRemarks = true; break; default: this.CanAddRemarks = false; break; } }
private static void InsertClient(ccEntities db, Client client) { var clientproperties = typeof(Client).GetProperties(); var method = typeof(ccEntities).GetMethod("Insert"); var parameters = method.GetParameters(); var values = new List <object>(); var q = from p in parameters join prop in clientproperties on p.Name.ToLowerInvariant() equals prop.Name.ToLowerInvariant() into g from prop in g.DefaultIfEmpty() select prop == null ? null : prop.GetValue(client); //db.Insert(client.Id, client.MasterId, client.AgencyId, client.NationalId, client.NationalIdTypeId, // client.FirstName, client.MiddleName, client.LastName, client.Phone, client.BirthDate, client.Address, client.City, client.StateId, // client.ZIP, client.JoinDate, client.LeaveDate, client.LeaveReasonId, client.LeaveRemarks, client.DeceasedDate, client.ApprovalStatusId, client.FundStatusId, client.IncomeCriteriaComplied, // client.IncomeVerificationRequired, client.NaziPersecutionDetails, client.Remarks, client.PobCity, client.PobCountry, // client.EmigrationDate, client.PrevFirstName, client.PrevLastName, client.OtherFirstName, client.OtherLastName, // client.OtherDob, client.OtherId, client.OtherIdTypeId, client.OtherAddress, client.PreviousAddressInIsrael, // client.CompensationProgramName, client.IsCeefRecipient, client.CeefId, client.AddCompName, client.AddCompId, client.GfHours, // client.GovHcHours, client.ExceptionalHours, client.UpdatedById, client.UpdatedAt, client.CreatedAt, client.SS_, // client.A2, client.HARDSHIP, client.CEEF, client.CEEF, client.MatchFlag, client.UserNameMatch, client.DateMatch, // client.Date_of_birth_was_not_matched, client.Provided_other_DOB, client.Identification_Card___was_not_matched, // client.Provided_other_ID_Card, client.Other_addresses_required, client.Provided_other_addresses, // client.Previous_address_in_Israel_required, client.Provided_previous_address_in_Israel, client.New_Client); var retval = method.Invoke(db, q.ToArray()); }
public CcRepository() { _dataContext = new ccEntities(); _dataContext.SavingChanges += new EventHandler(_dataContext_SavingChanges); CreateRepositories(_dataContext); }
public override void OnAuthorization(AuthorizationContext filterContext) { using (ccEntities context = new ccEntities()) { var membershipUser = context.MembershipUsers .Include(f => f.User) .SingleOrDefault(f => f.LoweredUserName == filterContext.HttpContext.User.Identity.Name); if (membershipUser != null) { if (PasswordExpiresInDays > 0 && (membershipUser.LastPasswordChangedDate == null || ((DateTime)membershipUser.LastPasswordChangedDate).AddDays(PasswordExpiresInDays) < DateTime.Now.Date) || membershipUser.User.TemporaryPassword) { if (!filterContext.HttpContext.Request.IsJsonRequest()) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Account", action = "ChangePassword" })); } else { filterContext.Result = new jsdtr() { Data = new { errorCode = "PasswordExpired", message = "Password has expired" }, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; filterContext.HttpContext.Response.StatusCode = 403; filterContext.HttpContext.Response.TrySkipIisCustomErrors = true; } } } } base.OnAuthorization(filterContext); }
public FundStatusConverter() { using (var db = new ccEntities()) { _fundStatuses = db.FundStatuses.ToList(); } }
public void CreatePost_Test() { ClientCreateModel cm = new ClientCreateModel(); cm.Data = new Client(); string randomName = System.IO.Path.GetRandomFileName(); cm.Data.FirstName = randomName; cm.Data.LastName = "last"; cm.Data.City = "city"; cm.Data.Address = "address"; cm.Data.AgencyId = new ccEntities().Agencies.First().Id; cm.Data.CountryId = new ccEntities().Countries.First().Id; cm.Data.JoinDate = DateTime.Now; ActionResult actual = Target.Create(cm); ccEntities context = new ccEntities(); Client newClient = context.Clients.Single(x => x.FirstName == randomName); Assert.IsNotNull(newClient == null, "new client was not created"); Assert.IsTrue(newClient.City == "city", "new client city was not saved"); }
public JsonResult PreviewData(Guid id, CC.Web.Models.jQueryDataTableParamModel jq) { CheckImportIdPermissions(id); using (var db = new ccEntities()) { var HomeCareEntitledPeriods = db.HomeCareEntitledPeriods; var ImportHceps = db.ImportHceps; var q = PreviewDataQuery(id, db, HomeCareEntitledPeriods, ImportHceps); var filtered = q; var sorted = filtered.OrderByDescending(f => f.Errors.Count()); if (jq.iSortCol_0 != 1) { sorted = filtered.OrderByField(Request["mDataProp_" + jq.iSortCol_0], jq.sSortDir_0 == "asc"); } if (Request["iSortCol_1"] != null && jq.iSortCol_0 != 1) { sorted = sorted.ThenByField(Request["mDataProp_" + Request["iSortCol_1"]], Request["sSortDir_1"] == "asc"); } if (Request["iSortCol_2"] != null && jq.iSortCol_0 != 1) { sorted = sorted.ThenByField(Request["mDataProp_" + Request["iSortCol_2"]], Request["sSortDir_2"] == "asc"); } var result = new jQueryDataTableResult() { sEcho = jq.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = q.Count(), aaData = sorted.Skip(jq.iDisplayStart).Take(jq.iDisplayLength).ToList() }; return(this.MyJsonResult(result, JsonRequestBehavior.AllowGet)); } }
public Repository(ccEntities objectContext) { _objectContext = objectContext as ccEntities; _objectSet = objectContext.CreateObjectSet <T>(); _objectContext.SavingChanges += new EventHandler(_objectContext_SavingChanges); _objectContext.ObjectMaterialized += new ObjectMaterializedEventHandler(_objectContext_ObjectMaterialized); }
public static void CreateClient(string FirstName, string LastName, string AgencyName) { var context = new ccEntities(); Client c1 = new Client(); int UpdateById = context.Users.First().Id; c1.Agency = context.Agencies.First(c => c.Name == AgencyName); c1.FirstName = FirstName; c1.LastName = LastName; c1.UpdatedById = UpdateById; c1.CountryId = c1.Agency.AgencyGroup.CountryId; c1.StateId = c1.Agency.AgencyGroup.StateId; c1.JoinDate = DateTime.Now; try { var client = context.Clients.First(x => x.FirstName == FirstName); } catch { context.Clients.AddObject(c1); context.SaveChanges(); } }
public object GetPreview(ccEntities db, CC.Web.Models.jQueryDataTableParamModel jq) { var q = PreviewData(db); var filtered = q; if (!string.IsNullOrEmpty(jq.sSearch)) { filtered = filtered.Where(f => f.FundName.Contains(jq.sSearch) || f.AgencyGroupName.Contains(jq.sSearch) || f.Name.Contains(jq.sSearch) || f.CurrencyId.Equals(jq.sSearch)); } var ordered = filtered.OrderByField(jq.sSortCol_0, jq.bSortDir_0); return(new CC.Web.Models.jQueryDataTableResult <object> { aaData = ordered.Skip(jq.iDisplayStart).Take(jq.iDisplayLength).ToList(), iTotalDisplayRecords = filtered.Count(), iTotalRecords = q.Count(), sEcho = jq.sEcho }); }
public object GetResult(ccEntities db, CC.Data.Services.IPermissionsBase permissionsBase) { var source = from c in db.Clients.Where(permissionsBase.ClientsFilter) where c.Id == this.ClientId from item in c.GrandfatherHours where item.ClientId == this.ClientId select new { StartDate = item.StartDate, Value = item.Value, Type = item.Type }; var filtered = source; var ordered = filtered.OrderByField(this.sSortCol_0, this.sSortDir_0 == "asc"); return(new jQueryDataTableResult { sEcho = this.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = source.Count(), aaData = ordered.Skip(this.iDisplayStart).Take(this.iDisplayLength).ToList().Select(f => new { StartDate = f.StartDate.ToShortDateString(), IsoStartDate = f.StartDate.ToString("s"), Value = f.Value.ToString(), Type = f.Type == 0 ? "Grandfathered" : f.Type == 1 ? "Exceptional" : "BMF Approved" //Type = f.Type == 0 ? "Grandfathered" : "Exceptional" }) }); }
public virtual Dictionary <int, string> GetAllowedServiceTypes() { using (var db = new ccEntities()) { return(db.ServiceTypes.Where(f => !f.DoNotReportInUnmetNeedsOther).Select(f => new { Id = f.ServiceTypeImportId ?? f.Id, Name = f.Name }).ToDictionary(f => f.Id, f => f.Name)); } }
public object GetResult(ccEntities db, CC.Data.Services.IPermissionsBase permissionsBase) { var source = from c in db.Clients.Where(permissionsBase.ClientsFilter) where c.Id == this.ClientId from item in c.UnmetNeedsOthers where item.ClientId == this.ClientId select new { ServiceTypeID = item.ServiceTypeId, ServiceType = item.ServiceType.Name, Amount = item.Amount, CUR = item.CurrencyId }; var filtered = source; var ordered = filtered.OrderByField(this.sSortCol_0, this.sSortDir_0 == "asc"); return(new jQueryDataTableResult { sEcho = this.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = source.Count(), aaData = ordered.Skip(this.iDisplayStart).Take(this.iDisplayLength).ToList().Select(f => new { ServiceTypeId = f.ServiceTypeID, ServiceType = f.ServiceType, Amount = f.Amount.Format(), CUR = f.CUR }) }); }
public static void CreateAgency(string agencyName, string groupName) { var context = new ccEntities(); int gr_id = 0; var gr = context.AgencyGroups.Where(x => x.Name == groupName); if (gr.Any()) { gr_id = gr.First().Id; } var ag = context.Agencies.Where(x => x.Name == agencyName); if (!ag.Any()) { Agency a = new Agency(); a.Name = agencyName; a.GroupId = gr_id; context.Agencies.AddObject(a); try { context.SaveChanges(); } catch (Exception ex) { } } }
public static User GetUser(FixedRoles role, string AgencyName = "") { var context = new ccEntities(); User newUser; string userName = "******" + role.ToString(); try { newUser = context.Users.First(c => c.UserName == userName); } catch { newUser = User.CreateUser(userName, userName); if (AgencyName == "") { AgencyName = "Agency1_FirstTest"; } Agency a1 = context.Agencies.First(c => c.Name == AgencyName); newUser.AgencyId = a1.Id; newUser.RoleId = (int)role; newUser.Email = userName; // newUser.RegionId = a1.RegionId; newUser.AgencyGroupId = a1.AgencyGroup.Id; newUser.MembershipUser.SetPassword(userName); context.Users.AddObject(newUser); context.MembershipUsers.AddObject(newUser.MembershipUser); context.SaveChanges(); } return(newUser); }
public object GetData() { using (var db = new ccEntities()) { var source = PreviewQuery(db, Permissions, Id); var filtered = source; IOrderedQueryable <DataRow> ordered = null; if (this.sSortCol_0 == "RowErrors") { ordered = source.OrderBy(f => f.RowErrors.Any, this.sSortDir_0 == "asc"); } else { ordered = source.OrderByField(this.sSortCol_0, this.sSortDir_0 == "asc"); } return(new jQueryDataTableResult { aaData = ordered.Skip(this.iDisplayStart).Take(this.iDisplayLength).ToList(), iTotalDisplayRecords = filtered.Count(), iTotalRecords = source.Count(), sEcho = sEcho }); } }
public override jQueryDataTableResult GetResult(ccEntities db, IPermissionsBase permissions) { var source = from c in db.Clients.Where(permissions.ClientsFilter) where c.Id == this.ClientId join cr in db.ViewClientReports on c.Id equals cr.ClientId join sr in db.SubReports.Where(permissions.SubReportsFilter) on cr.SubReportId equals sr.Id where sr.AppBudgetService.Service.TypeId != (int)Service.ServiceTypes.EmergencyAssistance where sr.AppBudgetService.Service.ReportingMethodId != (int)Service.ReportingMethods.Homecare && sr.AppBudgetService.Service.ReportingMethodId != (int)Service.ReportingMethods.HomecareWeekly let clientReportsCount = sr.ClientReports.Count() select new ostr { MrStart = sr.MainReport.Start, MrEnd = (DateTime)System.Data.Objects.EntityFunctions.AddDays(sr.MainReport.End, -1), Quantity = cr.Quantity, Amount = cr.TotalAmount, EstAmount = clientReportsCount == 0 ? (decimal?)null : sr.Amount / clientReportsCount, Cur = sr.AppBudgetService.AppBudget.App.CurrencyId, ServiceId = sr.AppBudgetService.ServiceId, ServiceName = sr.AppBudgetService.Service.Name, ServiceTypeName = sr.AppBudgetService.Service.ServiceType.Name, AppName = sr.AppBudgetService.AppBudget.App.Name, FundName = sr.AppBudgetService.AppBudget.App.Fund.Name, MasterFundName = sr.AppBudgetService.AppBudget.App.Fund.MasterFund.Name, SubReportId = sr.Id, MasterFundId = sr.AppBudgetService.AppBudget.App.Fund.MasterFundId }; var filtered = source; if (StartDate.HasValue) { filtered = filtered.Where(f => f.Date >= this.StartDate); } if (EndDate.HasValue) { filtered = filtered.Where(f => f.Date <= this.EndDate); } if (this.ServiceId.HasValue) { filtered = filtered.Where(f => f.ServiceId == this.ServiceId); } if (this.sSortCol_0 == "DateName") { this.sSortCol_0 = "Date"; } var sorted = filtered.OrderByField(this.sSortCol_0, this.sSortDir_0 == "asc"); var data = sorted.Skip(this.iDisplayStart).Take(this.iDisplayLength).ToList(); return(new jQueryDataTableResult { sEcho = this.sEcho, aaData = data, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }); }
public IRepository <Agency> GetAgenciesByRole(FixedRoles role, string AgencyName = "") { User user = Helper.GetUser(role, AgencyName); ccEntities entity = new ccEntities(user); CcRepository cr = new CcRepository(user); return(cr.Agencies); }
public void GetAgenciesForAdmin() { IRepository <Agency> ag1 = GetAgenciesByRole(FixedRoles.GlobalOfficer); IQueryable <Agency> ag2 = new ccEntities().Agencies; Assert.IsTrue(ag1.Select.Count() == ag2.Count(), "Admin can see all agencies"); }
HelpTableConverter() { using (var db = new ccEntities()) { var objectset = db.CreateObjectSet <T>(); this.list = objectset.ToList(); } }
public void UpdateClientsCount(ccEntities db) { var newClients = db.Clients.Where(f => f.ApprovalStatusId == (int)ApprovalStatusEnum.New) .Where(f => !AgencyGroup.TestIds.Contains(f.Agency.GroupId)); NewClientsCount = newClients.Count(); NewClientsExportedCount = newClients.Where(f => f.ACPExported).Count(); }
public static IPermissionsBase GetPermissionsFor(string username) { using (var db = new ccEntities()) { var user = db.Users.Single(f => f.UserName == username); return(GetPermissionsFor(user)); } }
/// <summary> ///Gets or sets the test context which provides ///information about and functionality for the current test run. ///</summary> /// public ClientsController GetTarget_ForUser(FixedRoles role, string AgencyName = "") { ClientsController target = new ClientsController(); ccEntities context = new ccEntities(); target.CcUser = Helper.GetUser(role, AgencyName); return(target); }
public static List <FunctionalityChangeRow> FunctionalityChangeReportHelper(ccEntities db, CC.Data.Services.IPermissionsBase Permissions, int?regionId, int?countryId, int?agencyGroupId) { var date30DaysAgo = DateTime.Now.AddDays(-30); var date180DaysAgo = DateTime.Now.AddDays(-180); var q = from a in db.viewFunctionalityScoreChangeReports where regionId == null || a.RegionId == regionId where countryId == null || a.CountryId == countryId where agencyGroupId == null || a.AgencyGroupId == agencyGroupId where a.UpdatedAt >= date30DaysAgo ? a.UpdatedAt >= date180DaysAgo : false join c in db.Clients.Where(Permissions.ClientsFilter) on a.ClientId equals c.Id select new { ClientId = a.ClientId, RegionId = a.RegionId, CountryId = a.CountryId, AgencyGroupId = a.AgencyGroupId, AgencyName = a.AgencyName, DiagnosticScore = a.DiagnosticScore, StartDate = a.StartDate }; var q1 = q.OrderBy(f => f.ClientId).ThenByDescending(f => f.StartDate).GroupBy(f => f.ClientId).ToList(); List <FunctionalityChangeRow> functionalityChangeList = new List <FunctionalityChangeRow>(); foreach (var item in q1) { FunctionalityChangeRow fcr = new FunctionalityChangeRow(); for (int i = 0; i < item.Count(); i++) { switch (i) { case 0: fcr.ActiveScore = item.ElementAt(i).DiagnosticScore; fcr.DateOfActiveScore = item.ElementAt(i).StartDate; break; case 1: fcr.PriorScore = item.ElementAt(i).DiagnosticScore; fcr.DateOfPriorScore = item.ElementAt(i).StartDate; break; case 2: fcr.PriorPriorScore = item.ElementAt(i).DiagnosticScore; fcr.DateOfPriorPriorScore = item.ElementAt(i).StartDate; break; default: break; } } var temp = item.First(); fcr.ClientId = temp.ClientId; fcr.AgencyName = temp.AgencyName; functionalityChangeList.Add(fcr); } return(functionalityChangeList.OrderBy(f => f.DateOfActiveScore).ToList()); }
public ActionResult Import(Guid id) { using (var db = new ccEntities()) { var res = db.ImportHcepProc(id, Permissions.User.AgencyId, Permissions.User.AgencyGroupId, Permissions.User.RegionId); return(RedirectToAction("Index", "Clients")); } }
public ClientsIndexModel() { HistoryExportModel = new HistoryExportModel(); using (var db = new ccEntities()) { UpdateClientsCount(db); } }
public FundStatusTypeConverter() { using (var db = new ccEntities()) { db.ContextOptions.LazyLoadingEnabled = false; db.ContextOptions.ProxyCreationEnabled = false; fundstatuses = db.FundStatuses.ToList(); } }
public override jQueryDataTableResult GetResult(ccEntities db, IPermissionsBase permissions) { var source = from cr in db.EmergencyReports.Where(permissions.EmergencyReportsFilter) .Where(f => GGOnly ? f.SubReport.AppBudgetService.AppBudget.App.Fund.MasterFundId == 73 : true) where cr.ClientId == this.ClientId where cr.SubReport.AppBudgetService.Service.TypeId == (int)Service.ServiceTypes.EmergencyAssistance select new etr { Date = cr.ReportDate, Amount = cr.Amount, Discretionary = cr.Discretionary, Total = cr.Total, TypeId = cr.TypeId, TypeName = cr.EmergencyReportType.Name, PurposeOfGrant = cr.Remarks, Cur = cr.SubReport.AppBudgetService.AppBudget.App.CurrencyId, ServiceId = cr.SubReport.AppBudgetService.ServiceId, ServiceName = cr.SubReport.AppBudgetService.Service.Name, AppName = cr.SubReport.AppBudgetService.AppBudget.App.Name, FundName = cr.SubReport.AppBudgetService.AppBudget.App.Fund.Name, MasterFundName = cr.SubReport.AppBudgetService.AppBudget.App.Fund.MasterFund.Name, SubReportId = cr.SubReport.Id }; var filtered = source; if (StartDate.HasValue) { filtered = filtered.Where(f => f.Date >= this.StartDate); } if (EndDate.HasValue) { filtered = filtered.Where(f => f.Date <= this.EndDate); } if (this.ServiceId.HasValue) { filtered = filtered.Where(f => f.ServiceId == this.ServiceId); } if (this.TypeId.HasValue) { filtered = filtered.Where(f => f.TypeId == this.TypeId); } if (this.sSortCol_0 == "DateName") { this.sSortCol_0 = "Date"; } var sorted = filtered.OrderByField(this.sSortCol_0, this.sSortDir_0 == "asc"); var data = sorted.Skip(this.iDisplayStart).Take(this.iDisplayLength).ToList(); return(new jQueryDataTableResult { sEcho = this.sEcho, aaData = data, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }); }
protected override void Dispose(bool disposing) { if (db != null) { db.Dispose(); db = null; } base.Dispose(disposing); }