C#•15mo ago

Need help connecting AJAX to Controller to DAL

I kind of need help also explaining the process cause it's alot of stuff happening. But I don't know where else to turn to and my job is a kind of on the line here and my Senior dev isn't helping

mvc_question.docx16.61KB

Adrian10777OP•10/4/24, 5:43 AM

https://pastebin.com/SC94zq5F

Pastebin

How do I connect Ajax to controller properly, then controller with ...

Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.

Adrian10777OP•10/4/24, 5:43 AM

easier access to code if it helps

AAdrian10777 I kind of need help also explaining the process cause it's alot of stuff happeni...

TeBeCo•10/4/24, 5:58 AM

please refrain from sending file known to potentially include malware or just because people don't have WORD installed (avoid DOCX file)

AAdrian10777 https://pastebin.com/SC94zq5F

TeBeCo•10/4/24, 6:00 AM

when you send code, don't mix C# Code + Text + Html code

TeBeCo•10/4/24, 6:00 AM

it's honnestly unreadable

TeBeCo•10/4/24, 6:00 AM

Original message was deleted

MODiX•10/4/24, 6:00 AM

If your code is too long, you can post to https://paste.mod.gg/, save, and copy the link into chat for others to see your shared code!

TeBeCo•10/4/24, 6:00 AM

create sub tabs and files inside

TeBeCo•10/4/24, 6:01 AM

each code in it own file

TeBeCo•10/4/24, 6:01 AM

and also specific what version of .net you're using

TeBeCo•10/4/24, 6:01 AM

the one you're using sounds ultra legacy

AAdrian10777 I kind of need help also explaining the process cause it's alot of stuff happeni...

JellyRekt•10/4/24, 1:22 PM

Is this code working but you just don't understand it? Or it's not working?

Adrian10777OP•10/4/24, 1:35 PM

I will work on providing a better file

Adrian10777OP•10/4/24, 1:35 PM

sorry about that guys

JJellyRekt Is this code working but you just don't understand it? Or it's not working?

Adrian10777OP•10/4/24, 1:35 PM

it's not working

Adrian10777OP•10/4/24, 1:36 PM

I was able to obtain the primaryid1

Adrian10777OP•10/4/24, 1:36 PM

when selecting dropdownlist

Adrian10777OP•10/4/24, 1:36 PM

to then push add new row to table 2 kendo button

Adrian10777OP•10/4/24, 1:37 PM

but I get a foreign key error because I don't know how to get the rest of the data to have anything

Adrian10777OP•10/4/24, 1:37 PM

if that makes sense

AAdrian10777 but I get a foreign key error because I don't know how to get the rest of the da...

JellyRekt•10/4/24, 1:51 PM

Foreign key error? Sounds to me like the table you're inserting into has a column that references another table, but the value you're inserting into that column doesn't exist as an ID in the target table.

Adrian10777OP•10/4/24, 1:52 PM

yeah, I assume it's because the training id I am selecting from dropdownlist, is not coming with the one that is getting the FK error

Adrian10777OP•10/4/24, 1:53 PM

because I was previously getting it for the primaryid1

Adrian10777OP•10/4/24, 1:53 PM

but now it's a different one

Adrian10777OP•10/4/24, 1:53 PM

but if I am not mistaken I can only base my dropdownlist based on one id

Adrian10777OP•10/4/24, 1:53 PM

not multiple

Adrian10777OP•10/4/24, 1:53 PM

that's where I thought my model will come in

Adrian10777OP•10/4/24, 1:53 PM

but not sure what piece I am missing

Adrian10777OP•10/4/24, 1:55 PM

I'll be back in like an hour in case I don't respond

JellyRekt•10/4/24, 2:47 PM

I'm confused. So sounds like you have a form to create a user, and that form contains a dropdown list of all possible training IDs. The training ID references another table, but when you go to save the user, the training ID you try to insert fails the foreign key check. Is that correct?

Adrian10777OP•10/4/24, 2:49 PM

So it's not a form which also confuses me, this is being done through JSON, the user is being created with the kendo button, the training id i try to insert does not fail

Adrian10777OP•10/4/24, 2:49 PM

it's another variable

