private void ShowProjectList()
{
projectController = (ListProjects)Page.LoadControl("~/Projects/ListProjects.ascx");
projectController.uvId = cUV.IdUv;
projectController.clientScript = ClientScript;
ProjectList.Controls.Add(projectController);
}
public RepositoriesDB()
{
_sqlManager = new SQL();
_listProjects = new ListProjects();
_listSkills = new ListSkills();
_listProjectImages = new ListProjectImages();
}
public void TestInitialize()
{
this.dbStub = new HatchlingCompanyDbContext(Effort.DbConnectionFactory.CreateTransient());
this.writerStub = new Mock <IWriter>();
this.mapperStub = new Mock <IMapper>();
this.createProjectService = new CreateProject(dbStub, writerStub.Object, mapperStub.Object);
this.listProjectsService = new ListProjects(dbStub, writerStub.Object);
}
public static ListProjects GetListProjects(this ListProjects l)
{
if (l == null)
{
return(null);
}
return(new ListProjects()
{
id = l.id,
id_type_project = l.id_type_project,
id_structural_subdivisions = l.id_structural_subdivisions,
name_project_ru = l.name_project_ru,
name_project_en = l.name_project_en,
goals_project_ru = l.goals_project_ru,
goals_project_en = l.goals_project_en,
id_project_customer = l.id_project_customer,
spp_sap = l.spp_sap,
id_spp_owner = l.id_spp_owner,
start_project = l.start_project,
id_work_performer = l.id_work_performer,
stop_project_contract = l.stop_project_contract,
budget = l.budget,
budget_currency = l.budget_currency,
contract_value = l.contract_value,
contract_currency = l.contract_currency,
contract_engineering_value = l.contract_engineering_value,
contract_engineering_currency = l.contract_engineering_currency,
contract_equipment_value = l.contract_equipment_value,
contract_equipment_currency = l.contract_equipment_currency,
contract_construction_value = l.contract_construction_value,
contract_construction_currency = l.contract_construction_currency,
contract_commissioning_value = l.contract_commissioning_value,
contract_commissioning_currency = l.contract_commissioning_currency,
contract_other_value = l.contract_other_value,
contract_other_currency = l.contract_other_currency,
payment_engineering_value = l.payment_engineering_value,
payment_engineering_currency = l.payment_engineering_currency,
payment_equipment_value = l.payment_equipment_value,
payment_equipment_currency = l.payment_equipment_currency,
payment_construction_value = l.payment_construction_value,
payment_construction_currency = l.payment_construction_currency,
payment_commissioning_value = l.payment_commissioning_value,
payment_commissioning_currency = l.payment_commissioning_currency,
payment_other_value = l.payment_other_value,
payment_other_currency = l.payment_other_currency,
workspace = l.workspace,
id_project_manager = l.id_project_manager,
id_status_project = l.id_status_project,
create = l.create,
create_user = l.create_user,
change = l.change,
change_user = l.change_user,
ProjectManager = l.ProjectManager.GetProjectManager(),
TypeProject = l.TypeProject.GetTypeProject(),
WorkPerformers = l.WorkPerformers.GetWorkPerformers(),
StagesProject = l.StagesProject.ToList().GetStagesProject(),
});
}
private void UserControlLoaded(object sender, RoutedEventArgs e)
{
ListProjects.Focus();
Task <Project> task = Project.OpenAsync(project);
task.GetAwaiter().OnCompleted(() =>
{
GeoDataTool.DefaultProject = task.Result;
ConfigurationManager1.DefaultProject = GeoDataTool.DefaultProject;
});
}
public int PutListProjects(int id, [FromBody] ListProjects value)
{
try
{
this.ef_lp.Update(value);
return(this.ef_lp.Save());
}
catch (Exception e)
{
//String.Format("Ошибка выполнения метода API:PutListProjects(id={0}, value={1})", id, value).SaveError(e);
return(-1);
}
}
/** Methode gibt die Tabelle "Projects" zurück als Liste **/
private List <ListProjects> getProjects()
{
List <ListProjects> listProjects = new List <ListProjects>();
DataTable currentProjectsTable = new DataTable();
DataTable currentProjectImagesTable = new DataTable();
string sqlQuery = "";
try
{
sqlQuery = "GetProjects";
/** SQL Select Statement gibt die Tabelle "Projects" zurück **/
currentProjectsTable = _sqlManager.ExecuteSelect(sqlQuery, new string[] { }, new object[] { });
/** Tabelle wird in einer Schleife durchlaufen und ins Modell geladen
* und anschließend zur Liste "listProjects" hinzugefügt **/
if (currentProjectsTable.Rows.Count > 0)
{
for (int i = 0; i < currentProjectsTable.Rows.Count; i++)
{
ListProjects currentProject = new ListProjects();
List <ListProjectImages> currentListProjectImages = new List <ListProjectImages>();
currentProject.Id = Convert.ToInt64(currentProjectsTable.Rows[i]["ID"]);
currentProject.Name = currentProjectsTable.Rows[i]["Name"].ToString();
currentProject.Description = currentProjectsTable.Rows[i]["Description"].ToString();
currentProject.Live = currentProjectsTable.Rows[i]["Live"].ToString();
currentProject.Active = (bool)currentProjectsTable.Rows[i]["Active"];
currentProject.CreationDate = (DateTime)currentProjectsTable.Rows[i]["CreationDate"];
currentListProjectImages = getProjectsImages(currentProject.Id);
if (currentListProjectImages.Count > 0)
{
currentProject.ListProjectImages = currentListProjectImages;
}
listProjects.Add(currentProject);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listProjects);
}
public int PostListProjects([FromBody] ListProjects value)
{
try
{
this.ef_lp.Add(value);
this.ef_lp.Save();
this.ef_lp.Refresh(value);
return(value.id);
}
catch (Exception e)
{
//String.Format("Ошибка выполнения метода API:PostFuelSale(value={0})", value).SaveError(e);
return(-1);
}
}
private void lstProjects_Click(object sender, EventArgs e)
{
try
{
var currItem = lstProjects.SelectedItem.ToString().Split('=');
foreach (var item in
ListProjects.Where(item => item.Server1 == currItem[0].Trim() && item.Server2 == currItem[1].Trim()))
{
propertyGridServers.SelectedObject = item;
btOK.Enabled = true;
IsUpdate = true;
CurrentProject = item;
break;
}
}
catch
{
MessageBox.Show(@"Error! Please Retry!");
}
}
public IHttpActionResult GetListProjects(int id)
{
try
{
ListProjects project = this.ef_lp
.Get()
.Where(p => p.id == id)
.ToList()
.Select(l => new ListProjects
{
id = l.id,
id_type_project = l.id_type_project,
id_structural_subdivisions = l.id_structural_subdivisions,
name_project_ru = l.name_project_ru,
name_project_en = l.name_project_en,
goals_project_ru = l.goals_project_ru,
goals_project_en = l.goals_project_en,
id_project_customer = l.id_project_customer,
spp_sap = l.spp_sap,
id_spp_owner = l.id_spp_owner,
start_project = l.start_project,
id_work_performer = l.id_work_performer,
stop_project_contract = l.stop_project_contract,
budget = l.budget,
budget_currency = l.budget_currency,
contract_value = l.contract_value,
contract_currency = l.contract_currency,
contract_engineering_value = l.contract_engineering_value,
contract_engineering_currency = l.contract_engineering_currency,
contract_equipment_value = l.contract_equipment_value,
contract_equipment_currency = l.contract_equipment_currency,
contract_construction_value = l.contract_construction_value,
contract_construction_currency = l.contract_construction_currency,
contract_commissioning_value = l.contract_commissioning_value,
contract_commissioning_currency = l.contract_commissioning_currency,
contract_other_value = l.contract_other_value,
contract_other_currency = l.contract_other_currency,
payment_engineering_value = l.payment_engineering_value,
payment_engineering_currency = l.payment_engineering_currency,
payment_equipment_value = l.payment_equipment_value,
payment_equipment_currency = l.payment_equipment_currency,
payment_construction_value = l.payment_construction_value,
payment_construction_currency = l.payment_construction_currency,
payment_commissioning_value = l.payment_commissioning_value,
payment_commissioning_currency = l.payment_commissioning_currency,
payment_other_value = l.payment_other_value,
payment_other_currency = l.payment_other_currency,
workspace = l.workspace,
id_project_manager = l.id_project_manager,
id_status_project = l.id_status_project,
create = l.create,
create_user = l.create_user,
change = l.change,
change_user = l.change_user,
ProjectManager = new ProjectManager
{
id = l.ProjectManager.id,
id_user = l.ProjectManager.id_user,
email = l.ProjectManager.email,
phone_work = l.ProjectManager.phone_work,
phone_mobile = l.ProjectManager.phone_mobile,
adress = l.ProjectManager.adress,
parent_id = l.ProjectManager.parent_id,
},
TypeProject = new TypeProject
{
id = l.TypeProject.id,
type_project_ru = l.TypeProject.type_project_ru,
type_project_en = l.TypeProject.type_project_en,
description_type_project_ru = l.TypeProject.description_type_project_ru,
description_type_project_en = l.TypeProject.description_type_project_en,
},
WorkPerformers = l.WorkPerformers != null ? new WorkPerformers
{
id = l.WorkPerformers.id,
name_performer_ru = l.WorkPerformers.name_performer_ru,
name_performer_en = l.WorkPerformers.name_performer_en,
email_performer = l.WorkPerformers.email_performer,
phone_performer = l.WorkPerformers.phone_performer,
name_boss = l.WorkPerformers.name_boss,
phone_boss = l.WorkPerformers.phone_boss,
} : null,
StagesProject = l.StagesProject.Select(t => new StagesProject
{
id = t.id,
id_project = t.id_project,
id_templates_stages_project = t.id_templates_stages_project,
position = t.position,
start = t.start,
stop = t.stop,
current = t.current,
skip = t.skip,
mile = t.mile,
resource = t.resource,
persent = t.persent,
group = t.group,
parent_id = t.parent_id,
depend = t.depend,
coment = t.coment,
TemplatesStagesProject = new TemplatesStagesProject
{
id = t.id,
stages_project_ru = t.TemplatesStagesProject.stages_project_ru,
stages_project_en = t.TemplatesStagesProject.stages_project_en,
stages_project_description_ru = t.TemplatesStagesProject.stages_project_description_ru,
stages_project_description_en = t.TemplatesStagesProject.stages_project_description_en,
id_project_manager = t.TemplatesStagesProject.id_project_manager,
parent_id = t.TemplatesStagesProject.parent_id,
ProjectManager = t.TemplatesStagesProject.ProjectManager != null ? new ProjectManager
{
id = t.TemplatesStagesProject.ProjectManager.id,
id_user = t.TemplatesStagesProject.ProjectManager.id_user,
email = t.TemplatesStagesProject.ProjectManager.email,
phone_work = t.TemplatesStagesProject.ProjectManager.phone_work,
phone_mobile = t.TemplatesStagesProject.ProjectManager.phone_mobile,
adress = t.TemplatesStagesProject.ProjectManager.adress,
parent_id = t.TemplatesStagesProject.ProjectManager.parent_id,
} : null,
},
}).ToList()
}).FirstOrDefault();
if (project == null)
{
return(NotFound());
}
return(Ok(project));
}
catch (Exception e)
{
return(NotFound());
}
}
private void UserControlLoaded(object sender, RoutedEventArgs e)
{
ListProjects.Focus();
}
public int IndexOf(Project project)
{
return(ListProjects.IndexOf(project));
}
public void Remove(Project project)
{
ListProjects.Remove(project);
}
public void Add(Project project)
{
ListProjects.Add(project);
}
