public static string CreateActivity(Activity activity, object member)
{
// getcurrentmember need their id , and name for created
// getclientbyid client name
//var memberService = ApplicationContext.Current.Services.MemberService;
//var memberId = Members.GetCurrentMember().Id;
//var member = memberService.GetById(memberId);
string activityResult;
Activity newOrder = Collection.Find <Activity>(o => o.Id == activity.Id).SingleOrDefault <Activity>();
if (newOrder == null)
{
activity.Status = "Created";
activity.CreatedDate = DateTime.Now;
activityResult = ActivityStore.Create(activity);
}
else
{
activity.UpdatedDate = DateTime.Now;
activityResult = ActivityStore.Update(activity);
}
return(activityResult);
//string newActivity = ActivityStore.Save(activity);
//return newActivity;
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <GenerateTableActivity_v1>(GenerateTableActivity_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <SimpleActivity_v1>(SimpleActivity_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <SimpleHierarchicalActivity_v1>(SimpleHierarchicalActivity_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <SimpleJumperActivity_v1>(SimpleJumperActivity_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Add_Payload_Manually_v1>(Add_Payload_Manually_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <App_Builder_v1>(App_Builder_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Build_Message_v1>(Build_Message_v1.ActivityTemplateDTO);
//ActivityStore.RegisterActivity<Build_Query_v1>(Build_Query_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Connect_To_Sql_v1>(Connect_To_Sql_v1.ActivityTemplateDTO);
//ActivityStore.RegisterActivity<Convert_Related_Fields_Into_Table_v1>(Convert_Related_Fields_Into_Table_v1.ActivityTemplateDTO); FR-4669
ActivityStore.RegisterActivity <Execute_Sql_v1>(Execute_Sql_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Extract_Table_Field_v1>(Extract_Table_Field_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Filter_Object_List_By_Incoming_Message_v1>(Filter_Object_List_By_Incoming_Message_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Get_Data_From_Fr8_Warehouse_v1>(Get_Data_From_Fr8_Warehouse_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Get_File_From_Fr8_Store_v1>(Get_File_From_Fr8_Store_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Loop_v1>(Loop_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Fr8_Events_v1>(Monitor_Fr8_Events_v1.ActivityTemplateDTO);
//ActivityStore.RegisterActivity<Query_Fr8_Warehouse_v1>(Query_Fr8_Warehouse_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Save_To_Fr8_Warehouse_v1>(Save_To_Fr8_Warehouse_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Search_Fr8_Warehouse_v1>(Search_Fr8_Warehouse_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Select_Fr8_Object_v1>(Select_Fr8_Object_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Set_Delay_v1>(Set_Delay_v1.ActivityTemplateDTO);
//ActivityStore.RegisterActivity<Show_Report_Onscreen_v1>(Show_Report_Onscreen_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Store_File_v1>(Store_File_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Make_A_Decision_v1>(Make_A_Decision_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Test_Incoming_Data_v1>(Test_Incoming_Data_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Send_Email_v1>(Send_Email_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Send_SMS_v1>(Send_SMS_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Save_All_Payload_To_Fr8_Warehouse>(Save_All_Payload_To_Fr8_Warehouse.ActivityTemplateDTO);
}
public static IEnumerable <Activity> GetActivitiesByShortCode(string clientShortCode)
{
IEnumerable <Activity> activities = ActivityStore.GetActivitiesByClientShortCode(clientShortCode)
.OrderByDescending((o => o.OrderNumber));
return(activities);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Monitor_Channel_v1>(Monitor_Channel_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Channel_v2>(Monitor_Channel_v2.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Publish_To_Slack_v1>(Publish_To_Slack_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Publish_To_Slack_v2>(Publish_To_Slack_v2.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Get_Google_Sheet_Data_v1>(Get_Google_Sheet_Data_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Form_Responses_v1>(Monitor_Form_Responses_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Save_To_Google_Sheet_v1>(Save_To_Google_Sheet_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Gmail_Inbox_v1>(Monitor_Gmail_Inbox_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Google_Spreadsheet_Changes_v1>(Monitor_Google_Spreadsheet_Changes_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Save_To_SalesforceDotCom_v1>(Save_To_SalesforceDotCom_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Get_Data_v1>(Get_Data_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Post_To_Chatter_v1>(Post_To_Chatter_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Post_To_Chatter_v2>(Post_To_Chatter_v2.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Mail_Merge_From_Salesforce_v1>(Mail_Merge_From_Salesforce_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Salesforce_Event_v1>(Monitor_Salesforce_Event_v1.ActivityTemplateDTO);
}
private static void InsertFeasibilityCostConsequence(int newTreatmentID, ActivityStore activity)
{
using (SqlConnection connection = new SqlConnection(DB.ConnectionString))
{
try
{
connection.Open();
string insert = "INSERT INTO " + DB.TablePrefix + "FEASIBILITY (TREATMENTID,CRITERIA) VALUES(@treatmentID, @criteria)";
SqlCommand cmd = new SqlCommand(insert, connection);
cmd.Parameters.Add(new SqlParameter("treatmentID", newTreatmentID));
cmd.Parameters.Add(new SqlParameter("criteria", activity.RawCriteria));
cmd.ExecuteNonQuery();
insert = "INSERT INTO " + DB.TablePrefix + "COSTS (TREATMENTID,COST_) VALUES(@treatmentID, @cost)";
cmd = new SqlCommand(insert, connection);
cmd.Parameters.Add(new SqlParameter("treatmentID", newTreatmentID));
cmd.Parameters.Add(new SqlParameter("cost", activity.RawCost));
cmd.ExecuteNonQuery();
if (activity.ConditionIndexes != null && activity.ConditionIndexes.Count > 0)
{
foreach (ActivityConditionIndex ci in activity.ConditionIndexes)
{
if (ci.Impact != null)
{
insert = "INSERT INTO " + DB.TablePrefix + "CONSEQUENCES (TREATMENTID,ATTRIBUTE_,CHANGE_) VALUES(@treatmentID, @attribute,@change)";
cmd = new SqlCommand(insert, connection);
cmd.Parameters.Add(new SqlParameter("treatmentID", newTreatmentID));
cmd.Parameters.Add(new SqlParameter("attribute", "__" + ci.DEConditionIndex.Replace(" ", "").Replace("/", "")));
cmd.Parameters.Add(new SqlParameter("change", ci.Impact));
cmd.ExecuteNonQuery();
}
}
}
else
{
insert = "INSERT INTO " + DB.TablePrefix + "CONSEQUENCES (TREATMENTID,ATTRIBUTE_,CHANGE_) VALUES(@treatmentID, @attribute,@change)";
cmd = new SqlCommand(insert, connection);
cmd.Parameters.Add(new SqlParameter("treatmentID", newTreatmentID));
cmd.Parameters.Add(new SqlParameter("attribute", "AGE"));
cmd.Parameters.Add(new SqlParameter("change", "+1"));
cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
}
}
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Monitor_DocuSign_Envelope_Activity_v1>(Monitor_DocuSign_Envelope_Activity_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Send_DocuSign_Envelope_v1>(Send_DocuSign_Envelope_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Send_DocuSign_Envelope_v2>(Send_DocuSign_Envelope_v2.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Use_DocuSign_Template_With_New_Document_v1>(Use_DocuSign_Template_With_New_Document_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Prepare_DocuSign_Events_For_Storage_v1>(Prepare_DocuSign_Events_For_Storage_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Mail_Merge_Into_DocuSign_v1>(Mail_Merge_Into_DocuSign_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Extract_Data_From_Envelopes_v1>(Extract_Data_From_Envelopes_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Track_DocuSign_Recipients_v1>(Track_DocuSign_Recipients_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Track_DocuSign_Recipients_v2>(Track_DocuSign_Recipients_v2.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Query_DocuSign_v1>(Query_DocuSign_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Query_DocuSign_v2>(Query_DocuSign_v2.ActivityTemplateDTO);
//ActivityStore.RegisterActivity<Search_DocuSign_History_v1>(Search_DocuSign_History_v1.ActivityTemplateDTO); FR-4750, reason in in activity class
ActivityStore.RegisterActivity <Get_DocuSign_Envelope_v1>(Get_DocuSign_Envelope_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Get_DocuSign_Template_v1>(Get_DocuSign_Template_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
//We no longer should use this activity
//ActivityStore.RegisterActivity<Generate_Table_Activity_v1>(Generate_Table_Activity_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Save_To_File_v1>(Save_To_File_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <PostToTelegramV1>(PostToTelegramV1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Post_To_Yammer_v1>(Post_To_Yammer_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Load_Excel_File_v1>(Load_Excel_File_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Save_To_Excel_v1>(Save_To_Excel_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Set_Excel_Template_v1>(Set_Excel_Template_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Create_Message_v1>(Create_Message_v1.ActivityTemplate);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Monitor_For_New_Media_Posted_v1>(Monitor_For_New_Media_Posted_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Activities.Post_Comment_v1>(Activities.Post_Comment_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Activities.Get_Tasks_v1>(Activities.Get_Tasks_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Send_Email_Via_SendGrid_v1>(Send_Email_Via_SendGrid_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Post_To_Timeline_v1>(Post_To_Timeline_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Feed_Posts_v1>(Monitor_Feed_Posts_v1.ActivityTemplateDTO);
}
public static IEnumerable <Activity> GetActivitiesByOrderNumber(List <OrderStuff> orders)
{
return(ActivityStore.GetActivitiesByOrderNumber(orders).ToList());
}
public static IEnumerable <Activity> GetRecentActivities()
{
return(ActivityStore.GetActivities());
}
protected override void RegisterActivities()
{
// ActivityStore.RegisterActivity<Convert_TableData_To_AccountingTransactions_v1>(Convert_TableData_To_AccountingTransactions_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Create_Journal_Entry_v1>(Create_Journal_Entry_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Get_File_List_v1>(Get_File_List_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Write_To_Sql_Server_v1>(Write_To_Sql_Server_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Send_Via_Twilio_v1>(Send_Via_Twilio_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Update_Stat_v1>(Update_Stat_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Stat_Changes_v1>(Monitor_Stat_Changes_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Create_Stat_v1>(Create_Stat_v1.ActivityTemplateDTO);
}
protected override void RegisterActivities()
{
ActivityStore.RegisterActivity <Get_Jira_Issue_v1>(Get_Jira_Issue_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Save_Jira_Issue_v1>(Save_Jira_Issue_v1.ActivityTemplateDTO);
ActivityStore.RegisterActivity <Monitor_Jira_Changes_v1>(Monitor_Jira_Changes_v1.ActivityTemplateDTO);
}
public static bool DeleteActivity(string activity)
{
var deleteActivity = ActivityStore.Delete(activity);
return(deleteActivity);
}
