public void ProcessRequest(HttpContext context) { string id = context.Request["id"]; var data = bll.GetActivityDataByOrderId(id); ActivityDataModel model = new ActivityDataModel(); JuActivityInfo activity = bll.GetActivity(data.ActivityID); model.id = int.Parse(data.OrderId); model.activity_name = activity.ActivityName; model.activity_img = activity.ThumbnailsPath; model.amount = data.Amount.ToString(); model.date_range = data.DateRange; model.group_type = data.GroupType; model.name = data.Name; model.status = bll.GetActivityStatus(activity); model.comment = data.Remarks; model.main_points = activity.MainPoints; model.remark = data.UserRemark; model.phone = data.Phone; model.email = data.Email; model.sex = data.Sex; model.birthday = data.BirthDay; model.date_range = data.DateRange; model.group_type = data.GroupType; model.member_type = data.IsMember; apiResp.status = true; apiResp.msg = "ok"; apiResp.result = model; bll.ContextResponse(context, apiResp); }
private void OnEnable() { #if !UNITY_EDITOR try { #endif if (removeBinding) { EventDispatcher.Instance.AddEventListener(CloseUiBindRemove.EVENT_TYPE, OnCloseUI); controller = UIManager.Instance.GetController(UIConfig.ActivityUI); if (controller == null) { return; } dataModel = controller.GetDataModel("") as ActivityDataModel; dataModel.PropertyChanged += OnEventPropertyChanged; Binding.SetBindDataSource(controller.GetDataModel("")); } FakeObjectCreate(dataModel.BossDataId); removeBinding = true; #if !UNITY_EDITOR } catch (Exception ex) { Logger.Error(ex.ToString()); } #endif }
private object GetActivityData(ActivityDataModel data) { DateTime start = DateTime.Parse(data.Start); DateTime end = DateTime.Parse(data.End); StringBuilder sb = new StringBuilder(); sb.Append(BuildArrayQuery(data.Filters, data.Field, data.Databases)); if (sb.Length > 0) { sb.Append(" AND "); } sb.Append(BuildArrayQuery(data.EventTypes, "event", data.Databases)); if (sb.Length > 0) { sb.Append(" AND "); } sb.Append($"date:[{start:yyyyMMdd} TO {end:yyyyMMdd}]"); IndexSearcher searcher = AuditLogger.Current.GetSearcher(); TopDocs results = AuditLogger.Current.Query(sb.ToString(), searcher); dynamic ret = new ExpandoObject(); ret.total = results.TotalHits; ret.perPage = 20; ret.results = getResults(results, data.Page, searcher); return(ret); }
protected override void ShowData(int activityId) { base.ShowData(activityId); oDetailButtonPanel.SetId = SetId; Clear(); var data = new ActivityDataModel(); data.ActivityId = activityId; var items = ActivityDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblLayer.Text = item.Layer; SetData(item); oHistoryList.Setup(PrimaryEntity, activityId, "Activity"); } }
public override int?Save(string action) { var data = new ActivityDataModel(); data.ActivityId = SystemKeyId; data.Name = Name; data.Description = Description; data.SortOrder = SortOrder; data.LayerId = LayerId; if (action == "Insert") { var dtActivity = ActivityDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtActivity.Rows.Count == 0) { ActivityDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { ActivityDataManager.Update(data, SessionVariables.RequestProfile); } return(data.ActivityId); }
//public static List<ActivityDataModel> GetEntityDetails(ActivityDataModel data, int auditId) //{ // var sql = "EXEC dbo.ActivitySearch " + // " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId) + // ", " + ToSQLParameter(data, ActivityDataModel.DataColumns.ActivityId); // var result = new List<ActivityDataModel>(); // using (var reader = new DBDataReader("Get Details", sql, DataStoreKey)) // { // var dbReader = reader.DBReader; // while (dbReader.Read()) // { // var dataItem = new ActivityDataModel(); // dataItem.ActivityId = (int)dbReader[ActivityDataModel.DataColumns.ActivityId]; // dataItem.LayerId = (int)dbReader[ActivityDataModel.DataColumns.LayerId]; // dataItem.Layer = (string)dbReader[ActivityDataModel.DataColumns.Layer]; // SetStandardInfo(dataItem, dbReader); // SetBaseInfo(dataItem, dbReader); // result.Add(dataItem); // } // } // return result; //} #endregion GetDetails #region CreateOrUpdate private static string CreateOrUpdate(ActivityDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.ActivityInsert " + "\r\n" + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.ActivityUpdate " + "\r\n" + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, ActivityDataModel.DataColumns.ActivityId) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Name) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Description) + ", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.SortOrder) + ", " + ToSQLParameter(data, ActivityDataModel.DataColumns.LayerId); return(sql); }
public static List <ActivityDataModel> GetCampaignActivities(int id) { List <ActivityDataModel> activitys = new List <ActivityDataModel>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("GetCampaignActivities", connection); MySqlParameter paramID = new MySqlParameter("pId", id); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; DataTable results = new DataTable(); adapter.Fill(results); foreach (DataRow item in results.Rows) { ActivityDataModel activity = new ActivityDataModel(); if (item["ID"].GetType() != typeof(DBNull)) { activity.ID = Convert.ToInt32(item["ID"]); } if (item["Name"].GetType() != typeof(DBNull)) { activity.Name = Convert.ToString(item["Name"]); } if (item["WorkflowID"].GetType() != typeof(DBNull)) { activity.WorkflowID = Convert.ToInt32(item["WorkflowID"]); } if (item["OwnerID"].GetType() != typeof(DBNull)) { activity.OwnerID = Convert.ToInt32(item["OwnerID"]); } if (item["CreatedBy"].GetType() != typeof(DBNull)) { activity.CreatedBy = Convert.ToInt32(item["CreatedBy"]); } if (item["DateCreated"].GetType() != typeof(DBNull)) { activity.DateCreated = Convert.ToDateTime(item["DateCreated"]); } if (item["ParentActivityID"].GetType() != typeof(DBNull)) { activity.ParentActivityID = Convert.ToInt32(item["ParentActivityID"]); } if (item["Approved"].GetType() != typeof(DBNull)) { activity.Approved = Convert.ToBoolean(item["Approved"]); } activitys.Add(activity); } return(activitys); }
public void ProcessRequest(HttpContext context) { int pageIndex = !string.IsNullOrEmpty(context.Request["pageindex"]) ? int.Parse(context.Request["pageindex"]) : 1; int pageSize = !string.IsNullOrEmpty(context.Request["pagesize"]) ? int.Parse(context.Request["pagesize"]) : 10; int totalCount; var data = bll.ActivityDataList(pageIndex, pageSize, out totalCount, "", CurrentUserInfo.UserID, "train"); List <ActivityDataModel> list = new List <ActivityDataModel>(); foreach (var item in data) { ActivityDataModel model = new ActivityDataModel(); JuActivityInfo activity = bll.GetActivity(item.ActivityID); model.id = int.Parse(item.OrderId); model.activity_name = activity.ActivityName; model.activity_img = activity.ThumbnailsPath; ; model.amount = item.Amount.ToString(); model.date_range = item.DateRange; model.group_type = item.GroupType; model.name = item.Name; model.status = bll.GetMyTrainStatus(item); list.Add(model); } apiResp.status = true; apiResp.msg = "ok"; apiResp.result = new { totalcount = totalCount, list = list }; bll.ContextResponse(context, apiResp); }
public void LoadData(int activityId, bool showId) { Clear(); var data = new ActivityDataModel(); data.ActivityId = activityId; var items = ActivityDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count != 1) { return; } var item = items[0]; SetData(item); LayerId = item.LayerId; if (!showId) { SystemKeyId = item.ActivityId; oHistoryList.Setup(PrimaryEntity, activityId, PrimaryEntityKey); } else { CoreSystemKey.Text = String.Empty; } }
public static DataTable Search(ActivityDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile); var table = list.ToDataTable(); return(table); }
protected override void Clear() { base.Clear(); var data = new ActivityDataModel(); SetData(data); }
protected override void Update(Dictionary <string, string> values) { var data = new ActivityDataModel(); PropertyMapper.CopyProperties(data, values); ActivityDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
// Si la actividad devuelve un valor, se debe derivar de CodeActivity<TResult> // y devolver el valor desde el método Execute. protected override void Execute(CodeActivityContext context) { // Obtenga el valor de tiempo de ejecución del argumento de entrada Text int workflowID = context.GetValue(this.WorkflowID); ActivityDataModel nextActivity = WorkflowBO.GetInstance().GetNextWorkflowActivity(workflowID); context.SetValue(Activity, nextActivity); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new ActivityDataModel(); var dt = ActivityDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override DataTable GetEntityData(int?entityKey) { var activitydata = new ActivityDataModel(); activitydata.ActivityId = entityKey; var results = ActivityDataManager.Search(activitydata, SessionVariables.RequestProfile); return(results); }
public object GetUserActivity(ActivityDataModel data) { using (var db = new SqlAuditLogDataContext()) { AuditGraph ret = new AuditGraph(); Dictionary <string, AuditGraphEntry> entries = new Dictionary <string, AuditGraphEntry>(); int max = 0; DateTime start = DateTime.Parse(data.Start); DateTime end = DateTime.Parse(data.End).AddDays(1); TimeSpan range = end.Subtract(start); var filter = BuildArrayQuery(data.Filters, data.Field, data.Databases); List <DateTime> dates = new List <DateTime>(); for (int i = 0; i <= range.Days; i++) { dates.Add(start.AddDays(i)); } foreach (string eventType in data.EventTypes) { AuditGraphEntry gentry = new AuditGraphEntry() { Color = GetEventType(eventType).Color }; foreach (var date in dates) { var query = "SELECT count(*) FROM [dbo].[AuditEntry] " + "WHERE {0} <= [Timestamp] AND [Timestamp] <= {1} AND [EventId] = {2} AND " + filter; var sqlAuditLogEntries = db.ExecuteQuery <int>( query, date, date.AddDays(1), eventType) .ToList(); var count = sqlAuditLogEntries.First(); if (count > max) { max = count; } gentry.Coordinates.Add(new AuditGraphCoordinates() { X = date.ToString("yyyy-MM-dd"), Y = count.ToString() }); } entries[eventType] = gentry; } ret.YMax = max.ToString(); ret.YMin = "0"; ret.XMin = start.ToString("yyyy-MM-dd"); ret.XMax = end.ToString("yyyy-MM-dd"); ret.GraphEntries = entries; ret.LogEntries = null; // timeSet; return(ret); } }
public static bool DoesExist(ActivityDataModel data, RequestProfile requestProfile) { var doesExistRequest = new ActivityDataModel(); doesExistRequest.Name = data.Name; var list = GetEntityDetails(doesExistRequest, requestProfile); return(list.Count > 0); }
public static DataSet DeleteChildren(ActivityDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.ActivityChildrenDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ActivityDataModel.DataColumns.ActivityId); var oDT = new DBDataSet("Activity.DeleteChildren", sql, DataStoreKey); return(oDT.DBDataset); }
public virtual void Update(ActivityDataModel activity) { if (activity.ID > 0) { ActivityDAL.Update(activity); } else { throw new Exception("Page not found"); } }
public ActionResult ActivitySave(ActivityDataModel model) { int id = 0; using (ActivityModule module = new ActivityModule()) { id = module.DoSaveData(model); } var redirectUrl = new UrlHelper(Request.RequestContext).Action("ActivityEdit", "_SysAdm", new { ID = id }); return(Json(new { Url = redirectUrl })); }
public static List <ActivityDataModel> GetAll() { List <ActivityDataModel> activitys = new List <ActivityDataModel>(); MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetActivitys", connection); DataTable results = new DataTable(); adapter.Fill(results); foreach (DataRow item in results.Rows) { ActivityDataModel activity = new ActivityDataModel(); if (item["ID"].GetType() != typeof(DBNull)) { activity.ID = Convert.ToInt32(item["ID"]); } if (item["Name"].GetType() != typeof(DBNull)) { activity.Name = Convert.ToString(item["Name"]); } if (item["WorkflowID"].GetType() != typeof(DBNull)) { activity.WorkflowID = Convert.ToInt32(item["WorkflowID"]); } if (item["OwnerID"].GetType() != typeof(DBNull)) { activity.OwnerID = Convert.ToInt32(item["OwnerID"]); } if (item["CreatedBy"].GetType() != typeof(DBNull)) { activity.CreatedBy = Convert.ToInt32(item["CreatedBy"]); } if (item["DateCreated"].GetType() != typeof(DBNull)) { activity.DateCreated = Convert.ToDateTime(item["DateCreated"]); } if (item["ParentActivityID"].GetType() != typeof(DBNull)) { activity.ParentActivityID = Convert.ToInt32(item["ParentActivityID"]); } if (item["Approved"].GetType() != typeof(DBNull)) { activity.Approved = Convert.ToBoolean(item["Approved"]); } activitys.Add(activity); } return(activitys); }
private void UpdateData(ArrayList values) { var data = new ActivityDataModel(); data.ActivityId = int.Parse(values[0].ToString()); data.Name = values[1].ToString(); data.Description = values[2].ToString(); data.SortOrder = int.Parse(values[3].ToString()); data.LayerId = int.Parse(values[4].ToString()); ActivityDataManager.Update(data, SessionVariables.RequestProfile); ReBindEditableGrid(); }
public ActivityDataModel GetNextWorkflowActivity(int workflowID) { ActivityDataModel activity = null; MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("GetNextWorkflowActivity", connection); MySqlParameter paramID = new MySqlParameter("pId", workflowID); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.Add(paramID); DataTable results = new DataTable(); adapter.Fill(results); if (results.Rows.Count > 0) { DataRow item = results.Rows[0]; activity = new ActivityDataModel(); if (item["ID"].GetType() != typeof(DBNull)) { activity.ID = Convert.ToInt32(item["ID"]); } if (item["Name"].GetType() != typeof(DBNull)) { activity.Name = Convert.ToString(item["Name"]); } if (item["OwnerID"].GetType() != typeof(DBNull)) { activity.OwnerID = Convert.ToInt32(item["OwnerID"]); } if (item["CreatedBy"].GetType() != typeof(DBNull)) { activity.CreatedBy = Convert.ToInt32(item["CreatedBy"]); } if (item["DateCreated"].GetType() != typeof(DBNull)) { activity.DateCreated = Convert.ToDateTime(item["DateCreated"]); } if (item["WorkflowID"].GetType() != typeof(DBNull)) { activity.WorkflowID = Convert.ToInt32(item["WorkflowID"]); } } return(activity); }
public static bool IsDeletable(ActivityDataModel data, RequestProfile requestProfile) { var isDeletable = true; var ds = GetChildren(data, requestProfile); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables.Cast <DataTable>().Any(dt => dt.Rows.Count > 0)) { isDeletable = false; } } return(isDeletable); }
public static void Delete(ActivityDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.ActivityDelete "; var parameters = new { AuditId = requestProfile.AuditId , ActivityId = dataQuery.ActivityId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public override void Create(ActivityDataModel activity) { if (!SecurityManager.SesionStarted()) { throw new Exception("Session not started"); } activity.CreatedBy = SecurityManager.GetLoggedUser().ID; activity.DateCreated = DateTime.Now; if (HttpContext.Current.Session["ParentID"] != null) { activity.WorkflowID = Convert.ToInt32(HttpContext.Current.Session["ParentID"]); } base.Create(activity); }
private object GetUserActivity(ActivityDataModel data) { AuditGraph ret = new AuditGraph(); int max = 0; DateTime start = DateTime.Parse(data.Start); DateTime end = DateTime.Parse(data.End); TimeSpan range = end.Subtract(start); var filter = BuildArrayQuery(data.Filters, data.Field, data.Databases); List <string> dates = new List <string>(); for (int i = 0; i <= range.Days; i++) { dates.Add(start.AddDays(i).ToString("yyyyMMdd")); } var searcher = AuditLogger.Current.GetSearcher(); Dictionary <string, AuditGraphEntry> entries = new Dictionary <string, AuditGraphEntry>(); foreach (string eventType in data.EventTypes) { AuditGraphEntry gentry = new AuditGraphEntry() { Color = AuditLogger.Current.GetEventType(eventType).Color }; foreach (string date in dates) { var results = AuditLogger.Current.Query($"date:{date} AND event:{eventType} {(filter.Length > 0 ? "AND " : "") + filter}", searcher); if (results.TotalHits > max) { max = results.TotalHits; } gentry.Coordinates.Add(new AuditGraphCoordinates() { X = date.Insert(6, "-").Insert(4, "-"), Y = results.TotalHits.ToString() }); } entries[eventType] = gentry; } ret.YMax = max.ToString(); ret.YMin = "0"; ret.XMin = start.ToString("yyyy-MM-dd"); ret.XMax = end.ToString("yyyy-MM-dd"); ret.GraphEntries = entries; ret.LogEntries = null; // timeSet; return(ret); }
public static string ToSQLParameter(ActivityDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ActivityDataModel.DataColumns.ActivityId: if (data.ActivityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityDataModel.DataColumns.ActivityId, data.ActivityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityDataModel.DataColumns.ActivityId); } break; case ActivityDataModel.DataColumns.LayerId: if (data.LayerId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityDataModel.DataColumns.LayerId, data.LayerId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityDataModel.DataColumns.LayerId); } break; case ActivityDataModel.DataColumns.Layer: if (data.Layer != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ActivityDataModel.DataColumns.Layer, data.Layer); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ActivityDataModel.DataColumns.Layer); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static void Create(ActivityDataModel activity) { MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]); MySqlDataAdapter adapter = new MySqlDataAdapter("Core_CreateActivity", connection); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; MySqlParameter paramID = new MySqlParameter("pID", activity.ID); paramID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramID); MySqlParameter paramName = new MySqlParameter("pName", activity.Name); paramName.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramName); MySqlParameter paramWorkflowID = new MySqlParameter("pWorkflowID", activity.WorkflowID); paramWorkflowID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramWorkflowID); MySqlParameter paramOwnerID = new MySqlParameter("pOwnerID", activity.OwnerID); paramOwnerID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramOwnerID); MySqlParameter paramCreatedBy = new MySqlParameter("pCreatedBy", activity.CreatedBy); paramCreatedBy.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramCreatedBy); MySqlParameter paramDateCreated = new MySqlParameter("pDateCreated", activity.DateCreated); paramDateCreated.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramDateCreated); MySqlParameter paramParentActivityID = new MySqlParameter("pParentActivityID", activity.ParentActivityID); paramParentActivityID.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramParentActivityID); MySqlParameter paramApproved = new MySqlParameter("pApproved", activity.Approved); paramApproved.Direction = ParameterDirection.Input; adapter.SelectCommand.Parameters.Add(paramApproved); DataTable results = new DataTable(); adapter.Fill(results); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new ActivityDataModel(); data.ActivityId = int.Parse(index); ActivityDataManager.Delete(data, SessionVariables.RequestProfile); DeleteAndRedirect(); } } catch (Exception ex) { Response.Write(ex.Message); } }