public string Save(Redirect query)
{
StringBuilder sql = new StringBuilder();
try
{
query.Replace4MySQL();
sql.Append(" INSERT INTO redirect(redirect_id,group_id,user_group_id,redirect_name,redirect_url,");
sql.Append(" redirect_status,redirect_total, redirect_note,redirect_createdate,redirect_updatedate,redirect_ipfrom ) ");
sql.AppendFormat(" VALUES ('{0}','{1}','{2}','{3}','{4}',", query.redirect_id, query.group_id, query.user_group_id, query.redirect_name, query.redirect_url);
sql.AppendFormat(" '{0}','{1}','{2}','{3}','{4}','{5}')", query.redirect_status, query.redirect_total, query.redirect_note, query.redirect_createdate, query.redirect_updatedate, query.redirect_ipfrom);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("RedirectDao-->Save-->" + ex.Message + sql.ToString(), ex);
}
}
public HttpResponseBase SaveRedirect()
{
string json = string.Empty;
try
{
Redirect redirect = new Redirect();
_redirectMgr = new RedirectMgr(mySqlConnectionString);
_serialMgr = new SerialMgr(mySqlConnectionString);
redirect.redirect_name = Request.Params["redirect_name"].ToString();
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
redirect.group_id = uint.Parse(Request.Params["group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["user_group_id"]))
{
redirect.user_group_id = int.Parse(Request.Params["user_group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["redirect_status"]))
{
redirect.redirect_status = uint.Parse(Request.Params["redirect_status"]);
}
redirect.redirect_url = Request.Params["redirect_url"];
redirect.redirect_note = Request.Params["redirect_note"];
redirect.redirect_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString();
if (!string.IsNullOrEmpty(Request.Params["redirect_id"]))
{
redirect.redirect_id = uint.Parse(Request.Params["redirect_id"]);
redirect.redirect_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime());
if (_redirectMgr.Update(redirect) > 0)
{
json = "{success:true}";
}
}
else
{
redirect.redirect_id = uint.Parse((_serialMgr.GetSerialById(4).Serial_Value + 1).ToString());
redirect.redirect_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime());
redirect.redirect_updatedate = redirect.redirect_createdate;
if (_redirectMgr.Save(redirect) > 0)
{
Serial serial = new Serial();
serial.Serial_id = 4;
serial.Serial_Value = redirect.redirect_id;
_serialMgr.Update(serial);
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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int Update(Redirect query)
{
StringBuilder sql = new StringBuilder("");
try
{
query.Replace4MySQL();
sql.AppendFormat("UPDATE redirect set ");
sql.AppendFormat(" group_id='{0}',user_group_id='{1}',redirect_name='{2}',", query.group_id, query.user_group_id, query.redirect_name);
sql.AppendFormat(" redirect_url='{0}',redirect_status='{1}',", query.redirect_url, query.redirect_status);
sql.AppendFormat(" redirect_note='{0}',redirect_updatedate='{1}',redirect_ipfrom='{2}'", query.redirect_note, query.redirect_updatedate, query.redirect_ipfrom);
sql.AppendFormat(" WHERE redirect_id='{0}' ;", query.redirect_id);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("RedirectDao-->Update-->" + ex.Message + sql.ToString(), ex);
}
}
