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);
}
}
