public string Generate(TariffInput input) { var result = "Success"; var exist = (from ta in Tariff where ta.Year == input.Year && ta.DivisionId == input.DivisionId select ta).Any(); if (exist) { return("Data already exist for this criteria"); } var rec = from ta in InitTariff select new DataModels.Billing.TariffMaster() { Borewell = ta.Borewell, CategoryId = ta.CategoryId, DivisionId = input.DivisionId, MeterCost = ta.MeterCost, Sanitary = ta.Sanitary, SanitaryType = ta.SanitaryType, SlabMax = ta.SlabMax, SlabMin = ta.SlabMin, Tariff = ta.Tariff, Year = input.Year }; Tariff.AddRange(rec.ToList()); SaveChanges(); return(result); }