ASP.NET MVC-Update existing and save new record excel upload

mike idowu

How do I update exiisting record using COUNTRY_CODE as the unique identifier and Save new record in excel batch upload using ASP.NET MVC.

I have this Model Class

public COUNTRIES()

{

public int COUNTRY_ID { get; set; }

public string COUNTRY_CODE { get; set; }

public string COUNTRY_NAME { get; set; }

}

See my excel sample

I want to perform batch upload of data from Excel with all the fields above and save into the database. I want the code to use the field COUNTRY_CODE as the UniqueIdentifier.

It will iterate through the Excel Sheet to check if COUNTRY_CODE exists in the database.

The application will save the one that are not in existence using COUNTRY_CODE
It will show the user the list of COUNTRY_CODE that exists in the database.
it will update the record where the uniqueidentifier exists.
The user will be able to select the ones he wants to update from the last.

3 Replies

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

Amit Kumar8y ago
Hi,
Please read below link artilce it help you to insert, edit, update , delete and call store-procedure in mvc

http://www.c-sharpcorner.com/article/crud-operation-using-single-stored-procedure-in-asp-net-mvc-of-real-time-proje/

Regards,
Amit
mike idowu8y ago
Please how I call the stored procedure from my application (from the controller) based on my code
Amit Kumar8y ago
Hi,

you can do first. Change in your procedure where u insert the data into datatable.

Create Procedure InsertCountry
(
Declare @countrycode nvarchar(10),
@countryName nvarchar(50)
)
as
begin
--First check country code is exists or not in countries table if exists then update otherwise insert
IF EXISTS (SELECT * FROM Countries WHERE Country_Code = @countrycode )
BEGIN
Update countries set country_name=@countryName where Country_Cdoe=@countrycode
END
ELSE
BEGIN
Insert into countries values(@countrycode,@countryName )
END
end