public string UpdateBlog(MyBlog s) { string result = ""; try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Rp\Documents\Blog.mdf;Integrated Security=True;Connect Timeout=30"); SqlCommand cmd = new SqlCommand(); string Query = @"UPDATE [Table] SET title=@title,content=@content WHERE blogNO=@blogNO"; cmd = new SqlCommand(Query, con); cmd.Parameters.AddWithValue("@blogNO", s.blogNO); cmd.Parameters.AddWithValue("@title", s.title); cmd.Parameters.AddWithValue("@content", s.content); con.Open(); cmd.ExecuteNonQuery(); con.Close(); result = "Blog Updated Successfully !"; } catch (FaultException fex) { result = fex.ToString() + "Error:Add Operation Failed"; } return(result); }
public string AddBlog(MyBlog s) { string result = ""; try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Rp\Documents\Blog.mdf;Integrated Security=True;Connect Timeout=30"); SqlCommand cmd = new SqlCommand(); string Query = @"INSERT INTO [Table] (title,doc,blogby,content,uid) Values(@title,@doc,@blogby,@content,@uid)"; cmd = new SqlCommand(Query, con); s.doc = DateTime.Now; //cmd.Parameters.AddWithValue("@GRNO",s.GRNO); cmd.Parameters.AddWithValue("@title", s.title); cmd.Parameters.AddWithValue("@doc", s.doc.Date); cmd.Parameters.AddWithValue("@blogby", s.blogby); cmd.Parameters.AddWithValue("@content", s.content); cmd.Parameters.AddWithValue("@uid", s.uid); con.Open(); cmd.ExecuteNonQuery(); con.Close(); result = "Blog Added Successfully !"; } catch (FaultException fex) { result = fex.ToString() + "Error:Add Operation Failed"; } return(result); }
public List <MyBlog> GetAllBlog() { DataSet ds = new DataSet(); try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Rp\Documents\Blog.mdf;Integrated Security=True;Connect Timeout=30"); string Query = "SELECT * FROM [Table]"; SqlDataAdapter sda = new SqlDataAdapter(Query, con); sda.Fill(ds); } catch (FaultException fex) { throw new FaultException <string>("Error: " + fex); } List <MyBlog> objList = new List <MyBlog>(); foreach (DataRow _dataRow in ds.Tables[0].Rows) { MyBlog obj = new MyBlog(); obj.blogNO = Convert.ToInt32(_dataRow["blogNO"]); obj.title = Convert.ToString(_dataRow["title"]); obj.doc = Convert.ToDateTime(_dataRow["doc"]); obj.blogby = Convert.ToString(_dataRow["blogby"]); obj.content = Convert.ToString(_dataRow["content"]); obj.uid = Convert.ToInt32(_dataRow["uid"]); objList.Add(obj); } return(objList); }
public List <MyBlog> GetAllMyBlog(string unm) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Rp\Documents\Blog.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM [User] WHERE username=@username", con); cmd.Parameters.AddWithValue("@username", unm); cmd.CommandType = CommandType.Text; int uuid = 0; using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { uuid = rdr.GetInt32(0); } } DataSet ds = new DataSet(); try { SqlConnection con2 = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Rp\Documents\Blog.mdf;Integrated Security=True;Connect Timeout=30"); string Query = "SELECT * FROM [Table] WHERE uid=@uid"; SqlDataAdapter sda = new SqlDataAdapter(Query, con2); sda.SelectCommand.Parameters.AddWithValue("@uid", uuid); sda.Fill(ds); } catch (FaultException fex) { throw new FaultException <string>("Error: " + fex); } List <MyBlog> objList = new List <MyBlog>(); foreach (DataRow _dataRow in ds.Tables[0].Rows) { MyBlog obj = new MyBlog(); obj.blogNO = Convert.ToInt32(_dataRow["blogNO"]); obj.title = Convert.ToString(_dataRow["title"]); obj.doc = Convert.ToDateTime(_dataRow["doc"]); obj.blogby = Convert.ToString(_dataRow["blogby"]); obj.content = Convert.ToString(_dataRow["content"]); obj.uid = Convert.ToInt32(_dataRow["uid"]); objList.Add(obj); } return(objList); }
public MyBlog GetBlogById(int id) { MyBlog s = new MyBlog(); try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Rp\Documents\Blog.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); SqlCommand cmd = new SqlCommand(@"SELECT * FROM [Table] WHERE blogNO=@blogNO", con); cmd.Parameters.AddWithValue("@blogNO", id); cmd.CommandType = CommandType.Text; using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.HasRows) { rdr.Read(); // get the first row s.blogNO = rdr.GetInt32(0); s.title = rdr.GetString(1); s.content = rdr.GetString(3); s.blogby = rdr.GetString(4); s.doc = rdr.GetDateTime(2); } } } catch (FaultException fex) { throw new FaultException <string>("Error: " + fex); } return(s); }