public IActionResult UpdateConstituency(int ConstituencyId, constituencyUpdate constituencyUpdate) { var user = HttpContext.User; ConstituencyResponseModel result = new ConstituencyResponseModel(); if (user.HasClaim(c => c.Type == "Typetoken")) { if (user.Claims.FirstOrDefault(c => c.Type == "Typetoken").Value == "Login") { result = constituencyBL.UpdateConstituency(ConstituencyId, constituencyUpdate); if (result != null) { var success = true; var message = "Constituency Updated"; return(Ok(new { success, message, result })); } else { var success = false; var message = "Constituency Updation failed"; return(Ok(new { success, message })); } } } return(BadRequest("Used Invalid Token")); }
/// <summary> /// This is the method for update constituency. /// </summary> /// <param name="ConstituencyId"></param> /// <param name="constituencyUpdate"></param> /// <returns></returns> public ConstituencyResponseModel UpdateConstituency(int ConstituencyId, constituencyUpdate constituencyUpdate) { try { if (ConstituencyId != 0) { return(constituencyRL.UpdateConstituency(ConstituencyId, constituencyUpdate)); } else { return(null); } } catch (Exception) { throw; } }
/// <summary> /// This is the method for Update constituency. /// </summary> /// <param name="ConstituencyId"></param> /// <param name="constituencyUpdate"></param> /// <returns></returns> public ConstituencyResponseModel UpdateConstituency(int ConstituencyId, constituencyUpdate constituencyUpdate) { try { SqlConnection sqlConnection = new SqlConnection(_configuration["connectionstring:ElectionDb"]); SqlCommand sqlCommand = new SqlCommand("sp_Constituency", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@ConstituencyId", ConstituencyId); sqlCommand.Parameters.AddWithValue("@Name", constituencyUpdate.Name); sqlCommand.Parameters.AddWithValue("@City", constituencyUpdate.City); sqlCommand.Parameters.AddWithValue("@State", constituencyUpdate.State); sqlCommand.Parameters.AddWithValue("@Query", 3); sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { constituency = new ConstituencyResponseModel(); constituency.ConstituencyId = Convert.ToInt32(reader["ConstituencyId"]); constituency.Name = reader["Name"].ToString(); constituency.City = reader["City"].ToString(); constituency.State = reader["State"].ToString(); constituency.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]).ToLocalTime(); constituency.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]).ToLocalTime(); } reader.Close(); if (constituency != null) { return(constituency); } else { return(null); } } catch (Exception e) { throw new Exception(e.Message); } }