//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);
}
}
