public void InsertNewCategory(string categoryName)
{
using (DAO)
{
DAO.text = insertCategoryIntoCategoryTable;
DAO.AddParameter("@NAME", categoryName, SqlDbType.VarChar);
DAO.ExecuteCommand();
}
}
public void InsertNewProject(ProjectModel newProject)
{
using (DAO)
{
DAO.text = insertProjectIntoProjectTable;
DAO.AddParameter("@NAME", newProject.name, SqlDbType.VarChar);
DAO.AddParameter("@STATUS", newProject.status, SqlDbType.VarChar);
DAO.AddParameter("@VIEW_STATE", newProject.viewState, SqlDbType.VarChar);
DAO.AddParameter("@DESCRIPTION", newProject.description, SqlDbType.VarChar);
DAO.ExecuteCommand();
}
}
public string ReturnCategory(string name)
{
var result = new DataTable();
using (DAO)
{
DAO.text = selectCategoruByName;
DAO.AddParameter("@NAME", name, SqlDbType.VarChar);
result = DAO.Select();
}
return(result.AsEnumerable().Select(x => x.Field <string>("name")).First());
}
public UserModel ReturnUser(string username)
{
var result = new DataTable();
using (DAO)
{
DAO.text = selectUserByUsername;
DAO.AddParameter("@USERNAME", username, SqlDbType.VarChar);
result = DAO.Select();
}
return(result.AsEnumerable().Select(x => new UserModel()
{
username = x.Field <string>("username"),
realName = x.Field <string>("realname"),
email = x.Field <string>("email"),
accessLevel = x.Field <string>("access_level")
}).First());
}
public ProjectModel ReturnProject(string name)
{
var result = new DataTable();
using (DAO)
{
DAO.text = selectProjectByName;
DAO.AddParameter("@NAME", name, SqlDbType.VarChar);
result = DAO.Select();
}
return(result.AsEnumerable().Select(x => new ProjectModel()
{
id = x.Field <int>("idt_project"),
name = x.Field <string>("name"),
status = x.Field <string>("status"),
viewState = x.Field <string>("status"),
description = x.Field <string>("description")
}).First());
}