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