public void setStageProject(StageProject stage, AdvanceUtil.paramStagInsert param) { stageProject = stage; paramInsert = param; if (stage != null) { if (param == AdvanceUtil.paramStagInsert.NOSUB) { textBoxNameStage.Text = stage.NameStage; comboBoxUser.SelectedItem = new KeyValuePair(stage.User.Id.ToString(), stage.User.FullName); dateBegin.Value = stage.DateBeginPlan; dateEnd.Value = stage.DateEndPlan; dateBeginUser.Checked = true; dateEndUser.Checked = true; dateBeginUser.Value = stage.DateBeginUser < dateBeginUser.MinDate ? stage.DateBeginPlan : stage.DateBeginUser; dateEndUser.Value = stage.DateEndUser < dateEndUser.MinDate ? stage.DateEndPlan : stage.DateEndUser; dateBeginProg.Value = stage.DateBeginProg < dateBeginProg.MinDate ? stage.DateBeginPlan : stage.DateBeginProg; dateEndProg.Value = stage.DateEndProg < dateEndProg.MinDate ? stage.DateEndPlan : stage.DateEndProg; textBoxAbout.Text = stage.CommentUser; comboBoxStatus.SelectedIndex = stage.StatusStage == 0 ? 0 : 1; } else { } } }
private void btnSave_Click(object sender, EventArgs e) { if (isValid()) { if (stageProject == null) { stageProject = new StageProject(); } stageProject.NameStage = textBoxNameStage.Text; UserDAO daoUser = new UserDAO(); stageProject.User = daoUser.getById(Convert.ToInt32(((KeyValuePair)comboBoxUser.SelectedItem).Key)); stageProject.DateBeginPlan = dateBegin.Value; stageProject.DateEndPlan = dateEnd.Value; if (dateBeginUser.Checked) { stageProject.DateBeginUser = dateBeginUser.Value; } else { stageProject.DateBeginUser = new DateTime(1, 1, 1); } if (dateEndUser.Checked) { stageProject.DateEndUser = dateEndUser.Value; } else { stageProject.DateEndUser = new DateTime(1, 1, 1); } stageProject.CommentUser = textBoxAbout.Text; stageProject.IdProject = idProject; stageProject.StatusStage = comboBoxStatus.SelectedIndex; if (paramInsert == AdvanceUtil.paramStagInsert.SUB) { stageProject.IdParentStage = stageProject.IdStage; } StageProjectDAO dao = new StageProjectDAO(); if (stageProject.IdStage != 0 && paramInsert != AdvanceUtil.paramStagInsert.SUB) { dao.update(stageProject); } else { dao.insert(stageProject); } this.Close(); } }
public StageProjectNode(string name, string comment, string dateBegin, string dateEnd, string dateBeginProg, string dateEndProg, string dateBeginUser, string dateEndUser, string user, string status, StageProject stage) : base() { this.stage = stage; NameStage = name; CommentUser = comment; DateBegin = dateBegin; DateEnd = dateEnd; DateBeginProg = dateBeginProg; DateEndProg = dateEndProg; DateBeginUser = (dateBeginUser.Equals("01.01.0001")) ? "" : dateBeginUser; DateEndUser = (dateEndUser.Equals("01.01.0001")) ? "" : dateEndUser; User = user; Status = (status.Equals("1") == true) ? "Факт" : "План"; }
private void mnuAddSubStage_Click(object sender, EventArgs e) { generateBookMark(); DialogStageProject dialog = new DialogStageProject(); TreeModel model = (TreeModel)treeViewAdv1.Model; if (model != null) { StageProject stage = ((StageProjectNode)model.Nodes[treeViewAdv1.SelectedNode.Index]).stage; dialog.setStageProject(stage, AdvanceUtil.paramStagInsert.SUB); dialog.idProject = stage.IdProject; } dialog.ShowDialog(); initializationInvestProject(); updateStageProject(); }
public HttpResponseMessage InsertStage([FromBody] StageProject stage) { conn.Open(); NpgsqlCommand cmd = new NpgsqlCommand( "INSERT INTO stage(idproject,stagetype,startdate,enddate)" + "VALUES(:project,:stagetype, :stardate, :enddate)", conn); cmd.Parameters.AddWithValue("stagetype", stage.stagetype); cmd.Parameters.AddWithValue("project", stage.idproject); cmd.Parameters.AddWithValue("stardate", stage.stardate); cmd.Parameters.AddWithValue("enddate", stage.enddate); cmd.Prepare(); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); conn.Close(); return(this.Request.CreateResponse(HttpStatusCode.OK, "Inserted")); }
private StageProject getCurrentStage() { StageProject stage = null; TreeModel model = (TreeModel)treeViewAdv1.Model; if (model != null && treeViewAdv1.SelectedNode != null) { if (treeViewAdv1.SelectedNode.Parent.Index >= 0) { stage = ((StageProjectNode)model.Nodes[treeViewAdv1.SelectedNode.Parent.Index].Nodes[treeViewAdv1.SelectedNode.Index]).stage; } else { stage = ((StageProjectNode)model.Nodes[treeViewAdv1.SelectedNode.Index]).stage; } } return(stage); }
private void menuStageProject_Opening(object sender, CancelEventArgs e) { TreeModel model = (TreeModel)treeViewAdv1.Model; int index = -1; try { if (treeViewAdv1.SelectedNode != null & treeViewAdv1.SelectedNode.Parent.Index >= 0) { index = treeViewAdv1.SelectedNode.Parent.Index; mnuAddSubStage.Enabled = false; } else { index = treeViewAdv1.SelectedNode.Index; mnuAddSubStage.Enabled = true; } if (model != null) { mnuDeleteStage.Enabled = true; mnuEditStage.Enabled = true; if (treeViewAdv1.SelectedNode != null) { StageProject stage = ((StageProjectNode)model.Nodes[index]).stage; } } else { mnuDeleteStage.Enabled = false; mnuAddSubStage.Enabled = false; mnuEditStage.Enabled = false; } } catch (Exception error) { //TODO mnuDeleteStage.Enabled = false; mnuAddSubStage.Enabled = false; mnuEditStage.Enabled = false; } }
public void setStageProject(StageProject stage) { setStageProject(stage, AdvanceUtil.paramStagInsert.NOSUB); }