public object UpdateLegislation([FromBody] LegislationRequestDTO legislationData)
{
string token = Request.Headers.Authorization == null ? "" : Request.Headers.Authorization.ToString();
Logger.Info(Request.RequestUri + " || Method: " + Request.Method, Request.Headers.ToString(), JsonConvert.SerializeObject(legislationData), Level.INFO);
ResponseDTO Response = new ResponseDTO();
ErrorDTO ErrorResponse = new ErrorDTO();
Response = LegislationBUS.AddOrUpdateLegislation(legislationData);
return(Response);
}
public static ResponseDTO AddOrUpdateLegislation(LegislationRequestDTO LegislationData)
{
ErrorDTO ErrorResponse = new ErrorDTO();
ResponseDTO Response = new ResponseDTO();
SqlConnection con = connection.loadDB();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = LegislationData.id == null ? "AddLegislationData" : "UpdateLegislationData";
if (LegislationData.id != null)
{
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "ID";
param1.SqlDbType = SqlDbType.Int;
param1.Value = LegislationData.id;
cmd.Parameters.Add(param1);
}
SqlParameter param6 = new SqlParameter();
param6.ParameterName = "Title";
param6.SqlDbType = SqlDbType.NVarChar;
param6.Value = LegislationData.title != "" ? LegislationData.title : "";
cmd.Parameters.Add(param6);
SqlParameter param2 = new SqlParameter();
param2.ParameterName = "Description";
param2.SqlDbType = SqlDbType.NVarChar;
param2.Value = LegislationData.description != "" ? LegislationData.description : "";
cmd.Parameters.Add(param2);
SqlParameter param10 = new SqlParameter();
param10.ParameterName = "Summary";
param10.SqlDbType = SqlDbType.NVarChar;
param10.Value = LegislationData.summary != "" ? LegislationData.summary : "";
cmd.Parameters.Add(param10);
SqlParameter param3 = new SqlParameter();
param3.ParameterName = "StartDate";
param3.SqlDbType = SqlDbType.VarChar;
param3.Value = LegislationData.start_date != "" ? LegislationData.start_date : "";
cmd.Parameters.Add(param3);
SqlParameter param4 = new SqlParameter();
param4.ParameterName = "EndDate";
param4.SqlDbType = SqlDbType.VarChar;
param4.Value = LegislationData.end_date != "" ? LegislationData.end_date : "";
cmd.Parameters.Add(param4);
SqlParameter param5 = new SqlParameter();
param5.ParameterName = "CategoryCode";
param5.SqlDbType = SqlDbType.NChar;
param5.Value = LegislationData.category_code != "" ? LegislationData.category_code : "";
cmd.Parameters.Add(param5);
SqlParameter param7 = new SqlParameter();
param7.ParameterName = "Reporter";
param7.SqlDbType = SqlDbType.NChar;
param7.Value = LegislationData.reporter != "" ? LegislationData.reporter : "";
cmd.Parameters.Add(param7);
SqlParameter param9 = new SqlParameter();
param9.ParameterName = "ImplementingAuthority";
param9.SqlDbType = SqlDbType.NVarChar;
param9.Value = LegislationData.implementing_authority != "" ? LegislationData.implementing_authority : "";
cmd.Parameters.Add(param9);
SqlParameter param11 = new SqlParameter();
param11.ParameterName = "IsImportingCountry";
param11.SqlDbType = SqlDbType.Int;
param11.Value = LegislationData.is_importing_country != "" ? LegislationData.is_importing_country : "";
cmd.Parameters.Add(param11);
SqlParameter param12 = new SqlParameter();
param12.ParameterName = "Agency";
param12.SqlDbType = SqlDbType.NChar;
param12.Value = LegislationData.agency != "" ? LegislationData.agency : "";
cmd.Parameters.Add(param12);
try
{
cmd.ExecuteNonQuery();
Response.Data = LegislationData.id == null ? "CREATED" : "UPDATED";
}
catch (Exception ex)
{
ErrorResponse.Code = 400;
ErrorResponse.Message = ex.ToString();
Response.Error = ErrorResponse;
}
finally
{
con.Close();
}
return(Response);
}
