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