in my c# code the request payload is:
{"lstContractInvoicePerdays":[{"ContractInvoicePerDayID":"1061","LastModifiedDate":"2023-04-24T04:37:44"},{"ContractInvoicePerDayID":"1135","LastModifiedDate":"2023-04-24T04:37:45"}]}
Let me help to pass the params in stored procedure as existing logic is not helping
try { int? BaseStateProvinceID = null; List<StaffCIPDApprovedPutModel> lstContractInvoicePerdays = new List<StaffCIPDApprovedPutModel>(); lstContractInvoicePerdays = staffCIPDApprovedViewModel.lstContractInvoicePerdays.ToList(); if (lstContractInvoicePerdays.Count == 1) { } CIPDPushReqMod timeCardPushRequest = new CIPDPushReqMod(); List <int> ContractInvoicePerDayIDs = staffCIPDApprovedViewModel.lstContractInvoicePerdays.Select(x=> x.ContractInvoicePerDayIDs.Split(',').Select(int.Parse).ToList(); using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString)) { try { using (SqlCommand command = new SqlCommand("spGetCIPDForPushToLawson", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ContractInvoicePerDayIDs", SqlDbType.NVarChar).Value = ContractInvoicePerDayIDs as object ?? DBNull.Value; if (connection.State != ConnectionState.Closed) { connection.Close(); } connection.Open(); using (var reader = command.ExecuteReader()) { timeCardPushRequest.TimeCardLst = ((IObjectContextAdapter)db).ObjectContext.Translate<CIPDPushReqObj>(reader).ToList(); reader.NextResult(); timeCardPushRequest.AdditionalComponents = ((IObjectContextAdapter)db).ObjectContext.Translate<CIPDPushReqObj_AdditionalComponent>(reader).ToList(); } } } catch (Exception) { }