multiple images insert by separate table using webapi

Question

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?

Sachin Singh · Answer

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

Rupesh N · Answer

@ 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.

Murali Krishnan · Answer

Please share the code.we will implement our logic and share with you

Rupesh N · Answer

I do not understand what you tell. so, if know please share the code. @ Murali Krishnan

Rupesh N · Answer

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.

Murali Krishnan · Answer

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