Ejemplo n.º 1
0
        public string ExcelUpload(List <TempCaseDetails> tempCaseDetails)
        {
            context.TempCaseDetails.AddRange(tempCaseDetails);
            int output = context.SaveChanges();

            if (output > 0)
            {
                context.Database.ExecuteSqlCommand("EXEC usp_tempCaseDetails_UpdateLocationMasterID");
                return(output.ToString() + " Records successfully uploaded from Excel file.");
            }
            else
            {
                return("No record uploaded from Excel");
            }
        }