public IActionResult AddConstituency(ConstituencyRequestmodel constituencyRequestmodel)
{
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.AddConstituency(constituencyRequestmodel);
if (result != null)
{
var success = true;
var message = "Constituency added";
return(Ok(new { success, message, result }));
}
else
{
var success = false;
var message = "Constituency added failed";
return(Ok(new { success, message }));
}
}
}
return(BadRequest("Use Invalid Token"));
}
/// <summary>
/// This is the method for add constituency.
/// </summary>
/// <param name="constituencyRequestmodel"></param>
/// <returns></returns>
public ConstituencyResponseModel AddConstituency(ConstituencyRequestmodel constituencyRequestmodel)
{
try
{
if (constituencyRequestmodel != null)
{
return(constituencyRL.AddConstituency(constituencyRequestmodel));
}
else
{
return(null);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// This is the method for add constituency.
/// </summary>
/// <param name="constituencyRequestmodel"></param>
/// <returns></returns>
public ConstituencyResponseModel AddConstituency(ConstituencyRequestmodel constituencyRequestmodel)
{
try
{
SqlConnection sqlConnection = new SqlConnection(_configuration["connectionstring:ElectionDb"]);
SqlCommand sqlCommand = new SqlCommand("sp_Constituency", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Name", constituencyRequestmodel.Name);
sqlCommand.Parameters.AddWithValue("@City", constituencyRequestmodel.City);
sqlCommand.Parameters.AddWithValue("@State", constituencyRequestmodel.State);
sqlCommand.Parameters.AddWithValue("@Query", 1);
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);
}
}
