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