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