multiple images insert by separate table using webapi

Rupesh N

5y669.NET

product registration

[pid, title, description, imageid, status, date]

images

[id, imageid, filepath, status, date]

actually, i am try to create below table and ouput.

but, i don't know, how to do that.

if anybody know please tell me or please send source code.

and output like this

i am using webapi. my code format

public string Post (project pr){
try{
}
catch(){throw;}
}

or else any other format?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rupesh N5y ago
@ Murali Krishnan, I just create project. and create classes in model folder. and creaate controller.
so, next, I don't know. what to do. if you want that folder. I will share.
+1
Murali Krishnan5y ago
Please share the code.we will implement our logic and share with you
+1
Rupesh N5y ago
I do not understand what you tell. so, if know please share the code.
@ Murali Krishnan
+1
Rupesh N5y ago
actually, I am not using the entity framework. @Sachin Singh. I am using SQL queries in the controller. so, if you know that way. please share.
+1
Sachin Singh5y ago
Step 1. First, create the necessary product class as
public class product
{
public int Pid {get;set;}
public string Title {get;set;}
public string Description {get;set;}
public List images{get;set;}
public int status {get;set;}
public DateTime Date{get;set;}
}

public class Image
{
public int Id {get;set;}
public string FilePath {get;set;}
}
step 2. Now, pass the data as you are passing in the example via fiddler or postman. (I am considering that you are using Entity Framework.)
public string Post (product pr){
try{
using(YourContext db= new YourContext ())
{
db.Products.Add( new product(){
Title=pr.Title,
Description=pr.Description,
Images= new List
{
new Image(){Id=1,FilePath="/abc"},
new Image(){Id=1,FilePath="/abc"}
},
Status=1,
Date= System.DateTime.Now
});
db.SaveChanges();
}
}
catch(){throw;}
}
+1
Murali Krishnan5y ago
I am suggesting to write the logic in DB Side , collect the data as per your need then sent it to DB procedure .
There you can do multiple table insert with the data you are receiving
+1

multiple images insert by separate table using webapi

@ Murali Krishnan, I just create project. and create classes in model folder. and creaate controller.

@ Murali Krishnan