public List <CategoryModel> Get()
{
var parameters = new
{
};
var categories = GetService.GetDataAccessService().LoadData <CategoryModel, dynamic>("GetAllCategories", parameters, "DataConnection");
return(categories);
}
public void UnpublishArticle(int articleId)
{
var parameters = new
{
ArticleId = articleId,
};
GetService.GetDataAccessService().SaveData <dynamic>("UnpublishArticle", parameters, "DataConnection");
}
public CategoryModel GetPublishedArticlesById(int id)
{
var parameters = new
{
CategoryId = id
};
var category = GetService.GetDataAccessService().LoadData <CategoryModel, dynamic>("GetCategoriesById", parameters, "DataConnection");
return(category.FirstOrDefault());
}
public void PublishArticle(string userId, int articleId)
{
var parameters = new
{
ArticleId = articleId,
UserId = userId
};
GetService.GetDataAccessService().SaveData <dynamic>("PublishArticle", parameters, "DataConnection");
}
public void Insert(ArticleModel articleModel)
{
//List<dynamic> categories = new List<dynamic>();
//foreach(var originalCategory in articleModel.Categories)
//{
// var category = new
// {
// CategoryId = originalCategory.CategoryId,
// Name = originalCategory.Name
// };
// categories.Add(category);
//};
//var parameters = new DynamicParameters();
//parameters.Add("@UserId", registrationModel.UserId);
//parameters.Add("@Username", registrationModel.UserId);
//parameters.Add("@Username", registrationModel.Username);
//parameters.Add("@Password", registrationModel.Password);
//parameters.Add("@FirstName", registrationModel.FirstName);
//parameters.Add("@LastName", registrationModel.LastName);
//parameters.Add("@Email", registrationModel.Email);
//parameters.Add("@TelephoneNumber", registrationModel.TelephoneNumber.);
//parameters.Add("@Categories", articleModel.Categories.AsTableValuedParameter);
//parameters.Add("@Message", dbType: SqlDbType.Udt, direction: ParameterDirection.Output, size: 1000);
//parameters.Add("UsernameAlreadyExists", dbType: DbType.Boolean, direction: ParameterDirection.Output);
var categoriesTable = new DataTable();
categoriesTable.Columns.Add("CategoryId", typeof(Int32));
foreach (var originalCategory in articleModel.Categories)
{
categoriesTable.Rows.Add(originalCategory.CategoryId);
}
var parameters = new
{
Title = articleModel.Title,
Summary = articleModel.Summary,
MainImage = articleModel.MainImage,
Body = articleModel.Body,
CreatedAt = DateTime.Now,
IsDeleted = false,
Categories = categoriesTable.AsTableValuedParameter("[dbo].[ArticleCategoriesAdding]"),
UserId = articleModel.UploadedUserId
};
GetService.GetDataAccessService().SaveData <dynamic>("AddArticle", parameters, "DataConnection");
}
public List <ArticleModel> GetPublishedArticles()
{
var parameters = new
{
};
var articles = GetService.GetDataAccessService().LoadData <ArticleModel, dynamic>("GetAllPublishedArticles", parameters, "DataConnection");
foreach (var article in articles)
{
var categories = GetService.GetCategoryService().GetArticleCategoriesbyArticleId(article.ArticleId);
article.Categories = categories;
}
return(articles);
}
public List <RoleModel> Get()
{
try
{
var parameters = new
{
};
var roles = GetService.GetDataAccessService().LoadData <RoleModel, dynamic>("GetAllRoles", parameters, "DefaultConnection");
return(roles);
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete(int id)
{
try
{
var parameters = new
{
ArticleId = id
};
GetService.GetDataAccessService().SaveData <dynamic>("DeleteArticle", parameters, "DataConnection");
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateUserRoles(string userId, string roleId)
{
try
{
var parameters = new
{
Id = userId,
RoleId = roleId
};
GetService.GetDataAccessService().LoadData <UserModel, dynamic>("UpdateUserRole", parameters, "DefaultConnection");
}
catch (Exception ex)
{
throw ex;
}
}
public List <CategoryModel> GetArticleCategoriesbyArticleId(int id)
{
try
{
var parameters = new
{
ArticleId = id
};
var categories = GetService.GetDataAccessService().LoadData <CategoryModel, dynamic>("GetArticleCategoriesById", parameters, "DataConnection");
return(categories);
}
catch (Exception ex)
{
throw ex;
}
}
public List <RoleModel> GetRolesNotInUser(string userId)
{
try
{
var parameters = new
{
UserId = userId
};
var roles = GetService.GetDataAccessService().LoadData <RoleModel, dynamic>("GetRolesNotInUser", parameters, "DefaultConnection");
return(roles);
}
catch (Exception ex)
{
throw ex;
}
}
public List <ArticleModel> GetPublishedArticlesByCategoryAndTitle(int categoryId, string title)
{
var parameters = new
{
CategoryId = categoryId,
Title = title
};
var articles = GetService.GetDataAccessService().LoadData <ArticleModel, dynamic>("GetPublishedArticlesByCategoryAndTitle", parameters, "DataConnection");
foreach (var article in articles)
{
var categories = GetService.GetCategoryService().GetArticleCategoriesbyArticleId(article.ArticleId);
article.Categories = categories;
}
return(articles);
}
public UserModel GetUserById(string id)
{
try
{
var parameters = new
{
Id = id
};
var user = GetService.GetDataAccessService().LoadData <UserModel, dynamic>("GetUsersById", parameters, "DefaultConnection").FirstOrDefault();
return(user);
}
catch (Exception ex)
{
throw ex;
}
}
public ArticleModel GetPublishedArticlesById(int id)
{
try
{
var parameters = new
{
ArticleId = id
};
var article = GetService.GetDataAccessService().LoadData <ArticleModel, dynamic>("GetPublishedArticlesById", parameters, "DataConnection").FirstOrDefault();
article.Categories = GetService.GetCategoryService().GetArticleCategoriesbyArticleId(article.ArticleId);
return(article);
}
catch (Exception ex)
{
throw ex;
}
}
public dynamic Register(RegistrationModel registrationModel)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@UserId", registrationModel.UserId);
parameters.Add("@Username", registrationModel.UserId);
parameters.Add("@Username", registrationModel.Username);
parameters.Add("@Password", registrationModel.Password);
parameters.Add("@FirstName", registrationModel.FirstName);
parameters.Add("@LastName", registrationModel.LastName);
parameters.Add("@Email", registrationModel.Email);
parameters.Add("@TelephoneNumber", registrationModel.TelephoneNumber);
parameters.Add("@CellphoneNumber", registrationModel.CellphoneNumber);
parameters.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 1000);
parameters.Add("UsernameAlreadyExists", dbType: DbType.Boolean, direction: ParameterDirection.Output);
GetService.GetDataAccessService().SaveData <DynamicParameters>("AddUser", parameters, "DataConnection");
var message = parameters.Get <string>("@Message");
var usernameAlreadyExists = parameters.Get <bool>("@UsernameAlreadyExists");
return(new { message, usernameAlreadyExists });
}
public void Update(int id, ArticleModel articleModel)
{
var categoriesTable = new DataTable();
categoriesTable.Columns.Add("CategoryId", typeof(Int32));
foreach (var originalCategory in articleModel.Categories)
{
categoriesTable.Rows.Add(originalCategory.CategoryId);
}
var parameters = new
{
ArticleId = id,
Title = articleModel.Title,
Summary = articleModel.Summary,
MainImage = articleModel.MainImage,
Body = articleModel.Body,
IsDeleted = false,
Categories = categoriesTable.AsTableValuedParameter("[dbo].[ArticleCategoriesAdding]")
};
GetService.GetDataAccessService().SaveData <dynamic>("UpdateArticle", parameters, "DataConnection");
}
