public async Task <IActionResult> Edit(int id, [Bind("ProjectID,Name,Description,CreatedBy,CreatedAt,UpdatedBy,UpdatedAt")] ProjectDM projectDM)
{
if (id != projectDM.ProjectID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var userId = User.FindFirst(ClaimTypes.NameIdentifier).Value;
projectDM.UpdatedAt = DateTime.UtcNow;
projectDM.UpdatedBy = userId;
await _projectService.Update(projectDM);
}
catch (DbUpdateConcurrencyException)
{
if (!_projectService.IsProjectExist(projectDM.ProjectID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(projectDM));
}
public async Task Delete(ProjectDM entity)
{
if (entity == null)
{
throw new ArgumentNullException();
}
_context.Projects.Remove(entity);
await _context.SaveChangesAsync();
}
public async Task <ProjectDM> Update(ProjectDM entity)
{
if (entity == null)
{
throw new ArgumentNullException();
}
_context.Projects.Update(entity);
await _context.SaveChangesAsync();
return(entity);
}
public async Task <IActionResult> Create([Bind("ProjectID,Name,Description,CreatedBy,CreatedAt,UpdatedBy,UpdatedAt")] ProjectDM projectDM)
{
if (ModelState.IsValid)
{
var userId = User.FindFirst(ClaimTypes.NameIdentifier).Value;
projectDM.CreatedBy = userId;
projectDM.CreatedAt = DateTime.UtcNow;
await _projectService.Create(projectDM);
return(RedirectToAction(nameof(Index)));
}
return(View(projectDM));
}
public static void DeleteProject(ProjectDM _project)
{
try
{
using (SqlCommand cmd = new SqlCommand("DELETE_PROJECT", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Project_ID", _project.ProjectId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
//Write to error log
throw ex;
}
}
public static List <ProjectDM> ReadProjects()
{
List <ProjectDM> projectList = new List <ProjectDM>();
try
{
using (SqlCommand cmd = new SqlCommand("READ_PROJECTS", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var _project = new ProjectDM();
_project.ProjectId = (Int64)reader["Project_ID"];
_project.ProjectName = (string)reader["Project_Name"];
_project.ProjectNumber = (int)reader["Project_Number"];
_project.StartDate = (DateTime)reader["Project_Start_Date"];
_project.EndDate = (DateTime)reader["Project_End_Date"];
_project.ClientId = (Int64)reader["Client_ID"];
projectList.Add(_project);
}
}
}
SqlConnect.Connection.Close();
}
return(projectList);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public static ProjectDM ReadProjectById(string projectId)
{
ProjectDM _project = new ProjectDM();
try
{
using (SqlCommand cmd = new SqlCommand("READ_PROJECT_BY_ID", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
cmd.Parameters.AddWithValue("@Project_ID", projectId);
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_project.ProjectId = (Int64)reader["Project_ID"];
_project.ProjectName = (string)reader["Project_Name"];
_project.ProjectNumber = (int)reader["Project_Number"];
_project.StartDate = (DateTime)reader["Project_Start_Date"];
_project.EndDate = (DateTime)reader["Project_End_Date"];
_project.ClientId = (Int64)reader["Client_ID"];
}
}
}
SqlConnect.Connection.Close();
}
return(_project);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
/// <summary>
/// Basic CRUD methods for Project information. ProjectDM is the model being used here.
/// </summary>
#region Project DAL METHODS
public static void CreateProject(ProjectDM _project)
{
try
{
//Creating a way of adding new user information to my database
using (SqlCommand cmd = new SqlCommand("CREATE_PROJECT", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Project_Name", _project.ProjectName);
cmd.Parameters.AddWithValue("@Project_Number", _project.ProjectNumber);
cmd.Parameters.AddWithValue("@Project_Start_Date", _project.StartDate.ToShortDateString());
cmd.Parameters.AddWithValue("@Project_End_Date", _project.EndDate.ToShortDateString());
cmd.Parameters.AddWithValue("@Client_ID", _project.ClientId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public ActionResult ReadProjectByID(ProjectDM project)
{
return(View(Mapper.Map <ProjectVM>(ProjectDAL.ReadProjectById(project.ProjectId.ToString()))));
}
