/// <summary> /// Loads the grid. /// </summary> private void LoadGrid() { IFulFilmentTemplate fulfilmentTemplate = EntityFactory.GetById <IFulFilmentTemplate>(_FulfilmentTemplate.Id); grdStages.DataSource = GetStageAndTasks(fulfilmentTemplate); grdStages.DataBind(); }
protected void cmdAddTemplate_Click1(object sender, EventArgs e) { IOpportunity CurrentOpportunity = this.BindingSource.Current as IOpportunity; CurrentOpportunity.Save(); String MytemplateID = ddlTemplates.SelectedValue; if (dtDeliveryDate.DateTimeValue == null) { throw new Sage.Platform.Application.ValidationException("Must have Deliverydate Selected"); } else { if (MytemplateID != "NONE") { IFulFilmentTemplate MyTemplate = EntityFactory.GetById <IFulFilmentTemplate>(MytemplateID); foreach (IFulFilTemplateStage tmpStage in MyTemplate.FulFilTemplateStages) { //==================================================== // Add the Stages //===================================================== IOppFulFilStage MyStage = EntityFactory.Create <IOppFulFilStage>(); MyStage.Description = tmpStage.Description; MyStage.Notes = tmpStage.Notes; MyStage.StageSequence = tmpStage.StageSequence; MyStage.Status = tmpStage.Status; MyStage.SeccodeId = tmpStage.SeccodeId; MyStage.Opportunity = CurrentOpportunity; MyStage.Save(); foreach (IFulFilTemplateTask tmpTask in tmpStage.FulFilTemplateTasks) { //==================================================== // Add the Tasks //===================================================== IOppFulFilTask MyTask = EntityFactory.Create <IOppFulFilTask>(); MyTask.Description = tmpTask.Description; MyTask.Status = tmpTask.Status; MyTask.TaskSequence = tmpTask.TaskSequence; MyTask.Priority = tmpTask.Priority; MyTask.Notes = tmpTask.Notes; MyTask.DueDate = Timelessize(CurrentOpportunity.DeliveryDate.Value.AddDays(-(double)tmpTask.DaysFromDeliveryDate)); MyTask.WeightedPercentage = tmpTask.WeightedPercentage; MyTask.SeccodeId = tmpTask.SeccodeId; MyTask.Opportunity = CurrentOpportunity; MyTask.OppFulFilStage = MyStage; if (tmpTask.DaysFromDeliveryDate == null) { MyTask.DaysFromDeliveryDate = 0; } else { MyTask.DaysFromDeliveryDate = tmpTask.DaysFromDeliveryDate; } MyTask.Completed = tmpTask.Completed.ToString(); MyTask.Save(); } } } } //RefreshPage(); Response.Redirect(Request.Url.ToString()); }
/// <summary> /// Loads the view. /// </summary> private void LoadView() { _FulfilmentTemplate = GetParentEntity() as IFulFilmentTemplate; LoadGrid(); }
public static DataTable GetStageAndTasks(IFulFilmentTemplate FulfilmentTemplate) { DataTable table = GetDataTable(); DataTable returntable = GetDataTable(); //========================================= //Create Return Table //========================================= foreach (IFulFilTemplateStage stage in FulfilmentTemplate.FulFilTemplateStages) { DataRow row = table.NewRow(); row["id"] = string.Format("{0}:S", stage.Id); row["Type"] = "STAGE"; row["Description"] = stage.Description; row["Status"] = stage.Status; if (stage.StageSequence == null) { row["StageSequence"] = 0; } else { row["StageSequence"] = stage.StageSequence; } row["TaskSequence"] = 0; table.Rows.Add(row); if (stage.FulFilTemplateTasks.Count == 0) { DataRow row2 = table.NewRow(); row2["id"] = string.Format("{0}:T", "PLACE_HOLDER"); row2["Type"] = "PLACE_HOLDER"; row2["Description"] = "There are no tasks assigned to this stage"; if (stage.StageSequence == null) { row2["StageSequence"] = 0; } else { row2["StageSequence"] = stage.StageSequence; } row2["TaskSequence"] = 0; table.Rows.Add(row2); } else { foreach (IFulFilTemplateTask task in stage.FulFilTemplateTasks) { DataRow row3 = table.NewRow(); row3["id"] = string.Format("{0}:T", task.Id); row3["Type"] = "TASK"; row3["Description"] = task.Description; row3["Status"] = task.Status; row3["Priority"] = task.Priority; try { row3["StageSequence"] = stage.StageSequence; } catch { row3["StageSequence"] = 0; } try { row3["TaskSequence"] = task.TaskSequence; } catch { row3["TaskSequence"] = 1; } try { row3["NeededDate"] = task.DueDate; } catch { } try { row3["WeightedPercentage"] = task.WeightedPercentage; } catch { row3["WeightedPercentage"] = 0; } table.Rows.Add(row3); } continue; } } //======================================================================== // Sort by Stage and Task // The Select Method just returns an Array of Rows //======================================================================== foreach (DataRow tmpRow in table.Select("", "StageSequence, TaskSequence")) { DataRow row4 = returntable.NewRow(); row4["id"] = tmpRow["id"]; row4["Type"] = tmpRow["Type"]; row4["Description"] = tmpRow["Description"]; row4["Status"] = tmpRow["Status"]; row4["Priority"] = tmpRow["Priority"]; row4["StageSequence"] = tmpRow["StageSequence"]; row4["TaskSequence"] = tmpRow["TaskSequence"]; row4["NeededDate"] = tmpRow["NeededDate"]; row4["WeightedPercentage"] = tmpRow["WeightedPercentage"]; returntable.Rows.Add(row4); } return(returntable); }
public static DataTable GetStageAndTasks(IFulFilmentTemplate FulfilmentTemplate) { DataTable table = GetDataTable(); DataTable returntable = GetDataTable(); //========================================= //Create Return Table //========================================= foreach (IFulFilTemplateStage stage in FulfilmentTemplate.FulFilTemplateStages) { DataRow row = table.NewRow(); row["id"] = string.Format("{0}:S", stage.Id); row["Type"] = "STAGE"; row["Description"] = stage.Description; row["Status"] = stage.Status; if (stage.StageSequence == null) { row["StageSequence"] = 0; } else { row["StageSequence"] = stage.StageSequence; } row["TaskSequence"] = 0; table.Rows.Add(row); if (stage.FulFilTemplateTasks.Count == 0) { DataRow row2 = table.NewRow(); row2["id"] = string.Format("{0}:T", "PLACE_HOLDER"); row2["Type"] = "PLACE_HOLDER"; row2["Description"] = "There are no tasks assigned to this stage"; if (stage.StageSequence == null) { row2["StageSequence"] = 0; } else { row2["StageSequence"] = stage.StageSequence; } row2["TaskSequence"] = 0; table.Rows.Add(row2); } else { foreach (IFulFilTemplateTask task in stage.FulFilTemplateTasks ) { DataRow row3 = table.NewRow(); row3["id"] = string.Format("{0}:T", task.Id); row3["Type"] = "TASK"; row3["Description"] = task.Description; row3["Status"] = task.Status; row3["Priority"] = task.Priority; try { row3["StageSequence"] = stage.StageSequence; } catch { row3["StageSequence"] = 0; } try { row3["TaskSequence"] = task.TaskSequence; } catch { row3["TaskSequence"] = 1; } try { row3["NeededDate"] = task.DueDate; } catch { } try { row3["WeightedPercentage"] = task.WeightedPercentage ; } catch { row3["WeightedPercentage"] = 0; } table.Rows.Add(row3); } continue; } } //======================================================================== // Sort by Stage and Task // The Select Method just returns an Array of Rows //======================================================================== foreach (DataRow tmpRow in table.Select("", "StageSequence, TaskSequence")) { DataRow row4 = returntable.NewRow(); row4["id"] = tmpRow["id"]; row4["Type"] = tmpRow["Type"]; row4["Description"] = tmpRow["Description"]; row4["Status"] = tmpRow["Status"]; row4["Priority"] = tmpRow["Priority"]; row4["StageSequence"] = tmpRow["StageSequence"]; row4["TaskSequence"] = tmpRow["TaskSequence"]; row4["NeededDate"] = tmpRow["NeededDate"]; row4["WeightedPercentage"] = tmpRow["WeightedPercentage"]; returntable.Rows.Add(row4); } return returntable; }
/// <summary> /// Loads the view. /// </summary> private void LoadView() { _FulfilmentTemplate = GetParentEntity() as IFulFilmentTemplate ; LoadGrid(); }