//Add new article:
public static bool addArticle(int userNumber, Article article)
{
bool result = false;
SqlConnection cnctn = null;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "addArticle";
cmd.Parameters.Add("@articleArticletitle", System.Data.SqlDbType.NVarChar, 128).Value = article.articleName;
cmd.Parameters.Add("@articleCngdt", System.Data.SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@articleArticlecntnt", System.Data.SqlDbType.NVarChar, -1).Value = article.articleContent;
cmd.Parameters.Add("@articleArticlepublic", System.Data.SqlDbType.Bit, 1).Value = article.isPublic;
cmd.Parameters.Add("@articleOwnerid", System.Data.SqlDbType.Int, 50).Value = userNumber;
try
{
cnctn = new SqlConnection(GlobalFunctions.getConnectionString());
cmd.Connection = cnctn;
cnctn.Open();
int rc = cmd.ExecuteNonQuery();
if (rc == 1)
result = true;
}
catch
{
}
finally
{
if (cnctn != null)
cnctn.Close();
}
return result;
}
//Method executes 'Select Article' procedure:
public static Article getArticleById(long id)
{
Article rslt = null;
SqlConnection cnctn = null;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "selectArticleById";
cmd.Parameters.Add("@articleArticleid", System.Data.SqlDbType.BigInt).Value = id;
SqlDataReader rdr = null;
try
{
cnctn = new SqlConnection(GlobalFunctions.getConnectionString());
cmd.Connection = cnctn;
cnctn.Open();
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
rslt = new Article
{
articleId = (Int64)rdr["Articleid"],
articleName = rdr["Articletitle"].ToString(),
articleContent = rdr["Articlecntnt"].ToString(),
date = (DateTime)rdr["Cngdt"],
userId = (int)rdr["Ownerid"],
isPublic = (bool)rdr["Articlepublic"]
};
}
}
catch// (Exception prblm)
{
}
finally
{
if (rdr != null)
rdr.Close();
if (cnctn != null)
cnctn.Close();
}
return rslt;
}
//Method executes 'Get All Articles' procedure:
private static List<Article> getAllArticles(string email)
{
List<Article> rslt = new List<Article>();
SqlConnection cnctn = null;
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "getAllArticles";
cmd.Parameters.Add("@usersEmail", System.Data.SqlDbType.VarChar, 254).Value = email;
SqlDataReader rdr = null;
int i = 0;
try
{
cnctn = new SqlConnection(GlobalFunctions.getConnectionString());
cmd.Connection = cnctn;
cnctn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Article tempArticle = new Article
{
articleId = (Int64)rdr["Articleid"],
articleName = rdr["Articletitle"].ToString(),
articleContent = rdr["Articlecntnt"].ToString(),
date = (DateTime)rdr["Cngdt"],
userId = (int)rdr["Ownerid"],
isPublic = (bool)rdr["Articlepublic"]
};
rslt.Add(tempArticle);
i++;
}
if (i == 0)
rslt = null;
}
catch// (Exception prblm)
{
rslt = null;
}
finally
{
if (rdr != null)
rdr.Close();
if (cnctn != null)
cnctn.Close();
}
return rslt;
}