public ActionResult SaveEdititngProjectCooperations(ProjectCooperationsVm model)
{
if (model is null || model.DateAssigned == DateTime.MinValue || model.Project_Id == 0 || model.Project_Id == null || model.Team_Id == 0 || model.Team_Id == null)
{
TempData["error"] = $"Problems with saving information to database (services).";
return(RedirectToAction("Edit", new { projectCooperations_id = model.Id }));
}
ProjectCooperaionsModel projectCooperations = new ProjectCooperaionsModel()
{
Id = model.Id,
Project_Id = model.Project_Id,
Team_Id = model.Team_Id,
DateAssigned = model.DateAssigned
};
try
{
if (!_projectCooperaionsService.Update(projectCooperations))
{
TempData["error"] = $"Problems with updating project cooperation (Service error \"Update/Edit\").";
return(RedirectToAction("Edit", new { projectCooperations_id = model.Id }));
}
}
catch (Exception e)
{
TempData["error"] = $"Problems with getting information from database (services). {e.Message}";
return(RedirectToAction("Edit", new { projectCooperations_id = model.Id }));
}
return(RedirectToAction("Index"));
}
public bool Create(ProjectCooperaionsModel projectCooperation)
{
if (projectCooperation == null)
{
return(false);
}
try
{
string dateAssigned = String.Format("{0}/{1}/{2}", projectCooperation.DateAssigned.Year, projectCooperation.DateAssigned.Month, projectCooperation.DateAssigned.Day);
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"INSERT INTO {ProjectCooperationsTable} (Project_Id, Team_Id, DateAssigned) " +
$"VALUES ({projectCooperation.Project_Id}, {projectCooperation.Team_Id}, '{dateAssigned}')";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public bool Update(ProjectCooperaionsModel projectCooperation)
{
if (projectCooperation is null || projectCooperation.DateAssigned == DateTime.MinValue)
{
return(false);
}
try
{
string dateAssigned = String.Format("{0}/{1}/{2}", projectCooperation.DateAssigned.Year, projectCooperation.DateAssigned.Month, projectCooperation.DateAssigned.Day);
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"UPDATE {ProjectCooperationsTable} " +
$"SET Project_Id = {projectCooperation.Project_Id}, " +
$"Team_Id = {projectCooperation.Team_Id}, " +
$"DateAssigned = CAST('{dateAssigned}' as DATETIME) " +
$"WHERE {ProjectCooperationsTable}.Id = {projectCooperation.Id}";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(int projectCooperations_id)
{
string errorMsg = String.Empty;
if (TempData.ContainsKey("error"))
{
errorMsg = TempData["error"].ToString();
}
ProjectCooperaionsModel projectCooperations = new ProjectCooperaionsModel();
List <SelectListItem> projectList = new List <SelectListItem>();
List <SelectListItem> teamList = new List <SelectListItem>();
try
{
projectList = Utils.Helper.GetProjectsList();
teamList = Utils.Helper.GetTeamList();
projectCooperations = _projectCooperaionsService.GetProjectCooperation(projectCooperations_id);
}
catch (Exception e)
{
TempData["error"] = $"Problems with getting information from database (services). {e.Message}";
return(RedirectToAction("Index", "Home"));
}
ProjectCooperationsVm model = new ProjectCooperationsVm()
{
ProjectList = projectList,
TeamList = teamList,
Id = projectCooperations.Id,
Project_Id = projectCooperations.Project_Id,
Team_Id = projectCooperations.Team_Id,
DateAssigned = projectCooperations.DateAssigned,
ErrorMsg = errorMsg
};
return(View("Edit", model));
}
public ActionResult Create(ProjectCooperationsVm model)
{
if (model is null || model.DateAssigned == DateTime.MinValue || model.Project_Id == 0 || model.Project_Id == null || model.Team_Id == 0 || model.Team_Id == null)
{
TempData["error"] = $"All data must be filled";
return(RedirectToAction("Create"));
}
ProjectCooperaionsModel projectCooperations = new ProjectCooperaionsModel()
{
Project_Id = model.Project_Id,
Team_Id = model.Team_Id,
DateAssigned = model.DateAssigned,
};
try
{
if (!_projectCooperaionsService.CheckIfRecordExist(projectCooperations))
{
if (!_projectCooperaionsService.Create(projectCooperations))
{
TempData["error"] = $"Problems with create project cooperation (Service error \"Create\").";
return(RedirectToAction("Create"));
}
}
else
{
TempData["error"] = $"This combination already exists. You are trying to duplicate (Service error \"Create\").";
return(RedirectToAction("Create"));
}
}
catch (Exception e)
{
TempData["error"] = $"Problems with saving information to database (services). {e.Message}";
return(RedirectToAction("Create"));
}
return(RedirectToAction("Index"));
}
public ProjectCooperaionsModel GetProjectCooperation(int projectCooperation_id)
{
ProjectCooperaionsModel projectCooperation = new ProjectCooperaionsModel();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"SELECT * FROM {ProjectCooperationsTable} WHERE {ProjectCooperationsTable}.id = {projectCooperation_id};";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
try
{
projectCooperation.Id = int.Parse(reader["Id"].ToString());
projectCooperation.Project_Id = int.Parse(reader["Project_Id"].ToString());
projectCooperation.Team_Id = int.Parse(reader["Team_Id"].ToString());
projectCooperation.DateAssigned = DateTime.Parse(reader["DateAssigned"].ToString());
}
catch (Exception)
{
return(new ProjectCooperaionsModel());
}
}
}
}
catch (Exception)
{
return(new ProjectCooperaionsModel());
}
return(projectCooperation);
}
public bool CheckIfRecordExist(ProjectCooperaionsModel projectCooperations)
{
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"SELECT * FROM {ProjectCooperationsTable} WHERE {ProjectCooperationsTable}.Project_Id = {projectCooperations.Project_Id} AND {ProjectCooperationsTable}.Team_Id = {projectCooperations.Team_Id};";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);;
}
}
