public ReturnResult <List <Activity_M> > GetActivity() { ReturnResult <List <Activity_M> > result = new ReturnResult <List <Activity_M> >(); try { List <Activity_M> ActivityList = new List <Activity_M>(); using (DashboardDataContext db = new DashboardDataContext(_connString)) { var ActivitiesDB = db.Activities.OrderBy(x => x.ActivityName).ToList(); foreach (var item in ActivitiesDB) { Activity_M objActivity = new Activity_M(); objActivity.ActivityID = item.ActivityID; objActivity.ActivityDesc = item.ActivityName; ActivityList.Add(objActivity); } result.result = ActivityList; result.status = new OperationStatus() { Status = StatusEnum.Success }; return(result); } } catch (Exception ex) { IExceptionHandler eHandler = new ExceptionHandler(); result.status = eHandler.HandleException(ex); commondbHandler.SaveErrorLog(result.status); return(result); } }
public void Initialize() { var connection = Effort.DbConnectionFactory.CreateTransient(); Context = new DashboardDataContext(connection, true); TestDataLoader.LoadData(new DashboardDataContext(connection, false)); }
public void SimpleIDKeyAttributeMissingQuery() { var context = new DashboardDataContext(); IRepository <Task> userRepo = new Repository <Task>(context); var results = userRepo.Entity.Any(); Assert.IsTrue(results); }
public static void LoadData(DashboardDataContext context) { var users = CreateUsers(); var projects = CreateProjects(); var tasks = CreateTasks(users, projects); int workLogCounter = 1; users.ForEach(u => { u.Tasks = tasks.Where(t => t.AssignedUserID == u.ID).ToList(); foreach (var t in u.Tasks) { t.WorkLogs.Add(CreateWorkLog(u, t, workLogCounter++, $"Work started for {t.Name}.", 10)); t.WorkLogs.Add(CreateWorkLog(u, t, workLogCounter++, $"Work in progress for {t.Name}.", 30)); if (t.Status == Status.Waiting || (t.Status == Status.Completed && t.TaskID % 3 == 0)) { t.WorkLogs.Add(CreateWorkLog(u, t, workLogCounter++, $"Work waiting for {t.Name}.", 20)); } if ((t.Status == Status.Completed && t.TaskID % 3 == 0)) { t.WorkLogs.Add(CreateWorkLog(u, t, workLogCounter++, $"Work resuming for {t.Name}.", 40)); } if (t.Status == Status.Testing || t.Status == Status.Completed) { t.WorkLogs.Add(CreateWorkLog(u, t, workLogCounter++, $"Work being tested for {t.Name}.", 25)); } if (t.Status == Status.Completed) { t.WorkLogs.Add(CreateWorkLog(u, t, workLogCounter++, $"Work finished for {t.Name}.", 60)); } } u.WorkLogs = u.Tasks.SelectMany(t => t.WorkLogs).ToList(); }); projects.ForEach(p => { p.Tasks = tasks.Where(t => t.ProjectID == p.ID).ToList(); }); var workLogs = users.SelectMany(u => u.WorkLogs); context.Users.AddRange(users); context.Projects.AddRange(projects); context.Tasks.AddRange(tasks); context.WorkLogs.AddRange(workLogs); context.SaveChanges(); }
public void SimpleDelete() { var context = new DashboardDataContext(); IRepository <User> userRepo = new Repository <User>(context); var user = userRepo.Entity.Where(n => n.FirstName == "Nate").FirstOrDefault(); userRepo.Delete(user); userRepo.Save(); }
public void SimpleQueryMapped() { var context = new DashboardDataContext(); TinyMapper.Bind <User, UserDTO>(); IRepository <User> userRepo = new Repository <User>(context); var user = userRepo.Entity.ByName("Nate", null).ToDto().ToList(); Assert.IsNotNull(user); }
public void SimpleQuery() { var context = new DashboardDataContext(); IRepository <User> userRepo = new Repository <User>(context); var results = userRepo.Entity .ByUserId(null) .ByName("Nate", null).Any(); Assert.IsTrue(results); }
public void SimpleInsert() { var context = new DashboardDataContext(); IRepository <User> userRepo = new Repository <User>(context); userRepo.AddOrUpdate(new User { FirstName = "Nate", LastName = "Zaugg", }); Assert.AreEqual(1, userRepo.Save()); }
public ReturnResult <List <Status_M> > GetStatus(int activityID) { ReturnResult <List <Status_M> > result = new ReturnResult <List <Status_M> >(); try { List <Status_M> StatusList = new List <Status_M>(); using (DashboardDataContext db = new DashboardDataContext(_connString)) { string errorMessage = ""; int? errorCode = 0; //int errorCode ; var StatusDB = db.USP_Status_Get(activityID, ref errorMessage, ref errorCode).ToList(); if (errorCode != 0) { result.status = new OperationStatus() { Status = StatusEnum.DatabaseMessage, StatusMessage = errorMessage }; return(result); } foreach (var item in StatusDB) { Status_M objStatus = new Status_M(); objStatus.StatusID = item.StatusID; objStatus.StatusDesc = item.StatusDesc; StatusList.Add(objStatus); } result.result = StatusList; result.status = new OperationStatus() { Status = StatusEnum.Success }; return(result); } } catch (Exception ex) { IExceptionHandler eHandler = new ExceptionHandler(); result.status = eHandler.HandleException(ex); commondbHandler.SaveErrorLog(result.status); return(result); } }
public void AbandonTest() { var context = new DashboardDataContext(); IRepository <User> userRepo = new Repository <User>(context); var user = userRepo.Entity.Where(n => n.FirstName == "Nate").FirstOrDefault(); user.LastName = "Zaugg-Abaondoned!"; userRepo.AddOrUpdate(user); userRepo.AbandonChanges(); userRepo.Save(); }
public void SimpleQueryMappedTransaction() { var context = new DashboardDataContext(); TinyMapper.Bind <User, UserDTO>(); IRepository <User> userRepo = new Repository <User>(context); using (var scope = new TransactionScope()) { var user = userRepo.Entity.ByName("Nate", null).ToDto().ToList(); Assert.IsNotNull(user); scope.Complete(); } }
public void DetachedUpdate() { var context = new DashboardDataContext(); IRepository <User> userRepo = new Repository <User>(context); // TODO: What if hte database doesn't generate the keys for us? var user = new User { ID = 4, FirstName = "Nate-Updated", LastName = "Zaugg-Updated", }; userRepo.AddOrUpdate(user); Assert.AreEqual(1, userRepo.Save()); }
public ReturnResult <bool> SaveNewActivityStatus(ActivityStatus_M activityStatus, int C_ID) { ReturnResult <bool> result = new ReturnResult <bool>(); try { using (DashboardDataContext db = new DashboardDataContext(_connString)) { string errorMessage = ""; int? errorCode = 0; //TBD int returnCode = db.USP_NewActivityStatus_Save(activityStatus.Activity.ActivityID, activityStatus.Status.StatusID, C_ID, activityStatus.Notes, activityStatus.Date, activityStatus.EmployeeID, 1, null, null, ref errorMessage, ref errorCode); if (errorCode != 0) { result.result = false; result.status = new OperationStatus() { Status = StatusEnum.DatabaseMessage, StatusMessage = errorMessage }; return(result); } result.result = true; result.status = new OperationStatus() { Status = StatusEnum.Success }; return(result); } } catch (Exception ex) { IExceptionHandler eHandler = new ExceptionHandler(); result.status = eHandler.HandleException(ex); commondbHandler.SaveErrorLog(result.status); return(result); } }
public ReturnResult <SearchCaseResult> GetCaseSearch(CaseSearch caseSearch) { ReturnResult <SearchCaseResult> result = new ReturnResult <SearchCaseResult>(); try { SearchCaseResult searchResult = new SearchCaseResult(); //List<CustomerInfo accounts = new CustomerInfo(); using (DashboardDataContext db = new DashboardDataContext(_connString)) { string errorMessage = ""; int? TotalCount = 0; var Resultdb = db.USP_SearchCase_Get(caseSearch.FirstName, caseSearch.LastName, caseSearch.APNNumber, caseSearch.Analyst.UserID, caseSearch.HearingOfficer.UserID, caseSearch.FromDate, caseSearch.ToDate, caseSearch.AddressLine1, caseSearch.AddressLine2, caseSearch.Zip, caseSearch.PhoneNumber, caseSearch.CaseNumber, caseSearch.CaseStatus, caseSearch.SortBy, caseSearch.SortReverse, caseSearch.PageSize, caseSearch.CurrentPage, ref TotalCount, ref errorMessage); foreach (var item in Resultdb) { SearchResultCaseInfo caseInfo = new SearchResultCaseInfo(); caseInfo.C_ID = Convert.ToInt32(item.C_ID); caseInfo.CaseID = item.CaseID; caseInfo.RankNo = Convert.ToInt32(item.RankNo); caseInfo.ActivityID = Convert.ToInt32(item.ActivityID); caseInfo.ActivityName = Convert.ToString(item.ActivityName); caseInfo.CreatedDate = Convert.ToDateTime(item.CreatedDate); caseInfo.LastModifiedDate = Convert.ToDateTime(item.LastModifiedDate); caseInfo.Analyst = Convert.ToString(item.Analyst); caseInfo.HearingOfficer = Convert.ToString(item.HearingOfficer); caseInfo.TenantName = Convert.ToString(item.TenantName); caseInfo.ApplicantAddressLine1 = Convert.ToString(item.ApplicantAddressLine1); caseInfo.ApplicantAddressLine2 = Convert.ToString(item.ApplicantAddressLine2); caseInfo.ApplicantCity = Convert.ToString(item.ApplicantCity); caseInfo.ApplicantStateID = Convert.ToInt32(item.ApplicantStateID); caseInfo.ApplicantStateCode = Convert.ToString(item.ApplicantStateCode); caseInfo.ApplicantZip = Convert.ToString(item.ApplicantZip); caseInfo.OwnerName = Convert.ToString(item.OwnerName); caseInfo.OPOwnerName = Convert.ToString(item.OPOwnerName); caseInfo.OPAddressLine1 = Convert.ToString(item.OPAddressLine1); caseInfo.OPAddressLine2 = Convert.ToString(item.OPAddressLine2); caseInfo.OPStateCode = Convert.ToString(item.OPStateCode); caseInfo.OPCity = Convert.ToString(item.OPCity); caseInfo.OPOwnerZip = Convert.ToString(item.OPOwnerZip); caseInfo.OwnerTenantName = Convert.ToString(item.OwnerTenantName); caseInfo.PetitionCategoryID = Convert.ToInt32(item.PetitionCategoryID); searchResult.List.Add(caseInfo); } searchResult.PageSize = caseSearch.PageSize; searchResult.SortBy = caseSearch.SortBy; searchResult.SortReverse = caseSearch.SortReverse; searchResult.CurrentPage = caseSearch.CurrentPage; searchResult.TotalCount = (int)TotalCount; } result.result = searchResult; result.status = new OperationStatus() { Status = StatusEnum.Success }; return(result); } catch (Exception ex) { IExceptionHandler eHandler = new ExceptionHandler(); result.status = eHandler.HandleException(ex); commondbHandler.SaveErrorLog(result.status); return(result); } }
/// <summary> /// Get customer information /// </summary> /// <returns>Customer Info Object</returns> public ReturnResult <List <ActivityStatus_M> > GetActivityStatusForCase(int C_ID) { ReturnResult <List <ActivityStatus_M> > result = new ReturnResult <List <ActivityStatus_M> >(); try { // CustomerInfo custinfo ; List <ActivityStatus_M> ActivityStatusList = new List <ActivityStatus_M>(); using (DashboardDataContext db = new DashboardDataContext(_connString)) { string errorMessage = ""; int? errorCode = 0; //int errorCode ; var activityStatusListDB = db.USP_ActivityStatusForCase_Get(C_ID, ref errorMessage, ref errorCode).ToList(); if (errorCode != 0) { result.status = new OperationStatus() { Status = StatusEnum.DatabaseMessage, StatusMessage = errorMessage }; return(result); } foreach (var item in activityStatusListDB) { ActivityStatus_M objActivityStatus = new ActivityStatus_M(); objActivityStatus.Activity.ActivityID = item.ActivityID; objActivityStatus.Activity.ActivityDesc = item.ActivityName; objActivityStatus.Status.StatusID = item.StatusID; objActivityStatus.Status.StatusDesc = item.StatusDesc; objActivityStatus.Date = item.CreatedDate; objActivityStatus.Notes = item.Notes; objActivityStatus.NotificationID = Convert.ToInt32(item.NotificationID); objActivityStatus.NotificationType = item.NotificationType; if (item.CityName != null) { objActivityStatus.CreatedBy = item.CityName; } if (item.CustName != null) { objActivityStatus.CreatedBy = item.CustName; } ActivityStatusList.Add(objActivityStatus); } result.result = ActivityStatusList; result.status = new OperationStatus() { Status = StatusEnum.Success }; return(result); } } catch (Exception ex) { IExceptionHandler eHandler = new ExceptionHandler(); result.status = eHandler.HandleException(ex); commondbHandler.SaveErrorLog(result.status); return(result); } }