public void UpdateProject(int projectId, DataAccessProjects projectToUpdate)
{
SqlConnection connection = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand("sp_UpdateProject", connection);
cmd.CommandType = CommandType.StoredProcedure;
try
{
cmd.Parameters.AddWithValue("@Project_ID", projectId);
cmd.Parameters.AddWithValue("@ProjectName", projectToUpdate.ProjectName);
cmd.Parameters.AddWithValue("@ProjectBody", projectToUpdate.ProjectBody);
cmd.Parameters.AddWithValue("@Difficulty_ID", projectToUpdate.Difficulty_ID);
cmd.Parameters.AddWithValue("@Craft_ID", projectToUpdate.Craft_ID);
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception error)
{
using (StreamWriter writer = new StreamWriter(_errorLog))
{
writer.Write("Update Exception: " + error);
}
}
finally
{
connection.Close();
}
}
public static DataAccessProjects RowToProjects(DataRow tableRow)
{
DataAccessProjects dProject = new DataAccessProjects();
dProject.Project_ID = (int)tableRow["Project_ID"];
dProject.User_ID = (int)tableRow["User_ID"];
dProject.Craft_ID = (int)tableRow["Craft_ID"];
dProject.ProjectName = tableRow["ProjectName"].ToString();
dProject.ProjectBody = tableRow["ProjectBody"].ToString();
dProject.DifficultyLevel = tableRow["DifficultyLevel"].ToString();
dProject.Difficulty_ID = (int)tableRow["Difficulty_ID"];
return(dProject);
}
public BusinessLogicProjects MapProject(DataAccessProjects dProject)
{
BusinessLogicProjects bProject = new BusinessLogicProjects();
bProject.Project_ID = dProject.Project_ID;
bProject.User_ID = dProject.User_ID;
bProject.Craft_ID = dProject.Craft_ID;
bProject.ProjectName = dProject.ProjectName;
bProject.ProjectBody = dProject.ProjectBody;
bProject.Difficulty_ID = dProject.Difficulty_ID;
bProject.DifficultyLevel = dProject.DifficultyLevel;
return(bProject);
}
public DataAccessProjects MapProject(BusinessLogicProjects bProject)
{
DataAccessProjects dProject = new DataAccessProjects();
dProject.Project_ID = bProject.Project_ID;
dProject.User_ID = bProject.User_ID;
dProject.Craft_ID = bProject.Craft_ID;
dProject.ProjectName = bProject.ProjectName;
dProject.ProjectBody = bProject.ProjectBody;
dProject.Difficulty_ID = bProject.Difficulty_ID;
dProject.DifficultyLevel = bProject.DifficultyLevel;
return(dProject);
}
public DataAccessProjects GetProjectByProjectId(int projectId)
{
DataAccessProjects projects = new DataAccessProjects();
foreach (DataAccessProjects dProject in GetProjects())
{
if (projectId == dProject.Project_ID)
{
projects = dProject;
}
}
return(projects);
}
public List <DataAccessProjects> TableToListOfProjects(DataTable projectsTable)
{
List <DataAccessProjects> dProjects = new List <DataAccessProjects>();
if (projectsTable != null && projectsTable.Rows.Count > 0)
{
foreach (DataRow row in projectsTable.Rows)
{
DataAccessProjects dProject = new DataAccessProjects();
dProject = RowToProjects(row);
dProjects.Add(dProject);
}
}
return(dProjects);
}
public BusinessLogicProjects MapProject(DataAccessProjects dProject)
{
if (dProject == null)
{
return(null);
}
BusinessLogicProjects bProject = new BusinessLogicProjects
{
Project_ID = dProject.Project_ID,
User_ID = dProject.User_ID,
Craft_ID = dProject.Craft_ID,
ProjectName = dProject.ProjectName,
ProjectBody = dProject.ProjectBody,
Difficulty_ID = dProject.Difficulty_ID,
DifficultyLevel = dProject.DifficultyLevel
};
return(bProject);
}
public DataAccessProjects MapProject(BusinessLogicProjects bProject)
{
if (bProject == null)
{
return(null);
}
DataAccessProjects dProject = new DataAccessProjects()
{
Project_ID = bProject.Project_ID,
User_ID = bProject.User_ID,
Craft_ID = bProject.Craft_ID,
ProjectName = bProject.ProjectName,
ProjectBody = bProject.ProjectBody,
Difficulty_ID = bProject.Difficulty_ID,
DifficultyLevel = bProject.DifficultyLevel
};
return(dProject);
}
