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