public HttpResponseBase UpdateStats()
{
string json = string.Empty;
try
{
edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString);
EdmGroupNewQuery query = new EdmGroupNewQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.group_id = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
query.enabled = Convert.ToInt32(Request.Params["active"]);
}
json = edmgroupmgr.UpdateStatus(query);
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SaveEdmGroupNewAdd() //add by yachao1120j 2015-9-22
{
string json = string.Empty;
try
{
EdmGroupNewQuery query = new EdmGroupNewQuery();
edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
query.group_id = Convert.ToInt32(Request.Params["group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["group_name"]))
{
query.group_name = Request.Params["group_name"];
}
if (!string.IsNullOrEmpty(Request.Params["is_member_edm"]))
{
query.is_member_edm = Convert.ToInt32(Request.Params["is_member_edm"]);
}
if (!string.IsNullOrEmpty(Request.Params["trial_url"]))
{
query.trial_url = Request.Params["trial_url"];
}
if (!string.IsNullOrEmpty(Request.Params["sort_order"]))
{
query.sort_order = Convert.ToInt32(Request.Params["sort_order"]);
}
if (!string.IsNullOrEmpty(Request.Params["description"]))
{
query.description = Request.Params["description"];
}
query.group_create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.group_update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
int _dt = edmgroupmgr.SaveEdmGroupNewAdd(query);
if (_dt > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}
public HttpResponseBase GetEdmGroupNewList()// add by yachao1120j 2015-9-21
{
string json = string.Empty;
int totalcount = 0;
try
{
EdmGroupNewQuery query = new EdmGroupNewQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
edmgroupmgr = new EdmGroupNewMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["group_name_list"]))
{
query.group_name = Request.Params["group_name_list"];
}
List<EdmGroupNewQuery> list = edmgroupmgr.GetEdmGroupNewList(query, out totalcount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
// timeConverter.DateTimeFormat = "yyyy-MM-dd";
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, Formatting.Indented, timeConverter) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}