How to save Employee basic info and Employee Image

Md Mustafa

10y1.4kGeneral

I Have employee table

Tbl Employee:

Id, Name ,Age ,gender ,Image

i want to save employee details and photo url in database

and employee photo in folder using Web API and AngularJS

5 Replies

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

Dharmraj Thakur9y ago

I am suggesting to do like this...

This is normalized way to storing image in database...


		tb_Image

ImageId	FileName	FilePath	Remarks
1	1.jpg	/Contents/Images/	NULL
2	2.jpg	/Contents/Images/	NULL
3	3.jpg	/Contents/Images/	NULL
4	4.jpg	/Contents/Images/	NULL
5	5.jpg	/Contents/Images/	NULL



		tb_Employees

EmployeeId	Name	Age	Gender	ImageId
1	Mustafa	23	M	2
1	Dh	20	M	3

Benifit : You can store all images of other tables like users, employees, companies, products. All images will store in single table, so you dont need to make Filename and filepath field in every table...

Mark accepted if it is helpful to you.

Thank you!

Manas Mohapatra10y ago
Below link will help how to upload image files through AJAX in WebAPI:

https://www.codeproject.com/articles/806075/file-upload-using-jquery-ajax-in-asp-net-web-api

http://galratner.com/blogs/net/archive/2013/03/22/using-html-5-and-the-web-api-for-ajax-file-uploads-with-image-preview-and-a-progress-bar.aspx
+1
Gowtham K10y ago
Hi Mustafa,

I hope, that below link will help you

https://www.codeproject.com/articles/996994/image-preview-using-mvc-angularjs-and-web-api
+1
Md Mustafa10y ago
I want to save Employee Image url in database along with Employee details.My Main Problem is to save Employee ImageUrl in database.Can anyone help me?
+1
Brijesh Rathor10y ago
Hi,
check this url
http://www.dotnetcurry.com/aspnet/1049/crud-database-aspnet-webapi-angularjs

hope this will help you.
+1