/// <summary> /// This is the method for get single record of party. /// </summary> /// <param name="partyId"></param> /// <returns></returns> public PartyresponseModel GetPartyById(int partyId) { try { SqlConnection sqlConnection = new SqlConnection(_configuration["connectionstring:ElectionDb"]); SqlCommand sqlCommand = new SqlCommand("sp_party", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@partyId", partyId); sqlCommand.Parameters.AddWithValue("@Query", 5); sqlConnection.Open(); SqlDataReader sdr = sqlCommand.ExecuteReader(); while (sdr.Read()) { partyresponse = new PartyresponseModel(); partyresponse.partyId = Convert.ToInt32(sdr["partyId"]); partyresponse.partyName = sdr["partyName"].ToString(); partyresponse.createdDate = Convert.ToDateTime(sdr["createdDate"]); partyresponse.modifiedDate = Convert.ToDateTime(sdr["modifiedDate"]); } sdr.Close(); if (partyresponse != null) { return(partyresponse); } else { return(null); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public IActionResult GetPartyById(int partyId) { var user = HttpContext.User; PartyresponseModel result = new PartyresponseModel(); if (user.HasClaim(c => c.Type == "Typetoken")) { if (user.Claims.FirstOrDefault(c => c.Type == "Typetoken").Value == "Login") { result = partyBL.GetPartyById(partyId); if (result != null) { var success = true; var message = "party Details"; return(Ok(new { success, message, result })); } else { var success = false; var message = "party Details getting failed"; return(Ok(new { success, message })); } } } return(BadRequest("used invalid token")); }
public IActionResult AddPartyDetails(Party details) { var user = HttpContext.User; PartyresponseModel response = new PartyresponseModel(); if (user.HasClaim(c => c.Type == "Typetoken")) { if (user.Claims.FirstOrDefault(c => c.Type == "Typetoken").Value == "Login") { response = partyBL.AddParty(details); if (response != null) { var success = true; var message = "party add successfully done"; return(Ok(new { success, message, response })); } else { var success = false; var message = "party add Failed"; return(BadRequest(new { success, message })); } } } return(BadRequest("used invalid token")); }
public IActionResult UpdateParty(int partyId, PartyRequestModel partyRequestModel) { var user = HttpContext.User; PartyresponseModel result = new PartyresponseModel(); if (user.HasClaim(c => c.Type == "Typetoken")) { if (user.Claims.FirstOrDefault(c => c.Type == "Typetoken").Value == "Login") { result = partyBL.UpdateParty(partyId, partyRequestModel); if (result != null) { var success = true; var message = "party Updated"; return(Ok(new { success, message, result })); } else { var success = false; var message = "Failed Updation"; return(BadRequest(new { success, message })); } } } return(BadRequest("used invalid token")); }