public static Models.WPage CreatePage(Models.WPage page)
{
Models.WPage ret = null;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(constr))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "CreatePage";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@mob",
Value = page.Mobile
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageUrl",
Value = page.PageUrl
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageName",
Value = page.PageName ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Ip",
Value = page.Ip
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Nick",
Value = page.Nick ?? "Yourid-" + RandomString(4)
});
cmd.Connection = con;
//con.Open();
//var obj = cmd.ExecuteNonQuery();
using (System.Data.SqlClient.SqlDataAdapter adapt = new SqlDataAdapter(cmd))
{
System.Data.DataSet set = new System.Data.DataSet();
adapt.Fill(set);
if (set != null && set.Tables.Count > 0)
{
var tret = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Models.WPage> >(Newtonsoft.Json.JsonConvert.SerializeObject(set.Tables[0]));
if (tret != null && tret.Count > 0)
{
ret = tret[0];
}
}
}
}
}
return(ret);
}
public HttpResponseMessage UpdatePage(Models.WPage page)
{
page.Ip = getIPAddress(Request);
Code.WupDataAccess.UpdatePage(page);
return(new HttpResponseMessage()
{
Content = new JsonContent(new
{
MsgResp = "Success",
Error = false
})
});
}
public static void UpdatePage(Models.WPage page)
{
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(constr))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "UpdatePage";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@mob",
Value = page.Mobile ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageName",
Value = page.PageName ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageUrl",
Value = page.PageUrl ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Nick",
Value = page.Nick ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Ip",
Value = page.Ip
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Secured",
Value = page.Secured
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@AllowedMobiles",
Value = page.AllowedMobiles ?? ""
});
cmd.Connection = con;
con.Open();
var obj = cmd.ExecuteNonQuery();
}
}
}
public static Models.WPage GetPageById(string pageid, string mob, string ip)
{
Models.WPage lst = null;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(constr))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "GetPageById";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageUrl",
Value = pageid ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@mob",
Value = mob ?? ""
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Ip",
Value = ip ?? ""
});
cmd.Connection = con;
using (System.Data.SqlClient.SqlDataAdapter adapt = new SqlDataAdapter(cmd))
{
System.Data.DataSet set = new System.Data.DataSet();
adapt.Fill(set);
if (set != null && set.Tables.Count > 0)
{
var lst1 = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Models.WPage> >(Newtonsoft.Json.JsonConvert.SerializeObject(set.Tables[0]));
if (lst1 != null && lst1.Count > 0)
{
lst = lst1[0];
}
}
}
}
}
return(lst);
}
