public string AddUnBlockLog(EmailBlockLogQuery query)
{
query.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"INSERT INTO email_block_log (email_address,block_start,block_end,block_reason,unblock_reason,block_create_userid,unblock_create_userid)
VALUES('{0}','{1}',NOW(),'{2}','{3}',{4},{5})", query.email_address, query.log_block_start, query.block_reason, query.unblock_reason, query.block_create_userid, query.unblock_create_userid);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("EmailBlockLogDao-->AddUnBlockLog-->" + ex.Message, ex);
}
}
public HttpResponseBase UnBlock()
{
string json = string.Empty;
bool result = false;
try
{
_emailBlockListMgr = new EmailBlockListMgr(mySqlConnectionString);
EmailBlockLogQuery query = new EmailBlockLogQuery();
if (!string.IsNullOrEmpty(Request.Params["email_address"]))
{
query.email_address = Request.Params["email_address"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["unblock_reason"]))
{
query.unblock_reason = Request.Params["unblock_reason"].ToString().Replace("\\", "\\\\"); ;
}
query.unblock_create_userid = Convert.ToInt32((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString());
result = _emailBlockListMgr.UnBlock(query);
if (result)
{
json = "{success:true}";
}
}
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,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