Adrian10777OP•10/4/24, 2:49 PM

or scalar variable

Adrian10777OP•10/4/24, 2:49 PM

that I am not sure how I can get access too

Adrian10777OP•10/4/24, 2:49 PM

and other ones

Adrian10777OP•10/4/24, 2:50 PM

I've never done much through JSON, but in the return controller function

return Json(new[] { x }.ToDataSourceResult(request, ModelState));

that's what I understand from it I guess

Adrian10777OP•10/4/24, 2:57 PM

I did a try and catch and still got : 'The INSERT statement conflicted with the FOREIGN KEY constraint

JellyRekt•10/4/24, 4:02 PM

Okay, so a couple of things:

Have you placed a breakpoint on your Create method and used the debugger to make sure the column name and value are what you expect for the foreign key field?. Does the name of the key on the JSON object match the name of the column on the users table?
Have you verified that a record exists on the target table whose ID is the same as the value you're trying to insert in the foreign key column on your users table?

Adrian10777OP•10/4/24, 4:07 PM

just to be clear, I placed a breakpoint in the Create method in the controller, I say to be clear because the function name in the DAL is also Create, I can confirm the value is not what I expect, it's basically just returning 0 when it should have a value of 1 or greater, and it's the case for the other columns except for primaryid1. By name or key of JSON object do you mean x? and sorry what do you mean if it matches the name of the column on the users table (table1 or table2)?

Yes I verified that the ID exists in both table which are the same

AAdrian10777 just to be clear, I placed a breakpoint in the Create method in the controller, ...

JellyRekt•10/4/24, 4:19 PM

Okay, 0 is the default value so that means it is not automatically mapping the field from the request body to the Model. If your other fields are correctly mapping to the model, my next guess is that either:

Your model has no default setter method for the property, so it cannot be implicitly mapped, or
There is no key in your request body matching the name of the property on the model; or if there is, the value's type is not one that can be mapped to the type of the property on the model.

Adrian10777OP•10/4/24, 4:23 PM

They all have default values except the primaryID1 which I retrieved from the dropdownlist,

the ones that dont have a @scalar variable, are the only ones that should be default values

problem is they can't have default values, because in the primary table they have a value, and they all are different so a default value wouldn't really work.

can you explain #2 more in simpler terms sorry, not sure what you mean by key, request body, and how will I know if the value type is not one that can be mapped to the type of the property on the model?

AAdrian10777 They all have default values except the primaryID1 which I retrieved from the dr...

JellyRekt•10/4/24, 4:26 PM

Not default values, default setters. A way for the framework to set the value behind the scenes. Your properties should almost definitely be defined like this:

The is important because the framework will not be able to set values without that.

Adrian10777OP•10/4/24, 4:27 PM

I see, they all do have that

Adrian10777OP•10/4/24, 4:28 PM

and both public int

AAdrian10777 They all have default values except the primaryID1 which I retrieved from the dr...

JellyRekt•10/4/24, 4:33 PM

For #2, you say "this is being done through JSON", so I assume you are somehow sending an HTTP request to your endpoint which contains a JSON request body. The body looks something like this:

The keys are the part before the and the values are the part after. Since you have a as your parameter, the framework will attempt to map these properties to the model. So with the body I used, it's going to look for a model definition like this:

The keys are used to find the property names on the model. If there's a typo in one of my keys:

Then it will fail to map the key to a property on the model. Since the default value of an integer is 0, SomeForeignKey will be 0 on the model; since the target table probably does not have a record with an id of 0, the FK check fails.

Adrian10777OP•10/4/24, 4:37 PM

Ah okay that makes sense, but how do I know if one my keys are mispelled?

Adrian10777OP•10/4/24, 4:37 PM

or where do I check for that?

JellyRekt•10/4/24, 4:38 PM

Good question. I don't really understand how you're sending the request, so I'm not sure where the best place is to stop and examine it.

JellyRekt•10/4/24, 4:39 PM

If your project has HttpLogging services configured, you can probably use that to examine the request body

Adrian10777OP•10/4/24, 4:41 PM

no HttpLogging unfortunately, if I were to put one, do I put it in the create controller function where the Json is being returned?