public string AddUploadFileDbEntry(string cicoid, string sYear, string atCd, string fileName, string flUrl) { string sMessage; var form3 = new HMT_PCIS_Docs(); { form3.CICOID = cicoid; form3.FiscalYear = sYear; form3.ATCode = atCd; form3.PCIS_DocName = fileName; form3.PCIS_DocUrl = flUrl; form3.PCIS_DocDt = DateTime.Now; } var rowExists = _hmEntities.HMT_PCIS_Docs.Where( x => x.CICOID == cicoid && x.FiscalYear == sYear && x.ATCode == atCd); //if (!rowExists.Any()) if (rowExists.Count() < 5) { using (var dbCtx = new HotelMotelTaxEntities()) { dbCtx.HMT_PCIS_Docs.Add(form3); dbCtx.SaveChanges(); sMessage = "Successfully added PCIS document"; } } else { using (var dbCtx = new HotelMotelTaxEntities()) { dbCtx.Entry(rowExists).State = System.Data.Entity.EntityState.Modified; dbCtx.SaveChanges(); sMessage = "Successfully updated PCIS document"; } } return(sMessage); }