public TestProjectServices()
{
systemService = new SystemTestDataServices(this.TContext);
service = new ProjectServices(this.TContext);
businessService = new BusinessServices(this.TContext);
//sa = GetUserSessionModel("*****@*****.**");
sa = GetUserSessionModel("*****@*****.**");
projecttypes = db.ProjectTypes.FirstOrDefault();
ProjectOpenStatus = db.ProjectOpenStatusTypes.FirstOrDefault();
projectstatus = db.ProjectStatusTypes.FirstOrDefault();
verticaltype = db.VerticalMarketTypes.FirstOrDefault();
}
public override IEnumerable <ProjectStatusType> Get(string name, StringComparison comparisonOption)
{
if (!string.IsNullOrEmpty(name) && this.CanGet())
{
string where = " WHERE ";
if (comparisonOption == StringComparison.CurrentCultureIgnoreCase || comparisonOption == StringComparison.OrdinalIgnoreCase)
{
where += "lower(\"Name\")=lower(:name)";
}
else
{
where += "\"Name\"=:name";
}
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.SelectStatTyp + where;
cmd.Parameters.AddWithValue("name", name);
NpgsqlDataReader rdr = Db.ExecuteReader(cmd);
List <ProjectStatusType> schemes = new List <ProjectStatusType>();
ProjectStatusType o = null;
if (rdr != null)
{
try
{
while (rdr.Read())
{
o = ProjecStatusTypeBuilder.Instance.Build(rdr);
if (o != null)
{
schemes.Add(o);
}
}
if (cmd.Connection.State == System.Data.ConnectionState.Open)
{
cmd.Connection.Close();
}
}
catch
{ }
finally
{
cmd.Dispose();
}
}
return(schemes);
}
return(null);
}
public TestProjectServices_Rule()
{
systemService = new SystemTestDataServices(this.TContext);
projectService = new ProjectServices(this.TContext);
businessService = new BusinessServices(this.TContext);
user = GetUserSessionModel("*****@*****.**");
_projectId = this.db.Context.Projects.Where(p => p.OwnerId == user.UserId && p.Deleted == false).OrderByDescending(p => p.ProjectId).Select(p => p.ProjectId).FirstOrDefault();
projectModel = projectService.GetProjectModel(user, _projectId).Model as ProjectModel;
projectsModel.ProjectId = _projectId;
Response = projectService.GetProjectsModel(user, projectsModel);
projectsModel = projectService.GetProjectsModel(user, projectsModel).Model as ProjectsModel;
projecttypes = db.ProjectTypes.FirstOrDefault();
ProjectOpenStatus = db.ProjectOpenStatusTypes.FirstOrDefault();
projectstatus = db.ProjectStatusTypes.FirstOrDefault();
verticaltype = db.VerticalMarketTypes.FirstOrDefault();
}
// ####################################################################################
// Create project
// ####################################################################################
public Project CreateTestProject(DPOContext context, User owner, string customername, string title, DateTime projectDate, ProjectType type, ProjectOpenStatusType status, ProjectStatusType projectstatus, VerticalMarketType vertical)
{
var project = Db.ProjectCreate(owner.UserId);
project.CustomerName = customername;
project.Name = title;
project.ProjectTypeId = type.ProjectTypeId;
project.ConstructionTypeId = (int)ConstructionTypeEnum.New;
project.ProjectOpenStatusTypeId = status.ProjectOpenStatusTypeId;
project.ProjectStatusTypeId = projectstatus.ProjectStatusTypeId;
project.VerticalMarketTypeId = vertical.VerticalMarketTypeId;
project.ProjectDate = projectDate;
project.BidDate = projectDate.AddDays(1);
project.EstimatedClose = projectDate.AddDays(3);
project.EstimatedDelivery = project.EstimatedClose.AddDays(7);
project.Expiration = project.EstimatedClose.AddDays(30);
return(project);
}
static void Main(string[] args)
{
ConfigurationManager.Instance.Bootstrap();
ConfigurationManager.Instance.Initialize();
ConfigurationManager.Instance.Start();
Console.WriteLine("Config state: " + ConfigurationManager.Instance.State);
LogManager.Instance.Bootstrap();
LogManager.Instance.Initialize();
LogManager.Instance.Start();
Console.WriteLine("Log state: " + LogManager.Instance.State);
AuthorizationManager.Instance.Bootstrap();
AuthorizationManager.Instance.Initialize();
AuthorizationManager.Instance.Start();
Console.WriteLine("Auth state: " + AuthorizationManager.Instance.State);
LocalSystemUser usr = new LocalSystemUser(SecurityUtils.AdminIdentity, "Admin", UserState.Active);
UserSecurityContext context = new UserSecurityContext(usr);
if (AuthorizationManager.Instance.State == Osrs.Runtime.RunState.Running)
{
//RegisterPermissions(context);
//Grant(context);
}
ProjectManager.Instance.Initialize();
Console.WriteLine("Projects state: " + ProjectManager.Instance.State);
ProjectManager.Instance.Start();
Console.WriteLine("Projects state: " + ProjectManager.Instance.State);
if (ProjectManager.Instance.State == Osrs.Runtime.RunState.Running)
{
IProjectStatusTypeProvider statProv = ProjectManager.Instance.GetStatusTypeProvider(context);
if (statProv != null)
{
IEnumerable <ProjectStatusType> typs = statProv.Get("Active");
ProjectStatusType activeStatus = null;
if (typs != null)
{
foreach (ProjectStatusType cur in typs)
{
activeStatus = cur;
}
}
if (activeStatus == null)
{
activeStatus = statProv.Create("Active", "An active project");
}
IProjectProvider prov = ProjectManager.Instance.GetProvider(context);
if (prov != null)
{
Console.WriteLine("Creating projects");
CreateProjs(prov, activeStatus);
IEnumerable <Project> projs = prov.Get();
foreach (Project p in projs)
{
Console.WriteLine(p.Name);
}
}
}
}
Console.WriteLine("ALL COMPLETE - Enter to exit");
Console.ReadLine();
}
public override bool CanUpdate(ProjectStatusType statusType)
{
return(this.CanUpdate());
}
