//on form submit - check user input against existing items //if editing, id is passed to ignore current item public bool IsAvailableClientDetailName(string groupName, int?groupId) { ClientDetailDC dbClientDetail = new ClientDetailDC(Settings.getConnectionString()); int count = 0; if (groupId.HasValue) { var result = from n in dbClientDetail.ClientDetails where n.ClientDetailName.Trim().Equals(groupName) && n.ClientDetailId != groupId select n.ClientDetailName; count = result.Count(); } else { var result = from n in dbClientDetail.ClientDetails where n.ClientDetailName.Trim().Equals(groupName) select n.ClientDetailName; count = result.Count(); } if (count == 0) { return(true); } else { return(false); } }