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