public void Context()
{
using (var context = new ProjectsEntities())
{
var worker = new Worker()
{
FirstName = "alex",
LastName = "rob",
Email = "alex@rob",
MiddleName = "middle"
};
worker = context.WorkersBase.Add(worker);
Assert.IsNotNull(worker);
var worker1 = new Worker()
{
FirstName = "alex1",
LastName = "rob1",
Email = "alex@rob1",
MiddleName = "middle1"
};
worker1 = context.WorkersBase.Add(worker1);
Assert.IsNotNull(worker1);
context.SaveChanges();
Assert.IsNotNull(context.WorkersBase.Find(worker.Id));
Assert.IsNotNull(context.WorkersBase.Find(worker1.Id));
var project = new Project()
{
Comment = "Comment",
ConstractorCompany = "Cons",
CustomerCompany = "cust",
Employee = worker,
Leader = worker1,
Start = DateTime.Now,
End = DateTime.Now,
Workers = new List <Worker>
{
worker,
worker1
}
};
project = context.ProjectsBase.Add(project);
Assert.IsNotNull(project);
context.SaveChanges();
Assert.IsNotNull(context.ProjectsBase.Find(project.Id));
}
}
public ActionResult Create([Bind(Include = "Id,Name,ProjectDescription,Screenshot,GitHub")] project project)
{
if (ModelState.IsValid)
{
db.projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
public ActionResult Create([Bind(Include = "Id,Role_Name,Description,Vendor,Manager")] Role role)
{
if (ModelState.IsValid)
{
db.Roles.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Create([Bind(Include = "Id,TMH_ID,Name,Description,Manager,Overall_LOE,Role1,Role1_LOE,Role2,Role2_LOE,Role3,Role3_LOE,Role4,Role4_LOE,Role5,Role5_LOE,Notes,Closed")] Project project)
{
if (ModelState.IsValid)
{
db.Projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
private void Drop()
{
using (var context = new ProjectsEntities())
{
context.Database.ExecuteSqlCommand("truncate table ProjectsWorkersBase");
context.ProjectsBase.RemoveRange(context.ProjectsBase);
context.WorkersBase.RemoveRange(context.WorkersBase);
context.SaveChanges();
}
}
public string NewProject(string project_name, string project_package, string project_type)
{
var username = User.Identity.GetUserName();
var project = new Project()
{
Name = project_name,
Package = project_package,
Type = project_type
};
db.Projects.Add(project);
db.SaveChanges();
var userProject = new UserProject()
{
ProjectId = project.ID,
UserId = User.Identity.GetUserId()
};
db.UserProjects.Add(userProject);
db.SaveChanges();
var workingDir = String.Format(@"{0}Projects\{1}", phonegapLocation, username);
if (project_type == "Android (PhoneGap)")
{
Directory.CreateDirectory(workingDir);
var createPsi = new ProcessStartInfo("cmd.exe", String.Format("/c {0}create.bat {1} {2} {3}", phonegapLocation, project_name, project_package, project_name))
{
WorkingDirectory = workingDir,
CreateNoWindow = true,
UseShellExecute = false
};
using (var process = Process.Start(createPsi))
{
process.WaitForExit();
}
}
else
{
var createPsiAndroid = new ProcessStartInfo("cmd.exe", String.Format("/c {0}new.bat {1} {2} {3}", @"C:\Android\", workingDir + @"\" + project_name + @"\android", project_name, project_package))
{
WorkingDirectory = @"C:\Android\",
CreateNoWindow = true,
UseShellExecute = false
};
using (var process = Process.Start(createPsiAndroid))
{
process.WaitForExit();
}
}
return("{ \"project_id\":\"" + project.ID + "\" }");
}
public void StartTest()
{
using (var context = new ProjectsEntities())
{
context.Database.ExecuteSqlCommand("truncate table ProjectsWorkersBase");
context.ProjectsBase.RemoveRange(context.ProjectsBase);
context.WorkersBase.RemoveRange(context.WorkersBase);
context.SaveChanges();
context.WorkersBase.Add(Worker1);
context.WorkersBase.Add(Worker2);
context.SaveChanges();
context.ProjectsBase.Add(Project1);
context.ProjectsBase.Add(Project2);
context.SaveChanges();
}
Start();
}
protected TResult WOperation <TResult>(Func <ProjectsEntities, TResult> action)
{
var result = default(TResult);
using (var context = new ProjectsEntities())
{
try
{
result = action(context);
context.SaveChanges();
}
catch (Exception exception)
{
ManagerFactory.Logger.Error(Tag, exception);
}
}
return(result);
}
