public static string GetContactId(CustomerContact contact)
{
var res = SQLDataHelper.GetNullableGuid(SQLDataAccess.ExecuteScalar("[Customers].[sp_GetContactIDByContent]", CommandType.StoredProcedure,
new SqlParameter("@Name", contact.Name),
new SqlParameter("@Country", contact.Country),
new SqlParameter("@City", contact.City),
new SqlParameter("@Zone", contact.RegionName ?? ""),
new SqlParameter("@Zip", contact.Zip ?? ""),
new SqlParameter("@Address", contact.Address),
new SqlParameter("@CustomerID", contact.CustomerGuid)
));
return(res == null ? null : res.ToString());
}