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